1. 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

Discussion in 'Troubleshooting and Problems' started by zadow, Aug 27, 2014.

  1. zadow

    zadow Member

    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: Aug 27, 2014
  2. Mike

    Mike XenForo Developer Staff Member

    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.
     
  3. zadow

    zadow Member

    Yes its a shared host.
    Just wierd that i get the combat errror each time.
     

Share This Page