XF 1.2 Server Errors

X3nman

Member
Hi all,
I am constantly getting these server errors, and I dont know what the problem is.
I have read a bit about it on the forums with issues similar to mine (zend db stuff), but the recommendations are not working for me.
I wonder if someone can take a look and try and help me out.

Thanks



Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 15 - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Unknown Account, Today at 7:52 AM



Stack Trace

#0 /home/mysite.com/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('?????SELECT????...')
#1 /home/mysite.com/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '?????SELECT????...')
#2 /home/mysite.com/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('?????SELECT????...')
#3 /home/mysite.com/library/XenForo/Model.php(219): Zend_Db_Adapter_Abstract->query('?????SELECT????...', 'post', 2)
#4 /home/mysite.com/library/InsertFullAttachment/Model/InsertFull.php(26): XenForo_Model->fetchAllKeyed('?????SELECT????...', 'attachment_id', 'post')
#5 /home/mysite.com/library/InsertFullAttachment/CronEntry/Insert.php(12): InsertFullAttachment_Model_InsertFull->getAllAttachmentsForInsert()
#6 [internal function]: InsertFullAttachment_CronEntry_Insert::insertFullAttachments(Array)
#7 /home/mysite.com/library/XenForo/Model/Cron.php(356): call_user_func(Array, Array)
#8 /home/mysite.com/library/XenForo/Deferred/Cron.php(24): XenForo_Model_Cron->runEntry(Array)
#9 /home/mysite.com/library/XenForo/Model/Deferred.php(243): XenForo_Deferred_Cron->execute(Array, Array, 9.9999980926514, '')
#10 /home/mysite.com/library/XenForo/Model/Deferred.php(369): XenForo_Model_Deferred->runDeferred(Array, 9.9999980926514, '', false)
#11 /home/mysite.com/library/XenForo/Model/Deferred.php(322): XenForo_Model_Deferred->_runInternal(Array, NULL, '', false)
#12 /home/mysite.com/deferred.php(18): XenForo_Model_Deferred->run(false)
#13 {main}




Request State

array(3) {
["url"] => string(36) "http://mysite.com/deferred.php"
["_GET"] => array(0) {
}
["_POST"] => array(3) {
["_xfRequestUri"] => string(10) "/index.php"
["_xfNoRedirect"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
}
}
 

X3nman

Member
OK, I removed that addon, I also removed all addons that were not enabled.
I then disabled every addon that I had installed, and im still getting the error.

I have an auction addon that I know can recreate the error. That addon is not the problem because I only recently installed it and I have had the error for a long time.
Here is the error recreated in the auction addon....

Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'bid_status' in 'where clause' - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Unknown Account, A moment ago

Stack Trace

#0 /home/mysite.com/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('????SELECT *???...')
#1 /home/mysite.com/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '????SELECT *???...')
#2 /home/mysite.com/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('????SELECT *???...')
#3 /home/mysite.com/library/Zend/Db/Adapter/Abstract.php(753): Zend_Db_Adapter_Abstract->query('????SELECT *???...', Array)
#4 /home/mysite.com/library/XenAuction/Model/Auction.php(107): Zend_Db_Adapter_Abstract->fetchRow('????SELECT *???...', Array)
#5 /home/mysite.com/library/XenAuction/CronEntry/Auction.php(66): XenAuction_Model_Auction->getWinningBid(1)
#6 /home/mysite.com/library/XenAuction/CronEntry/Auction.php(37): XenAuction_CronEntry_Auction::runExpireAuction(Array)
#7 [internal function]: XenAuction_CronEntry_Auction::runExpireAuctions(Array)
#8 /home/mysite.com/library/XenForo/Model/Cron.php(356): call_user_func(Array, Array)
#9 /home/mysite.com/library/XenForo/Deferred/Cron.php(24): XenForo_Model_Cron->runEntry(Array)
#10 /home/mysite.com/library/XenForo/Model/Deferred.php(243): XenForo_Deferred_Cron->execute(Array, Array, 9.9999980926514, '')
#11 /home/mysite.com/library/XenForo/Model/Deferred.php(369): XenForo_Model_Deferred->runDeferred(Array, 9.9999980926514, '', false)
#12 /home/mysite.com/library/XenForo/Model/Deferred.php(322): XenForo_Model_Deferred->_runInternal(Array, NULL, '', false)
#13 /home/mysite.com/deferred.php(18): XenForo_Model_Deferred->run(false)
#14 {main}

Request State

array(3) {
["url"] => string(36) "http://mysite.com/deferred.php"
["_GET"] => array(0) {
}
["_POST"] => array(4) {
["_xfRequestUri"] => string(10) "/admin.php"
["_xfNoRedirect"] => string(1) "1"
["_xfToken"] => string(8) "********"
["_xfResponseType"] => string(4) "json"
}
}
 

Dan

Well-known member
The Auction addon is actually a different error. That auction addon has a bug in the installer that doesn't install all the needed tables. That error is telling you that you are missing a cloumn.
 
Last edited:

X3nman

Member
ok, thanks.
I guess I need to just sit and wait for the error to appear or not then to see if the issue has been solved.
 

X3nman

Member
OK, didn't have to wait too long.





Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Incorrect key file for table './admin/xf_session.MYI'; try to repair it - library/Zend/Db/Statement/Mysqli.php:214
Generated By: Unknown Account, A moment ago
Stack Trace

#0 /home/mysite.com/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/mysite.com/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/mysite.com/library/Zend/Db/Adapter/Abstract.php(661): Zend_Db_Adapter_Abstract->query('DELETE FROM `xf...')
#3 /home/mysite.com/library/XenForo/Session.php(773): Zend_Db_Adapter_Abstract->delete('xf_session', 'expiry_date < 1...')
#4 /home/mysite.com/library/XenForo/CronEntry/CleanUp.php(23): XenForo_Session->deleteExpiredSessions()
#5 [internal function]: XenForo_CronEntry_CleanUp::runHourlyCleanUp(Array)
#6 /home/mysite.com/library/XenForo/Model/Cron.php(356): call_user_func(Array, Array)
#7 /home/mysite.com/library/XenForo/Deferred/Cron.php(24): XenForo_Model_Cron->runEntry(Array)
#8 /home/mysite.com/library/XenForo/Model/Deferred.php(243): XenForo_Deferred_Cron->execute(Array, Array, 9.9999978542328, '')
#9 /home/mysite.com/library/XenForo/Model/Deferred.php(369): XenForo_Model_Deferred->runDeferred(Array, 9.9999978542328, '', false)
#10 /home/mysite.com/library/XenForo/Model/Deferred.php(322): XenForo_Model_Deferred->_runInternal(Array, NULL, '', false)
#11 /home/mysite.com/deferred.php(18): XenForo_Model_Deferred->run(false)
#12 {main}

Request State

array(3) {
["url"] => string(36) "http://mysite.com/deferred.php"
["_GET"] => array(0) {
}
["_POST"] => array(4) {
["_xfRequestUri"] => string(10) "/index.php"
["_xfNoRedirect"] => string(1) "1"
["_xfToken"] => string(8) "********"
["_xfResponseType"] => string(4) "json"
 

Brogan

XenForo moderator
Staff member
You will need to resolve the issues with any add-ons (as previously posted) and then possibly have to repair the session table.
 

Brogan

XenForo moderator
Staff member
There is an option in your control panel, available in the database management section.
 

X3nman

Member
found it.
The sessions table was marked as crashed.
All fixed now, hopefully I don't get that error back now :D

thanks everyone for the help.
 
Top