Got the following errors when trying to install Amazon API, Filter, Media and Search all at once. I'm running PHP 5.2.3 and PostgreSQL 8.3.

    * warning: pg_query() [function.pg-query]: Query failed: ERROR: type "real_unsigned" does not exist LINE 13: listpriceamount real_unsigned, ^ in /usr/share/php/drupal/includes/database.pgsql.inc on line 138.
    * 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, 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) ) in /usr/share/php/drupal/includes/database.inc on line 509.

Comments

Anonymous’s picture

Anonymous (not verified) commented

By the way, I filed this bug for Drupal Core, which I think is the real culprit.

http://drupal.org/node/258258

Thanks,
Curtis.

eaton’s picture

eaton commented
Status: Active » Closed (duplicate)

Yes -- as best as I can tell this is a SchemaAPI issue. I'm going to set it to duplicate based on the other issue. Thanks!