Error Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resour

I am getting the following when attempting to login:

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/hhr/public_html/CMS/admin/index.php on line 42

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/hhr/public_html/CMS/admin/index.php on line 44

Any ideas?

New install v1.2

Do you have a different connection file for live versus local? You normally only get this error when the values referenced on these lines is not in the connection file that is included at the top of the page. If you have different connection files for the live versus the local you will need to update one or the other so that the connection file itself is the same, but the values used in it differ.

For example, if you have a different host, username, password, or db value in the connection file you should update the version you are working with to have the correct values in it. Normally the file just makes use of the values that were entered into the wizard, so if you set it up locally but now want it to be on a live server you will need to update the information that is in this connection file.

I am able to get to the login screen but when I login that's the message I get. I am on a remote server using localhost. My database, username and password remain the same from my local machine.

There might be a problem with the location of the connection file on this page. You must ensure that the require_once line for the connection file occurs before any recordset code. If you have any further trouble with this post back with a zip archive of the login page and the page you are trying to go to after logging in so that I can take a look.

Originally Said By: Eric Mittman

  There might be a problem with the location of the connection file on this page. You must ensure that the require_once line for the connection file occurs before any recordset code. If you have any further trouble with this post back with a zip archive of the login page and the page you are trying to go to after logging in so that I can take a look.  

I remember a full "install" guide when v.1 was available.

I have attached the index file from the admin folder and the connection file.

Thanks

Note: The password has been changed

The problem is that your connection file has been modified and a key piece has been removed. In the connection file after the values are set you need to have this line of code:

$localhost = mysql_pconnect($hostname_localhost, $username_localhost, $password_localhost) or trigger_error(mysql_error(),E_USER_ERROR);

This is what is creating the connection to your MySQL server, the MySQL link resource is then stored in this $localhost variable. On your index page on the line you are getting the error on the code looks like this:

mysql_select_db($database_localhost, $localhost);

It is referencing this $localhost variable that was missing in the connection file. So the error is letting you know that this MySQL resource, $localhost, is not valid.

That solved the issue; thank you!

Glad to hear that, let us know if you have any other questions.