close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 or 2018 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

not a valid MySQL-Link resource

Thread began 4/30/2010 7:55 am by bretherine396470 | Last modified 5/03/2010 6:16 pm by Eric Mittman | 1024 views | 4 replies |

bretherine396470

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!

Sign in to reply to this post

bretherine396470

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.

Sign in to reply to this post

Eric Mittman

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.

Sign in to reply to this post

bretherine396470

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

Sign in to reply to this post

Eric Mittman

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.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...