To reproduce, first enable Cart, Product, Order, Store, CA, Shipping Quotes. Submit. Now enable Shipping, and these errors pop up:
Notice: Undefined index: integer:normal in DatabaseSchema_mysql->processField() (line 165 of /xxxx/xxxx/public_html/includes/database/mysql/schema.inc).
PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'unsigned DEFAULT NULL, PRIMARY KEY (`package_id`) ) ENGINE = InnoDB DEFAULT CHA' at line 13: CREATE TABLE {uc_packages} ( `package_id` INT unsigned NOT NULL auto_increment, `order_id` INT unsigned NOT NULL DEFAULT 0, `shipping_type` VARCHAR(255) NOT NULL DEFAULT '', `pkg_type` VARCHAR(255) NOT NULL DEFAULT '', `length` FLOAT DEFAULT NULL, `width` FLOAT DEFAULT NULL, `height` FLOAT DEFAULT NULL, `length_units` VARCHAR(255) DEFAULT NULL, `value` DECIMAL(16, 5) DEFAULT 0, `sid` INT unsigned DEFAULT NULL, `tracking_number` VARCHAR(255) DEFAULT NULL, `label_image` unsigned DEFAULT NULL, PRIMARY KEY (`package_id`) ) ENGINE = InnoDB DEFAULT CHARACTER SET UTF8; Array ( ) in db_create_table() (line 2406 of /xxxx/xxxx/public_html/includes/database/database.inc).
Comments
Comment #1
Island Usurper commentedThe type for the label_image was set as "integer" when it is supposed to be "int". The Schema API maybe ought to accept both, but mostly I should have paid better attention to what had already been done.
Comment #2
tr commentedThat fixes it.
Comment #3
Island Usurper commentedGreat. Committed.