[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-tracker] [bugs #8191] SQL error in phpbrain
From: |
Dr. Christian Böttger |
Subject: |
[Phpgroupware-tracker] [bugs #8191] SQL error in phpbrain |
Date: |
Wed, 21 Apr 2004 00:49:12 -0400 |
User-agent: |
Mozilla/5.0 (X11; U; Linux i686; de-AT; rv:1.6) Gecko/20040113 |
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/
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-tracker] [bugs #8191] SQL error in phpbrain,
Dr. Christian Böttger <=