Login | Register
My pages Projects Community openCollabNet

Discussions > issues > [Issue 246] New - MySQL INSERTS crash on MySQL5 in Strict Mode

cowiki
Discussion topic

Hide all messages in topic

All messages in topic

[Issue 246] New - MySQL INSERTS crash on MySQL5 in Strict Mode

Author tgossmann
Full name Thomas Gossmann
Date 2006-01-20 16:41:48 PST
Message http://cowiki.tigris​.org/issues/show_bug​.cgi?id=246
                 Issue #|246
                 Summary|MySQL INSERTS crash on MySQL5 in Strict Mode
               Component|cowiki
                 Version|0.3.4
                Platform|All
              OS/Version|All
                     URL|
                  Status|NEW
       Status whiteboard|
                Keywords|
              Resolution|
              Issue type|DEFECT
                Priority|P3
            Subcomponent|Database
             Assigned to|paulha
             Reported by|tgossmann






------- Additional comments from tgossmann at tigris dot org Fri Jan 20 16:41:48 -0800 2006 -------
While Trying to add either a new Directory or Article and MySQL5 is in Strict
Mode (STRICT_TRANS_TABLES), coWiki throws an 560 Error. Therefore I looked up
the query, I'm trying to insert, which was the following:

--------------------​--------------------​----------
INSERT INTO cowiki_node (rec_tan, rec_mod_id,
rec_mod_ip, user_id, group_id, mode, tree_id,
parent_id, is_dir, is_index, notify_user,
notify_group, name, wikiname, metaphone,
encoding, content, summary, keywords,
comments, views, rec_mod_host, rec_state,
author_id, revision, created, sort_order)
VALUES ('1137803357-63770048', '0',
'127.0.0.1', '0', '0', '0775', '0', '0', 'Y',
'', '', '', 'test', 'Test', 'TST', '', '',
'', '', '', '', 'gym', 'R', '0', '1',
'2006-01-21 01:29:17', '20');
--------------------​--------------------​----------

This will end up in this error: #1264 - Out of range value adjusted for column
'view' at line 1

After turning off the Strict Mode of MySQL5 the problems solves itself.
Messages per page: