Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
  #1  
Old 09-13-2007, 05:12 PM
angelpie angelpie is offline
 
Join Date: May 2007
Posts: 35
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 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
Reply With Quote
  #2  
Old 09-13-2007, 05:26 PM
Calash's Avatar
Calash Calash is offline
 
Join Date: Jun 2006
Location: East Coast, USA
Posts: 297
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #3  
Old 09-13-2007, 05:38 PM
angelpie angelpie is offline
 
Join Date: May 2007
Posts: 35
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #4  
Old 09-13-2007, 05:47 PM
Kirk Y's Avatar
Kirk Y Kirk Y is offline
 
Join Date: Apr 2005
Location: Tallahassee, Florida
Posts: 2,604
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Go into phpMyAdmin and repair the tables from there. It's located in your cPanel, Plesk, etc.
Reply With Quote
  #5  
Old 09-13-2007, 05:54 PM
angelpie angelpie is offline
 
Join Date: May 2007
Posts: 35
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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?
Reply With Quote
  #6  
Old 09-13-2007, 05:58 PM
Kirk Y's Avatar
Kirk Y Kirk Y is offline
 
Join Date: Apr 2005
Location: Tallahassee, Florida
Posts: 2,604
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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".
Reply With Quote
  #7  
Old 09-13-2007, 06:06 PM
angelpie angelpie is offline
 
Join Date: May 2007
Posts: 35
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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!
Reply With Quote
  #8  
Old 09-13-2007, 06:20 PM
Calash's Avatar
Calash Calash is offline
 
Join Date: Jun 2006
Location: East Coast, USA
Posts: 297
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Glad you are back up and running
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 05:19 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04015 seconds
  • Memory Usage 2,226KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (8)post_thanks_box
  • (8)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (8)post_thanks_postbit_info
  • (8)postbit
  • (8)postbit_onlinestatus
  • (8)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete