[Phpgroupware-tracker] [bugs #8191] SQL error in phpbrain

[Dr. Christian Böttger]

This mail is an automated notification from the bugs tracker
 of the project: phpGroupWare.

/**************************************************************************/
[bugs #8191] Latest Modifications:

Changes by: 
                Dr. Christian Böttger <address@hidden>
'Date: 
                Wed 04/21/04 at 04:49 (Europe/Berlin)

            What     | Removed                   | Added
---------------------------------------------------------------------------
         Assigned to | None                      | skwashd







/**************************************************************************/
[bugs #8191] Full Item Snapshot:

URL: <http://savannah.gnu.org/bugs/?func=detailitem&item_id=8191>
Project: phpGroupWare
Submitted by: 0
On: Thu 03/18/04 at 21:29

Category:  None
Item Group:  0.9.16.000 release
Severity:  5 - Average
Priority:  1 - Later
Resolution:  None
Assigned to:  skwashd
Status:  Open
Component Version:  CVS
Platform Version:  GNU/Linux - Debian
Reproducibility:  Every Time


Summary:  SQL error in phpbrain

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

Follow-up Comments
------------------


-------------------------------------------------------
Date: Tue 03/30/04 at 11:58         By: primeFACTOR
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

-------------------------------------------------------
Date: Wed 03/24/04 at 21:14         By: franR
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 !













For detailed info, follow this link:
<http://savannah.gnu.org/bugs/?func=detailitem&item_id=8191>

_______________________________________________
  Message sent via/by Savannah
  http://savannah.gnu.org/