| fatal error upgrading to 3.02 [message #165522] |
Sun, 10 July 2011 14:37  |
srchild
Messages: 88
Registered: December 2003
Location: UK
Karma:
|
Member |
|
|
I took a backup first 
I upgraded from 2.7.7 to 3.0.0, ran consistency checker, logged into forum, all looked ok
I started an upgrade to 3.0.2. It failed with:
Fatal error: Uncaught exception 'Exception' with message '1068: Multiple primary key defined @ ALTER IGNORE TABLE fud_index ADD PRIMARY KEY (word_id,msg_id)' in /usr/www/users/myname/web/nvug/forum/upgrade.php:99 Stack trace: #0 /usr/www/users/myname/web/nvug/FUDforum/sql/mysql/db.inc(72): fud_sql_error_handler('ALTER IGNORE TA...', 'Multiple primar...', 1068, '5.0.45-log') #1 /usr/www/users/myname/web/nvug/FUDforum/include/dbadmin.inc(225): q('ALTER IGNORE TA...') #2 /usr/www/users/myname/web/nvug/forum/upgrade.php(911): create_primary_key('fud_index', 'word_id,msg_id') #3 {main} thrown in /usr/www/users/myname/web/nvug/forum/upgrade.php on line 99
I restarted it a couple of times, but it failed at same point.
Looked at table fud_index and it did indeed have a primary key already, on id. fud seems to be wanting to change that to something else, so I deleted the primary key on id and ran the upgrade again - failed at same point.
So I put the primary key back on id (using heidisql) and commented out line 911 in upgrade.php and then it completed OK.
Currently the consistency checker is running - it has been running much longer than usual and it at the stage of 'Checking search indexes'. Not sure whether it has hung, or whether it is just doing a large task (fud_index is 7million rows, 300Mb).
Why the above error?
What should I do to fix it?
Does it matter that I commented out that index update...
Simon Child
[Updated on: Sun, 10 July 2011 14:46] Report message to a moderator |
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]