Ok, this is a two-for question. First of all, is there a search function for this forum? There are some things that I'd like to find but it's hard to look through every post.
Secondly, I successfully received a data feed from a provider and put it into my /feed/ directory. I then registered it and mapped most of it successfully. I did a trial import. I then went to browse the 10 records that I had just imported. I was able to have a list of merchants (the one imported so far) but when I click on the merchant, the "search.php" page returns the following (as a side note, I haven't modified the database.php, search.php, header.php or the navigation.php):
---------------------------------------------------
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/website/public_html/domain.com/includes/database.php on line 21
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/website/public_html/domain.com/includes/database.php on line 26
Warning: Cannot modify header information - headers already sent by (output started at /home/website/public_html/domain.com/includes/database.php:21) in /home/website/public_html/domain.com/html/header.php on line 6
Home
Product search results for merchant:MerchantsName: (showing 1 to 0 of 10)
Order by: Relevance, Product Rating | Price: Low to High, High to Low
Previous |
Warning: Division by zero in /home/website/public_html/domain.com/html/navigation.php on line 28
Hi David
Did you ever find the solution to this problem? I am having the same on one of my installs.
Thank You
Dean
Hello Dean,
That sounds like the result count SQL hasn't worked correctly. To reveal more information about the error; please could you enable database debug mode by changing line 6 of config.advanced.php as follows;
$config_databaseDebugMode = TRUE;...and then view the page again and let me know what is displayed...
Cheers,
David.
--
PriceTapestry.com
Hi David
Nothing changes. No error codes. I tried a search and it says. Product search results for The California Wine Club (showing 1 to 0 of 21)
Thank You
Dean
Hi Dean,
I know you've been using the script for a few years now; please could you email me your current search.php and includes/database.php and I'll check it out for you.
For example; a modification to avoid a database conflict with WordPress if you have used the legacy external scripts could cause the above effect which I know how to workaround...
Cheers,
David.
--
PriceTapestry.com
Hi,
Firstly, to search the forum use the site-search box on this page:
http://www.pricetapestry.com/forum/
Regarding the database errors - that sounds very strange as if you were able to register / import correctly then the database is obviously working.
Could you please email me a link to your site so that I can take a look for you...
Cheers,
David.