|
fatal error: sql error... [message #23221 is a reply to message #23219] |
Wed, 09 March 2005 11:39 |
tufan
Messages: 70 Registered: June 2002
Karma: 0
|
Member |
|
|
I found a copy of the files, and now I get:
Fatal error: SQL Error has occurred, please contact the administrator of the forum and have them review the forum's SQL query log in /home/one9org/public_www/forum/index.php on line 59
sql_errors gives:
(/home/one9org/public_www/forum/index.php:246<br />
/home/one9org/public_www/forum/index.php:337<br />
/home/one9org/public_www/forum/index.php:957<br />
/home/one9org/public_www/forum/index.php:1126<br />
) 1146: Table 'one9org_fud.fud2_ses' doesn't exist<br />
Query: INSERT INTO fud2_ses (ses_id, time_sec, sys_id, user_id) VALUES ('4feb16281fcf951c51e5c749e0cc17a3', 1110363052, 'a357f41898b655e549227aa4374ebf43', 2005231820)<br />
Server Version: 4.0.23-standard<br />
[Referring Page] http://19.org/?tr<br />
But fud2_ses does exist, although I emptied it, a try upon some of the messages I saw in the forum.
{Edit}
Upon checking with command line mysql util, I noticed that really some of the tables don't show up, so it seems there are some (configuration?) problems with the hosting.
[Updated on: Wed, 09 March 2005 11:56] Report message to a moderator
|
|
|
Re: fatal error: sql error... [message #23223 is a reply to message #23221] |
Wed, 09 March 2005 14:21 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
If some tables do not exist it looks like your hoster has somehow 'lost' them. The upgrade script can be used to re-create them, but the data that was in those tables would be lost.
FUDforum Core Developer
|
|
|
Re: fatal error: sql error... [message #23226 is a reply to message #23223] |
Wed, 09 March 2005 17:16 |
tufan
Messages: 70 Registered: June 2002
Karma: 0
|
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 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 ?
I'll try (as a last action), installing a fresh copy of fudforum, and importing tables one-by-one
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'
|
|
|
|
Re: fatal error: sql error... [message #23323 is a reply to message #23231] |
Sat, 12 March 2005 13:33 |
tufan
Messages: 70 Registered: June 2002
Karma: 0
|
Member |
|
|
Hi Ilia,
Interesting, they did something and phpMyAdmin began showing the half of the database too.
Fortunately, I took a backup of db before they did what they did.
I inserted that backup into my MySQL, copied the forum files from the server to my server, changed GLOBALS.php to adjust directories, and voila! Currently, I have one running copy of the forum with no messages lost except the last 5 messages, which I guess were posted when the problem first appeared.
Currently, it's simply moving the forum from one server to another using FUDforum's own data dump, which we did in the past once with no serious problems. But first, we must find a working database server
Quote: | try doing REPAIR [table_name] on the "missing" tables.
|
I tried doing that when the phpMyAdmin showed good copy of the db, but didn't work. I guess it operated on a different db server. I create a db using mysqladmin and it doesn't show up in phpMyAdmin/cpanel and vice versa.
I decide to no longer wait for them, and began searching for a new hosting company. And if you don't mind, let me tell that they're bluehost.com, so that people can avoid signing up with them nowadays.
Oh, and thanks for your help. You helped more than the sys.admins of the hoster.
cya,
tiu
|
|
|