I've just installed, run update.php and am running the test - but I'm getting an error

Field 'brand' doesn't have a default value query: INSERT INTO amazon_item (asin, title, detailpageurl, salesrank, publisher, manufacturer, studio, label, binding, productgroup, producttypename, timestamp) VALUES ('0316726648', 'Persian Fire', 'http://www.amazon.com/Persian-Fire-Tom-Holland/dp/0316726648%3FSubscriptionId%3D0CD9RCQYM0TBVH55NB82%26tag%3Dviaposit-20%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3D0316726648', 1632508, 'Time Warner Books UK', 'Time Warner Books UK', 'Time Warner Books UK', 'Time Warner Books UK', 'Hardcover', 'Book', 'ABIS_BOOK', 1242646939)

Comments

pkiraly’s picture

I receive same warning messages with the 'binding' field.

user warning: Field 'binding' doesn't have a default value query: INSERT INTO amazon_item (asin, title, detailpageurl, salesrank, brand, publisher, manufacturer, mpn, studio, label, listpriceamount, listpricecurrencycode, listpriceformattedprice, productgroup, producttypename, timestamp) VALUES ('B000HG84CS', 'Timolino 16 oz. Aromatic Australian Press, black', 'http://www.amazon.com/Timolino-Aromatic-Australian-Press-black/dp/B000HG...', 515525, 'Timolino', 'Timolino', 'Timolino', 'APA-05GBL', 'Timolino', 'Timolino', 1700, 'USD', '$17.00', 'Kitchen', 'KITCHEN', 1249555901)

I tried 6.x-1.x-dev, and amazon-6.x-1.0-beta7 and both gave the same warning.

shaundychko’s picture

Hello, I get the same type of error with the 'releasedate' when referring to a tea kettle: (installed amazon-6.x-1.0-beta7 with Drupal 6.13 and the latest everything else)

user warning: Field 'releasedate' doesn't have a default value query: INSERT INTO amazon_item (asin, title, detailpageurl, salesrank, brand, publisher, manufacturer, mpn, studio, label, binding, productgroup, producttypename, timestamp) VALUES ('B000CQFEKS', 'KitchenAid 2-qt.Teakettle Multiple Colors Available', 'http://www.amazon.com/KitchenAid-2-qt-Teakettle-Multiple-Colors-Availabl...', 0, 'KitchenAid', 'Meyer Corp.', 'Meyer Corp.', '177446', 'Meyer Corp.', 'Meyer Corp.', 'Kitchen', 'Kitchen', 'HOME', 1251131890) in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\chap04\includes\common.inc on line 3436.

And I get the exact same type of error when referring to a book:

user warning: Field 'brand' doesn't have a default value query: INSERT INTO amazon_item (asin, title, detailpageurl, salesrank, publisher, manufacturer, studio, label, binding, listpriceamount, listpricecurrencycode, listpriceformattedprice, productgroup, producttypename, timestamp) VALUES ('0143113100', 'The Brain That Changes Itself: Stories of Personal Triumph from the Frontiers of Brain Science (James H. Silberman Books)', 'http://www.amazon.com/Brain-That-Changes-Itself-Frontiers/dp/0143113100%...', 494, 'Penguin (Non-Classics)', 'Penguin (Non-Classics)', 'Penguin (Non-Classics)', 'Penguin (Non-Classics)', 'Paperback', 1600, 'USD', '$16.00', 'Book', 'ABIS_BOOK', 1251133674) in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\chap04\includes\common.inc on line 3436.

ahansen1’s picture

rfay’s picture

Status: Active » Postponed (maintainer needs more info)

Is this a current issue with the current release? (6.x-1.0-beta7)?

rfay’s picture

Status: Postponed (maintainer needs more info) » Fixed

I believe this is fixed in the current dev release and in upcoming 6.x-1.0-beta9. Please reopen if it's still a problem.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.