Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 03-18-2013, 07:51 PM
Floyd R Turbo Floyd R Turbo is offline
 
Join Date: Sep 2012
Posts: 22
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Lots of database errors

I have been running VB4.2P2 on GoDaddy hosting for a few months. I also use vb Bad Behaviour and GlowHost Spam-o-matic and it seems to do a good job so these might be related to that security in place. But i just wanted to check because I keep getting this error message:

Code:
Database error in vBulletin 4.2.0:

Invalid SQL:
SHOW COLUMNS FROM user LIKE 'username';

MySQL Error   : Incorrect key file for table '/tmp/mysqltmp/#sql_XXXX_0.MYI'; try to repair it
Error Number  : 126
Request Date  : Wednesday, March 13th 2013 @ 09:19:55 AM
Error Date    : Wednesday, March 13th 2013 @ 09:20:05 AM
Script        : http://www.turbosaquatics.com/vb4/register.php?do=addmember
Referrer      : https://www.turbosaquatics.com/vb4/register.php
IP Address    :  [varies]
Username      :  [varies]
Classname     : vB_Database
MySQL Version :
the XXXX_0.MYI has been one of 2 numbers.
The IP Addresses are always different
The Usernames are always ones that are not registered.

So is this just automated spammer activity I am seeing, and their attempts to post something without having registered is causing a database error e-mail to be generated?

This is not the only recurring error I am getting, but it is the dominant one. So I'll just leave it at this one for now. Thanks

--------------- Added [DATE]1363637302[/DATE] at [TIME]1363637302[/TIME] ---------------

Correction I'm running PL3

also I'm running GlowHost SOM 2.0.2
Reply With Quote
  #2  
Old 03-18-2013, 08:26 PM
ForceHSS ForceHSS is offline
 
Join Date: Apr 2008
Posts: 6,357
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You need to run a repair if you don't know how ask ur host to do it
Reply With Quote
  #3  
Old 03-18-2013, 08:36 PM
Floyd R Turbo Floyd R Turbo is offline
 
Join Date: Sep 2012
Posts: 22
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I've logged into my php admin and repaired all the tables with overhead values many times, this error keeps coming back no matter what. No one is complaining that they cannot register, and whenever I register a dummy/test account, it works just fine.

--------------- Added [DATE]1363639054[/DATE] at [TIME]1363639054[/TIME] ---------------

Looking at my Bad Behavior logs also shows that some of the IP addresses match as well.
Reply With Quote
  #4  
Old 03-18-2013, 08:39 PM
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Location: Michigan
Posts: 3,733
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thats a tmp table, it could of been created for a few reasons, basically if there are no crashed or unusable tables in the db, that file can be removed from the server.

The overheaded tables shouldnt be repaired either, they should be optimized.

Did you run a repair on the USER table?
Reply With Quote
  #5  
Old 03-18-2013, 08:48 PM
Floyd R Turbo Floyd R Turbo is offline
 
Join Date: Sep 2012
Posts: 22
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Have not repaired USER table to my knowledge.

I read somewhere to 'repair' overheaded tables. Will 'optimize' from now on.

Ran check tables on all files. Only the .session and .cpsession tables said anything but OK.
Reply With Quote
  #6  
Old 03-18-2013, 08:51 PM
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Location: Michigan
Posts: 3,733
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Run a repair on the user table, not a check.
Reply With Quote
  #7  
Old 03-18-2013, 08:58 PM
borbole's Avatar
borbole borbole is offline
 
Join Date: Jan 2010
Posts: 2,559
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Are you on a shared server there or do you have your own vps/dedicated box?
Reply With Quote
  #8  
Old 03-18-2013, 09:43 PM
Floyd R Turbo Floyd R Turbo is offline
 
Join Date: Sep 2012
Posts: 22
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Snakes, I ran a repair on all tables actually before you said to optimize. Is there any harm done in repairing vs optimizing?

borbole, I believe it is a shared server. I'm not big enough for a dedicated server or vps (I'm guessing that means virtual private server). I have read that running vb on a shared server can cause issues with temporary tables created during queries, could that be what is going on? I need to have them bump up my allowable table size or shared space?

I also heard godaddy is a PITA for this stuff.
Reply With Quote
  #9  
Old 03-18-2013, 09:56 PM
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Location: Michigan
Posts: 3,733
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

There really is no harm, but there is no need to repair a table that isnt broke/crashed.

If the tables have overhead, a simple optimize will do.

If you ran a repair & your still getting those emails, then yes the shared how could be the cause, as those can be created for numerous reasons as i said previously, some can be from large joins or large order by, which you can run into both in the case of vb.

Large user table & piss poor resource settings by the host on a over sold virtual server with hundreds of accounts on it.

It may be time for your site to get on a vps & yes, godaddy sucks pitas....
Reply With Quote
  #10  
Old 03-18-2013, 10:43 PM
ForceHSS ForceHSS is offline
 
Join Date: Apr 2008
Posts: 6,357
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Sometimes you need to run repair a few times as once is not enough. If the problem is still there after you have I would get your host to look into it.
Reply With Quote
Reply


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 01:52 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04020 seconds
  • Memory Usage 2,251KB
  • Queries Executed 11 (?)
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)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)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_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
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete