The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Help "OVERLOAD!!!!!
Ok so our site isnt working!!! everytime we get on it reads a error and then i get a message in my email saying
Database error in vBulletin 3.6.5: Invalid SQL: SELECT userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, language.phrasegroup_holiday AS phrasegroup_holiday, language.phrasegroup_global AS phrasegroup_global, language.options AS lang_options, language.languagecode AS lang_code, language.charset AS lang_charset, language.locale AS lang_locale, language.imagesoverride AS lang_imagesoverride, language.dateoverride AS lang_dateoverride, language.timeoverride AS lang_timeoverride, language.registereddateoverride AS lang_registereddateoverride, language.calformat1override AS lang_calformat1override, language.calformat2override AS lang_calformat2override, language.logdateoverride AS lang_logdateoverride, language.decimalsep AS lang_decimalsep, language.thousandsep AS lang_thousandsep FROM vbuser AS user LEFT JOIN vbuserfield AS userfield ON (user.userid = userfield.userid) LEFT JOIN vbusertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN vblanguage AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid)) WHERE user.userid = 37; MySQL Error : Table './tpggirlz_forum/vbuser' is marked as crashed and should be repaired Error Number : 145 Date : Thursday, September 13th 2007 @ 12:11:31 PM Script : http://www.tpggirlz.com/tpgvb/ Referrer : IP Address : 75.179.62.223 Username : Classname : vB_Database_MySQLi |
#2
|
||||
|
||||
Looks like the same issue as here
https://vborg.vbsupport.ru/showthread.php?t=157738 The table needs to be repaired. Go into your admin panel, select Maintenance, then Repair/Optimize tables. Click the Check All box, then Continue. Run it 2-3 times and see if that clears up your problem. |
#3
|
|||
|
|||
it wont let me even in the control panel! it wont let me on the board at all this is what is says
Database error The tpggirlz database has encountered a problem. Please try the following: * Load the page again by clicking the Refresh button in your web browser. * Open the www.tpggirlz.com home page, then try to open another page. * Click the Back button to try another link. The www.tpggirlz.com forum technical staff have been notified of the error, though you may contact them if the problem persists. We apologise for any inconvenience. |
#4
|
||||
|
||||
Go into phpMyAdmin and repair the tables from there. It's located in your cPanel, Plesk, etc.
|
#5
|
|||
|
|||
ok im in phpmyadmin but im not sure what to click on , i went to the link posted and seen your instructions but i dont see the things yo uare talking about?
|
#6
|
||||
|
||||
OK, when you first start out in phpMyAdmin: select your Database from the left-hand dropdown menu, then place a check to any table you need to repair, then go all the way to the bottom and look for "With selected:" and select "Repair table".
|
#7
|
|||
|
|||
ok i did it twice and it says this
Error SQL query: REPAIR TABLE `CHARACTER_SETS` , `COLLATIONS` , `COLLATION_CHARACTER_SET_APPLICABILITY` , `COLUMNS` , `COLUMN_PRIVILEGES` , `KEY_COLUMN_USAGE` , `PROFILING` , `ROUTINES` , `SCHEMATA` , `SCHEMA_PRIVILEGES` , `STATISTICS` , `TABLES` , `TABLE_CONSTRAINTS` , `TABLE_PRIVILEGES` , `TRIGGERS` , `USER_PRIVILEGES` , `VIEWS` MySQL said: Documentation #1044 - Access denied for user 'tpggirlz'@'localhost' to database 'information_schema' ok awesome i got it finally thanks for the quick response guys you rock! |
#8
|
||||
|
||||
Glad you are back up and running
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|