| 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: 0
|
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 |
|
|
|
|
|
|
|
| Re: Getting major error after database restoration [message #32489 is a reply to message #32488] |
Tue, 04 July 2006 19:52  |
ligesh
Messages: 63
Registered: July 2005
Karma: 0
|
Member |
|
|
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 19: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 22:52 |
ligesh
Messages: 63
Registered: July 2005
Karma: 0
|
Member |
|
|
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.;
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]