I recently upgraded my drupal install to beta 4 and it seems to have broken my amazon tools.

If I try to import a node through administer/amazon item import, I get a listing as I should, I select one item and move forward and receive a :

user warning: Unknown column 'rating' in 'field list' query: INSERT INTO amazonnode (nid, asin, ntype, rating) VALUES (319, '0393059979', 'amazon_node', 0) in /home/kazys/public_html/varnelis/includes/database.mysql.inc on line 118.

ok, now, i don't know much about mysql, but that field is under amazonitem, not amazonnode. of course, i ran the upgrade to mysql...

if I use create content-> amazon node, i am told the item is already registered (even on items i know i've never registered!!)

If i use create content-> amazon, I am give the first error.

i tried the 4.7 module and cvs. neither works. the errors given are for cvs.

Any thoughts?

Comments

Prometheus6’s picture

Prometheus6 commented

First, I had to get rid of update.mysql. It's been replaced by the amazon.install file, which uses the install system that will ship with 4.7. I added the rating column afterward. That bit of confusion is entirely my fault.

If you run this SQL command in your database

ALTER TABLE amazonnode ADD rating smallint

You'll be okay. If you use table prefixing, you probably know enough not to need my advice. :-)

Your other problem was dealt with here

http://drupal.org/node/51697

just a few minutes ago.

Prometheus6’s picture

Prometheus6 commented
Assigned: Unassigned » Prometheus6
Status: Active » Closed (duplicate)