close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

cart works locally not at remote server

Thread began 7/17/2011 8:36 am by James L | Last modified 7/18/2011 5:04 pm by Jason Byrnes | 1165 views | 5 replies |

James L

cart works locally not at remote server

Finally after much trial and error the store works perfectly on local MAMP server, but files put on remote server I get this error message:

Notice: Undefined variable: database_connNewProRes in /home2/charles4/public_html/store.php on line 43
Notice: Undefined variable: connNewProRes in /home2/charles4/public_html/store.php on line 43
Warning: mysql_select_db() expects parameter 2 to be resource, null given in /home2/charles4/public_html/store.php on line 43
Notice: Undefined variable: connNewProRes in /home2/charles4/public_html/store.php on line 45
Warning: mysql_query() expects parameter 2 to be resource, null given in /home2/charles4/public_html/store.php on line 45


In the store.php file lines 43 and 45 are:

43 - mysql_select_db($database_connNewProRes, $connNewProRes);
44 - $query_rsItems = "SELECT * FROM items WHERE ItemCatID = 1 ORDER BY ItemID ASC";
45 - $rsItems = mysql_query($query_rsItems, $connNewProRes) or die(mysql_error());

What does "mysql_query() expects parameter 2 to be resource, null given" mean??

I used the same files when this worked remotely before (with UPS shipping) the only thing different is the changeover to USPS shipping (which I would think has nothing to do with this issue so early in the process).
I'm also using the same database that I used before...

Sign in to reply to this post

Jason ByrnesWebAssist

these errors mean that there is a problem with the connection file and creating the database connection.


usually this happens if you edit the connection file by hand and change the names of the variables that are created by the connection. Did you edit the connection file at all?

Sign in to reply to this post

James L

changed connection file

Yes, I have to change it because it's different for local and remote. For local I use root and root for username and password, but on remote server it has to be the clients login and password, also for this host I have to add the username to the beginning of the database name. I change it on the server using ControlPanel/File Manager/edit file. I've done it this way before and it never caused me this error...

Sign in to reply to this post

Jason ByrnesWebAssist

From your description of the problem, it sounds liker you edited the names of the variables in the connection, not just the values.



for example, if I create a connection named test, the code in my connection file will look like this:

php:
<?php

# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_test "localhost";
$database_test "test";
$username_test "root";
$password_test "rootPW";
$test mysql_pconnect($hostname_test$username_test$password_test) or trigger_error(mysql_error(),E_USER_ERROR); 
?>




when you edit this for the remote server, the variable names must stay the same, only the values of the variables get changed:

php:
<?php

# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_test "remoteServer";
$database_test "remoteDB";
$username_test "root";
$password_test "rootPW";
$test mysql_pconnect($hostname_test$username_test$password_test) or trigger_error(mysql_error(),E_USER_ERROR); 
?>





if you change the variable names, for example:
$hostname_test

it will cause the errors you are describing.

Sign in to reply to this post

James L

I see the problem

So glad you showed those examples, I got it immediately. I had changed the file name of the connection file, and dreamweaver set it up correctly, but then I had just cut and pasted the content out of the original working connection file. I was blind to the fact that the names on the left side changed also (they are similar, after all...)

original working file that I copied:
$hostname_connProRes = "localhost"; etc.

my new should have been:
$hostname_connNewProRes = "localhost";

Thanks again for the rescue.

Sign in to reply to this post

Jason ByrnesWebAssist

you're welcome.

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...