vb.org Archive - my site is down due to mysql error 1030

Page 2 of 3

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - my site is down due to mysql error 1030 (https://vborg.vbsupport.ru/showthread.php?t=103889)

Paul M

12-28-2005 11:45 AM

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

12-28-2005 12:40 PM

Quote:

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.

Quote:

#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

12-28-2005 01:21 PM

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

Revpolar

12-28-2005 01:24 PM

Quote:

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

12-28-2005 01:35 PM

From post #10:

Generated by vB:

Code:

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:

Code:

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

12-28-2005 01:48 PM

Quote:

Originally Posted by MarcoH64

From post #10:

Generated by vB:

Code:

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:

Code:

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

12-28-2005 01:57 PM

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

12-28-2005 01:59 PM

Quote:

Originally Posted by MarcoH64

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

Marco van Herwaarden

12-28-2005 02:03 PM

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

12-28-2005 02:06 PM

Quote:

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.

All times are GMT. The time now is 07:30 PM.

Page 2 of 3

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01324 seconds Memory Usage 1,751KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (4)bbcode_code_printable (6)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: