FUDforum: Bug Reports » Getting major error after database restoration (....later... Not a fud issue)

Home » FUDforum Development » Bug Reports » Getting major error after database restoration (....later... Not a fud issue)

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

Getting major error after database restoration (....later... Not a fud issue) [message #32483]

Tue, 04 July 2006 19:09

ligesh

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]

		Getting major error after database restoration (....later... Not a fud issue) By: ligesh on Tue, 04 July 2006 19:09
		Re: Getting major error after database restoration By: Ilia on Tue, 04 July 2006 19:28
		Re: Getting major error after database restoration By: ligesh on Tue, 04 July 2006 19:35
		Re: Getting major error after database restoration By: ligesh on Tue, 04 July 2006 19:52
		Re: Getting major error after database restoration By: ligesh on Tue, 04 July 2006 22:52

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) ] [

]

Current Time: Tue Nov 26 10:53:35 GMT 2024

Total time taken to generate the page: 0.31581 seconds