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
Your user table is broken, as shown when you try and login to the admincp ;
Quote:
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
12-28-2005, 02:19 PM
Linear Mode
