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]

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/arianworld.com/ShowLetter?MsgId=2719_747828_172227_1398_189_0_456 _-1_0&Idx=0&YY=78908&inc=25&order=down&sort=date&pos=0&view=a&head=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

[Paul M]

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.

[Revpolar]

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.

#1146 - Table '__DBNAME__.PMA_bookmark' doesn't exist
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.

[Marco van Herwaarden]

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

[Revpolar]

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.

[Marco van Herwaarden]

From post #10:

Generated by vB:
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/arianwo...ead=b&box=Inbox
IP Address : *******
Username : ******
Classname : vb_database


Generated by 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

[Revpolar]

From post #10:

Generated by vB:
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/arianwo...ead=b&box=Inbox
IP Address : *******
Username : ******
Classname : vb_database


Generated by 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


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

[Marco van Herwaarden]

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.

[Revpolar]

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.

[Marco van Herwaarden]

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.

[Revpolar]

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.

[Marco van Herwaarden]

Error 127 is not because of a missing table prefix.

[arashjaf]

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.

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

[Marco van Herwaarden]

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

[Paul M]

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

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

[arashjaf]

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


thank you all
it is working now

[madramper]

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

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

How do you fix a broken user table?

[Marco van Herwaarden]

Please post the exact error message you are getting.