my site is down due to mysql error 1030

[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]

Originally Posted by 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.

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]

Originally Posted by MarcoH64

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]

Originally Posted by MarcoH64

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]

Originally Posted by MarcoH64

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]

Originally Posted by MarcoH64

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.