I just installed the latest version of amazontools, and run the update.php . It updated the database to version 2 successfully. Now when i went back to admin/modules it is giving error message.

user warning: Unknown column 'rating' in 'where clause' query: SELECT COUNT(DISTINCT asin) AS count FROM amazonnode WHERE rating >= 3 AND ntype = 'amazon' in /home/website/public_html/drupal/includes/database.mysql.inc on line 120.

any idea whats the problem? Previously in drupal version 4.6 i used to use amazonsearch and amazon_items modules as well, but since these two are no longer working in drupal 4.7 i removed both of them from drupal/modules folder. Now the only amazon module in drupal/modules folder is the most recent version of amazontools.

regards,
--rafi

Comments

chaos21in’s picture

chaos21in commented
Priority: Critical » Normal
Status: Active » Closed (fixed)

Sorry i didnt read the install.txt previously. For upgradation from 4.6 to 4.7, i had to choose update 1 from amazon module combo box and not 2. So now when i chose 1, it worked perfectly. I still do not understand why the latest version is called 1 and not 2. I thought 2 is higher and hence latest.

regards,
--rafi

Prometheus6’s picture

Prometheus6 commented

Actually, I thought selecting 2 would run both, in order. I have to look into that.

Prometheus6’s picture

Prometheus6 commented

Okay, for the record, you have to pick the first applicable upgrade (which will be automatically selected for you). The update runs that and all subsequent (rather than all prior) upgrades.