The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
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 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 |
#2
|
|||
|
|||
You need to run a repair if you don't know how ask ur host to do it
|
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
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. |
#6
|
|||
|
|||
Run a repair on the user table, not a check.
|
#7
|
||||
|
||||
Are you on a shared server there or do you have your own vps/dedicated box?
|
#8
|
|||
|
|||
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. |
#9
|
|||
|
|||
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.... |
#10
|
|||
|
|||
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.
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|