| fatal error upgrading to 3.02 [message #165522] |
Sun, 10 July 2011 14:37  |
srchild
Messages: 88
Registered: December 2003
Location: UK
Karma: 1
|
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 |
|
|
|
|
|
|
|
| Re: fatal error upgrading to 3.02 [message #165525 is a reply to message #165524] |
Sun, 10 July 2011 16:05  |
srchild
Messages: 88
Registered: December 2003
Location: UK
Karma: 1
|
Member |
|
|
Thanks for that. I'd already aborted and started restoring from backup (into a different database and directory), but have now aborted the restore and instead trying the upgrade again.
Have removed the id column with heidisql (looks like I didn't actually remove the key before, though I thought I had) and now upgrade is rebuilding the composite index and I'll let it run.
What prompted me to restore was that after aborting the slow consistency check, my forum looked OK except it showed no posts - it showed a pager for each form, but no actual posts. But perhaps they will all come back once the consistency check completes...
Simon Child
|
|
|
|
|
|
| Re: fatal error upgrading to 3.02 [message #165527 is a reply to message #165525] |
Sun, 10 July 2011 16:24 |
srchild
Messages: 88
Registered: December 2003
Location: UK
Karma: 1
|
Member |
|
|
Same problem again further down - got past fud_index then hit:
Fatal error: Uncaught exception 'Exception' with message '1068: Multiple primary key defined @ ALTER IGNORE TABLE fud_thread_notify ADD PRIMARY KEY (user_id,thread_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(75): 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_thread_noti...', 'user_id,thread_...') #3 {main} thrown in /usr/www/users/myname/web/nvug/forum/upgrade.php on line 99
Simon Child
|
|
|
|
|
|
| Re: fatal error upgrading to 3.02 [message #165529 is a reply to message #165528] |
Sun, 10 July 2011 16:46 |
srchild
Messages: 88
Registered: December 2003
Location: UK
Karma: 1
|
Member |
|
|
And next...
Fatal error: Uncaught exception 'Exception' with message '1068: Multiple primary key defined @ ALTER IGNORE TABLE fud_title_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(75): 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_title_index', 'word_id,msg_id') #3 {main} thrown in /usr/www/users/myname/web/nvug/forum/upgrade.php on line 99
Simon Child
|
|
|
|
|
|
| Re: fatal error upgrading to 3.02 [message #165531 is a reply to message #165529] |
Sun, 10 July 2011 16:50 |
srchild
Messages: 88
Registered: December 2003
Location: UK
Karma: 1
|
Member |
|
|
The only 'non-standard' thing that I am doing, is ticking the box 'Have you manually modified FUDforum's SQL structure? (leave unchecked if unsure)' because I have added a couple of columns to fud_users.
Next:
Fatal error: Uncaught exception 'Exception' with message '1068: Multiple primary key defined @ ALTER IGNORE TABLE fud_bookmarks ADD PRIMARY KEY (user_id,thread_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(75): 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_bookmarks', 'user_id,thread_...') #3 {main} thrown in /usr/www/users/myname/web/nvug/forum/upgrade.php on line 99
Simon Child
|
|
|
|
|
|
|
|
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]