Problems with repair.php
Posted: Fri Sep 23, 2005 1:26 pm
I'm getting the same error while trying to access my forum and also when trying to use repair.php
The user.MYD file is there and it has the same owner and permissions as the rest of the files. I also tried using repair from phpmyadmin and it said it worked but I'm still getting the same error.
Invalid SQL:
SELECT administrator.*,
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_sql AS phrasegroup_sql,
language.phrasegroup_cpglobal AS phrasegroup_cpglobal,
language.phrasegroup_global AS phrasegroup_global,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep
FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN administrator AS administrator ON (administrator.userid = user.userid) INNER JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))
WHERE user.userid = 583
mysql error: Can't open file: 'user.MYD'. (errno: 145)
The user.MYD file is there and it has the same owner and permissions as the rest of the files. I also tried using repair from phpmyadmin and it said it worked but I'm still getting the same error.