url TEXT NOT NULL DEFAULT ''
is a line in the files links.mysql and also links.install.
It is failing at the time of links module installation.
I am using mysql 5.0.27 windows version.
I am able to solve the problem after removing the
NOT NULL DEFAULT ''
part of the mysql script.

So the final create script looks like
-- lid, the link ID, is linked to the sequence links_lid
CREATE TABLE links (
lid INT(10) UNSIGNED NOT NULL DEFAULT '0',
url_md5 CHAR(32) NOT NULL,
url TEXT,
link_title VARCHAR(255) NOT NULL DEFAULT '',
last_click_time INT(11) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (lid),
UNIQUE INDEX url_ix (url_md5),
UNIQUE INDEX title_ix (link_title, lid),
UNIQUE INDEX stale_ix (last_click_time, lid)
) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;

Comments

syscrusher’s picture

syscrusher commented
Assigned: Unassigned » syscrusher

I'm not able to duplicate this issue using MySQL 5.0.18 or 5.0.30 on Linux. It appears to be a Windows-specific issue, or else a bug in 5.0.27 that was corrected between that and 5.0.30. Can you please check with a later version of MySQL to see if you still have the problem? I'm hesitant to change the Links code to work around a MySQL bug that probably is already corrected. The NOT NULL part of the declaration was designed to help insure data integrity. I'll take it out if I must, but I'd like to avoid this if possible.

Could you please test with the NOT NULL present but the DEFAULT '' taken out? I don't mind taking out the default clause if I can leave NOT NULL in place.

Let me know if you still see the problem in MySQL 5.0.30 or later, and I'll commit a workaround for it.

Kind regards, and thanks for your assistance
Syscrusher