Hi David,
As mentioned in an earlier post have moved a site to a new dedicated server. Now having problems with importing feeds. The host copied all the information across to the new server and I copied the databases by doing a backup on my old server and restoring them on to my new one. All looks ok on the site, all products are being displayed.
Running into problems when importing a new feed. Getting
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/username/public_html/includes/database.php on line 21
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/username/public_html/includes/database.php on line 26
Ran setup.php and all is ok there.
Any ideas?
Thanks
Adrian
Hi Adrian,
Had you made any modifications to the database schema on the old site... You mentioned running setup.php - that (presumably) would have installed the database tabled from the setup.sql file - or did you recreate your database from backup, run setup.php and it just shows all OK?
At which stage of importing does the error occur; is it immediately as you click 'Import'? (I presume all feeds are already registered if you have recreated the database from a backup)...
I'll email you the debug version of database.php which will reveal the query that failed and the MySQL error message, which should point to the problem...
Cheers,
David.