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

Home » FUDforum Development » Bug Reports » Getting major error after database restoration (....later... Not a fud issue)
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
Getting major error after database restoration (....later... Not a fud issue) [message #32483] Tue, 04 July 2006 15:09 Go to next message
ligesh is currently offline  ligesh   India
Messages: 63
Registered: July 2005
Karma: 0
Member
add to buddy list
ignore all messages by this user
Addendum:
The problem turned out to be with teh way i took the backup, and did not have anything to do with fud. Please read my last message .

Thanks.
======================


Hi,
mY fudforum is giving me this error, after i restored the database alone from another website. i had restored the files also some time back, but i think there was a small difference in the times of the backups fo the files and teh database, and now when i try to make a post, i get this error.


---------------------------
/www/forum/theme/lxtheme/post.php:2830
/www/forum/theme/lxtheme/post.php:1636
/www/forum/theme/lxtheme/post.php:3829
www/forum/index.php:1178
) 1062: Duplicate entry '3-2147483645-0' for key 1
Query: INSERT INTO fud26_thread_view (thread_id,forum_id,page) SELECT fud26_thread.id, 3, 2147483645 FROM fud26_thread INNER JOIN fud26_msg ON fud26_thread.root_msg_id=fud26_msg.id WHERE forum_id=3 AND fud26_msg.apr=1 ORDER BY (CASE WHEN thread_opt>=2 AND (fud26_msg.post_stamp+fud26_thread.orderexpiry>1152039892 OR fud26_thread.orderexpiry=0) THEN 4294967294 ELSE fud26_thread.last_post_date END) DESC, fud26_thread.last_post_id DESC

---------------------------

Could anybody help me please. My live forum has screwed up because of this.

Thanks a lot in advance.

[Updated on: Tue, 04 July 2006 18:54]

Report message to a moderator

Re: Getting major error after database restoration [message #32484 is a reply to message #32483] Tue, 04 July 2006 15:28 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
What version of the forum are you running? Have you tried running the consistency checker?

FUDforum Core Developer
Re: Getting major error after database restoration [message #32488 is a reply to message #32483] Tue, 04 July 2006 15:35 Go to previous messageGo to next message
ligesh is currently offline  ligesh   India
Messages: 63
Registered: July 2005
Karma: 0
Member
add to buddy list
ignore all messages by this user
]
Thanks for the reply.

i ran it and i got the same error at "building topic views".


--------
062: Duplicate entry '1-2147483645-0' for key 1
Query: INSERT INTO fud26_thread_view (thread_id,forum_id,page) SELECT fud26_thread.id, 1, 2
---------------

I am using a slightly older version fudforum. 2.6.11

Thanks.

[Updated on: Tue, 04 July 2006 15:36]

Report message to a moderator

Re: Getting major error after database restoration [message #32489 is a reply to message #32488] Tue, 04 July 2006 15:52 Go to previous messageGo to next message
ligesh is currently offline  ligesh   India
Messages: 63
Registered: July 2005
Karma: 0
Member
add to buddy list
ignore all messages by this user

OK,

i got an older copy of the database, and it now works fine, and i got a clean bill from the consistency checker too.

But i would really like to know what was the cause of this. Isn't restoring the database enough for fudforum; like in the case of most of the php applications. i have heard that fud uses a file to store the messages, but is that really necessary. i mena, is the efficiency increase so high as to make it almost impossible to easily restore a fud to some pre-existing state?

Thanks.

[Updated on: Tue, 04 July 2006 15:53]

Report message to a moderator

Re: Getting major error after database restoration [message #32491 is a reply to message #32489] Tue, 04 July 2006 18:52 Go to previous message
ligesh is currently offline  ligesh   India
Messages: 63
Registered: July 2005
Karma: 0
Member
add to buddy list
ignore all messages by this user


Sorry, the problem was not with fudforum. When i took the backup using mysqldump, i used --compabible323 option, which seems to have screwed up the db structure, and and that's why fud was complaining.

I took a backup with the --compatible, and restored, and the consistency checker said it was fine.

i apologize for the false alarm.

Thanks.;
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: loosing lang parameters in wikipedia tag
Next Topic: Show own posts - tab doesn't show as active (V2.7.5)
Goto Forum:
  

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

Current Time: Fri Sep 20 21:19:59 EDT 2019

Total time taken to generate the page: 0.00640 seconds