[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-tracker] [Bug #1820] MySQL 3.22.x problems with chat
From: |
nobody |
Subject: |
[Phpgroupware-tracker] [Bug #1820] MySQL 3.22.x problems with chat |
Date: |
Thu, 28 Nov 2002 18:33:07 -0500 |
=================== BUG #1820: LATEST MODIFICATIONS ==================
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=1820&group_id=509
Changes by: Dave Hall <address@hidden>
Date: 2002-Nov-29 10:33 (Australia/Melbourne)
What | Removed | Added
---------------------------------------------------------------------------
Summary | SQL tables creation incompatible with MySQL | MySQL
3.22.x problems with chat
=================== BUG #1820: FULL BUG SNAPSHOT ===================
Submitted by: cb Project: phpGroupWare
Submitted on: 2002-Nov-28 21:39
Category: chat Bug Group: 0.9.14.001 release
Severity: 5 - Major Priority: High
Resolution: None Assigned to: stagno
Status: Open Component Version: CVS
Platform Version: Linux - Debian Reproducibility: Every Time
Summary: MySQL 3.22.x problems with chat
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-29 01:32 By: stagno
finally I found it!
http://www.mysql.com/doc/en/News-3.23.0.html ; from v.3.23.0 " ... # Using
AUTO_INCREMENT will now automatically make the column NOT NULL. " .
-------------------------------------------------------
Date: 2002-Nov-28 22: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 21:44 By: cb
MySQL version is "3.22.32-log"
CC List
*******
CC Address | Comment
------------------------------------+-----------------------------
address@hidden |
File Attachments
****************
-------------------------------------------------------
Date: 2002-Nov-28 21: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
- [Phpgroupware-tracker] [Bug #1820] MySQL 3.22.x problems with chat,
nobody <=