• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.3 Getting error, i dont know what to do.

#1
Hey!

I have problems with my website since yesterday. I get this error ''
The following error occurred
The server responded with an error. The error message is in the JavaScript console.
''

Website: www.goldguardmc.net (You cant use the login button, or place a post ect. Then you will get that error)


The serverlog says this:
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Table 'ringo_Xenforo.xf_template_compiled' doesn't exist - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Unknown Account, Yesterday at 3:12 PM
Stack Trace
#0 /home/ringo/domains/goldguardmc.net/public_html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('\n\t\t\tSELECT titl...')
#1 /home/ringo/domains/goldguardmc.net/public_html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '\n\t\t\tSELECT titl...')
#2 /home/ringo/domains/goldguardmc.net/public_html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('\n\t\t\tSELECT titl...')
#3 /home/ringo/domains/goldguardmc.net/public_html/library/Zend/Db/Adapter/Abstract.php(808): Zend_Db_Adapter_Abstract->query('\n\t\t\tSELECT titl...', Array)
#4 /home/ringo/domains/goldguardmc.net/public_html/library/XenForo/Template/Public.php(130): Zend_Db_Adapter_Abstract->fetchPairs('\n\t\t\tSELECT titl...', Array)
#5 /home/ringo/domains/goldguardmc.net/public_html/library/XenForo/Template/Abstract.php(572): XenForo_Template_Public->_getTemplatesFromDataSource(Array)
#6 /home/ringo/domains/goldguardmc.net/public_html/library/XenForo/Template/Abstract.php(556): XenForo_Template_Abstract->_loadTemplates()
#7 /home/ringo/domains/goldguardmc.net/public_html/library/XenForo/Template/Abstract.php(180): XenForo_Template_Abstract->_loadTemplate('error')
#8 /home/ringo/domains/goldguardmc.net/public_html/library/XenForo/Template/Public.php(110): XenForo_Template_Abstract->render()
#9 /home/ringo/domains/goldguardmc.net/public_html/library/XenForo/ViewRenderer/HtmlPublic.php(123): XenForo_Template_Public->render()
#10 /home/ringo/domains/goldguardmc.net/public_html/library/XenForo/FrontController.php(618): XenForo_ViewRenderer_HtmlPublic->renderContainer(Object(XenForo_Template_Public), Array)
#11 /home/ringo/domains/goldguardmc.net/public_html/library/XenForo/FrontController.php(158): XenForo_FrontController->renderView(Object(XenForo_ControllerResponse_Error), Object(XenForo_ViewRenderer_HtmlPublic), Array)
#12 /home/ringo/domains/goldguardmc.net/public_html/index.php(15): XenForo_FrontController->run()
#13 {main}
Request State
array(3) {
["url"] => string(30) "http://goldguardmc.net/online/"
["_GET"] => array(0) {

And

Server Error Log
Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Table 'ringo_Xenforo.xf_template_compiled' doesn't exist - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Unknown Account, Yesterday at 3:12 PM
Stack Trace
#0 /home/ringo/domains/goldguardmc.net/public_html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('\n\t\t\tSELECT titl...')
#1 /home/ringo/domains/goldguardmc.net/public_html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '\n\t\t\tSELECT titl...')
#2 /home/ringo/domains/goldguardmc.net/public_html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('\n\t\t\tSELECT titl...')
#3 /home/ringo/domains/goldguardmc.net/public_html/library/Zend/Db/Adapter/Abstract.php(808): Zend_Db_Adapter_Abstract->query('\n\t\t\tSELECT titl...', Array)
#4 /home/ringo/domains/goldguardmc.net/public_html/library/XenForo/Template/Public.php(130): Zend_Db_Adapter_Abstract->fetchPairs('\n\t\t\tSELECT titl...', Array)
#5 /home/ringo/domains/goldguardmc.net/public_html/library/XenForo/Template/Abstract.php(572): XenForo_Template_Public->_getTemplatesFromDataSource(Array)
#6 /home/ringo/domains/goldguardmc.net/public_html/library/XenForo/Template/Abstract.php(556): XenForo_Template_Abstract->_loadTemplates()
#7 /home/ringo/domains/goldguardmc.net/public_html/library/XenForo/Template/Abstract.php(180): XenForo_Template_Abstract->_loadTemplate('error')
#8 /home/ringo/domains/goldguardmc.net/public_html/library/XenForo/Template/Public.php(110): XenForo_Template_Abstract->render()
#9 /home/ringo/domains/goldguardmc.net/public_html/library/XenForo/ViewRenderer/HtmlPublic.php(123): XenForo_Template_Public->render()
#10 /home/ringo/domains/goldguardmc.net/public_html/library/XenForo/FrontController.php(618): XenForo_ViewRenderer_HtmlPublic->renderContainer(Object(XenForo_Template_Public), Array)
#11 /home/ringo/domains/goldguardmc.net/public_html/library/XenForo/FrontController.php(158): XenForo_FrontController->renderView(Object(XenForo_ControllerResponse_Error), Object(XenForo_ViewRenderer_HtmlPublic), Array)
#12 /home/ringo/domains/goldguardmc.net/public_html/index.php(15): XenForo_FrontController->run()
#13 {main}
Request State
array(3) {
["url"] => string(30) "http://goldguardmc.net/online/"
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}

What to do now? I dont know the answer this bug.

Thanks for reading!

Sincerely, Muziekjuh
 

Brogan

XenForo moderator
Staff member
#3
The error indicates the xf_template_compiled table is missing from your database.

You should contact your host and ask them to investigate when the problems started occurring as there is clearly now something wrong with the database.
 

borbole

Well-known member
#4
This part of the error:

Code:
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Table 'ringo_Xenforo.xf_template_compiled' doesn't exist - library/Zend/Db/Statement/Mysqli.php:77
indicates that the xf_template_compiled is missing in the db. Can you check your db and see if that table is indeed missing?

What changes did you to to your forum before this error happened btw?
 
#5
This part of the error:

Code:
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Table 'ringo_Xenforo.xf_template_compiled' doesn't exist - library/Zend/Db/Statement/Mysqli.php:77
indicates that the xf_template_compiled is missing in the db. Can you check your db and see if that table is indeed missing?

What changes did you to to your forum before this error happened btw?
Thanks for your reply! I dont miss that table.



We did change from dedicated server for the website. It was oke first. And now that error is comming.
 

Brogan

XenForo moderator
Staff member
#6
How did you do the back and restore/move?

I hope you didn't just copy the database files as that won't work for InnoDB.
 
#7
How did you do the back and restore/move?

I hope you didn't just copy the database files as that won't work for InnoDB.
Database is moved by the host. And we did upload it again, but it doesnt help. Can i remove that table, and let it auto created? Or doesnt work that.
 

Brogan

XenForo moderator
Staff member
#8
The table can be recreated but there may be other issues.

It sounds to me as if the backup and restore was not totally successful.
 

borbole

Well-known member
#10
Can you ask your host to restore only that particular table?

The error is very strange btw. Why is that table being mentioned as missing when in fact it is present in the db.