[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: Mon, 24 Feb 2003 03:27:30 -0500

=================== BUG #1820: LATEST MODIFICATIONS ==================

Changes by: Marco Andriolo-Stagno (MAS!) <address@hidden>
Date: 2003-Feb-24 09:27 (Europe/Rome)

            What     | Removed                   | Added
              Status | Open                      | Closed

=================== BUG #1820: FULL BUG SNAPSHOT ===================

Submitted by: cb                      Project: phpGroupWare                 
Submitted on: 2002-Nov-28 11:39
Category:  chat                       Bug Group: release        
Severity:  5 - Major                  Priority:  High                       
Resolution:  None                     Assigned to:  stagno                  
Status:  Closed                       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 15:24             By: stagno
added patch #740

Date: 2002-Nov-28 15:32             By: stagno
finally I found it! ; from v.3.23.0 " ... # Using 
AUTO_INCREMENT will now automatically make the column NOT NULL. " .

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
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:  Size: 2KB   By: cb
patch to fix bug described here;bug_id=1820&amp;bug_file_id=167

For detailed info, follow this link:

reply via email to

[Prev in Thread] Current Thread [Next in Thread]