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

Home » FUDforum » How To » urgent, lost the files under forum directory :(
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Re: fatal error: sql error... [message #23226 is a reply to message #23223] Wed, 09 March 2005 17:16 Go to previous messageGo to previous message
tufan is currently offline  tufan   Turkey
Messages: 70
Registered: June 2002
Karma:
Member
Strange problem.

I can access the tables and the data using their phpMyAdmin. But fudforum says 'no fud2_ses', and i can see no tables (alphabetically) after fud2_index using mysql command line. All the tables, again alphabetically before and including fud2_index is accesible through mysql client with the command 'show tables;'.

Hosting guys said the database seems to be corrupt, so is the one in their backups, and asked me if I had any backups.

Well, I can take a backup using the phpMyAdmin NOW, because, for example I can see the data in fud2_users Smile Actually I emptied fud2_ses using phpMyAdmin interface, it contained data, fud2_users contains data, all tables have their data in place, accessible through phpMyAdmin, but not accessible through the very own client of MySQL (and fudforum).

No, there must be something wrong with either permissions, installation of MySQL or just some configuration. I mean phpMyAdmin doesn't skip MySQL server and use "direct access" methods when accessing data, does it ? Laughing

I'll try (as a last action), installing a fresh copy of fudforum, and importing tables one-by-one Rolling Eyes

But before it, I'll take a look at mysql forums, because I guess the hosting guys' only way of solution is 'restoring from backups' Rolling Eyes


http://sfx-images.mozilla.org/affiliates/Buttons/firefox2/firefox-spread-btn-1.png
[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Undeleting deleted threads
Next Topic: Issue with rdf.php and rdf_parser.php
Goto Forum:
  

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

Current Time: Fri Nov 29 13:12:32 GMT 2024

Total time taken to generate the page: 0.04206 seconds