Print

[itsnetservices]

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

[Nibbler]

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

[itsnetservices]

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

[Nibbler]

Repair the table as suggested using phpMyAdmin.

Code: [Select]

REPAIR TABLE cpg14x_pictures

[itsnetservices]

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