FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.
Home » FUDforum » How To » all posts gone!
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
all posts gone! [message #31337] Tue, 18 April 2006 13:14 Go to next message
curtis is currently offline  curtis   United States
Messages: 29
Registered: November 2002
Karma: 0
Junior Member
My forum has gone blank: an old structure of forums and categories appear with NO posts. I tried checking and repairing the database via my host's cpanel with the same result. I am able to log on to the forum as admin and access the admin control panel. Should I run the forum consistency function (I'm afraid to do too much until I know what I SHOULD do)? Any help greatly appreciated.

Forum is (WAS!) at http://www.coastguides.com/forum/index.php?channel=coastguides.com

In admin control panel error messages, I get many errors that read similar to this, starting on the 12th:

(t=getfile&id=22&rid=&S=07c2f9360ded5050e4e84e462a0bac4e) 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Query: SELECT * FROM fud23_group_cache WHERE user_id=0 AND resource_type='forum' AND resource_id=
Server Version: 4.1.18-standard

[Updated on: Tue, 18 April 2006 13:46]

Report message to a moderator

Re: all posts gone! [message #31342 is a reply to message #31337] Tue, 18 April 2006 13:54 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
Try running the consistency checker, it is a fairly safe action to take.

FUDforum Core Developer

Report message to a moderator

Re: all posts gone! [message #31351 is a reply to message #31342] Tue, 18 April 2006 14:44 Go to previous messageGo to next message
curtis is currently offline  curtis   United States
Messages: 29
Registered: November 2002
Karma: 0
Junior Member
Hi Illia,

Thank you. I ran the consistency check, and now post appear but only posts up to 2002 and in a forum/category structure from that period. I'm particulary worried about these lines in the consistency check, which sounds like a deletion of all the entries from 2002 forward:

Checking read table against users
1654 entries unmatched, deleted
Checking read table against topics/messages
235 entries unmatched, deleted
Checking file attachments against messages
160 Bad Attachments removed

Report message to a moderator

Re: all posts gone! [message #31355 is a reply to message #31351] Tue, 18 April 2006 19:43 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
The big deletions occured from the "read" table, which is fine it won't affect message removal. This table is used to store read/unread indicators for messages. The entries removed didn't have associated messages/topics to them.

FUDforum Core Developer

Report message to a moderator

Re: all posts gone! [message #31360 is a reply to message #31355] Tue, 18 April 2006 22:46 Go to previous messageGo to next message
curtis is currently offline  curtis   United States
Messages: 29
Registered: November 2002
Karma: 0
Junior Member
Thank you for your help. That's a huge relief! But I still need to reserect my forum to include all messages up to present. What's the next step?

Report message to a moderator

Re: all posts gone! [message #31363 is a reply to message #31360] Tue, 18 April 2006 22:58 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
The newer posts, were they in a specific forum or all over?

FUDforum Core Developer

Report message to a moderator

Re: all posts gone! [message #31373 is a reply to message #31363] Wed, 19 April 2006 13:03 Go to previous messageGo to next message
curtis is currently offline  curtis   United States
Messages: 29
Registered: November 2002
Karma: 0
Junior Member
The newer posts were in two forums, and in a different category setup. There is a running copy of this setup through March 24, 2006 at http://www.mainecoastguide.com/forum/index.php?channel=coastguides.com

My worst case scemario is that I start from here, but I'm hoping to salvge the postings since then.

Report message to a moderator

Re: all posts gone! [message #31383 is a reply to message #31373] Wed, 19 April 2006 20:45 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
Are the forums active?

FUDforum Core Developer

Report message to a moderator

Re: all posts gone! [message #31402 is a reply to message #31383] Fri, 21 April 2006 02:23 Go to previous messageGo to next message
curtis is currently offline  curtis   United States
Messages: 29
Registered: November 2002
Karma: 0
Junior Member
Yes, both forums are active. I can log onto the one that has reverted back to 2002 and it seems as though I could post to it (but I don't want to do this and confuse the database even more).

Report message to a moderator

Re: all posts gone! [message #31421 is a reply to message #31402] Fri, 21 April 2006 14:19 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
Try to check the fud26_msg table to see if you have message in the post 2002 date range.

FUDforum Core Developer

Report message to a moderator

Re: all posts gone! [message #31456 is a reply to message #31337] Wed, 26 April 2006 13:39 Go to previous messageGo to next message
curtis is currently offline  curtis   United States
Messages: 29
Registered: November 2002
Karma: 0
Junior Member
How do I check messages in the Fud26_msg table? From the admin control panel? I don't seem to be able to open any of my forums subfolders via my FTP sopftware.

My forum statistics show no posts from 2002 onward, but the error log viewer shows errors for all the years between 2002 and present.

Report message to a moderator

Re: all posts gone! [message #31458 is a reply to message #31456] Wed, 26 April 2006 15:07 Go to previous messageGo to next message
curtis is currently offline  curtis   United States
Messages: 29
Registered: November 2002
Karma: 0
Junior Member
Here's another clue:

I couldn't access the forum files becasue they were locked. When I unlocked them via the admin control panel, I got a long list of errors like this (but the files did get unlocked):

ERROR: /home/coastgui/public_html/forum/thm/New2/tmpl/header.tmpl -> f (777)
ERROR: /home/coastgui/public_html/forum/thm/New2/images/youarehere.gif -> f (777)
ERROR: /home/coastgui/public_html/forum/include2 -> d (777)
ERROR: /home/coastgui/public_html/forum/include2/adm.inc -> f (777)
ERROR: /home/coastgui/public_html/forum/include2/announce_adm.inc -> f (777)
ERROR: /home/coastgui/public_html/forum/include2/cfg.inc -> f (777)
ERROR: /home/coastgui/public_html/forum/include2/compiler.inc -> f (777)
ERROR: /home/coastgui/public_html/forum/include2/core.inc -> f (777)

Report message to a moderator

Re: all posts gone! [message #31509 is a reply to message #31456] Tue, 02 May 2006 01:07 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
This is a MySQL table, so you can use any mysql client to access its contents.

FUDforum Core Developer

Report message to a moderator

  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: where are my thread message bodies stored?
Next Topic: Change Forum display style
Goto Forum:
  

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

Current Time: Sun Nov 10 12:56:17 GMT 2024

Total time taken to generate the page: 0.02857 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.1.3.
Copyright ©2001-2023 FUDforum Bulletin Board Software