Database

[crazyrockerz]

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: User ******** already has more than 'max_user_connections' active connections
/hermes/web01/****/moo.******/includes/class_core.php on line 311

MySQL Error :
Error Number :
Request Date : Wednesday, June 3rd 2009 @ 12:08:29 PM
Error Date : Wednesday, June 3rd 2009 @ 12:08:29 PM
Script : http://www..com/misc.php?show=latestposts&resultsnr=5
Referrer : http://www..com/index.php
IP Address : 117.197.212.114
Username :
Classname : vB_Database
MySQL Version :



i am new to vbulletin

and i am getting 100 of same error ia not understanding whats the problem ? can some one help me out

Thanks in advance

[crazyrockerz]

Database error in vBulletin 3.8.2:

Invalid SQL:

SELECT COUNT(*) as cnt,max(lastpost) as lastupdate
FROM thread AS thread
INNER JOIN tagthread AS tagthread ON
(tagthread.tagid = 1 AND tagthread.threadid = thread.threadid)
WHERE thread.forumid IN()
AND thread.visible = 1
AND thread.sticky IN (0, 1)
AND thread.open <> 10
GROUP BY tagthread.tagid;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
AND thread.visible = 1
AND thread.sticky IN (0, 1)' at line 5
Error Number : 1064
Request Date : Wednesday, June 3rd 2009 @ 02:08:56 AM
Error Date : Wednesday, June 3rd 2009 @ 02:08:57 AM
Script : http://www..com/cron.php?rand=1244009333
Referrer : http://www..com/
IP Address : 98.200.68.187
Username : Unregistered
Classname : vB_Database
MySQL Version :


Thanks in advance

[crazyrockerz]

Database error in vBulletin 3.8.2:

Invalid SQL:

insert into infernoshoutusers
(s_user, s_bold, s_italic, s_underline, s_color, s_font)
values
('34', '1', '0', '0', '', '');

MySQL Error : Duplicate entry '34' for key 1
Error Number : 1062
Request Date : Thursday, June 4th 2009 @ 09:39:35 AM
Error Date : Thursday, June 4th 2009 @ 09:40:10 AM
Script : http://www..com/infernoshout.php
Referrer : http://www..com/
IP Address : 124.15.50.XXX
Username : XXXXXXXX
Classname : vB_Database
MySQL Version :



Thanks in advance

[Lynne]

Try disabling your modifications/plugins and see if you still have this problem.
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

define('DISABLE_HOOKS', true);

[Lynne]

This is a server problem. You'll have to talk to your host about increasing the number of max_user_connections.

[Lynne]

You can read this in the manual - Duplicate entry 'XXX' (http://www.vbulletin.com/docs/html/mysql_duplicatekey). The table infernoshoutusers is not a default vbulletin table. If the manual page doesn't help, you should ask for help with this in the modification thread (or read the thread first to see if this issue has come up before).

[Dismounted]

Three related threads merged.