execute SQL bug?

[fodboldforumdk]

Hi,
I have a problem when i try to "Execute SQL Query"

Its for my "vbookie" mod were i need to reset the cash for my users.

I enter: UPDATE user SET vbookie_cash=500 and press excecute

The outcome says:
An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'fodboldforum_dk.user' doesn't exist

I really dont know how to fix this or even understand what it mean.

Anyone ?

[Lynne]

You probably have a table prefix and you need to add that in front of "user" in the query.

You should be asking questions regarding modifications in the modification thread.

[fodboldforumdk]

yes, i tried to vb3_user
And the outcome was: Affected Rows: 16 (0.0263s)

So i guess the excetuting was done right?

[Lynne]

I would guess so, if there were affected rows. If you are able to view the database, you could always check. Or, you'll find out when you try to use the mod whether or not you did it correctly.

[Dismounted]

So i guess the excetuting was done right?
If the affected rows count is more than 0, then it should be OK. You can verify this by looking at the table through phpMyAdmin, etc.

[fodboldforumdk]

16 rows was affected i think it said... but now i got problems with the DB.. but it dont say what type of errors.. just "Database error" 2 out of 3 trys to enter site i get that anoying error.

Are there a way i can do something about this? - can i re-update the software VB ?

[Marco van Herwaarden]

View the page source to get the full SQL error.

[fodboldforumdk]

how can i do this?

[Marco van Herwaarden]

Rogt click on the error page and select View Source.

[fodboldforumdk]

okay,
here is the error.. can anyone se whats wrong?

Database error in vBulletin :

mysql_pconnect() [<a href='function.mysql-pconnect'>function.mysql-pconnect</a>]: 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 : Monday, February 23rd 2009 @ 05:49:15 PM
Error Date : Monday, February 23rd 2009 @ 05:49:15 PM
Script : http://www.fodboldforum.dk/forumdisplay.php?f=0
Referrer : http://www.fodboldforum.dk/
IP Address : 79.138.255.77
Username :
Classname : vb_database
MySQL Version :

[Lynne]

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

[fodboldforumdk]

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

[Marco van Herwaarden]

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]

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]

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

[fodboldforumdk]

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]

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]

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 1235649218 at 1235649218 ---------------

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]

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

[Lynne]

Database error in vBulletin :

mysql_pconnect() [<a href='function.mysql-pconnect'>function.mysql-pconnect</a>]: 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.

[fodboldforumdk]

seems like i need to change host then because they just say its not a problem at them...

So the big question is, what should i ask a new host about to keep out of this problem in the future ?

[Lynne]

I notice you have a chatbox on your site. I'd try turning that off and see if the problem goes away.

If you have questions regarding hosting, you should post over at vb.com in their Hosting forum. They should be able to help you out.

[Zachery]

The mysql user is using more active connections than it is allowed. Its not a vBulletin issue, your webhost is limiting your mysql resources.

[fodboldforumdk]

are there any way to find out how much trafik total a VB forum use a month and how many "connections" to sql?