vb.org Archive - execute SQL bug?

Page 2 of 3

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - execute SQL bug? (https://vborg.vbsupport.ru/showthread.php?t=206233)

Lynne

02-23-2009 03:11 PM

That is a server problem. You will have to talk to your host about it.

fodboldforumdk

02-24-2009 08:50 AM

My host says that its not the server but VB most likely...

Marco van Herwaarden

02-24-2009 09:03 AM

The error is very clear:

User fodboldforum_dk already has more than 'max_user_connections' active connections

This is a setting in the MySQL configuration, which your host can edit.

fodboldforumdk

02-25-2009 09:30 AM

the new answer i got from my host is:

that i need is to insert a code like this mysql_close () to stop the active alltime acess to DB because of the limited connections.

So, what can i do? - i have a bad feeling that this comes out of the Execute SQL Query i did. Seems like it came after this really bad.

Marco van Herwaarden

02-25-2009 12:05 PM

Make sure that you are not using persistent connections (setting in your config.php).

fodboldforumdk

02-25-2009 12:40 PM

for some reason i got 2 config files
config.php
config.php.new

Were in config.php it accually was set to "1" (on) so now i have set it to "0" (off)

Now i really cant get access to my site
can you get access? www fodboldforum.dk

Blaine0002

02-25-2009 12:56 PM

your config.php.new is what you are requred to edit when you install a new vbulletin, it probably got uploaded when you were upgrading. The file can be deleted.
I am still recieving the error when I go to your website, if you have set the persistant connection to 0 then i would agree that it is a host problem.

What hosting service do you use?

fodboldforumdk

02-25-2009 01:13 PM

www.one.com

I have tried to set it back to "1" (on) and i can access my site - but still get errors alot.

Really wierd
Right now its on "1" just to have access, but its really not optimal...

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

So what can i do now?- will it be fixed if i run an month old backup i did of the DB? or is it doable the problem to fix`?

fodboldforumdk

02-27-2009 03:45 PM

anyone? - and somehow the avatars on my users and myself not showing anymore

Lynne

02-27-2009 05:40 PM

Code:

Database error in vBulletin :



mysql_pconnect() [&lt;a href='function.mysql-pconnect'&gt;function.mysql-pconnect&lt;/a&gt;]: User fodboldforum_dk already has more than 'max_user_connections' active connections

/customers/fodboldforum.dk/fodboldforum.dk/httpd.www/includes/class_core.php on line 311



MySQL Error   : 

Error Number  : 

Request Date  : Friday, February 27th 2009 @ 08:38:58 PM

Error Date    : Friday, February 27th 2009 @ 08:38:58 PM

Script        : http://www.fodboldforum.dk/forumdisplay.php?f=0

Referrer      : http://fodboldforum.dk/

IP Address    : xxxxxx

Username      : 

Classname     : vb_database

MySQL Version :

This is something you need to talk to your host about.

As for the avatars, look in the page source and see if the image is being linked there. Then try to go directly to that link - are you getting an error? If so, that is why they aren't showing up.

All times are GMT. The time now is 11:52 AM.

Page 2 of 3

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02224 seconds Memory Usage 1,731KB 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 (1)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: