Deploying Zen Trails Database Error

Source: Internet
Author: User

A fault description

After you deploy Zen trails, you cannot sign in to the page. Have the following error message:

60507 17:03:49 [ERROR]/opt/zbox/run/mysql/mysqld:table './zentao/zt_group ' is marked as crashed and last (automatic?) re Pair failed

Zen Road All database tables are the MyISAM storage engine used, and the MyISAM storage engine can easily cause database tables to crash.


Ii. Solutions


Stop MySQL, and then use Myisamchk to check the Zt_group database file Zt_group for this table. MYI

Myisamchk is MySQL's own MyISAM storage engine inspection and Repair tool

# myisamchk zt_group. Myichecking myisam file: zt_group. myidata records:      11   deleted blocks:        0myisamchk: warning: table is marked as crashed  and last repair failed- check file-sizemyisamchk: warning: Size  of datafile is: 416              Should be: 380- check record delete-chain- check key  delete-chain- check index reference- check data record references  Index: 1- check record linksmyisamchk: error: keypointers and record  POSITIONS DOESN ' t matchmyisamchk: warning: found          13 key parts. should be: 11myisam-table  ' Zt_group. MYI '  is corruptedFix it using switch  "-r"  or  "-O"
# myisamchk-r-o-f Zt_group. Myi-recovering (with Keycache) myisam-table ' Zt_group. MYI ' Data records:11


Reboot to start MySQL, then you can log into Zen road.





Reference Documentation:

Http://www.thinkphp.cn/code/430.html


This article is from the Linux SA John blog, so be sure to keep this source http://john88wang.blog.51cto.com/2165294/1771043

Deploying Zen Trails Database Error

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.