I am updating my current Site (Under Development) to the Latest Joomla 2.5.4 and Jom Shopping 3.11.2
I am configurig all the settings like my current site and everthing appears fine with 2 exceptions:
1. In the "CONFIGURATION" - "CATEGORY/PRODUCT" Tab - When ever I make a change (check Box) to any product selection - I get a "Error by saving into database" and the change does not save.
Every other tab works - Every Image works - just these settings in this TAB.
2. Video's - I do not see the "INSERT CODE" Check Box for YouTube Videos.
Other than that - everything else appears to work.
My Development Site is: http://www.wildbikers.com/NEW/test/en/
My LIVE Site is: http://www.wildbikers.com (Using Joomla 1.7 and Shopping 3.3.2 and all features work properly.
Here is the Joomla DEBUG info:
JDatabaseMySQLi::query: 1054 - Unknown column 'cart_display_extra_fields' in 'field list' SQL=UPDATE `jos_jshopping_config` SET `count_products_to_page`='12',`count_products_to_row`='3',`count_category_to_row`='1',`allow_reviews_prod`='1',`allow_reviews_only_registered`='1',`max_mark`='10',`hide_product_not_avaible_stock`='0',`show_buy_in_category`='1',`show_tax_in_product`='0',`show_tax_product_in_cart`='0',`show_plus_shipping_in_product`='1',`hide_buy_not_avaible_stock`='1',`show_sort_product`='1',`show_count_select_products`='1',`show_delivery_time`='1',`demo_type`='0',`product_show_manufacturer_logo`='1',`product_show_weight`='0',`product_attribut_first_value_empty`='0',`show_hits`='1',`hide_text_product_not_available`='0',`use_plugin_content`='1',`product_list_show_weight`='0',`product_list_show_manufacturer`='0',`show_product_code`='1',`product_list_show_min_price`='1',`product_count_related_in_row`='3',`category_sorting`='2',`product_sorting`='6',`product_sorting_direction`='0',`show_product_list_filters`='1',`product_list_display_extra_fields`='a:0:{}',`filter_display_extra_fields`='a:0:{}',`product_hide_extra_fields`='a:0:{}',`product_show_vendor`='0',`product_show_vendor_detail`='0',`product_list_show_vendor`='0',`product_show_button_back`='1',`product_list_show_product_code`='0',`radio_attr_value_vertical`='0',`attr_display_addprice`='1',`product_list_show_price_description`='0',`display_button_print`='1',`product_show_manufacturer`='0',`product_list_show_price_default`='0',`product_list_show_qty_stock`='0',`product_show_qty_stock`='1',`displayprice`='0',`display_reviews_without_confirm`='0',`manufacturer_sorting`='2',`main_unit_weight`='2',`other_config`='a:45:{s:17:\"cart_back_to_shop\";s:4:\"list\";s:32:\"product_button_back_use_end_list\";s:1:\"0\";s:21:\"display_tax_id_in_pdf\";s:1:\"0\";s:13:\"image_quality\";s:3:\"100\";s:16:\"image_fill_color\";s:8:\"16777215\";s:26:\"product_price_qty_discount\";s:1:\"2\";s:16:\"rating_starparts\";s:1:\"2\";s:31:\"show_list_price_shipping_weight\";s:1:\"0\";s:23:\"product_price_precision\";s:1:\"2\";s:26:\"cart_decimal_qty_precision\";s:1:\"2\";s:25:\"default_frontend_currency\";s:1:\"0\";s:27:\"product_file_upload_via_ftp\";s:1:\"0\";s:25:\"product_file_upload_count\";s:1:\"1\";s:26:\"product_image_upload_count\";s:2:\"10\";s:26:\"product_video_upload_count\";s:1:\"3\";s:33:\"show_insert_code_in_product_video\";s:1:\"0\";s:29:\"max_number_download_sale_file\";s:1:\"3\";s:26:\"max_day_download_sale_file\";s:3:\"365\";s:34:\"order_display_new_digital_products\";s:1:\"1\";s:24:\"display_user_groups_info\";s:1:\"1\";s:18:\"display_user_group\";s:1:\"1\";s:47:\"display_delivery_time_for_product_in_order_mail\";s:1:\"1\";s:11:\"load_jquery\";s:1:\"1\";s:19:\"load_jquery_version\";s:5:\"1.6.2\";s:20:\"load_jquery_lightbox\";s:1:\"1\";s:15:\"load_javascript\";s:1:\"1\";s:8:\"load_css\";s:1:\"1\";s:25:\"show_manufacturer_in_cart\";s:1:\"0\";s:17:\"weight_in_invoice\";s:1:\"0\";s:19:\"shipping_in_invoice\";s:1:\"0\";s:18:\"payment_in_invoice\";s:1:\"0\";s:23:\"date_invoice_in_invoice\";s:1:\"0\";s:3:\"tax\";s:1:\"1\";s:30:\"count_products_to_page_tophits\";s:2:\"12\";s:32:\"count_products_to_page_toprating\";s:2:\"12\";s:28:\"count_products_to_page_label\";s:2:\"12\";s:33:\"count_products_to_page_bestseller\";s:2:\"12\";s:29:\"count_products_to_page_random\";s:2:\"12\";s:27:\"count_products_to_page_last\";s:2:\"12\";s:29:\"count_products_to_row_tophits\";s:1:\"3\";s:31:\"count_products_to_row_toprating\";s:1:\"3\";s:27:\"count_products_to_row_label\";s:1:\"3\";s:32:\"count_products_to_row_bestseller\";s:1:\"3\";s:28:\"count_products_to_row_random\";s:1:\"3\";s:26:\"count_products_to_row_last\";s:1:\"3\";}',`cart_display_extra_fields`='a:0:{}' WHERE `id`='1'
Joomla: 2.5.4
JoomShopping: 3.11.2
PHP: 5.3.13
JoomShopping: 3.11.2
PHP: 5.3.13
Last change: 02.10.2012 19:41