DiscuzÊý¾Ý¿âsecurity_failedlog´íÎó¼°ÐÞ¸´

ËùÓöÎÊÌâÏÖÏó£º

Discuz! Database Error(144) Table ¡®.\bbsdata\security_failedlog¡¯ is marked as crashed and last (automatic?) repair failedDELETE FROM security_failedlog WHERE pid = 0 AND tid = 0 AND uid = 0 OR lastfailtime = 0 OR failcount >= 10 PHP Debug No.FileLineCode 1index.php126require(%s) 2forum.php53runhooks() 3source/function/function_core.php1064hookscript(%s, %s, %s, Array, %s) 4source/function/function_core.php1110plugin_security->common(Array) 5source/plugin/security/security.class.php45plugin_security->_reportLoginUser(Array) 6source/plugin/security/security.class.php233plugin_security->_retryReport() 7source/plugin/security/security.class.php294Cloud_Service_Security->retryReportData() 8api/manyou/Service/Security.php521table_security_failedlog->deleteDirtyLog() 9source/plugin/security/table/table_security_failedlog.php27discuz_database::delete(%s, %s) 10source/class/discuz/discuz_database.php48discuz_database::query(%s, %s) 11source/class/discuz/discuz_database.php136db_driver_mysql->query(%s, false, true) 12source/class/db/db_driver_mysql.php151db_driver_mysql->halt(%s, %d, %s) 13source/class/db/db_driver_mysql.php218break()

• 
  
  
• ºÎΪpre_security_failedlog£º
  pre_security_failedlog£º·Àˮǽʧ°ÜÈÕÖ¾¼Ç¼¡£
  
  
  
  
• 
  ½â¾ö·½°¸Ò»£º
  Ö±½Ó¹Ø±Õ·Àˮǽ£¨Öα겻Öα¾£©
  ÓÉÓÚÕâÊDzå¼þ·ÀˮǽµÄÔµ¹Ê£¬×î¼òµ¥µÄ¾ÍÊǽøÈëºǫ́¹Øµô¡£µ«ÕâÖ»Öα겻Öα¾£¬×îºÃÈ¥Êý¾Ý¿âÐÞ¸´Ò»Ï¡£Èô²»ÐÞ¸´£¬ÔÚ¸üÐÂÂÛ̳°æ±¾Ê±»áÌáʾÈçÏ£º
  
  
  
  
• 
  ½â¾ö·½°¸¶þ£ºÐÞ¸´»òÖؽ¨security_failedlog±í£¨´Ë´¦Ö»Ð´Öؽ¨±í£©
  ½øÈëmysqlÊý¾Ý¿â
  ɾ³ý±ípre_security_failedlog£ºDROP TABLE  pre_security_failedlog;
  ÏÂÃæ Õâ¸öÒ²¿ÉÒÔ£¬Ö»ÊÇÎҵĵ±³õÒѾ­È·¶¨´æÔÚÁË£¬¾ÍÖ±½ÓÓõÄÉÏÃæµÄ
  
  1. DROP TABLE IF EXISTS pre_security_failedlog;

  ¸´ÖÆ´úÂë
  
  Öؽ¨±í
  
  1. CREATE TABLE pre_security_failedlog ( id int(11) NOT NULL
     
  2. 
     
  3. 
     
  4. 
     
  5. AUTO_INCREMENT, reporttype char(20) NOT NULL, tid int(10)
     
  6. 
     
  7. 
     
  8. 
     
  9. unsigned NOT NULL DEFAULT '0', pid int(10) unsigned NOT NULL
     
  10. 
      
  11. 
      
  12. 
      
  13. DEFAULT '0', uid int(10) unsigned NOT NULL DEFAULT '0',
      
  14. 
      
  15. 
      
  16. 
      
  17. failcount int(10) unsigned NOT NULL DEFAULT '0', createtime int
      
  18. 
      
  19. 
      
  20. 
      
  21. (10) unsigned NOT NULL DEFAULT '0', posttime int(10) unsigned
      
  22. 
      
  23. 
      
  24. 
      
  25. NOT NULL DEFAULT '0', delreason char(255) NOT NULL, scheduletime
      
  26. 
      
  27. 
      
  28. 
      
  29. int(10) unsigned NOT NULL DEFAULT '0', lastfailtime int(10)
      
  30. 
      
  31. 
      
  32. 
      
  33. unsigned NOT NULL DEFAULT '0', extra1 int(10) unsigned NOT NULL,
      
  34. 
      
  35. 
      
  36. 
      
  37. extra2 char(255) NOT NULL DEFAULT '0', PRIMARY KEY (id), KEY pid
      
  38. 
      
  39. 
      
  40. 
      
  41. (pid), KEY uid (uid) ) ENGINE=MYISAM DEFAULT CHARSET=gbk

  ¸´ÖÆ´úÂë
  
  
  
  
  
• 
  ÐÞ¸´±íµÄ¹ý³Ì¾Í²»ÔÙдÁË£¬ÓÐÐËȤµÄÅóÓÑÃÇ¿ÉÒÔ×Ô¼ºÌ½Ë÷Ï¡££¨ÆäʵҲºÜ¼òµ¥£©
  
  
  
  
•