not a valid MySQL-Link resource

This doesnt seem to be a new problem. I've just uploaded a site to my hosting server, which is working properly on my local WAMP server. Im getting the following errors when trying to login users:

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in .../WA_SecurityAssist/Helper_PHP.php on line 14

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in .../WA_SecurityAssist/Helper_PHP.php on line 20

This corresponds to the following code:

line 14: mysql_select_db($WA_Auth_Parameter["database"], $WA_Auth_Parameter["connection"]);

line 20: $WA_Auth_RS = mysql_query($WA_Auth_loginSQL, $WA_Auth_Parameter["connection"]) or die(mysql_error());

Following another SA forum thread i read i removed the 1st argument in line 14 and the 2nd argument in line 20. This removed the warning errors, but left me with a "no database selected" error.

Please, any help would be so appreciated!

p.s. Ive checked the database connection settings and that appears to be fine.

I also had to change "pconnect" to "connect" due to the way my hosting server is configured. Im not sure if that would make any difference.

Does your local db connection file refer to a different db or is it named differently? You could try updating these lines of code to have the db values that you know will work:

mysql_select_db($the variable from your connection file for the db, $the variable from your connection file that is assigned to your connect function call);

The variables that are referenced on these lines should hold the proper reference. Make sure that the include for the connection file is before the include for the helper file or the authenticate user server behavior.

Solved - I had defined a new connection for the remote mysql server. I noticed that there were instances of the old connection being used in my login page. I altered my old connection, for testing on my local server, to use the remote database, and now all works fine. Should I expect any problems from editing my old DB connection or should a new connection be used when uploading to the remote server? And is there an easy way to update all the connection calls used throughout WA created pages?

Thanks

When I have needs for different connection files I will usually keep them named the same if possible and just update the details of the local or live file to point to the proper db. This way you can have completely separate connections for local and live, but if they have the same name there is no need to update the code that makes use of the connection.

You can update the connection used within the Server Behavior interface or by doing a manual find and replace in the site for the old connection values and updating them to the new one.