CiviCRM Community Forums (archive)

I tried register to my free online event as registered user. And got this error.
Drupal 5.6, Mysql 5.0.25, CiviCRM 1.9

I put 1 as default value to  payment_entity_id field. And I don't have this error. But I'm not happy to make changes in database. 
Maybe something is going wrong?

Sorry. A non-recoverable error has occurred.
Database Error Code: Field 'payment_entity_id' doesn't have a default value, 1364
Return to home page.


Error Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_participant_payment (participant_id , payment_entity_table ) VALUES ( 27 , 'civicrm_contribution' )  [nativecode=1364 ** Field 'payment_entity_id' doesn't have a default value]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_participant_payment (participant_id , payment_entity_table ) VALUES ( 27 , 'civicrm_contribution' )  [nativecode=1364 ** Field 'payment_entity_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_participant_payment (participant_id , payment_entity_table ) VALUES ( 27 , 'civicrm_contribution' )  [nativecode=1364 ** Field 'payment_entity_id' doesn't have a default value]"]
)


Can you please reproduce on demo and file an issue if so. I suspect this is a bug with CiviEvent with mysql in strict ansi mode

lobo

I can't reproduce it. Yes my mysql is in strict mode. And then value for payment_entity_id for all rows is 1 !
How can I fix this problem ?

To lobo

My site is in offline. I set default to NULL for that column. But I have another problem in http://forum.civicrm.org/index.php/topic,2012.0.html
Could you help me ? I think it's about firewall. What port do I have to open?