Closed (fixed)
Project:
Wordfilter
Version:
6.x-1.x-dev
Component:
Code
Priority:
Critical
Category:
Bug report
Assigned:
Unassigned
Reporter:
Anonymous (not verified)
Created:
20 May 2008 at 22:43 UTC
Updated:
31 May 2025 at 14:14 UTC
When installing wordfilter on 6.2 the following error is reported:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL DEFAULT '', `standalone` TINYINT NOT NULL DEFAULT 0, PRIMARY KEY (id)' at line 4 query: CREATE TABLE wordfilter ( `id` INT NOT NULL auto_increment, `words` TEXT NOT NULL, `replacement` VARCHAR NOT NULL DEFAULT '', `standalone` TINYINT NOT NULL DEFAULT 0, PRIMARY KEY (id) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /xyz/includes/database.inc on line 509.
This is caused by a missing 'length' attribute on the VARCHAR field in wordfilter.install. See patch attached
| Comment | File | Size | Author |
|---|---|---|---|
| wordfilter.patch | 411 bytes | Anonymous (not verified) |
Comments
Comment #1
jaydub commentedthanks for tracking that down. I hadn't done enough testing
of install from scratch for d6.
Committed to CVS
Comment #2
Anonymous (not verified) commentedAutomatically closed -- issue fixed for two weeks with no activity.