FUDforum: FUDforum Installation Issues » Backup/restore fails 3.0.3RC1 (FIXED)

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

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: 3

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

Re: Backup/restore fails 3.0.3RC1 [message #165912 is a reply to message #165851]

Tue, 23 August 2011 07:24

The Witcher

Messages: 675
Registered: May 2009
Location: USA

Karma: 3

Senior Member

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!"

Report message to a moderator

Re: Backup/restore fails 3.0.3RC1 [message #165915 is a reply to message #165912]

Tue, 23 August 2011 10:37

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

You need the patches for dbadmin.inc as well.

Report message to a moderator

Re: Backup/restore fails 3.0.3RC1 [message #165917 is a reply to message #165915]

Tue, 23 August 2011 19:40

The Witcher

Messages: 675
Registered: May 2009
Location: USA

Karma: 3

Senior Member

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 22:48]

Report message to a moderator

Previous Topic:	db_version missing with upgrade for 3.0.3rc1
Next Topic:	Analytics

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 03 07:28:07 GMT 2024

Total time taken to generate the page: 0.02905 seconds