Database Error Message

[MikeCaine]

I've had a working EE on my site for a few months now

Tonight when I was browsing some photos I got the following error message

"Unable to connect to the photo database at this time
PLEASE PRESS REFRESH ON YOUR BROWSER TO TRY AGAIN.

Why do you get this error? Maybe because:

The database does not exist
The database name you try to use is wrong
The database permissions for this user have been set wrong"

I haven't changed anything

Does it seem likely that this is a problem with my host / server rather than a problem with my configuration?

[Pekka]

Ask your server provider if they have changed mysql database in any way in your account and point them to file /add/connect.php where the login info is. Try also "localhost" as server name.

[HMetal]

Ask your server provider if they have changed mysql database in any way in your account and point them to file /add/connect.php where the login info is. Try also "localhost" as server name.

Pekka, can you either modify the administration utilities so that they display the actual PHP SQL error message from mysql_error() or add a "test database connection" utility that displays the actual SQL error message from mysql_error() ?

This would probably be much more helpful a message than giving a list of possibly unrelated reasons why the operation failed.

[Pekka]

Pekka, can you either modify the administration utilities so that they display the actual PHP SQL error message from mysql_error() or add a "test database connection" utility that displays the actual SQL error message from mysql_error() ?

This would probably be much more helpful a message than giving a list of possibly unrelated reasons why the operation failed.

Yes, better reporting connect.php is attached to this post.

[MikeCaine]

Well, the first suggestion in the error report was correct, the database had totally dissapeared!

I contacted my host's support desk and they reinstalled it from a backup and all was OK again when I went to bed

When I checked it again this morning I have errors again. My snippets section of my site's front page has errors -

Got error 127 from table handler
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/mikec/public_html/gallery/snippets.php on line 383

Notice: Undefined variable: randarray in /home/mikec/public_html/gallery/snippets.php on line 393

Warning: Invalid argument supplied for foreach() in /home/mikec/public_html/gallery/snippets.php on line 38

and when I go to gallery/index.php I also get these errors

popula_microthumbs: Got error 127 from table handler
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/mikec/public_html/gallery/indexstyles/building_blocks.php on line 381

I haven't a clue what's going on, I haven't done anything to alter anything my end

[MikeCaine]

I also notice that if I scroll down my gallery front page some sections have thumbnails displayed OK but if I click on them I get

Exhibit Engine MySQL error!
ERROR FROM QUERY get_exhibition in page 'photo':

------------------------------
Got error 127 from table handler
------------------------------

If you encounter this error with unmodified EE source code please mail this error to EE developers with version number, detailed circumstances when it happened and preferably with a database backup dump. All reports helps improving EE to your satisfaction. Thank You.

[Pekka]

I also notice that if I scroll down my gallery front page some sections have thumbnails displayed OK but if I click on them I get

Exhibit Engine MySQL error!
ERROR FROM QUERY get_exhibition in page 'photo':

------------------------------
Got error 127 from table handler
------------------------------

If you encounter this error with unmodified EE source code please mail this error to EE developers with version number, detailed circumstances when it happened and preferably with a database backup dump. All reports helps improving EE to your satisfaction. Thank You.

This is mysql server error which means the installation of the database server is somehow faulty, in usually this error means:

MySql error: 127 = Record-file is crashed

Until this server error is resolved by your admin there is no chance EE will work without errors.

[MikeCaine]

If I install the database data from my last backup would that cure it, or are you saying there's a problem with the database server itself?

My previous photo gallery on the same site, which also uses a SQL database, still seems to be working OK

[Pekka]

If I install the database data from my last backup would that cure it, or are you saying there's a problem with the database server itself?

You can try optimize editor in EE, it may help.

See also http://sunsite.mff.cuni.cz/MIRRORS/ftp.mysql.com/doc/en/Repair.html

My previous photo gallery on the same site, which also uses a SQL database, still seems to be working OK

Corruption may be based on disk sectors, mysql stores all data on disk.

[MikeCaine]

You can try optimize editor in EE, it may help.

I can't even get the editor to work, I get

"Error in performing query fetch_one: Got error 127 from table handler"

See also http://sunsite.mff.cuni.cz/MIRRORS/ftp.mysql.com/doc/en/Repair.html

That's a little bit beyond me, I don't really know that much about SQL and servers

What if I wipe the database, recreate it and somehow restore the backup through myphpadmin, would that give me a foghting chance of getting going again?

What's my other alternative, resinstall EE from scratch and reupload all of the photos again?

[MikeCaine]

Hmmm.. I went into my cpanel, picked the database and clicked repair and it seems to be working again now. I don't really understand what's happened but I'll keep an close eye on it for a while to see if anything else goes bad