I have a wierd problem which has just started since our admin upgraded our server. <br /> <br />Current s/w versions are UBB6.2.3, PHP 4.3.1, MySQL 3.23.49, Apache 1.3.27 <br /> <br />I have written a package which uses the UBB user-id for the username. So, the first thing I do is to check the UBB authentication of the user: <br /> <br /> <br />Once this is done, I load my code and login to the db with a separate user and select my database: <br /> <br /> <br />Now, the problem is that when the UBB authenticate() function is called, it makes a query on the database. However, the db query fails because it appears to be attempting to access "mydb.xxxxx" (sorry, can't recall the table name off-hand). The issue is that is appears to be trying to use mydb rather than the UBB database - even though the mysql_select_db() has not yet been run to connect to mydb. <br /> <br />From what I can tell from the PHP/MySQL status, there is a single persistent connection to MySQL, which I assume belongs to UBB. <br /> <br />This all worked fine before the upgrade, but I can't think for the life of me why it is failing now. <br /> <br />Anyone got any ideas of why it is failing or things I might try ?

I think I should add that UBB works fine on its own.

Ah, I now have the answer to this problem.<br /><br />The sysadmin had given the UBBThreads db the same login id and password as my database, so they had ended up sharing the connection which became a problem when my code selected a different database.<br /><br />Fixed by adding an extra parameter to mysql_connect in my code:<br /><br />$db = mysql_connect("localhost", $dbuser, $dbpass, true);