Posted by tresero on September 28, 2009 at 6:36pm
| Project: | Amazon Module |
| Version: | 6.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed (fixed) |
| Issue tags: | 6.x-1.0 blocker |
Issue Summary
# warning: pg_query() [function.pg-query]: Query failed: ERROR: type "real_unsigned" does not exist LINE 14: listpriceamount real_unsigned, ^ in /var/www/sites/dev.xxxxx.com/drupal-6.14/includes/database.pgsql.inc on line 139.
# user warning: query: CREATE TABLE amazon_item ( asin varchar(64) NOT NULL, title varchar(255) NOT NULL, detailpageurl varchar(255) NOT NULL, salesrank int_unsigned, brand varchar(64) NOT NULL, publisher varchar(64) NOT NULL, manufacturer varchar(64) NOT NULL, mpn varchar(128), studio varchar(64) NOT NULL, label varchar(64) NOT NULL, binding varchar(64) NOT NULL, releasedate varchar(64) NOT NULL, listpriceamount real_unsigned, listpricecurrencycode varchar(32), listpriceformattedprice varchar(32), productgroup varchar(255) NOT NULL, producttypename varchar(255) NOT NULL, timestamp int_unsigned NOT NULL default 0, PRIMARY KEY (asin) ) There is no unsigned in SQL, please change it to numeric. float and real are inexact.
Comments
#1
You also are using not null in fields that are returned null.
binding
releasedate
are 2.
#2
Postgres porting will be a significant task. Is it worth doing? Please chime in if this is relevant to you.
#3
#4
#5
Fixed as you suggested, @tresero. Please download the dev version and see how it works for you.
It seems to work for me, with a modest level of testing.
Thanks,
-Randy
http://drupal.org/cvs?commit=306720
#6
Automatically closed -- issue fixed for 2 weeks with no activity.