bugphpGroupWare - Bugs: bug #8191, SQL error in phpbrain

 
 

You are not allowed to post comments on this tracker with your current authentication level.

bug #8191: SQL error in phpbrain

Submitter:  None
Submitted:  Thu 18 Mar 2004 09:29:39 PM UTC
   
 
Category:  None Item Group:  0.9.16.000 release
Severity:  3 - Normal Priority:  1 - Later
Status:  Fixed Privacy:  Public
Assigned to:  skwashd Open/Closed:  Closed
Component Version:  SVN Operating System:  GNU/Linux - Debian
Reproducibility:  Every Time Planned Release:  None
Fixed Release: 

Sun 06 Jun 2004 11:20:50 PM UTC, comment #3: 

fixed in cvs

Dave Hall <skwashd>
Group administrator
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

No Way <primeFACTOR>
Wed 24 Mar 2004 09:14:34 PM UTC, comment #1: 

Same pb on Debian (Sarge) with phpgw fresh install (from tarball).
Apache 1.3.29 + php4 (4.3).

phpbrain appears not to be installed in admin setup, step 4. And couldn't be installed !

François <franR>
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

Anonymous

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

CC list is empty

 

There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

 

Follow 3 latest changes.

Date Changed by Updated Field Previous Value => Replaced by
2004-06-06 skwashd StatusNone Fixed
    Open/ClosedOpen Closed
2004-04-21 cboettger Assigned toNone skwashd

Back to the top

Powered by Savane 3.13-caa5.
Corresponding source code