Hi David,
my host transferred my website to another server and now I get the following errors. I believe it has sometzhing to do with the MySQL but I do not understand it. Could you please help me?
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/drjayco/public_html/pay-day-cash/includes/database.php on line 21
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/drjayco/public_html/pay-day-cash/includes/database.php on line 26
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/drjayco/public_html/pay-day-cash/includes/database.php on line 21
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/drjayco/public_html/pay-day-cash/includes/database.php on line 26
Regards Roland
Hi Roland,
In addition to the check that jonny mentions (and also that the other MySQL config parameters are correct); check that you have setup the script again. Either way, the setup script will tell you which MySQL parameters in config.php may be wrong. Go to:
http://www.yoursite.com/setup.php
...and assuming that you are set up, see if there are any error messages displayed as these will indicate which fields in config.php need to be changed on your new server.
If everything is OK in setup.php, send me an email and I will send you the debug version of database.php that will reveal which query is generating the error.
Cheers,
David.
Hi David, hi Jonny
the config.php is setup correctly and befor the transfer of the site everything was ok. Now that I have checked the setup.php I found the following entries:
Checking database connection...PASS
Checking database selection...PASS
Checking database tables...FAIL click here to install tables
When I click on "install tables" nothing happens. I have checked the MySQL database and saw that all tables are installed and in the tables all products are registered and imported.
Regards
Roland
Hi Roland,
I have sent you the debug version of database.php - check your email for it and instructions. This should tell us what is wrong..!
Cheers,
David.
Hi Jonny,
The problem is fixed - MySQL had crashed on his server and some tables needed to be repaired.
Cheers!
David.
go to your config file and make sure you have localhost and not the ip address set, if it is the ip address replace with "localhost"