FUDforum: Bug Reports » New web server, try to install 3.0.0 / clearos 5.2

Home » FUDforum Development » Bug Reports » New web server, try to install 3.0.0 / clearos 5.2 (backup)

Show: Today's Messages :: Polls :: Message Navigator

Is this a bug? [message #164183 is a reply to message #164054]

Sat, 08 January 2011 01:26

The Witcher

Messages: 675
Registered: May 2009
Location: USA

Karma:

Senior Member

Is this a bug? Several times trying to restore 3.0.2 data dumps I get the same error, now I got it while attempting a restore from a FUDforum2Go dump.

Fatal error: Uncaught exception 'Exception' with message '(/home/username/testforum/include/theme/default/db.inc:75<br /> /home/username/testforum/include/dbadmin.inc:417<br /> /home/username/testforum.com/adm/admimport.php:224<br /> ) 1061: Duplicate key name 'fud30_tv_1_i_t'<br /> Query: ALTER IGNORE TABLE fud30_tv_1 ADD UNIQUE fud30_tv_1_i_t (thread_id)<br /> _POST: array ( 'S' =&gt; 'be9e01e75bf017d9f9ea84c4551e8ecd', 'SQ' =&gt; '0e0fd37ccf3ceg49977346639ca9e5e8', 'path' =&gt; '/home/username/testforum/tmp/FUDforum_07_01_2011_06_54.fud.gz', 'btn_submit' =&gt; 'Import Data', )<br /> Database version: 5.1.39-log<br /> [Referring Page] http://testforum.com/adm/admimport.php?S=be9e01ec9bf017d9f9ea2154551e8ecd&amp;SQ=0e0fd37ccf3ca249977346639ca9e5e8<br /> ' in /home/username/testforum/include/core.inc:215 Stack trace: #0 /home/username/testforum/include/theme/default/db.inc(75): fud_sql_error_handler() #1 /home/username/testforum/include/dbadmin.inc(417): q('ALTER IGNORE TA...', 'Duplicate key n...', 1061, '5.1.39-log') #2 /home/username/testforum.com/adm/admimport.php(224): create_index('ALTER IGNORE TA...') #3 {main} thrown in /home/username/testforum/include/core.inc on line 215

If you attempt to return to the forum you get: "FATAL ERROR: No session, cannot update status!" And a check of the SQL shows that there are nolonger any users installed!

Your earlier solution to delete duplicate table and run upgrade worked but there were some problems with making sure the users table was valid see (New web server http://fudforum.org/forum/index.php?t=msg&th=119768&goto=164054& ;#msg_164054).

So is this a bug or just errant behavior from switching servers and upgrading at the same time?

I will try and narrow it down better.

I still have a few copies I need to move so I'm sure I will encounter it again.

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

Report message to a moderator

[Message index]

		New web server, try to install 3.0.0 / clearos 5.2 By: kongarne on Sat, 01 January 2011 10:29
		Re: New web server By: Ernesto on Sat, 01 January 2011 11:02
		Re: New web server By: kongarne on Sat, 01 January 2011 11:32
		Re: New web server By: Ernesto on Sat, 01 January 2011 11:52
		Re: New web server By: kongarne on Sat, 01 January 2011 12:33
		Re: New web server By: kongarne on Sat, 01 January 2011 14:34
		Re: New web server By: naudefj on Sat, 01 January 2011 17:02
		Re: New web server By: kongarne on Sun, 02 January 2011 07:41
		Re: New web server By: kongarne on Sun, 02 January 2011 09:36
		Re: New web server By: naudefj on Sun, 02 January 2011 12:09
		Re: New web server By: The Witcher on Sun, 02 January 2011 12:36
		Re: New web server By: kongarne on Sun, 02 January 2011 14:03
		Is this a bug? By: The Witcher on Sat, 08 January 2011 01:26
		Re: Is this a bug? By: kongarne on Mon, 31 January 2011 17:19
		Re: Is this a bug? By: Ernesto on Tue, 01 February 2011 03:33
		Re: Is this a bug? By: kongarne on Tue, 01 February 2011 04:02
		Re: Is this a bug? By: Ernesto on Tue, 01 February 2011 04:19
		Re: Is this a bug? By: kongarne on Tue, 01 February 2011 04:38
		Re: Is this a bug? By: Ernesto on Tue, 01 February 2011 05:17
		Re: Is this a bug? By: naudefj on Sun, 17 July 2011 06:24

Previous Topic:	3.0.2 typo on fudapi.inc.php
Next Topic:	Import forum data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 09 16:05:45 GMT 2024

Total time taken to generate the page: 0.04324 seconds