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

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
Return to the default flat view Create a new topic Submit Reply
Is this a bug? [message #164183 is a reply to message #164054] Sat, 08 January 2011 01:26 Go to previous messageGo to previous message
The Witcher is currently offline  The Witcher   United States
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!"
[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: 3.0.2 typo on fudapi.inc.php
Next Topic: Import forum data
Goto Forum:
  

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

Current Time: Sat Nov 23 07:37:43 GMT 2024

Total time taken to generate the page: 0.04611 seconds