Hi David,
I have decided (reluctantly) to move hosting providers as the one I currently use does not offer CRON functionality. I had thought I could get around this by calling the data collection and loading from a local PC (running 24/7) but when I tried this it timed out so I decided to migrate instead. I have moved everything set up new dB etc using your dB backup and restore tool, I have also loaded some data. All works fine except for when I display a review page with the embedded code you kindly wrote for me which allows me to display the lowest price on my product review pages. When I view one of these pages I get the error:
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/content/43/10924243/html/Sites/MySite/pt/includes/database.php on line 27
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/content/43/10924243/html/Sites/MySite/pt/includes/database.php on line 32
Despite the error the lowest price is displayed ...
The same error is also displayed on price and product pages.
I wondered if you could suggest what's going wrong and how I might correct it?
Thanks in advance.
Regards
Chris
Hi David,
Thanks as always for your quick response. I changed the config as you suggested and the error pointed to ASIN ...I realised that the ASIN field was missing from my new database as I had neglected to run on of the dbmod files. I emptied all the tables ran the dbmod, restored the backup and reloaded the data only to get a different error!..I was just about to mail you again when I realised the product mappings did not contain ASIN values (even though) my pre migration dB did. Am I correct in thinking that the pt backup does not backup ASIN? Anyway, it's fixed now (I hope!).
Thanks again for your help.
Regards
Chris
Hi Chris,
Glad you're up and running - if you want to add your custom field `asin` to the Product Mapping backup, you can edit admin/database_tool.php and look for the following code at line 50:
$fields["productsmap"][] = "description";..and REPLACE with:
$fields["productsmap"][] = "description";
$fields["productsmap"][] = "asin";Apologies for any inconvenience - as it was a custom added field it wasn't included in the backup by default.
Cheers,
David.
--
PriceTapestry.com
Hi Chris,
If you could view the page with database debug mode enabled by changing line 6 of config.advanced.php as follows:
$config_databaseDebugMode = TRUE;...and let me know the extended MySQL error message that will be displayed that should indicate what's going on...
Cheers,
David.
--
PriceTapestry.com