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

[Muziekjuh]

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:

Spoiler

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

Spoiler

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

 

[Muziekjuh]

Someone knows it?

 

[Paul B]

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]

Someone knows it?

This part of the error:

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?

 

[Muziekjuh]

This part of the error:

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.

 

[Paul B]

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.

 

[Muziekjuh]

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.

 

[Paul B]

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.

 

[Muziekjuh]

What can i do, to fix it now? The host says to me, that there wasn't wrong with transfer.

 

[borbole]

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.

 

[Muziekjuh]

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.

Thanks! I will ask the host to put a backup.. I hope its solved than.

 

[Muziekjuh]

Nope we did put a older backup but it didnt work