Details
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']"]
)