Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-1684

1.7 sql update script missing thankyou_title column for civicrm_event_page table.

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Minor
    • Resolution: Fixed/Completed
    • Affects Version/s: 1.7
    • Fix Version/s: 1.7
    • Component/s: CiviEvent
    • Labels:
      None

      Description

      Error when trying to add an event to upgraded CiviCrm from 1.6 clean install with generated data to svn 1.7 branch revision 8846.

      I looked at the upgrade script in the civicrm/sql directory and confirmed that it is missing the thankyou_title column.

      Diff file is attached for civicrm_upgradedb_v1.6_v1.7_41.mysql

      (If MySQL 4.0 is being dropped with 1.7 why is there an upgrade script for 4.0?)

      Here's the error message I'm receiving:

      Sorry. A non-recoverable error has occurred.

      Database Error Code: Unknown column 'thankyou_title' in 'field list', 1054

      Return to CiviCRM menu.

      Error Details:

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

      [code] => -19
      [message] => DB Error: no such field
      [mode] => 16
      [debug_info] => UPDATE civicrm_event_page SET event_id = 1 , intro_text = NULL , footer_text = NULL , confirm_title = 'You\'re confirmed. Get ready to eat some cake!' , confirm_text = NULL , confirm_footer_text = NULL , is_email_confirm = 1 , confirm_email_text = NULL , confirm_from_name = 'blueseed@seedsofblue.com' , confirm_from_email = 'blueseed@seedsofblue.com' , cc_confirm = NULL , bcc_confirm = NULL , default_fee_id = 14 , thankyou_title = 'Thank you for registering for cake eating' , thankyou_text = NULL , thankyou_footer_text = NULL WHERE ( civicrm_event_page.id = 1 ) [nativecode=1054 ** Unknown column 'thankyou_title' in 'field list']
      [type] => DB_Error
      [user_info] => UPDATE civicrm_event_page SET event_id = 1 , intro_text = NULL , footer_text = NULL , confirm_title = 'You\'re confirmed. Get ready to eat some cake!' , confirm_text = NULL , confirm_footer_text = NULL , is_email_confirm = 1 , confirm_email_text = NULL , confirm_from_name = 'blueseed@seedsofblue.com' , confirm_from_email = 'blueseed@seedsofblue.com' , cc_confirm = NULL , bcc_confirm = NULL , default_fee_id = 14 , thankyou_title = 'Thank you for registering for cake eating' , thankyou_text = NULL , thankyou_footer_text = NULL WHERE ( civicrm_event_page.id = 1 ) [nativecode=1054 ** Unknown column 'thankyou_title' in 'field list']
      [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="UPDATE civicrm_event_page SET event_id = 1 , intro_text = NULL , footer_text = NULL , confirm_title = 'You\'re confirmed. Get ready to eat some cake!' , confirm_text = NULL , confirm_footer_text = NULL , is_email_confirm = 1 , confirm_email_text = NULL , confirm_from_name = 'blueseed@seedsofblue.com' , confirm_from_email = 'blueseed@seedsofblue.com' , cc_confirm = NULL , bcc_confirm = NULL , default_fee_id = 14 , thankyou_title = 'Thank you for registering for cake eating' , thankyou_text = NULL , thankyou_footer_text = NULL WHERE ( civicrm_event_page.id = 1 ) [nativecode=1054 ** Unknown column 'thankyou_title' in 'field list']"]
      )

        Attachments

          Activity

            People

            • Assignee:
              shailesh Shailesh Lende
              Reporter:
              thom k Thom K
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: