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

XF 1.3 Table errror due to Baidu spider

#1
Runing xenforo 1.3.3
Almost every night i get error and have to fix table in cpanel.
Wanna hear if any having the same problem latelly, and any work around.

using Current PHP version: 5.6


i have edited my DB name out.
Code:
Server Error

Mysqli statement execute error : Incorrect key file for table './######_######/xf_session.MYI'; try to repair it

  Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
  Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
  Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 574
  Zend_Db_Adapter_Abstract->insert() in XenForo/Session.php at line 784
  XenForo_Session->saveSessionToSource() in XenForo/Session.php at line 518
  XenForo_Session->save() in XenForo/Controller.php at line 412
  XenForo_Controller->updateSession() in XenForo/Controller.php at line 356
  XenForo_Controller->postDispatch() in XenForo/FrontController.php at line 354
  XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
  XenForo_FrontController->run() in /home/######/public_html/index.php at line 13
in admin panel error log above error and this also

Code:
array(3) {
  ["url"] => string(60) "http://www.######.org/forums/software.118/?direction=desc"
  ["_GET"] => array(1) {
    ["direction"] => string(4) "desc"
  }
  ["_POST"] => array(0) {
  }
}


Also in cpanel error log all ip seems to be Baidu spider or from china.

Code:
[Wed Aug 27 08:59:12.206515 2014] [access_compat:error] [pid 72639] [client 123.125.71.94:28522] AH01797: client denied by server configuration: /home/######/public_html/posts
[Wed Aug 27 08:51:21.523515 2014] [access_compat:error] [pid 51842] [client 180.76.5.223:43559] AH01797: client denied by server configuration: /home/######/public_html/forums
[Wed Aug 27 08:49:53.329648 2014] [access_compat:error] [pid 61793] [client 180.76.6.149:58050] AH01797: client denied by server configuration: /home/######/public_html/members
[Wed Aug 27 08:31:42.681012 2014] [access_compat:error] [pid 988249] [client 220.181.108.144:51159] AH01797: client denied by server configuration: /home/######/public_html/forums
[Wed Aug 27 08:25:02.844860 2014] [access_compat:error] [pid 964884] [client 220.181.108.81:37220] AH01797: client denied by server configuration: /home/######/public_html/forums
[Wed Aug 27 08:21:19.534916 2014] [access_compat:error] [pid 901709] [client 180.76.6.46:50462] AH01797: client denied by server configuration: /home/######/public_html/forums
[Wed Aug 27 07:58:23.527396 2014] [access_compat:error] [pid 778553] [client 220.181.108.111:24790] AH01797: client denied by server configuration: /home/######/public_html/forums
[Wed Aug 27 07:42:10.965450 2014] [access_compat:error] [pid 630761] [client 180.76.6.42:59139] AH01797: client denied by server configuration: /home/######/public_html/members
[Wed Aug 27 07:23:05.415854 2014] [access_compat:error] [pid 547999] [client 180.76.5.71:32206] AH01797: client denied by server configuration: /home/######/public_html/forums
[Wed Aug 27 06:53:03.258777 2014] [access_compat:error] [pid 325591] [client 180.76.6.48:39818] AH01797: client denied by server configuration: /home/######/public_html/threads
[Wed Aug 27 06:35:26.312171 2014] [access_compat:error] [pid 238755] [client 123.125.71.20:31821] AH01797: client denied by server configuration: /home/######/public_html/posts
[Wed Aug 27 06:01:44.108768 2014] [access_compat:error] [pid 42524] [client 180.76.5.80:37507] AH01797: client denied by server configuration: /home/######/public_html/forums
[Wed Aug 27 05:57:17.074116 2014] [access_compat:error] [pid 1040046] [client 220.181.108.101:27196] AH01797: client denied by server configuration: /home/######/public_html/categories
[Wed Aug 27 05:53:04.093031 2014] [access_compat:error] [pid 1021716] [client 180.76.5.20:39012] AH01797: client denied by server configuration: /home/######/public_html/members
[Wed Aug 27 05:38:04.440507 2014] [access_compat:error] [pid 920599] [client 180.76.6.157:55366] AH01797: client denied by server configuration: /home/######/public_html/members
[Wed Aug 27 05:31:44.132137 2014] [access_compat:error] [pid 910799] [client 180.76.5.62:63652] AH01797: client denied by server configuration: /home/######/public_html/posts
[Wed Aug 27 05:23:57.506262 2014] [access_compat:error] [pid 822184] [client 220.181.108.149:42400] AH01797: client denied by server configuration: /home/######/public_html/forums
[Wed Aug 27 05:23:03.922180 2014] [access_compat:error] [pid 823252] [client 180.76.5.146:17294] AH01797: client denied by server configuration: /home/######/public_html/categories
[Wed Aug 27 05:03:39.373786 2014] [access_compat:error] [pid 723913] [client 123.125.71.16:14687] AH01797: client denied by server configuration: /home/######/public_html/posts
[Wed Aug 27 05:01:44.187783 2014] [access_compat:error] [pid 716358] [client 180.76.5.95:14268] AH01797: client denied by server configuration: /home/######/public_html/forums
[Wed Aug 27 05:01:39.972032 2014] [access_compat:error] [pid 717607] [client 106.120.173.72:59565] AH01797: client denied by server configuration: /home/######/public_html/threads
[Wed Aug 27 05:01:24.919167 2014] [access_compat:error] [pid 717067] [client 106.120.173.72:47829] AH01797: client denied by server configuration: /home/######/public_html/recent-activity
[Wed Aug 27 05:01:20.728416 2014] [access_compat:error] [pid 719462] [client 106.120.173.72:58201] AH01797: client denied by server configuration: /home/######/public_html/robots.txt
[Wed Aug 27 04:53:03.861034 2014] [access_compat:error] [pid 643702] [client 180.76.5.71:31072] AH01797: client denied by server configuration: /home/######/public_html/posts
[Wed Aug 27 04:23:11.459624 2014] [access_compat:error] [pid 453916] [client 180.76.5.171:40780] AH01797: client denied by server configuration: /home/######/public_html/threads
[Wed Aug 27 04:16:44.232381 2014] [access_compat:error] [pid 429273] [client 180.76.5.167:41512] AH01797: client denied by server configuration: /home/######/public_html/members
[Wed Aug 27 04:11:33.023305 2014] [access_compat:error] [pid 418756] [client 220.181.108.84:52283] AH01797: client denied by server configuration: /home/######/public_html/threads
[Wed Aug 27 03:53:03.292275 2014] [access_compat:error] [pid 265089] [client 180.76.5.177:19969] AH01797: client denied by server configuration: /home/######/public_html/forums
[Wed Aug 27 03:46:44.173942 2014] [access_compat:error] [pid 238887] [client 180.76.6.62:57849] AH01797: client denied by server configuration: /home/######/public_html/goto
[Wed Aug 27 03:46:17.821066 2014] [access_compat:error] [pid 225396] [client 123.125.71.57:21978] AH01797: client denied by server configuration: /home/######/public_html/posts
[Wed Aug 27 02:53:55.020484 2014] [access_compat:error] [pid 938298] [client 180.76.5.173:10621] AH01797: client denied by server configuration: /home/######/public_html/threads
[Wed Aug 27 02:43:08.511418 2014] [access_compat:error] [pid 813927] [client 220.181.108.85:17895] AH01797: client denied by server configuration: /home/######/public_html/forums
[Wed Aug 27 02:21:20.856159 2014] [access_compat:error] [pid 740600] [client 23.238.18.119:62716] AH01797: client denied by server configuration: /home/######/public_html/forums,
[Wed Aug 27 02:15:27.810566 2014] [access_compat:error] [pid 700731] [client 180.76.6.53:14781] AH01797: client denied by server configuration: /home/######/public_html/members
[Wed Aug 27 02:07:29.178201 2014] [access_compat:error] [pid 648748] [client 180.76.6.151:59768] AH01797: client denied by server configuration: /home/######/public_html/forums
[Wed Aug 27 01:48:07.636316 2014] [access_compat:error] [pid 545718] [client 23.244.164.43:59526] AH01797: client denied by server configuration: /home/######/public_html/threads,
[Wed Aug 27 01:30:27.752145 2014] [access_compat:error] [pid 440129] [client 180.76.5.95:13570] AH01797: client denied by server configuration: /home/######/public_html/members
[Wed Aug 27 01:22:41.546874 2014] [access_compat:error] [pid 358265] [client 220.181.108.184:10978] AH01797: client denied by server configuration: /home/######/public_html/misc
[Wed Aug 27 01:22:31.193105 2014] [access_compat:error] [pid 362458] [client 180.76.5.95:60825] AH01797: client denied by server configuration: /home/######/public_html/css.php
[Wed Aug 27 01:00:27.727159 2014] [access_compat:error] [pid 246835] [client 180.76.5.190:64590] AH01797: client denied by server configuration: /home/######/public_html/goto
[Wed Aug 27 00:36:14.726439 2014] [access_compat:error] [pid 73684] [client 180.76.5.81:30722] AH01797: client denied by server configuration: /home/######/public_html/css.php
[Wed Aug 27 00:22:49.265759 2014] [access_compat:error] [pid 1036467] [client 23.232.133.243:36050] AH01797: client denied by server configuration: /home/######/public_html/login,
[Wed Aug 27 00:22:48.610323 2014] [access_compat:error] [pid 1034606] [client 23.232.133.243:36878] AH01797: client denied by server configuration: /home/######/public_html/login,
All the ip's seems to be from china Baidu spider.

I added this to my htacces and help a couple of days .


Code:
RewriteEngine On
RewriteCond %{HTTP_USER_AGENT} Baiduspider [NC]
RewriteRule .* - [F,L]
RewriteCond %{HTTP_USER_AGENT} ^Baiduspider.* [NC]
:oops: need help.
 
Last edited:

Mike

XenForo developer
Staff member
#2
Fundamentally, this indicates that you're getting table corruption. If it's happening consistently, you need to talk to your hose about it (assuming this is a shared host). Table corruption generally indicates that MySQL is being shut down incorrectly or that there's some sort of hardware issue.