Results 1 to 1 of 1

Thread: Upgrade 3.0 to 3.1.7 (error in Open-Realty Control Panel)

  1. #1
    Join Date
    Jul 2004
    Posts
    61

    Default Upgrade 3.0 to 3.1.7 (error in Open-Realty Control Panel) - Resolved

    I've upgraded from 3.0 to 3.1.7 and the upgrade process went through without any problem.

    But when I logged into my Open-Realty Control Panel -> in "Site Config" -> "Listings" tab - When I clicked on "Save Changes", it results in errors as displayed in the screenshot below:

    open-realty-error.jpg

    And I received an email notification of the error with the following content:

    Code:
    SQL Error Message: Unknown column 'controlpanel_multiple_pclass_selection' in 'field list'
    SQL statement that failed below: 
    ---------------------------------------------------------
    UPDATE default_controlpanel SET `controlpanel_number_format_style` = '1' , `controlpanel_number_decimals_number_fields` = '0' , `controlpanel_number_decimals_price_fields` = '0' , `controlpanel_force_decimals` = '0' , `controlpanel_money_format` = '1' , `controlpanel_money_sign` = '฿' , `controlpanel_date_format` = '3' , `controlpanel_zero_price` = '0' , `controlpanel_price_field` = '' , `controlpanel_multiple_pclass_selection` = '{value}' , `controlpanel_num_featured_listings` = '6' , `controlpanel_use_expiration` = '0' , `controlpanel_days_until_listings_expire` = '0' , `controlpanel_moderate_listings` = '0' , `controlpanel_export_listings` = '0' , `controlpanel_show_listedby_admin` = '0' , `controlpanel_show_next_prev_listing_page` = '0' , `controlpanel_show_notes_field` = '1' , `controlpanel_feature_list_separator` = '<br />' , `controlpanel_admin_listing_per_page` = '10' , `controlpanel_search_step_max` = '100' , `controlpanel_listings_per_page` = '10' , `controlpanel_search_sortby` = 'listingsdb_last_modified' , `controlpanel_search_sorttype` = 'DESC' , `controlpanel_special_search_sortby` = 'none' , `controlpanel_special_search_sorttype` = 'DESC' , `controlpanel_configured_show_count` = '1' , `controlpanel_max_search_results` = '0' , `controlpanel_search_list_separator` = '<br />' , `controlpanel_textarea_short_chars` = '150' , `controlpanel_map_type` = 'mapquest_TH' , `controlpanel_map_address` = '' , `controlpanel_map_address2` = '' , `controlpanel_map_address3` = '' , `controlpanel_map_address4` = '' , `controlpanel_map_city` = '' , `controlpanel_map_state` = '' , `controlpanel_map_zip` = '' , `controlpanel_map_country` = ''
    
    ---------------------------------------------------------
    
    ERROR REPORT www.chiangmaibetterhome.com: August 10, 2011, 2:09:51 pm
    
    ---------------------------------------------------------
    Server Type: LiteSpeed
    Request Method: POST
    Query String: action=update_site_config
    Refereer: http://www.chiangmaibetterhome.com/admin/index.php?action=configure
    User Agent: Mozilla/5.0 (Windows NT 6.1; rv:5.0) Gecko/20100101 Firefox/5.0
    Request URI: /admin/ajax.php?action=update_site_config
    POST Variables: array (
      'controlpanel_number_format_style' => '1',
      'controlpanel_number_decimals_number_fields' => '0',
      'controlpanel_number_decimals_price_fields' => '0',
      'controlpanel_force_decimals' => '0',
      'controlpanel_money_format' => '1',
      'controlpanel_money_sign' => '฿',
      'controlpanel_date_format' => '3',
      'controlpanel_zero_price' => '0',
      'controlpanel_price_field' => '',
      'controlpanel_multiple_pclass_selection' => '{value}',
      'controlpanel_num_featured_listings' => '6',
      'controlpanel_use_expiration' => '0',
      'controlpanel_days_until_listings_expire' => '0',
      'controlpanel_moderate_listings' => '0',
      'controlpanel_export_listings' => '0',
      'controlpanel_show_listedby_admin' => '0',
      'controlpanel_show_next_prev_listing_page' => '0',
      'controlpanel_show_notes_field' => '1',
      'controlpanel_feature_list_separator' => '<br />',
      'controlpanel_admin_listing_per_page' => '10',
      'controlpanel_search_step_max' => '100',
      'controlpanel_listings_per_page' => '10',
      'controlpanel_search_sortby' => 'listingsdb_last_modified',
      'controlpanel_search_sorttype' => 'DESC',
      'controlpanel_special_search_sortby' => 'none',
      'controlpanel_special_search_sorttype' => 'DESC',
      'controlpanel_configured_show_count' => '1',
      'controlpanel_max_search_results' => '0',
      'controlpanel_search_list_separator' => '<br />',
      'controlpanel_textarea_short_chars' => '150',
      'controlpanel_map_type' => 'mapquest_TH',
      'controlpanel_map_address' => '',
      'controlpanel_map_address2' => '',
      'controlpanel_map_address3' => '',
      'controlpanel_map_address4' => '',
      'controlpanel_map_city' => '',
      'controlpanel_map_state' => '',
      'controlpanel_map_zip' => '',
      'controlpanel_map_country' => '',
    )
    GET Variables: array (
      'action' => 'update_site_config',
    )

    Deleted the "Allow multiple Property Class" field in Admin Template and that solved the problem; because 3.1.7 does not allow assignment of multiple property class for property listing.
    Last edited by tomyken; 08-10-2011 at 03:41 AM. Reason: Problem Resolved

Similar Threads

  1. Message Control Panel
    By cundali in forum Addon help, ideas and discussion (CLOSED)
    Replies: 0
    Last Post: 04-15-2010, 09:19 AM
  2. Tag for diplaying agent name in control panel?
    By zarathustra in forum General Help (CLOSED)
    Replies: 6
    Last Post: 11-06-2008, 03:33 PM
  3. 2.5 admin control panel
    By castopia in forum Installation/Configuration Help (CLOSED)
    Replies: 2
    Last Post: 06-06-2008, 12:17 PM
  4. Agent Control Panel
    By jamesd116 in forum Addon help, ideas and discussion (CLOSED)
    Replies: 4
    Last Post: 12-11-2006, 02:32 PM
  5. Control Panel
    By lstr in forum General Help (CLOSED)
    Replies: 1
    Last Post: 11-07-2005, 08:17 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •