my site is down due to mysql error 1030
 

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

MySQL error code 127: Record-file is crashed

Try repairing your tables (multiple times).

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

I suggest you ask your host for assistence.

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.

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

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

Do you have SSH/Telnet access to the server?

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

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

Do you have a backup ? if not then you look to be pretty well screwed.

If you have only been with then for four days I would just give up and move to a real host.

Thats an error with every single user field in the database. Sounds like to me you installed a hack that was missing a Table Prefix in its code and you use a table prefix in your database setup. Try uninstalling your hacks one by one till you find the source of the problem.

Is the key. Why would you have a table called "DBNAME" in database PMA_bookmark?
Or I must have it backwards. What is your database name? Is there a table prefix? Lets see your config.php minus the dbusername and pass.

Revpolar, that SQL is generated by phpMyAdmin. Seem there is a lot more database corruption/missing tables.

Im reffering to post #10 that comes from VB. Bsides he says he can get into the admincp to run repairs. So its not a complete fubarred DB. Just eems to be a bad hack to me. Like i said probably has to do with his DB having a table prefix. And the hack missing TABLE_PREFIX in its code.

From post #10:

Generated by vB:
Generated by phpMyAdmin:

Ive never heard of that table in any VB install is what Im saying. It has to be a hack.

There are only 3 tables mentioned in the error generated by vB (user, userfield & usertextfield), and these are all default vB tables.

The table you are mentioning is in an error generated by phpMyAdmin and has nothing to do with vB.

http://arianworld.com/forum/admincp/
If his database was that messed up he wouldnt see a login on this page.

Sorry i don't understand what you want to show with that Admin Login. An admin login page has nothing to do with the corruption of one of those tables.

You are right but if he can login there then the tables are ok. Because those tables are required to login.

I seem to be confussing someone. So let me start over. He says e has run repair tables from within admincp. To do that he had to login to th admincp. If his database tables for user fields wee really bad then he would not be able to login to the admincp. So what Im trying to say is that I think (speculate r guess) that he has installed some hack that is missing the Table_prefix from its code. And his database is installed with a table prefix. Therefore when that hack queries te database it doesnt look for the table prefix in the config so he get an error because there is no such table user instead it should be table PMA_user.
Uninstall hacks one at a time until you figure out which one causes the error is my recommendation.
Sorry for the confusion.

Error 127 is not because of a missing table prefix.

no i can't login to vb admin, as son as i give my username and pass it gives me the same error for the site, and i haven't installed anything.

the last thing i did was to password protect some of my folders, like log folder in my root directory. and i made them public just like the way they were from the stat.

i did the repair in my host control panel not from vb as i can't get into vb admin

If you can not solve it, you could try opening a support ticket at vb.com.

Your user table is broken, as shown when you try and login to the admincp ;

thank you all
it is working now

I am having the same problem right now. How did you resolve this issue?

How do you fix a broken user table?

Please post the exact error message you are getting.