[RESOLVED] No database selected

lajkonik86

Im running twice the same website
- one for the public
- one for private testing
Everything is moreless the same, except some config variables in the php and the replacement of css directories

However on the test server im getting a no database selected

mysql_query('sqlhere') doesnt work
mysql_query('sqlhere',$conn) does work

So somehow on my test server it is not taking the only open connection, but wants it specified.

After trying for an hour, what could be causing this?

Another little question, how are you guys using testservers and how do you update the live website when neccesary, should i put it in maintenance mode, or just simply upload at 12 in the evening. What is the best approach?

Thanks,
Thierry

bradgrafelman

If specifying the connection resource works, then you apparently have more than one connection open and PHP is picking the wrong one.

Do you have any other mysql_connect() calls (or, for whatever reason, mysql_pconnect()) in the script?

lajkonik86

not in my script,
there's just one connect

thats the strange thing

could an old persistent connection have been left open and if so how do i check for that?

lajkonik86

how do i close or see old pconnect connections?

lajkonik86

cant really seem to figure this one out, very strange problem.
could it be some php setting or something?

bradgrafelman

If you do a phpinfo(), you'll see a MySQL table. In that table, there are two lines that give you information about the number of connections - "Active Persistent Links" and "Active Links." What do these two say? What if you do a phpinfo() from within the above mentioned script?

lajkonik86

from within the script:

Active Persistent Links 0
Active Links 2

bradgrafelman

Any chance you can attach the script as a .txt file so we can look at it?

lajkonik86

having that info i was able to go through the code looking for the problem.

a script i used made a double connection to the database,
on my normal server it made the same connection, here it tried a different one

solved🙂