CiviCRM Community Forums (archive)

Posted this to the CiviMail list by mistake, moving into the forum.

Hello,

    I have been working with CiviCRM version 1.8.10954 anerror when
creating a new event. After pressing the "Continue" button on the "Event
Fees (step 3 of 4)" page of the New Event Wizard, I get the following error.

Sorry. A non-recoverable error has occurred. Database Error Code: Field
'default_fee_id' doesn't have a default value, 1364

Array ( [callback] => Array ([0] => CRM_Core_Error [1] => handle )

    => -1
   [message] => DB Error: unknown error
   [mode] => 16
   [debug_info] => INSERT INTO civicrm_event_page (event_id ) VALUES ( 6 )
[nativecode=1364 ** Field 'default_fee_id' doesn't have a default value]
   [type] => DB_Error
   [user_info] => INSERT INTO civicrm_event_page (event_id ) VALUES ( 6 )
[nativecode=1364 ** Field 'default_fee_id' doesn't have a default value]
   [to_string] => [db_error: message="DB Error: unknown error" code=-1
mode=callback callback=CRM_Core_Error:
:handle prefix="" info="INSERT INTO
civicrm_event_page (event_id ) VALUES ( 6 )  [nativecode=1364 ** Field
'default_fee_id' doesn't have a default value]"]
)

Apparently the event row is created in the civicrm_event table but no rows
are created  in the civicrm_event_page table.  I have been digging through
the code to see where the problem is but I haven't figured all the details
of CiviCRM yet. The error is correct as the default_fee_id is NOT NULL and
no parameters are being inserted for that field.

CREATE TABLE civicrm_event_page (
    default_fee_id int unsigned NOT NULL   COMMENT 'FK to
civicrm_custom_option.',


Any pointers would be greatly appreciated. If people think this is a bug, I
can open an issue.


Ed Geraghty

Yet another reply to myself. Seems the default in 5.0.27 is now "Strict Mode" that enforces the constraints on field values. Do you know what version and if strict mode is enabled on the MySQL server for http://demo.civicrm.org?

More information on SQL modes http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html

C:\>mysql -u civicrm -p civicrm
Enter password: ********
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8013 to server version: 5.0.27-community-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> SELECT @@global.sql_mode;
+----------------------------------------------------------------+
| @@global.sql_mode                                              |
+----------------------------------------------------------------+
| STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
+----------------------------------------------------------------+
1 row in set (0.00 sec)

mysql>

Ed:

This is a bug with CiviCRM. We should work properly with STRICT_TRANS_MODE enabled. Can you please file an issue against 1.8 and we'll get it fixed before the next release

thanx

lobo