Hi - I just installed PT and set the config.php variables. Now I get a search box and these messages on my website:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/content/p/r/i/pricescan/html/includes/database.php on line 21
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/p/r/i/pricescan/html/includes/database.php on line 26
Does anyone know what I might have done wrong or how I should resolve this?
Thanks so much. -- Steve
Thanks David - this is what I get when I add set.up to my url:
Checking database connection...FAIL check $config_databaseUsername and $config_databasePassword values
Checking database selection...FAIL
Checking database tables...FAIL
I'm using GoDaddy. I set up a sql database there in my account. I placed the username and password in the config.php file.
Thanks - Steve
P.S. here is my config.php file
<?php
$config_title = "PriceTapestry";
$config_charset = "";
$config_baseHREF = "/";
$config_useRewrite = false;
$config_useTracking = false;
$config_useJavaScript = true;
$config_useInteraction = true;
$config_currencyHTML = "$";
$config_resultsPerPage = 10;
$config_databaseServer = "mysql111.secureserver.net";
$config_databaseUsername = "pricescan";
$config_databasePassword = "**********";
$config_databaseName = "pricescan";
$config_databaseTablePrefix = "";
?>
Thanks for that Steve - can you try the following script. Save it as a file called "mysqltest.php", and see what error message or output you get. It should display the mysql server version.
<?php
$link = mysql_connect("mysql111.secureserver.net","pricescan","**********");
print "<p>".mysql_get_server_info($link)."</p>";
print "<p>".mysql_error($link)."</p>";
?>
Apologies for the inconvenience; it is all down to the mysql connection so we just need to figure out what's going on and you should be in business...
(edit: i've now removed your password from this and your previous post)
Hi David - Now I get:
Checking database connection...PASS
Checking database selection...PASS
Checking database tables...FAIL click here to install tables
What should I do next? Thanks so much...
Great - that means you're nearly there now - just click the link to install the tables, and the page should refresh to setup.php with all tests passed.
Did you find out what the problem was with the mysql connection? I'm wondering if it just took a few minutes for your new database to be setup, and when you first tried it wasn't ready...?
Thanks David,
It looks like everything is working. I'll go to the manual to get started on category mapping and datafeeds. I'm not sure if the sql connection had to do with time delays or not. I'll talk to Go Daddy at some point and see if I can give you some feedback. Now I just want get going with this great program! - Take care. Steve
Hi Steve,
Just to confirm, you have run setup.php to install the database tables?
Would you mind posting the URL to your site so that I can take a look?
Thanks,
David.