uc_store_footers database update error

Project:Ubercart Contributions
Component:Code
Category:
Priority:critical
Assigned:Unassigned
Status:active
Description
Project: 
Ubercart

I did a recent pull of the repository and I am getting a database update error related to creating the new uc_store_footers table:

user warning: BLOB/TEXT column 'message' can't have a default value query: CREATE TABLE uc_store_footers ( `path_hash` varchar(32) NOT NULL, `message` text NOT NULL default '', PRIMARY KEY (path_hash) ) /*!40100 DEFAULT CHARACTER SET UTF8 COLLATE utf8_unicode_ci

uc_store module
Update #3

* Failed: CREATE TABLE {uc_store_footers} ( `path_hash` varchar(32) NOT NULL, `message` text NOT NULL default '', PRIMARY KEY (path_hash) ) /*!40100 DEFAULT CHARACTER SET UTF8 COLLATE utf8_unicode_ci */

I am using PHP5 with MySql 5.0.45.

Table is not created.

Lyle's picture
Offline
AdministratoreLiTe!
Joined: 08/07/2007
Juice: 6846
Re: uc_store_footers database update error

I think I remembered that text columns couldn't have default values, but I must have deleted the wrong one. Even worse, PostgreS requires a default value for every NOT NULL field. Oh well.

Fixed that, and added the store footer table to uc_store_install() like I should have, as well.