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 :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Getting major error after database restoration (....later... Not a fud issue) [message #32483] Tue, 04 July 2006 19:09 Go to previous message
ligesh is currently offline  ligesh   India
Messages: 63
Registered: July 2005
Karma:
Member
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 22:54]

Report message to a moderator

[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
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: Wed Nov 27 11:19:53 GMT 2024

Total time taken to generate the page: 0.04691 seconds