Print Page - Most Viewed : Critical Error

Title: Most Viewed : Critical Error
Post by: itsnetservices on January 04, 2008, 12:26:00 AM

Hello, I recently started having a problem with the Most Viewed link on my clients gallery.

Out of no where, I am getting a "There was an error while processing a database query" message when trying to view the Most Viewed pictures.

The problem I am going to have with getting help on this, is that its a private gallery thats password protected. I can probably get a temporary password from the client to give to an admin of this site.

But I just figured I would post here first if someone know a potential problem and/or solution.

Thanks,
-Adam

Title: Re: Most Viewed : Critical Error
Post by: Nibbler on January 04, 2008, 12:51:47 AM

Enable debug mode in config and post the MySQL error message you receive (not the entire debug output) when you replicate the error.

Title: Re: Most Viewed : Critical Error
Post by: itsnetservices on January 04, 2008, 02:30:46 AM

Thanks Nibbler.

Code Select

While executing query "SELECT * FROM cpg14x_pictures WHERE approved = 'YES'AND hits > 0   ORDER BY hits DESC, filename   LIMIT 0 ,20" on 0

mySQL error: Incorrect key file for table './anagal_db/cpg14x_pictures.MYI'; try to repair it

File: /xxx/xxx/xxxxxxx/xxxxxxx/xxxxxx/gallery/include/functions.inc.php - Line: 249

Gotta love debug mode I guess.

Thanks,
-Adam

Title: Re: Most Viewed : Critical Error
Post by: Nibbler on January 04, 2008, 10:11:27 AM

Repair the table as suggested using phpMyAdmin.

Code Select

REPAIR TABLE cpg14x_pictures

Title: Re: Most Viewed : Critical Error
Post by: itsnetservices on January 04, 2008, 07:57:13 PM

Woo Hoo! Thanks Nibbler, it worked perfectly

You are a god among men my friend!

You can mark this post as solved.

Thanks again.
-Adam

coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: itsnetservices on January 04, 2008, 12:26:00 AM