vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   vBulletin Database Errors after Successful 3.7.0 Upgrade (https://vborg.vbsupport.ru/showthread.php?t=180177)

dcster2001 05-22-2008 08:45 PM

vBulletin Database Errors after Successful 3.7.0 Upgrade
 
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):

Quote:

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...02&postcount=7
Referrer :
IP Address : [IP adress deleted]
Username :
Classname : vB_Database
MySQL Version :

Quote:

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?...l&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 05-22-2008 09:01 PM

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 05-23-2008 08:41 AM

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 05-23-2008 11:24 AM

Quote:

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 05-25-2008 04:52 PM

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

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

Quote:

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 [DATE]1211738614[/DATE] at [TIME]1211738614[/TIME] ---------------

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 06-05-2008 05:58 PM

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

Quote:

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/attachme...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 06-05-2008 09:05 PM

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 06-05-2008 10:57 PM

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 06-06-2008 07:09 AM

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 06-06-2008 12:58 PM

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!


All times are GMT. The time now is 12:55 PM.

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.01061 seconds
  • Memory Usage 1,744KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete