CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • MySQL DB error after upgrading to 4.5.5 please help!
Pages: [1]

Author Topic: MySQL DB error after upgrading to 4.5.5 please help!  (Read 436 times)

davey

  • I’m new here
  • *
  • Posts: 1
  • Karma: 0
  • CiviCRM version: 4.5.5
  • CMS version: wordpress latest
  • MySQL version: 5.6.2.2
  • PHP version: 5.4
MySQL DB error after upgrading to 4.5.5 please help!
January 22, 2015, 08:11:48 pm
I recently followed the upgrade guide to update CiviCRM (running on wordpress) to version 4.5.5.

Now, whenever I add a new event the following error occurs:

Code: [Select]
Database Error Code: Unknown column 'is_confirm_enabled' in 'field list', 1054
Additional Details:
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_event (title , summary , description , event_type_id , participant_listing_id , is_public , start_date , end_date , max_participants , event_full_text , is_map , is_active , default_role_id , has_waitlist , is_template , created_id , created_date , is_share ) VALUES ('Test event 45' ,  NULL ,  NULL ,  3 ,  NULL ,  0 ,  20150123040400 ,  NULL ,  NULL , 'This event is currently full.' ,  0 ,  1 ,  1 ,  0 ,  0 ,  14126 ,  20150123040516 ,  0 )  [nativecode=1054 ** Unknown column 'is_confirm_enabled' in 'field list']
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_event (title , summary , description , event_type_id , participant_listing_id , is_public , start_date , end_date , max_participants , event_full_text , is_map , is_active , default_role_id , has_waitlist , is_template , created_id , created_date , is_share ) VALUES ('Test event 45' ,  NULL ,  NULL ,  3 ,  NULL ,  0 ,  20150123040400 ,  NULL ,  NULL , 'This event is currently full.' ,  0 ,  1 ,  1 ,  0 ,  0 ,  14126 ,  20150123040516 ,  0 )  [nativecode=1054 ** Unknown column 'is_confirm_enabled' in 'field list']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_event (title , summary , description , event_type_id , participant_listing_id , is_public , start_date , end_date , max_participants , event_full_text , is_map , is_active , default_role_id , has_waitlist , is_template , created_id , created_date , is_share ) VALUES ('Test event 45' ,  NULL ,  NULL ,  3 ,  NULL ,  0 ,  20150123040400 ,  NULL ,  NULL , 'This event is currently full.' ,  0 ,  1 ,  1 ,  0 ,  0 ,  14126 ,  20150123040516 ,  0 )  [nativecode=1054 ** Unknown column 'is_confirm_enabled' in 'field list']"]
)

However, I can see clearly in the civicrm_event table that the column is_confirm_enabled exists??
When I update an existing Event, it works fine.. its only when creating a new one.

Can anyone shed light on what is happening here? I have tried everything to fix it!!

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: MySQL DB error after upgrading to 4.5.5 please help!
January 24, 2015, 12:35:48 pm
Can you export just the structure of your civicrm_event table and post that here?
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • MySQL DB error after upgrading to 4.5.5 please help!

This forum was archived on 2017-11-26.