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

XF 1.3 MySQL Errors

wickedstangs

Well-known member
#1
Server Error
Mysqli prepare error: Table 'wsdecals_store.xf_error_log' doesn't exist

  1. Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
  2. Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
  3. Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
  4. Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 825
  5. Zend_Db_Adapter_Abstract->fetchOne() in XenForo/Model/Log.php at line 33
  6. XenForo_Model_Log->countServerErrors() in XenForo/ControllerAdmin/Home.php at line 37
  7. XenForo_ControllerAdmin_Home->actionIndex() in XenForo/FrontController.php at line 347
  8. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
  9. XenForo_FrontController->run() in /home/wsdecals/public_html/admin.php at line 13

I am getting this error what is it? Looks like my server is going down?
Mysqli statement execute error : Got error 122 from storage engine - library/Zend/Db/Statement/Mysqli.php:214
 

Brogan

XenForo moderator
Staff member
#3
Error 122 is a storage space related error, which your host will be able to help with.

However, that shouldn't have deleted the xf_error_log table.
Did you do anything which may have caused that?
Any recent actions at all?
 

wickedstangs

Well-known member
#4
Error 122 is a storage space related error, which your host will be able to help with.

However, that shouldn't have deleted the xf_error_log table.
Did you do anything which may have caused that?
Any recent actions at all?
I was uploading an image in the Resource center and then it crashed...
 

Brogan

XenForo moderator
Staff member
#6
This is the query to create the table:
Code:
CREATE TABLE xf_error_log (
        error_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
        exception_date INT UNSIGNED NOT NULL,
        user_id INT UNSIGNED DEFAULT NULL,
        ip_address VARBINARY(16) NOT NULL DEFAULT '',
        exception_type VARCHAR(75) NOT NULL,
        message TEXT NOT NULL,
        filename VARCHAR(255) NOT NULL,
        line INT UNSIGNED NOT NULL,
        trace_string MEDIUMTEXT NOT NULL,
        request_state MEDIUMBLOB NOT NULL,
        PRIMARY KEY (error_id),
        KEY exception_date (exception_date)
    ) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci
 

wickedstangs

Well-known member
#7
This is the query to create the table:
Code:
CREATE TABLE xf_error_log (
        error_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
        exception_date INT UNSIGNED NOT NULL,
        user_id INT UNSIGNED DEFAULT NULL,
        ip_address VARBINARY(16) NOT NULL DEFAULT '',
        exception_type VARCHAR(75) NOT NULL,
        message TEXT NOT NULL,
        filename VARCHAR(255) NOT NULL,
        line INT UNSIGNED NOT NULL,
        trace_string MEDIUMTEXT NOT NULL,
        request_state MEDIUMBLOB NOT NULL,
        PRIMARY KEY (error_id),
        KEY exception_date (exception_date)
    ) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci
Got this error..
error.PNG
 

Brogan

XenForo moderator
Staff member
#8
You may need to contact your host.
It appears there may be some database corruption and they will need to investigate.
 

vinafix

Active member
#11
I Help

Mysqli prepare error: Table 'datavina.xf_error_log' doesn't exist in engine

  1. Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
  2. Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
  3. Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
  4. Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 825
  5. Zend_Db_Adapter_Abstract->fetchOne() in XenForo/Model/Log.php at line 33
  6. XenForo_Model_Log->countServerErrors() in XenForo/ControllerAdmin/Home.php at line 37
  7. XenForo_ControllerAdmin_Home->actionIndex() in XenForo/FrontController.php at line 347
  8. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
  9. XenForo_FrontController->run() in /home/vinafix.vn/public_html/admin.php at line 13
Screen Shot 2014-12-20 at 1.32.49 AM.png
 

vinafix

Active member
#13
Server Error
Mysqli prepare error: Table 'datavina.xf_error_log' doesn't exist in engine

  1. Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
  2. Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
  3. Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
  4. Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 825
  5. Zend_Db_Adapter_Abstract->fetchOne() in XenForo/Model/Log.php at line 33
  6. XenForo_Model_Log->countServerErrors() in XenForo/ControllerAdmin/Home.php at line 37
  7. XenForo_ControllerAdmin_Home->actionIndex() in XenForo/FrontController.php at line 347
  8. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
  9. XenForo_FrontController->run() in /home/vinafix.vn/public_html/admin.php at line 13

Screen Shot 2014-12-20 at 9.29.22 AM.png
 

Mike

XenForo developer
Staff member
#14
As said in your ticket, based on your explanation, it appears that you have DB corruption and only your host will be able to help.
 

51463

Well-known member
#15
I just had this problem. I was not able fix it via php my admin. I tried to drop it via phpmyadmin and it wouldn't drop, because it already exists, i tried to create it and it wouldn't create because it already existed

i had to get right down and dirty and into the mysql program command line program!

i used the command:

DROP TABLE xf_error_log;

and it said query ok,

then i went to phpmyadmin and i enter Borgon's code in the sql query box and it worked!

my admin panel finally worked! luckily i am getting better at the command line

not sure what caused it, but it happend after i updated a bunch of add-ons, not sure if i removed some also,

but it's working, hopefully this helps someone in the future

my version was 1.5.1.12