Forum Multitudes of database issues (reoccurring)
 

Here are a few database errors that we consistently get (as in 15+ per day for each).

I understand that they may be for mods, however when we switched to 4.0.2 we de-activated and deleted every mod that was under the old software. So I have no idea why it would be still be error'ing (:)) For example, I believe Error 2 is due to VB Shout... which we don't have anymore.

Database error 1:

Code:
nvalid SQL:

SELECT languageid,
phrasegroup_global AS phrasegroup_global,
phrasegroup_user AS phrasegroup_user,
phrasegroup_mysmiliesvb AS phrasegroup_mysmiliesvb,
options AS lang_options,
languagecode AS lang_code,
charset AS lang_charset,
locale AS lang_locale,
imagesoverride AS lang_imagesoverride,
dateoverride AS lang_dateoverride,
timeoverride AS lang_timeoverride,
registereddateoverride AS lang_registereddateoverride,
calformat1override AS lang_calformat1override,
calformat2override AS lang_calformat2override,
logdateoverride AS lang_logdateoverride,
decimalsep AS lang_decimalsep,
thousandsep AS lang_thousandsep
FROM language
WHERE languageid = 1;

MySQL Error : Unknown column 'phrasegroup_mysmiliesvb' in 'field list'
Error Number : 1054
Request Date : Thursday, March 4th 2010 @ 06:10:30 PM
Error Date : Thursday, March 4th 2010 @ 06:10:30 PM
Script : http://www.buffalorange.com/mysmiliesvb.php
Referrer :
IP Address : 66.249.67.113
Username :
Classname : vB_Database
MySQL Version :
This error is common, except the MySQL RED part changes.

Database error 2:

Code:
Invalid SQL:
select count(*) as `ts` from shout;

MySQL Error : Table 'db65181_rangevb.shout' doesn't exist
Error Number : 1146
Request Date : Thursday, March 4th 2010 @ 05:41:23 PM
Error Date : Thursday, March 4th 2010 @ 05:41:23 PM
Script : http://www.buffalorange.com/vbshout....chive&page=108
Referrer :
IP Address : 67.195.112.224
Username : Unregistered
Classname : vB_Database
MySQL Version :
Will deleting the table end the error? If so, how do I do that?

Database error 3:

Code:
mysql_connect() [function.mysql-connect]: User db65181_ryan already has more than 'max_user_connections' active connections
/nfs/c04/h03/mnt/65181/domains/buffalorange.com/html/includes/class_core.php on line 312

MySQL Error :
Error Number :
Request Date : Tuesday, March 2nd 2010 @ 01:10:24 PM
Error Date : Tuesday, March 2nd 2010 @ 01:10:24 PM
Script : http://www.buffalorange.com/
Referrer : http://www.buffalorange.com/
IP Address : 71.243.145.19
Username :
Classname : vB_Database
MySQL Version :