| Backup/restore fails 3.0.3RC1 (FIXED) [message #165851] |
Wed, 17 August 2011 21:36  |
The Witcher
Messages: 675
Registered: May 2009
Location: USA
Karma:
|
Senior Member |
|
|
After upgrade to 3.0.3RC1 and compact.php fix, backup/restore fails.
After upgrade to 3.0.3RC1 ran rebuild messages: Fatal error: Call to undefined method fud_page::read_pmsg_body() in /home/user/domain.name/adm/compact.php on line 263
Applied Fix. http://fudforum.org/forum/index.php?t=msg&th=120118&goto=165842& ;amp ;#msg_165842
Consistency Checker, Rebuild Search Index, OK.... Rebuild Messages .....
FUDforum (/home/ user/FUDforum/include/theme/default/db.inc:104
/home/ user/ FUDforum/include/dbadmin.inc:592
/home/ user/domain.name/adm/compact.php:249
) 1061: Duplicate key name 'fud30_pmsg_foff_idx'
Query: ALTER IGNORE TABLE fud30_pmsg ADD INDEX fud30_pmsg_foff_idx (foff)
_POST: array ( 'conf' => 'Yes', 'SQ' => '49058075200da0c5e2d29758db48048a', )
Manually deleted all PM's via SQL.
Ran: Consistency Checker, Rebuild Search Index, Rebuild Messages, All good!!!!
Performed Backup, then restored!
Fatal error: Uncaught exception 'Exception' with message '(/home/user/FUDforum/include/theme/default/db.inc:104<br /> /home/user/FUDforum/include/dbadmin.inc:592<br /> /home/user/domain.name/adm/admimport.php:223<br /> ) 1061: Duplicate key name 'fud30_tv_1_seq'<br /> Query: ALTER IGNORE TABLE fud30_tv_1 ADD INDEX fud30_tv_1_seq (seq)<br /> _POST: array ( 'S' => 'f5f7dc437cac6246c295aaa70eb8ade5', 'SQ' => 'b8370348e9f91cdda0bdb0ed7362ec6c', 'path' => '/home/user/FUDforum/tmp/FUDforum_17_08_2011_02_26.fud.gz', 'btn_submit' => 'Import Data', )<br /> Database version: 5.1.53-log<br /> [Referring Page] http://domain.name/adm/admimport.php?S=f5f7dc437cac6246c295aaa70eb8ade5&SQ=b8370348e9f91cdda0bdb0ed7362ec6c<br /> ' in /home/user/FUDforum/include/core.inc:232 Stack trace: #0 /home/user/FUDforum/include/theme/default/db.inc(104): fud_sql_error_handler() #1 /home/user/FUDforum/include/dbadmin.inc(592): q('ALTER IGNORE TA...', 'Duplicate key n...', 1061, '5.1.53-log') #2 /home/user/domain.name/adm/admimport.php(223): create_index('ALTER IGNORE TA...') #3 {main} thrown in /home/user/FUDforum/include/core.inc on line 232
REPEATED: Consistency Checker, Rebuild Search Index, Rebuild Messages, All good!!!!
Dropped fud30_tv_1 and fud30_tv_2 via SQl , REPEATED: Consistency Checker, Rebuild Search Index, Rebuild Messages, All good!!!!
Back up and restore .... Same error! I will redo the 3.0.3RC1 upgrade process and try again.
"I'm a Witcher, I solve human problems; not always using a sword!"
[Updated on: Tue, 23 August 2011 19:40] Report message to a moderator |
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]