During installation, log shows (directory obfuscated):

BLOB/TEXT column 'url' can't have a default value query: CREATE TABLE facebook_link ( `sid` INT unsigned NOT NULL DEFAULT 0, `url` TEXT NOT NULL DEFAULT '', `image` TEXT NOT NULL DEFAULT '', `description` TEXT NOT NULL DEFAULT '', `title` TEXT NOT NULL DEFAULT '', PRIMARY KEY (sid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in D:\...\portal\includes\database.inc on line 550.

Since the table doesn't show, the component doesn't work. We're running:

MySQL 5.0.45-community-nt

Removing the default value from all the TEXT fields (manually run through the MySQL query browser) created the tables and restored function of the component. I was still able to submit an empty status so it doesn't appear to have broken the component at all.

Comments

publicmind’s picture

fixed in dev. seems like you are on a windows installation, I forgot about this known issue: #113030: BLOB/TEXT column - can't have a default value query on MySQL 5.0

publicmind’s picture

Assigned: Unassigned » publicmind
Status: Active » Fixed

oops.. forgot to set it to fixed.

Status: Fixed » Closed (fixed)

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