vBulletin Database Errors after Successful 3.7.0 Upgrade

[dcster2001]

I started receiving database error notices several days after I upgraded from 3.6.8 to 3.7.0.

I will list them here in case there is an error in the code causing this (server IP address deleted):

Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Host [IP Adddress Deleted] is not allowed to connect to this MySQL server
/data/13/1/161/7/1324170/user/1418708/htdocs/forum/includes/class_core.php on line 311

MySQL Error :
Error Number :
Request Date : Monday, May 19th 2008 @ 01:09:53 AM
Error Date : Monday, May 19th 2008 @ 01:09:54 AM
Script : http://www.mysite.com/forum/showpost.php?&p=5902&postcount=7
Referrer :
IP Address : [IP adress deleted]
Username :
Classname : vB_Database
MySQL Version :



Database error in vBulletin 3.7.0:

Invalid SQL:

SELECT varname AS faqname, fieldname
FROM phrase AS phrase
WHERE phraseid IN(140763, 140764, 140765, 140766, 140767, 140768, 140769, 140770, 140771, 140772, 140773, 140774, 140775, 140776, 140777, 140778, 140779, 140780, 140781, 140782, 140783, 140784, 140785, 140786, 140787, 140788, 140789, 140790, 140791, 140792, 140793, 140794, 140795, 140796, 140797, 140798, 140799, 140800, 140801, 140802, 140803, 140804, 140805, 140806, 140807, 140808, 140809, 140810, 140811, 140812, 140813, 140814, 140815, 140816, 140817, 140818, 140819, 140820, 140821, 140822, 140823, 140824, 140825, 140826, 140827, 140828, 140829, 140830, 140831, 140832, 140833, 140834, 140835, 140836, 140837, 140838, 140839, 140840, 140841, 140842, 140843, 140844, 140845, 140846, 131246, 131247, 131248, 131249, 131250, 131251, 131252, 131253, 131254, 131255, 131256, 131257, 131258, 131259, 131260, 131261, 131262, 131263, 131264, 131265, 131266, 131267, 131268, 131269, 131270, 131271, 131272, 131273, 131274, 131275, 131276, 131277, 131278, 131279, 131280, 131281, 131282, 1!
31283, 131284, 131285, 131286, 131287, 131288, 131289, 131290, 131291, 131292, 131293, 131294, 131295, 131296, 131297, 131298, 131299, 131300, 131301, 131302, 131303, 131304, 131305, 131306, 131307, 131308, 131309, 131310, 131311)
AND ();

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 ')' at line 4
Error Number : 1064
Request Date : Wednesday, May 21st 2008 @ 06:34:46 AM
Error Date : Wednesday, May 21st 2008 @ 06:34:49 AM
Script : http://www.mysite.com/forum/faq.php?s=&do=search&q=%00'&match=all&titlesonly=0
Referrer :
IP Address : [IP Address Deleted]
Username : Unregistered
Classname : vB_Database
MySQL Version :

I also noticed that when I try to access my forum without the trailing "/" in the URL after "forum", I get a "page not found" error. I don't recall this happening before.

Are these errors vB internal errors or are they server configuration problems?

[SEOvB]

It looks like your MySQL host doesnt allow your server to connect to it from that IP

Is your config.php file correct, and for the mysql host field is it localhost or another setting.

[Marco van Herwaarden]

The first error is strange. This should either not happen, or happen all the time (in which case your board would not work at all). Maybe your host was doing something on the server if it was only once.

The 2nd error is someone who is trying to exploit an alleged vulnerability, by creating a special URL. This will cause a database error, but is not vulnerable to SQL-Injections. You can ignore this error.

[Opserty]

I also noticed that when I try to access my forum without the trailing "/" in the URL after "forum", I get a "page not found" error. I don't recall this happening before.

This seems more a sever configuration problem, I'd contact your host to see if they can provide you with assistance or rectify the problem for you.

[dcster2001]

Thanks for the replies, I'll look into your suggestions.

--------------- Added 1211738202 at 1211738202 ---------------

opb FRDS, It looks like your MySQL host doesnt allow your server to connect to it from that IP

Is your config.php file correct, and for the mysql host field is it localhost or another setting

The config.php mysql host field is set to a specific server IP address. What circumstances would cause a server to reject a specific IP?

--------------- Added 1211738614 at 1211738614 ---------------

BTW, I have received the first error about 10 - 12 times in total since I upgraded. Each time it specifies the same error, ".../includes/class_core.php on line 311". The last error message was received yesterday. It seems the error messages usualy cluster around weekends (Friday - Mon), so it is possible it is a server issue with my provider when they are performing maintenance.

The board is otherwise active and works as it should.

[dcster2001]

After being error-free for some time, I got three db errors today, all the same:

Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: User [username deleted] already has more than 'max_user_connections' active connections
/data/13/1/161/7/1324170/user/1418708/htdocs/forum/includes/class_core.php on line 311

MySQL Error :
Error Number :
Request Date : Thursday, June 5th 2008 @ 09:19:10 AM
Error Date : Thursday, June 5th 2008 @ 09:19:10 AM
Script : http://www.mysite.com/forum/attachment.php?attachmentid=169&stc=1&d=1034268353
Referrer : http://www.mysite.com/forum/showthread.php?t=273
IP Address : [IP DELETED]
Username :
Classname : vB_Database
MySQL Version :

The errors all occurred within about three minutes of each other. Is this an easy fix? I'm still running vBulletin 3.7.0.

Thanks!

[snakes1100]

Your connecting to mysql above the limit set in my.cnf for mysql:

max_connections

That limit will have to be raised, if this isnt a vps/dedicated server, you will have to ask your host to raise the limit.

[dcster2001]

Snakes,

Thanks for the reply. I am hosted by Network Solutions. What is a"vps/dedicated server"?

I would imagine that the connection limit is some sort of default value-- I've never seen this error before. Is it possible that some sort of flood attack occurred which reached the limit, or is this a server issue (the entire server had a flood of connections all at once)? The traffic on my site is fairly low (a handful of users at a time), so I don't think it would've been due to high traffic on my site, unless it was some sort of malicious attack of some kind.

[Dismounted]

If you are on a shared server (ie. no access to SSH/Remote Desktop), you will have to ask your host to raise the limit.

[dcster2001]

I do have access to Telnet and I think, SSH also. How do I raise the limit myself, and what is the recommended value?

Thanks for your help!