Print Page - critical error. cant open file....

Title: critical error. cant open file....
Post by: jagmike8 on July 15, 2005, 01:25:21 AM

QuoteWhile executing query "SELECT count(*) FROM cpg132_pictures as p, cpg132_albums as a WHERE p.aid = a.aid AND category >= 10000" on 0

mySQL error: Can't open file: 'cpg132_pictures.MYD'. (errno: 145)

i tried searching on here and came up with something about repairing the file cpg132 because something is broken, but when i go to my phpmyadmin database tool, and try to click on the file cpg132_pictures it says:
Can't open file: 'cpg132_pictures.MYD'. (errno: 145)

Error

SQL-query :

SHOW KEYS FROM `cpg132_pictures`

MySQL said:
#1016 - Can't open file: 'cpg132_pictures.MYD'. (errno: 145)

[Documentation] · [Back]

any suggestions?

Title: Re: critical error. cant open file....
Post by: Nibbler on July 15, 2005, 01:38:24 AM

Run the repair query in the sql tab without attempting to view the table first

Code Select

REPAIR TABLE `cpg132_pictures`

Title: Re: critical error. cant open file....
Post by: jagmike8 on July 15, 2005, 01:49:33 AM

sweet. it worked. thanks for your help.

coppermine-gallery.com/forum

Support => Older/other versions => cpg1.3.x Support => Topic started by: jagmike8 on July 15, 2005, 01:25:21 AM