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

Submitted by:  None
Submitted on:  Thu 18 Mar 2004 09:29:39 PM UTC  
 
Item Group: 0.9.16.000 releaseCategory: None
Severity: 3 - NormalPriority: 1 - Later
Status: FixedPrivacy: Public
Assigned to: Dave Hall <skwashd>Open/Closed: Closed
Component Version: SVNOperating System: GNU/Linux - Debian
Reproducibility: Every TimePlanned Release: None
Fixed Release: 

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

fixed in cvs

Dave Hall <skwashd>
Project AdministratorIn charge of this item.
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

 

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

CC list is empty

 

Do you think this task is very important?
If so, you can click here to add your encouragement to it.
This task has 0 encouragements so far.

Only logged-in users can vote.

 

Please enter the title of George Orwell's famous dystopian book (it's a date):

 

 

Follow 3 latest changes.

Date Changed By Updated Field Previous Value => Replaced By
Sun 06 Jun 2004 11:20:50 PM UTCskwashdStatusNone=>Fixed
  Open/ClosedOpen=>Closed
Wed 21 Apr 2004 04:49:09 AM UTCcboettgerAssigned toNone=>skwashd

Back to the top


Powered by Savane 3.1-cleanup1