Too many skipped books and problems with discounted items

[reDDevil]

I have been trying to use FREEBS with a search phrase "slot machines" and noticed the following strange things and probably bugs:

1. Amazon finds 208 items for keywords "slot machines" but FREEBS with its script p3.php gets only 177 items. Moreover it skips 114 items so only 63 books are added to a database. The question here is why there is a difference between search results and why so many books skipped by FREEBS?

2. There is a price-problem with all discounted books like this one:
[url]http://www.amazon.com/exec/obidos/tg/detail/-/156980169X/qid=1134396775/sr=1-1/ref=sr_1_1/104-2384456-4830333?v=glance&s=books[/url]
As you can see there is no "Our Price" field but there are "List price" and "Price" fields. The problem is that FREEBS doesn't show any price for such items on detailed page
Strange thing here that in alphabetical list there is a parsed price:

Don't Play the Slot Machines (Until You've Read This Book)
ISBN: 156980169X ASIN: 156980169X
Author: Michael D. Geller
Publisher: Barricade Books, Inc. March, 2001
Our Price: $9.60 Usually ships in 2 to 3 weeks
As of: December 12th, 2005 04:41:23 PM

But on details page of item there is no any price.

Don't Play the Slot Machines (Until You've Read This Book)
Published: March, 2001
Our price:
List price:

As of: December 12th, 2005 05:55:01 PM

Author: Michael D. Geller

Is it possible to show "List Price", "Price" and "You Save" fields for discounted items? Or as a minimum "Our price" as it's parced?

3. The second problems with discounted books is that the button "Buy from Us" always leeds to a Not Found page of Amazon with a notice:

Important Message:
The item that you tried to add to your cart is not recognized by our catalog. To find the item that you're looking for, try using the search box at the top of the page.

Look here:
[url]http://www.amazon.com/gp/legacy-handle-buy-box.html/104-2384456-4830333?asin.156980169x=1&tag%5Fvalue=eurocazino-20&tag-value=eurocazino-20&dev-tag-value=0DZDQYXBZ0N8AYB379G2&submit.add-to-cart=Buy%20From%20Us[/url]

4. The block "Similar Slot Machines Books" has always the same book and only one as current book is loaded
Example:
A description page of book "Don't Play the Slot Machines..."
/slot-machines-books/isbn156980169X.html
Has the same book as "Similar Slot Machines Books" with the same link:
/slot-machines-books/isbn156980169X.html

Don't Play the Slot Machines (Until You've Read This Book)
Published: March, 2001
Our price:
List price:

As of: December 12th, 2005 05:55:01 PM

Author: Michael D. Geller

Similar Slot Machines Books

Don't Play the Slot Machines (Until You've Read This Book)

Unfortunately I can not show you all these problems on my public server because I have the following errors while trying to run p3.php script there:

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ENGINE=MyISAM' at line 24You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ENGINE=MyISAM' at line 7

Processing search record 1 of 177 actual search records returned.
ASIN: 1566250013
Name: Break the One-Armed Bandits!
Availability: Usually ships in 2 to 4 weeks

MySql Error Result Code: No Database Selected
on item asin: 1566250013 no DB insert occured.
My Sql Error Result Code: No Database Selected
on sims for asin: 0929712099 no DB insert occured.
My Sql Error Result Code: No Database Selected
on sims for asin: 1566252350 no DB insert occured.
My Sql Error Result Code: No Database Selected
on sims for asin: 0818406402 no DB insert occured.
My Sql Error Result Code: No Database Selected
on sims for asin: 0818405848 no DB insert occured.
My Sql Error Result Code: No Database Selected
on sims for asin: 0966459229 no DB insert occured.

And so on...

Any ideas how to resolve it?

[Greg]

What version of PHP, MySql, and apache are you on? Are you in safe mode?

If two different ISBN's have the same book and different info, that's on amazon and it's common. Very common. I've had discussions with authors regarding this. I don't have any solution to this.

The MyIsam Thing can be fixed. Open p3.php...

Find:

PHP Code:

ENGINE=MyISAM 


Change to:

PHP Code:

TYPE=MyISAM 


All the info for the book pricing is pulled on demand so ALL the pricing info is available for display and is current to the second. If it's not there, the soap call for that book didn't include it.

[reDDevil]

Thank you! MyISAM problem fixed on remote server and database problem also resolved after restarting MySQL. And after that the problems with thr prices, button "Buy From Us" and "Similar books" are not noticed anymore on a remote server with a remark that a block "Similar books" is showing on only some pages. Is it normal? What are criteria for Similar books?

And unfortunately on a local machine I have all described problems in my previous message excluding database problem.

I have installed there:
Apache/1.3.33 (Win32)
PHP/4.4.0
MySQL 4.1.8-max

Safe mode is off on a local machine. Shall I turn it On?
What exactly Safe mode do you mean. In my php.ini there are three strings:
safe_mode = Off
safe_mode_gid = Off
sql.safe_mode = Off

[Greg]

Your safe mode setting should be fine, don't change it.

Similars are not available for all books. They are supplied with the book info from amazon if there are any.

I'm not certain why you have issues with your test server. We have users on many *nix flavors and windows servers too running book stores.