[Phpgroupware-tracker] [Bug #1820] MySQL 3.22.x problems with chat

[nobody]

=================== 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-29 15:24 (Europe/Rome)

------------------ Additional Follow-up Comments ----------------------------
added patch #740



=================== 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:  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 15:24             By: stagno
added patch #740

-------------------------------------------------------
Date: 2002-Nov-28 15: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 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&amp;bug_id=1820&amp;bug_file_id=167


For detailed info, follow this link:
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=1820&group_id=509