I'm getting the following error on install

user warning: BLOB/TEXT column 'asku-settings' can't have a default value query: CREATE TABLE uc_power_tools ( `pcid` VARCHAR(32) NOT NULL DEFAULT '', `enabled` TINYINT unsigned NOT NULL DEFAULT 0, `asku` TINYINT unsigned DEFAULT 0, `asku-settings` TEXT DEFAULT '', `lp` TINYINT unsigned DEFAULT 0, `lp-settings` DECIMAL(15, 3) DEFAULT 0, `cost` TINYINT unsigned DEFAULT 0, `cost-settings` DECIMAL(15, 3) DEFAULT 0, `sp` TINYINT unsigned DEFAULT 0, `sp-settings` DECIMAL(15, 3) DEFAULT 0, `dq` TINYINT unsigned DEFAULT 0, `dq-settings` INT DEFAULT 1, `pq` TINYINT unsigned DEFAULT 0, `pq-settings` INT DEFAULT 1, `ship` TINYINT unsigned DEFAULT 0, `lpos` TINYINT unsigned DEFAULT 0, `lpos-settings` INT unsigned DEFAULT 0, `stock` TINYINT unsigned DEFAULT 0, `stock-settings` INT unsigned DEFAULT 0, `stock-threshold` INT unsigned DEFAULT 0, `weight` FLOAT unsigned NOT NULL DEFAULT 0, `weight_units` VARCHAR(255) NOT NULL DEFAULT 'lb', `length` FLOAT unsigned NOT NULL DEFAULT 0, `width` FLOAT unsigned NOT NULL DEFAULT 0, `height` DECIMAL(15, 3) unsigned NOT NULL DEFAULT 0, `length_units` VARCHAR(255) NOT NULL DEFAULT 'in', PRIMARY KEY (pcid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in D:\Sites\janjou\includes\database.inc on line 529.

Any idea how to fix this?

Comments

willvincent’s picture

willvincent commented

What kind of database are you running?
I haven't had the opportunity to test this on anything other than mysql.

I will take a look later and see if the last update broke the installer.

mor_eli’s picture

mor_eli commented

i'm running on mysql version 5.1.30-community.

willvincent’s picture

willvincent commented
Status: Active » Fixed

I see the problem. db fields that are set to be NULL shouldn't have a default setting. Really though there's only one field that should be null, not the 18 or so that are currently set that way.

I've fixed this and it will be in the next update (which will be posted shortly)

Status: Fixed » Closed (fixed)

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