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 :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
Backup/restore fails 3.0.3RC1 (FIXED) [message #165851] Wed, 17 August 2011 17:36 Go to next message
The Witcher is currently offline  The Witcher   United States
Messages: 662
Registered: May 2009
Location: USA
Karma: 2
Senior Member
add to buddy list
ignore all messages by this user
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 15:40]

Report message to a moderator

Re: Backup/restore fails 3.0.3RC1 [message #165912 is a reply to message #165851] Tue, 23 August 2011 03:24 Go to previous messageGo to next message
The Witcher is currently offline  The Witcher   United States
Messages: 662
Registered: May 2009
Location: USA
Karma: 2
Senior Member
add to buddy list
ignore all messages by this user
Deleted fud30_tv_1
Ran 3.0.3RC1 upgrade script,
Applied revisions 5352-5361 including compact.php fix'

Ran Forum Consistency, Rebuild Search Index, Rebuild Messages OK
Created data dump, - restored data dump to fresh install

Fatal error: Uncaught exception 'Exception' with message

(/home/user/FUDforum/include/theme/default/db.inc:104
/home/user/FUDforum/include/dbadmin.inc:592
/home/user/localareaforums.com/adm/admimport.php:223
) 1061: Duplicate key name 'fud30_tv_1_seq'
Query: ALTER IGNORE TABLE fud30_tv_1 ADD INDEX fud30_tv_1_seq (seq)
_POST: array ( 'SQ' => '7d8dc4812d374c1daf9c5d0e437b52be', 'path' => '/home/user/FUDforum/tmp/FUDforum_23_08_2011_01_14.fud.gz', 'btn_submit' => 'Import Data', )
Database version: 5.1.53-log
[Referring Page] http://Domain.name/adm/admimport.php?&SQ=7d8dc4812d374c1daf9c5d0e437b52be


Ran Forum Consistency, Rebuild Search Index, Rebuild Messages ALL OK, with the exception of custom header image, and forum icons missing everything appears normal.

Was rinse repeat.... Same, same.,,,, Any ideas?



"I'm a Witcher, I solve human problems; not always using a sword!"
Re: Backup/restore fails 3.0.3RC1 [message #165915 is a reply to message #165912] Tue, 23 August 2011 06:37 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3678
Registered: December 2004
Karma: 19
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
You need the patches for dbadmin.inc as well.
Re: Backup/restore fails 3.0.3RC1 [message #165917 is a reply to message #165915] Tue, 23 August 2011 15:40 Go to previous message
The Witcher is currently offline  The Witcher   United States
Messages: 662
Registered: May 2009
Location: USA
Karma: 2
Senior Member
add to buddy list
ignore all messages by this user
naudefj wrote on Tue, 23 August 2011 05:37
You need the patches for dbadmin.inc as well.

Success! Applied rev 5351 to source and target forum, dumped source and restored to target, restore process completed without incident.

REPEATED: Dump Restore process, all good!!!!

I was placing too much emphasis on the "1061: Duplicate key name 'fud30_tv_1_seq" and not enough attention to the 2nd half of the compact.php fix you provided!

So are there any other revisions which apply to 3.0.3RC1 I currently have most recent upgrade, and revisions 5351 through 5361 applied.

UPDATE: Answered my own question, starts with 5329


"I'm a Witcher, I solve human problems; not always using a sword!"

[Updated on: Tue, 23 August 2011 18:48]

Report message to a moderator

Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
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: Wed Sep 19 11:37:06 EDT 2018

Total time taken to generate the page: 0.00730 seconds