[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-tracker] [Bug #1820] SQL tables creation incompatible with
From: |
nobody |
Subject: |
[Phpgroupware-tracker] [Bug #1820] SQL tables creation incompatible with MySQL |
Date: |
Thu, 28 Nov 2002 05:44:22 -0500 |
=================== BUG #1820: LATEST MODIFICATIONS ==================
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=1820&group_id=509
Changes by: Camille Bégnis <address@hidden>
Date: 2002-Nov-28 10:44 (GMT)
------------------ Additional Follow-up Comments ----------------------------
MySQL version is "3.22.32-log"
=================== BUG #1820: FULL BUG SNAPSHOT ===================
Submitted by: cb Project: phpGroupWare
Submitted on: 2002-Nov-28 10:39
Category: chat Bug Group: 0.9.14.001 release
Severity: 5 - Major Priority: High
Resolution: None Assigned to: None
Status: Open Component Version: CVS
Platform Version: Linux - Debian Reproducibility: Every Time
Summary: SQL tables creation incompatible with MySQL
Original Submission: When installing table:
CREATE TABLE phpgw_chat_channel (con int(11) auto_increment, name varchar(10)
NOT NULL, title char(50) NOT NULL, UNIQUE(con))
MySQL complains:
Column 'con' is used with UNIQUE or INDEX but is not defined as NOT NULL
Follow-up Comments
*******************
-------------------------------------------------------
Date: 2002-Nov-28 10:44 By: cb
MySQL version is "3.22.32-log"
CC list is empty
File Attachments
****************
-------------------------------------------------------
Date: 2002-Nov-28 10:39 Name: tables_current.inc.php.patch Size: 2KB By: cb
patch to fix bug described here
http://savannah.gnu.org/bugs/download.php?group_id=509&bug_id=1820&bug_file_id=167
For detailed info, follow this link:
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=1820&group_id=509