my site is down due to mysql error 1030

[arashjaf]

here is the error i get

ERROR: Database error.
Cannot execute the query: SELECT userid, username FROM user ORDER BY userid DESC LIMIT 1
MySql Error returned: Got error 127 from storage engine
MySql Error code: 1030

please help me, i know it is due to an acess, what should i do to fix the problem?

thanks in advance

[Marco van Herwaarden]

MySQL error code 127: Record-file is crashed

Try repairing your tables (multiple times).

[arashjaf]

thanks for ur quick reply

I have tried to repair it many times, but so far no luck, anything else i can do?

thanks in advance

[Marco van Herwaarden]

I suggest you ask your host for assistence.

[arashjaf]

my host is yahoo, i did call them up, and they said they can't help about mysql and they gave me an email address to contact, and i have contacted that address before, they won't reply for atleast 2 weeks. i can't have my site down until they decide to reply to my email.

[Dan]

I think It's time to find a new host then.

[arashjaf]

i got the host 4 days ago, so there is no way i can fix it myself?

[Marco van Herwaarden]

Do you have SSH/Telnet access to the server?

[Dan]

If it takes more than a couple days to even get a reply I'd really think you would need a new host, if it's just a new install with only a couple posts maybe a fresh install would be better than trying to fix it because I don't think you would be able to if repairing the db didn't work

[arashjaf]

Originally Posted by MarcoH64

Do you have SSH/Telnet access to the server?

i have phpMyAdmin access to the databade, is there anything i can do in there?

thats the error i get in my email

Database error in vBulletin 3.5.2:

Invalid SQL:

SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight, customprofilepic.userid AS profilepic, customprofilepic.dateline AS profilepicdateline, customprofilepic.width AS ppwidth, customprofilepic.height AS ppheight

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 avatar AS avatar ON (avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON (customavatar.userid = user.userid) LEFT JOIN customprofilepic AS customprofilepic ON (user.userid = customprofilepic.userid)

WHERE user.userid = 443;

MySQL Error : Got error 127 from storage engine
Error Number : 1030
Date : Wednesday, December 28th 2005 @ 12:46:35 PM
Script : http://arianworld.com/forum/member.php?u=443
Referrer : http://b4.mail.yahoo.com/ym/arianwor...ad=b&box=Inbox
IP Address : *******
Username : ******
Classname : vb_database

thats what i get in phpmyadmin

SQL query:

SELECT label, id
FROM `__DBNAME__`.`PMA_bookmark`
WHERE dbase = 'db'
AND (

user = 'arashjaf'
OR user = ''
)
ORDER BY label
MySQL said:

#1146 - Table '__DBNAME__.PMA_bookmark' doesn't exist