[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 06:05:43 -0500 |
=================== BUG #1820: LATEST MODIFICATIONS ==================
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=1820&group_id=509
Changes by: Marco Andriolo-Stagno (MAS!) <address@hidden>
Date: 2002-Nov-28 12:05 (Europe/Rome)
What | Removed | Added
---------------------------------------------------------------------------
CC | | address@hidden
=================== BUG #1820: FULL BUG SNAPSHOT ===================
Submitted by: cb Project: phpGroupWare
Submitted on: 2002-Nov-28 11: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 12:03 By: stagno
I guess the problem is in the old MySQL version; with the 3.23.53-log (and I
guess with almost all 3.23.xx version) I didn't find any error (and MySQL
automagically add 'not null' in the field definition as you can check with a
'show create' command).
_IMHO_ to keep the full compatibility with the older db version could be a good
idea to handle that in class.schema_proc_mysql.inc.php.
what about?
-------------------------------------------------------
Date: 2002-Nov-28 11:44 By: cb
MySQL version is "3.22.32-log"
CC List
*******
CC Address | Comment
------------------------------------+-----------------------------
address@hidden |
File Attachments
****************
-------------------------------------------------------
Date: 2002-Nov-28 11: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