FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » FUDforum Installation Issues » Backup/restore fails 3.0.3RC1 (FIXED) (After upgrade to 3.0.3RC1 and compact.php fix, backup/restore fails)
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Backup/restore fails 3.0.3RC1 (FIXED) [message #165851] Wed, 17 August 2011 21:36 Go to previous message
The Witcher is currently offline  The Witcher   United States
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' =&gt; 'f5f7dc437cac6246c295aaa70eb8ade5', 'SQ' =&gt; 'b8370348e9f91cdda0bdb0ed7362ec6c', 'path' =&gt; '/home/user/FUDforum/tmp/FUDforum_17_08_2011_02_26.fud.gz', 'btn_submit' =&gt; 'Import Data', )<br /> Database version: 5.1.53-log<br /> [Referring Page] http://domain.name/adm/admimport.php?S=f5f7dc437cac6246c295aaa70eb8ade5&amp;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

[Message index]
 
Read Message
Read Message
Read Message
Read Message
Previous Topic: db_version missing with upgrade for 3.0.3rc1
Next Topic: Analytics
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 12 21:22:13 GMT 2024

Total time taken to generate the page: 0.04606 seconds