MySQL Errors

Cre8ive · March 20th, 2007, 11:10 PM

I have received about 300 emails with a MySQL Error Reports. This is what it states:

An error was encountered during execution of the query:
SELECT id FROM pp_photos WHERE approved=0
The query returned with an errorcode of:
Can't open file: 'pp_photos.MYI'. (errno: 145)
If you need assistence or feel this is a 'bug'; please report it to our support forums at: http://www.photopost.com/members/forum/f66/index.html

To turn off these emails, set $debug=0 in your config-inc.php file.

All over the Gallery there are WARNINGS like

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in E:\webspace\wahmweb\Cre8ive\XXXXXXX.com\www\gallery\pp-inc.php on line 1041

There are a number of different line numbers stated.

Can someone help me and tell me what is going on?

THANKS!!!

Chuck S · March 21st, 2007, 11:03 AM

Your photos mysql table is corrupt

Try running a repair through your mysql viewer like phpmyadmin or issue a query like so in an sql window

REPAIR TABLE pp_photos

Cre8ive · March 21st, 2007, 02:24 PM

I don't know how to do that. Can you give me instructions?

Chuck S · March 21st, 2007, 05:50 PM

Do you know how to use phpmyadmin? You simply enter that query in the sql window

Cre8ive · March 21st, 2007, 07:22 PM

No, I don't. Tell me where to find the sql window. I have looked in the admin section of my site, the admin section of the gallery.

Chuck S · March 21st, 2007, 07:33 PM

This is not something in photopost

You would go to the control panel for your site select your mysql database admin and there should be a phpmyadmin link. Once you select that you view your database and there is an sql window to enter that command.

Your host would probally be able to help you correct this

Cre8ive · April 6th, 2007, 11:45 AM

I am still having problems with my Gallery. It now times out when trying to load the gallery. Please help me with this as the gallery is very important to my site. Thank you.

CGI Timeout
The specified CGI application exceeded the allowed time for processing. The server has deleted the process.

Chuck S · April 6th, 2007, 12:01 PM

Have you repaired your mysql database? You have not given any indication you have done this yet.

Cre8ive · April 6th, 2007, 12:14 PM

I gave all of the information to the host of the site and it worked for a little bit. I believe he did this. He is also telling me to come back to you guys to fix the errors.

Chuck S · April 6th, 2007, 04:43 PM

The only errors I see here was your mysql errors from corrupted table and I stated how to fix that