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
Comment #1
publicmind commentedfixed 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
Comment #2
publicmind commentedoops.. forgot to set it to fixed.