upgrade to 4.7 causes 'no image' on all pages using amazon tools

actually - the problem was different that what anyone of us thought. I painstakingly deactivated each module I had installed one by one with no luck....and then I noticed the note at the top of the modules page that said 'Be sure to run the update.php script each time you update to a new module". I hadn't updated to any new modules - but I thought, why not? What do I have to lose?

I did the update.php script, and for amazon tools this is what I got:

amazon module
Update #1

    * ALTER TABLE {amazonitem} CHANGE ASIN asin VARCHAR(10)
    * ALTER TABLE {amazonitem} CHANGE DetailPageURL detailpageurl TEXT
    * ALTER TABLE {amazonitem} CHANGE SmallImageURL smallimageurl VARCHAR(255)
    * ALTER TABLE {amazonitem} CHANGE SmallImageHeight smallimageheight INT(10)
    * ALTER TABLE {amazonitem} CHANGE SmallImageWidth smallimagewidth INT(10)
    * ALTER TABLE {amazonitem} CHANGE MediumImageURL mediumimageurl VARCHAR(255)
    * ALTER TABLE {amazonitem} CHANGE MediumImageHeight mediumimageheight INT(10)
    * ALTER TABLE {amazonitem} CHANGE MediumImageWidth mediumimagewidth INT(10)
    * ALTER TABLE {amazonitem} CHANGE LargeImageURL largeimageurl VARCHAR(255)
    * ALTER TABLE {amazonitem} CHANGE LargeImageHeight largeimageheight INT(10)
    * ALTER TABLE {amazonitem} CHANGE LargeImageWidth largeimagewidth INT(10)
    * ALTER TABLE {amazonitem} CHANGE Author author VARCHAR(255)
    * ALTER TABLE {amazonitem} CHANGE Binding binding VARCHAR(100)
    * ALTER TABLE {amazonitem} CHANGE listAmount listamount INT(10)
    * ALTER TABLE {amazonitem} CHANGE listCurrencyCode listcurrencycode CHAR(3)
    * ALTER TABLE {amazonitem} CHANGE listFormattedPrice listformattedprice VARCHAR(10)
    * ALTER TABLE {amazonitem} CHANGE Title title VARCHAR(100)
    * ALTER TABLE {amazonitem} CHANGE Amount amount INT(10)
    * ALTER TABLE {amazonitem} CHANGE CurrencyCode currencycode CHAR(3)
    * ALTER TABLE {amazonitem} CHANGE FormattedPrice formattedprice VARCHAR(10)
    * ALTER TABLE {amazonitem} CHANGE Availability availability VARCHAR(50)
    * ALTER TABLE {amazonitem} ADD editorialreview longtext
    * ALTER TABLE {amazonnode} ADD rating smallint
    * ALTER TABLE {amazonnode} CHANGE ASIN asin VARCHAR(10)
    * UPDATE amazonnode SET ntype='amazon_node' WHERE ntype='amazon-node'
    * UPDATE node SET type='amazon_node' WHERE type='amazon-node'
    * UPDATE vocabulary_node_types SET type='amazon_node' WHERE type='amazon-node'

Update #2

    * UPDATE {node} SET type = 'amazon_node' WHERE type = 'amazon-node'
    * UPDATE {amazonnode} SET ntype = 'amazon_node' WHERE ntype = 'amazon-node'

Now remember, as I previously stated....I updated my 4.6.3 installation to the latest 4.7.3. I followed the upgrade instructions by backing up my site, starting with new code, running update.php to update the database, then adding in an enabling all additional modules one by one. But for some reason, when the 4.6.3-4.7 udpate occured - it did NOT update the amazon tools database tables to the newer version at all.

You should put this in your documentation. I'm going to post this to all the similar problems I can find in the forums! Thanks for the help, it wasn't really your fault, but it's something to note. One would never suspect that the upgrade to 4.7 would not update these (new) tables, that why what the new install.sql scripts are supposed to do. I guess they didn't work (right) in this instance.

make sure your permissions allow all roles to see amazon items....