We have a live and a test server (exact copies of the website)
On the live we can update feeds "import", "register" etc
On the test server we get errors, any ideas please
-----------------------------
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\fetchandcompare_new\dog-shop\includes\database.php on line 27
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\fetchandcompare_new\dog-shop\includes\database.php on line 32
Warning: Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\fetchandcompare_new\dog-shop\includes\database.php:27) in C:\xampp\htdocs\fetchandcompare_new\dog-shop\admin\feeds_import.php on line 31
-----------------------------
We use xamp on a windows machine but don't think that is the issue as we have always used it
Hi David, We have already tried that and the error we get when trying to import is as follows:
---------------------
Warning: Cannot modify header information - headers already sent by ({code saved}\admin\feeds_import.php on line 31
----------------
The fields ‘Product Name’, ‘Product Description’ etc do not exist in the table pt_products?
Regards
Jason
Hi Jason,
That's a strange one! Please could you email me your modified:
includes/admin.php
admin/feeds_import.php
...from your dev site and i'll check that out for you...
Cheers,
David.
--
PriceTapestry.com
Hi Jason,
Whenever database errors occur during development you can enable debug mode to view the full MySQL error message. To do this, edit line 6 of config.advanced.php as follows;
$config_databaseDebugMode = TRUE;That should reveal the problem - let me know what is displayed if you're still not sure of course; but don't forget to disable by changing back to FALSE once the problem is resolved.
The same issue may in fact be present on the live server but the PHP configuration is different and error messages are not displayed...
Cheers,
David.
--
PriceTapestry.com