knowledge base home | submit a request

Knowledge Base

Query Failed: Can't open file: 'tgp_gal.MYI'. (errno: 145)

Question
Hi Im getting this message in my admin area is there away to fix this with out reloading the whole script? Category Active Queue Query Failed: Can't open file: 'tgp_gal.MYI'. (errno: 145) Query: SELECT COUNT(gal_id) AS active_count FROM tgp_gal WHERE gal_cat_id = 1 AND gal_date <= NOW() AND gal_approved = 1 Query Failed: Can't open file: 'tgp_gal.MYI'. (errno: 145) Query: SELECT COUNT(gal_id) AS active_count FROM tgp_gal WHERE gal_cat_id = 1 AND gal_date <= NOW() AND gal_approved = 1 Thanks Brad

Answer
I believe there is a problem with your MySQL installation. Also try the database repair utility in the admin.