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

Home » General » Database discussions » table fud28_ses missing issue
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
table fud28_ses missing issue [message #162490] Fri, 21 May 2010 20:02 Go to next message
quatrevingt is currently offline  quatrevingt
Messages: 10
Registered: May 2010
Karma: 0
Junior Member
Hello,

My forum is locked and its impossible to access user interface.
In SQL logs, the last error I see is:
...
) no such table: fud28_ses: HY000<br />
Query: INSERT INTO fud28_ses (ses_id, time_sec, sys_id, user_id) VALUES ('18f668f0c86d9a5701277b83010d48d0', 1274468785, 'd1dade0d4f0d59fd241f62e057dd6b14', 2024541229)<br />
Server Version: 3.3.6<br />

What exactly is that table, and how could it suddenly disappear? Any suggestions how to put is back to life very welcome:)

Thank you in advance.
Re: table fud28_ses missing issue [message #162499 is a reply to message #162490] Sun, 23 May 2010 07:01 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
FUDforum won't drop your tables!

Please check our MySQL logs for errors or ask for assistance on a MySQL forum.

BTW: You can simply recreate the table or restore it from a backup. The data in it is used to maintain sessions and can be removed.
Re: table fud28_ses missing issue [message #162788 is a reply to message #162499] Fri, 16 July 2010 15:14 Go to previous messageGo to next message
quatrevingt is currently offline  quatrevingt
Messages: 10
Registered: May 2010
Karma: 0
Junior Member
hello, still struggling with upgrade.

getting quite desperate with this:

-Fatal error: SQL Error has occurred;
-miraculously, forum.db.php got empty, substituting with one from 3.0 does not help;
-upgrade to 3.0 does not work (says php memory is exceeded 8mb, although we have 16limit on the server);
-restoring to 3.0 from 2.8 dump will not work;
-cannot find 2.8 installation anymore to install from scratch and load data in it;

any help greatly appreciated!
Re: table fud28_ses missing issue [message #162789 is a reply to message #162788] Sat, 17 July 2010 02:05 Go to previous message
quatrevingt is currently offline  quatrevingt
Messages: 10
Registered: May 2010
Karma: 0
Junior Member
update

i found 2.8 installation, but restore will not work, it says "Fatal error: Call to a member function fetchAll() on a non-object in...".
Is there a way to manually migrate messages from the old corrupt forum? (there is no forum.db.php)
I have a structure dump (backup in fud.gz, which will not restore), is it possible to get something out from that archive?

thank you in advance
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: MySQL error when importing NNTP message
Next Topic: Error Message
Goto Forum:
  

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

Current Time: Thu Nov 21 11:23:39 GMT 2024

Total time taken to generate the page: 0.01945 seconds