CiviCRM Community Forums (archive)

I've just started using CiviMail and have come across a database error on creating a new mailing (directly after clicking "Next" when it has been named and a group selected). Here is the error generated:

     Sorry. A non-recoverable error has occurred.

    Database Error Code: Field 'resubscribe_id' doesn't have a default value, 1364

    Return to home page.

Error Details:

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

    [code] => -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_mailing (domain_id , reply_id , unsubscribe_id , optout_id , name ) VALUES ( 1 ,  8 ,  5 ,  7 , 'Test' )  [nativecode=1364 ** Field 'resubscribe_id' doesn't have a default value]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_mailing (domain_id , reply_id , unsubscribe_id , optout_id , name ) VALUES ( 1 ,  8 ,  5 ,  7 , 'Test' )  [nativecode=1364 ** Field 'resubscribe_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_mailing (domain_id , reply_id , unsubscribe_id , optout_id , name ) VALUES ( 1 ,  8 ,  5 ,  7 , 'Test' )  [nativecode=1364 ** Field 'resubscribe_id' doesn't have a default value]"]
)

If anyone can offer suggestions about what could be causing this I'd appreciate it. Thanks.[/code]

Thanks Dave. It's version 1.9.11960 but I haven't come across any Resubscribe Message option in Step 2, in fact the error comes up after clicking Next in Step 1.

Upgrade seems to have fixed it, thanks.