node level - amazon side

Paste the URL the module generated here so I can see what's up.

Prometheus,
I also really like your module.
It also worked great for a while, and someone even used it to buy a book at amazon.

Now when i click on the links, for some reason, i get redirected with a link of the following url
http://www.amazon.com/exec/obidos/subst/home/home.html/002-1042880-7148035

It doesn't show the book anymore but substitutes....
Help! what do i do?

Okay, this is critical.

Amazon.com released a new version of ECS, and the detail page URLs are CONSIDERABLY longer than the old ones (which still work for now). The field currently is 255 characters long, and Amazon says with the new back end I need to be ready for URLs 1000 characters and more long.

That fix alone is easy. Thing is, in accordance with Amazon's requirements, the module updates book records once per week, which means over the course of a week or less ALL the links will be broken. And the other thing is, I don't get to work on it today.

It WILL be fixed this weekend though.

Thanks, but it's more something that just must be done. The fix is all in the database schema, and since the records are refreshed weekly, the easiest fiix for the whole set of problems is to let the cron job update things 10 records at a time as it does anyway.

So.

ALTER TABLE amazonitem CHANGE DetailPageURL DetailPageURL text
UPDATE amazonitem SET PriceDate = '2005-01-01'

Execute these SQL statements.

When you say that the cron job automatically takes care of this, are you referring to the poormanscron that can be downloaded for drupal or...? I've never been able to get my own cron job to work properly.

Poormanscron will do it.

I'm storing price data in case a site that uses it get popular enough to exceed Amazon's one query per second rule. But when you do that, you have to refresh your prices at least once per week. amazon_cron() gets the 10 oldesr items with PriceDate one week ago or less and refreshes the record (including the new detail page url). Poormanscron will call amazon_cron() like any other cron hook.

Depending on how many books you've already got loaded up, you could load http://www.example.com/cron.php a couple of times.

Question:
(not specifically related to this issue)

I see that Amazon also offers the used book prices for the same book.
Is there a way to link to the used books so to offer my visitors the 'cheaper' version from Amazon?

Tim

Check this to see the data the module retrieves.