Template problems in the Configurator

[computersltd]

Not sure if this is the right place to post this, but It started with changing from one template to another and saving changes I get this:
SQL statement that failed below and on next post:
---------------------------------------------------------
UPDATE default_controlpanel SET controlpanel_admin_name = 'Patty Lance' , controlpanel_admin_email = 'pclance@alltel.net' , controlpanel_company_name = 'pattyclance.com' , controlpanel_company_location = 'Blairsville, GA' , controlpanel_company_logo = 'title.jpg' , controlpanel_automatic_update_check = '1' , controlpanel_template = 'free4_22' , controlpanel_admin_template = 'OR' , controlpanel_listing_template = 'listing_detail_slideshow.html' , controlpanel_template_listing_sections = 'headline,top_left,top_right,center,feature1,featu re2,bottom_left,bottom_right' , controlpanel_search_result_template = 'search_result_box.html' , controlpanel_agent_template = 'view_user_default.html' , controlpanel_url_style = '1' , controlpanel_seo_default_title = 'Patty C Lance (Realtor)' , controlpanel_seo_default_keywords = '' , controlpanel_seo_default_description = '' , controlpanel_seo_listing_title = 'My Listings' , controlpanel_seo_listing_keywords = '' , controlpanel_seo_listing_description = '' , controlpanel_wysiwyg_editor = 'fckeditor' , controlpanel_wysiwyg_execute_php = '0' , controlpanel_add_linefeeds = '0' , controlpanel_strip_html = '0' , controlpanel_allowed_html_tags = '
' , controlpanel_number_format_style = '1' , controlpanel_number_decimals_number_fields = '0' , controlpanel_number_decimals_price_fields = '0' , controlpanel_money_format = '1' , controlpanel_money_sign = '$' , controlpanel_date_format = '1' , controlpanel_zero_price = '0' , controlpanel_allowed_upload_extensions = 'jpg,gif,png,egg' , controlpanel_allowed_upload_types = 'image/pjpeg,image/jpeg,image/gif,image/x-png,application/octet-stream' , controlpanel_make_thumbnail = '1' , controlpanel_thumbnail_width = '100' , controlpanel_thumbnail_prog = 'gd' , controlpanel_path_to_imagemagick = '/usr/X11R6/bin/convert' , controlpanel_jpeg_quality = '100' , controlpanel_resize_img = '1' , controlpanel_gd_version = '1' , controlpanel_show_no_photo = '1' , controlpanel_max_listings_uploads = '7' , controlpanel_max_listings_upload_size = '100000' , controlpanel_max_listings_upload_width = '700' , controlpanel_max_user_uploads = '20' , controlpanel_max_user_upload_size = '100000' , controlpanel_max_user_upload_width = '700' , controlpanel_max_vtour_uploads = '15' , controlpanel_max_vtour_upload_size = '900000' , controlpanel_max_vtour_upload_width = '3000' , controlpanel_listings_per_page = '10' , controlpanel_search_sortby = 'listingsdb_id' , controlpanel_search_sorttype = 'ASC' , controlpanel_configured_show_count = '1' , controlpanel_vtour_width = '' , controlpanel_vtour_height = '' , controlpanel_vtour_fov = '' , controlpanel_vt_popup_width = '' , controlpanel_vt_popup_height = '' , controlpanel_email_notification_of_new_users = '1' , controlpanel_email_notification_of_new_listings = '1' , controlpanel_email_users_notification_of_new_listi ngs = '1' , controlpanel_moderate_members = '0' , controlpanel_allow_member_signup = '1' , controlpanel_moderate_agents = '0' , controlpanel_allow_agent_signup = '0' , controlpanel_agent_default_active = '1' , controlpanel_agent_default_admin = '0' , controlpanel_agent_default_edit_all_users = '0' , controlpanel_agent_default_edit_all_listings = '0' , controlpanel_agent_default_feature = '0' , controlpanel_agent_default_moderate = '0' , controlpanel_agent_default_logview = '0' , controlpanel_agent_default_edit_site_config = '0' , controlpanel_agent_default_edit_member_template = '0' , controlpanel_agent_default_edit_agent_template = '0' , controlpanel_agent_default_edit_listing_template = '0' , controlpanel_agent_default_can_export_listings = '0' , controlpanel_agent_default_canchangeexpirations = '0' , controlpanel_agent_default_editpages = '0' , controlpanel_agent_default_havevtours = '0' , controlpanel_agent_default_num_listings = '-1' , controlpanel_multiple_pclass_selection = '0' , controlpanel_num_featured_listings = '4' , controlpanel_use_expiration = '0' , controlpanel_days_until_listings_expire = '365' , controlpanel_moderate_listings = '0' , controlpanel_export_listings = '0' , controlpanel_show_listedby_admin = '1' , controlpanel_show_next_prev_listing_page = '1' , controlpanel_map_type = 'mapquest_US' , controlpanel_map_address = 'address' , controlpanel_map_address2 = '' , controlpanel_map_address3 = '' , controlpanel_map_address4 = '' , controlpanel_map_city = 'city' , controlpanel_map_state = 'state' , controlpanel_map_zip = 'zip' , controlpanel_map_country = 'mls'

---------------------------------------------------------

[computersltd]

ERROR REPORT www.pattyclance.com: May 18, 2006, 12:34:09 pm

---------------------------------------------------------
SQL ERROR: UPDATE default_controlpanel SET controlpanel_admin_name = 'Patty Lance' , controlpanel_admin_email = 'pclance@alltel.net' , controlpanel_company_name = 'pattyclance.com' , controlpanel_company_location = 'Blairsville, GA' , controlpanel_company_logo = 'title.jpg' , controlpanel_automatic_update_check = '1' , controlpanel_template = 'free4_22' , controlpanel_admin_template = 'OR' , controlpanel_listing_template = 'listing_detail_slideshow.html' , controlpanel_template_listing_sections = 'headline,top_left,top_right,center,feature1,featu re2,bottom_left,bottom_right' , controlpanel_search_result_template = 'search_result_box.html' , controlpanel_agent_template = 'view_user_default.html' , controlpanel_url_style = '1' , controlpanel_seo_default_title = 'Patty C Lance (Realtor)' , controlpanel_seo_default_keywords = '' , controlpanel_seo_default_description = '' , controlpanel_seo_listing_title = 'My Listings' , controlpanel_seo_listing_keywords = '' , controlpanel_seo_listing_description = '' , controlpanel_wysiwyg_editor = 'fckeditor' , controlpanel_wysiwyg_execute_php = '0' , controlpanel_add_linefeeds = '0' , controlpanel_strip_html = '0' , controlpanel_allowed_html_tags = '
' , controlpanel_number_format_style = '1' , controlpanel_number_decimals_number_fields = '0' , controlpanel_number_decimals_price_fields = '0' , controlpanel_money_format = '1' , controlpanel_money_sign = '$' , controlpanel_date_format = '1' , controlpanel_zero_price = '0' , controlpanel_allowed_upload_extensions = 'jpg,gif,png,egg' , controlpanel_allowed_upload_types = 'image/pjpeg,image/jpeg,image/gif,image/x-png,application/octet-stream' , controlpanel_make_thumbnail = '1' , controlpanel_thumbnail_width = '100' , controlpanel_thumbnail_prog = 'gd' , controlpanel_path_to_imagemagick = '/usr/X11R6/bin/convert' , controlpanel_jpeg_quality = '100' , controlpanel_resize_img = '1' , controlpanel_gd_version = '1' , controlpanel_show_no_photo = '1' , controlpanel_max_listings_uploads = '7' , controlpanel_max_listings_upload_size = '100000' , controlpanel_max_listings_upload_width = '700' , controlpanel_max_user_uploads = '20' , controlpanel_max_user_upload_size = '100000' , controlpanel_max_user_upload_width = '700' , controlpanel_max_vtour_uploads = '15' , controlpanel_max_vtour_upload_size = '900000' , controlpanel_max_vtour_upload_width = '3000' , controlpanel_listings_per_page = '10' , controlpanel_search_sortby = 'listingsdb_id' , controlpanel_search_sorttype = 'ASC' , controlpanel_configured_show_count = '1' , controlpanel_vtour_width = '' , controlpanel_vtour_height = '' , controlpanel_vtour_fov = '' , controlpanel_vt_popup_width = '' , controlpanel_vt_popup_height = '' , controlpanel_email_notification_of_new_users = '1' , controlpanel_email_notification_of_new_listings = '1' , controlpanel_email_users_notification_of_new_listi ngs = '1' , controlpanel_moderate_members = '0' , controlpanel_allow_member_signup = '1' , controlpanel_moderate_agents = '0' , controlpanel_allow_agent_signup = '0' , controlpanel_agent_default_active = '1' , controlpanel_agent_default_admin = '0' , controlpanel_agent_default_edit_all_users = '0' , controlpanel_agent_default_edit_all_listings = '0' , controlpanel_agent_default_feature = '0' , controlpanel_agent_default_moderate = '0' , controlpanel_agent_default_logview = '0' , controlpanel_agent_default_edit_site_config = '0' , controlpanel_agent_default_edit_member_template = '0' , controlpanel_agent_default_edit_agent_template = '0' , controlpanel_agent_default_edit_listing_template = '0' , controlpanel_agent_default_can_export_listings = '0' , controlpanel_agent_default_canchangeexpirations = '0' , controlpanel_agent_default_editpages = '0' , controlpanel_agent_default_havevtours = '0' , controlpanel_agent_default_num_listings = '-1' , controlpanel_multiple_pclass_selection = '0' , controlpanel_num_featured_listings = '4' , controlpanel_use_expiration = '0' , controlpanel_days_until_listings_expire = '365' , controlpanel_moderate_listings = '0' , controlpanel_export_listings = '0' , controlpanel_show_listedby_admin = '1' , controlpanel_show_next_prev_listing_page = '1' , controlpanel_map_type = 'mapquest_US' , controlpanel_map_address = 'address' , controlpanel_map_address2 = '' , controlpanel_map_address3 = '' , controlpanel_map_address4 = '' , controlpanel_map_city = 'city' , controlpanel_map_state = 'state' , controlpanel_map_zip = 'zip' , controlpanel_map_country = 'mls'
Server Type: Apache
Request Method: POST
Query String: &action=configure&printer_friendly=
Refereer: http://www.pattyclance.com/admin/ind...tion=configure
User Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727)
Request URI: /admin/index.php?&action=configure&printer_friendly=
POST Variables: array (
'controlpanel_admin_name' => 'Patty Lance',
'controlpanel_admin_email' => 'pclance@alltel.net',
'controlpanel_company_name' => 'pattyclance.com',
'controlpanel_company_location' => 'Blairsville, GA',
'controlpanel_company_logo' => 'title.jpg',
'controlpanel_automatic_update_check' => '1',
'controlpanel_template' => 'free4_22',
'controlpanel_admin_template' => 'OR',
'controlpanel_listing_template' => 'listing_detail_slideshow.html',
'controlpanel_template_listing_sections' => 'headline,top_left,top_right,center,feature1,featu re2,bottom_left,bottom_right',
'controlpanel_search_result_template' => 'search_result_box.html',
'controlpanel_agent_template' => 'view_user_default.html',
'controlpanel_url_style' => '1',
'controlpanel_seo_default_title' => 'Patty C Lance (Realtor)',
'controlpanel_seo_default_keywords' => '',
'controlpanel_seo_default_description' => '',
'controlpanel_seo_listing_title' => 'My Listings',
'controlpanel_seo_listing_keywords' => '',
'controlpanel_seo_listing_description' => '',
'controlpanel_wysiwyg_editor' => 'fckeditor',
'controlpanel_wysiwyg_execute_php' => '0',
'controlpanel_add_linefeeds' => '0',
'controlpanel_strip_html' => '0',
'controlpanel_allowed_html_tags' => '
',
'controlpanel_number_format_style' => '1',
'controlpanel_number_decimals_number_fields' => '0',
'controlpanel_number_decimals_price_fields' => '0',
'controlpanel_money_format' => '1',
'controlpanel_money_sign' => '$',
'controlpanel_date_format' => '1',
'controlpanel_zero_price' => '0',
'controlpanel_allowed_upload_extensions' => 'jpg,gif,png,egg',
'controlpanel_allowed_upload_types' => 'image/pjpeg,image/jpeg,image/gif,image/x-png,application/octet-stream',
'controlpanel_make_thumbnail' => '1',
'controlpanel_thumbnail_width' => '100',
'controlpanel_thumbnail_prog' => 'gd',
'controlpanel_path_to_imagemagick' => '/usr/X11R6/bin/convert',
'controlpanel_jpeg_quality' => '100',
'controlpanel_resize_img' => '1',
'controlpanel_gd_version' => '1',
'controlpanel_show_no_photo' => '1',
'controlpanel_max_listings_uploads' => '7',
'controlpanel_max_listings_upload_size' => '100000',
'controlpanel_max_listings_upload_width' => '700',
'controlpanel_max_user_uploads' => '20',
'controlpanel_max_user_upload_size' => '100000',
'controlpanel_max_user_upload_width' => '700',
'controlpanel_max_vtour_uploads' => '15',
'controlpanel_max_vtour_upload_size' => '900000',
'controlpanel_max_vtour_upload_width' => '3000',
'controlpanel_listings_per_page' => '10',
'controlpanel_search_sortby' => 'listingsdb_id',
'controlpanel_search_sorttype' => 'ASC',
'controlpanel_configured_show_count' => '1',
'controlpanel_vtour_width' => '',
'controlpanel_vtour_height' => '',
'controlpanel_vtour_fov' => '',
'controlpanel_vt_popup_width' => '',
'controlpanel_vt_popup_height' => '',
'controlpanel_email_notification_of_new_users' => '1',
'controlpanel_email_notification_of_new_listings' => '1',
'controlpanel_email_users_notification_of_new_list ings' => '1',
'controlpanel_moderate_members' => '0',
'controlpanel_allow_member_signup' => '1',
'controlpanel_moderate_agents' => '0',
'controlpanel_allow_agent_signup' => '0',
'controlpanel_agent_default_active' => '1',
'controlpanel_agent_default_admin' => '0',
'controlpanel_agent_default_edit_all_users' => '0',
'controlpanel_agent_default_edit_all_listings' => '0',
'controlpanel_agent_default_feature' => '0',
'controlpanel_agent_default_moderate' => '0',
'controlpanel_agent_default_logview' => '0',
'controlpanel_agent_default_edit_site_config' => '0',
'controlpanel_agent_default_edit_member_template' => '0',
'controlpanel_agent_default_edit_agent_template' => '0',
'controlpanel_agent_default_edit_listing_template' => '0',
'controlpanel_agent_default_can_export_listings' => '0',
'controlpanel_agent_default_canchangeexpirations' => '0',
'controlpanel_agent_default_editpages' => '0',
'controlpanel_agent_default_havevtours' => '0',
'controlpanel_agent_default_num_listings' => '-1',
'controlpanel_multiple_pclass_selection' => '0',
'controlpanel_num_featured_listings' => '4',
'controlpanel_use_expiration' => '0',
'controlpanel_days_until_listings_expire' => '365',
'controlpanel_moderate_listings' => '0',
'controlpanel_export_listings' => '0',
'controlpanel_show_listedby_admin' => '1',
'controlpanel_show_next_prev_listing_page' => '1',
'controlpanel_map_type' => 'mapquest_US',
'controlpanel_map_address' => 'address',
'controlpanel_map_address2' => '',
'controlpanel_map_address3' => '',
'controlpanel_map_address4' => '',
'controlpanel_map_city' => 'city',
'controlpanel_map_state' => 'state',
'controlpanel_map_zip' => 'zip',
'controlpanel_map_country' => 'mls',
)
GET Variables: array (
'action' => 'configure',
'printer_friendly' => '',
)

I'm not sure how or why this is happening and there is nothing in the error logs showing a problem. any help would be thankful.

[pbflash]

Was this a clean install or upgrade? If it was an upgrade, did you run install and choose the upgrade option? Did you try pasting the sql satement into phpmyadmin to get the exact error?

I ran the sql statement on my db and it went through fine so I am guessing that you upgraded and didn't run install so you're missing some fields in your db.

[computersltd]

Thanks, think I know what I did wrong I had 2.2 installed and removed it completly but did not clear mysql then I installed 2.3. I'm guessing the tables in 2.2 and 2.3 are different?

[pbflash]

Yes, there are additional fields in 2.3. You need to run install and select upgrade to update the db.