Tue 30 Mar 2004 11:58:00 AM UTC, comment #2:
Same problem on Debian/woody testing.
Have determined that specifying the byte length into the text fields for keying as below example will allow the db to be manually installed, but still doesn't work.
INDEX (title(25)), INDEX (text(25)), INDEX (cat_id), INDEX (published), INDEX (keywords(25)), INDEX (is_faq)
Would love someone to take a look at this!
Cheers,
--spook
|
Thu 18 Mar 2004 09:29:39 PM UTC, original submission:
Hi,
I'm using 0.9.16 with latest cvs patches on debian woody.
Apache, etc, are all woody versions
Can't install papbrain app because there is an SQL error
Full error message follows:
Database error: Invalid SQL: CREATE TABLE phpgw_kb_faq (faq_id int(11) auto_increment not null NOT NULL, title text NOT NULL, text text NOT NULL, cat_id int NOT NULL DEFAULT '0', published smallint NOT NULL DEFAULT '0', keywords text NOT NULL, user_id int NOT NULL DEFAULT '0', views int NOT NULL DEFAULT '0', modified int, is_faq smallint NOT NULL DEFAULT '1', url varchar(128) NOT NULL, votes int NOT NULL DEFAULT '0', total int NOT NULL DEFAULT '0', PRIMARY KEY(faq_id), INDEX (title), INDEX (text), INDEX (cat_id), INDEX (published), INDEX (keywords), INDEX (is_faq))
MySQL Error: 1170 (BLOB column 'title' used in key specification without a key length)
cheers
Roman
|