Intermediary transaction http://www.aliyun.com/zixun/aggregation/6858.html ">seo diagnose Taobao guest stationmaster buy cloud host technology Hall
Yesterday put one of my DZ forum from X2 upgrade to X2.5 there was a problem, upgrade into a dead loop, specific tips as follows:
update.php?step=waitingdb&nextstep=prepare& sql[]=5786554789722f09b8f635c20410e507& sql[]= EE4F20B8582052367F5BEB9BD19FEA58] is upgrading the data, please later ...
[Time-long]:113[state]:copy to TMP table[information]:alter table pre_forum_post ORDER by PID ASC
[Time-long]:113[state]:locked[information]:alter TABLE pre_forum_post change ' pid ' pid ' INT (a) UNSIGNED not NULL, change ' replycredit ' rep Lycredit ' int ' not NULL default ' 0 ', change ' status ' status ' int (ten) NOT null default ' 0 ', ADD UNIQUE KEY pid (PID), D ROP PRIMARY key, add ' position ' INT (8) UNSIGNED not NULL auto_increment, add PRIMARY KEY (' tid ', ' position '), DROP INDEX au Thorid, ADD INDEX Authorid (authorid,invisible)
(Jump ...)
DZ Official forum to find, found that many people have encountered this problem, the official did not give a solution. Since I used to upgrade DZ, I didn't care about it and didn't back up my database. Now return X2 also cannot return, can only find a way to upgrade to X2.5. Then carefully analyzed the SQL statement, found that the upgrade post data can not advance, the original reason for this. After finding out the reason, the resolute login phpadmin into the forum database. There are two databases, the first information_schema is not the forum database, the second is. Click on the Forum database to enter the table structure, pull the page to the bottom click on the full selection, and then select the Repair table selected items, then the prompt SQL statement success, and then click the full selection, select the Optimization table in the selection, prompts the SQL statement success.
The first step is done, and an important step is to delete the index.php in the install directory, the official note, many beginners do not know.
Then, after emptying the browser cache, the upgrade finds that the upgrade is successful and no longer falls into a dead loop.
Write in the last advice: DZ upgrade must back up the database, in accordance with the official instructions step-by-step operation, do not be anxious. In addition, DZ out of the new version do not rush to upgrade, such as the formal version of stability and then consider the upgrade.
Copyright: Rod's SEO Blog
This article link address: http://www.seorod.com/wzyy/29.html
Welcome reprint, reprint must indicate the link and source.