New Site Joom Shopping 3.11.2

New Site Joom Shopping 3.11.2

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'

---

---

Aw: New Site Joom Shopping 3.11.2

missing update.

Need update step to step.

Aw: New Site Joom Shopping 3.11.2

I was very very careful to ensure I did not miss any but anything is possible!!!

How can you tell WHICH one I missed (if I did) and how do I go back?

Do I simply add the missing update or do I delete back then go forward?

Thanks for the quick response!

---

Aw: New Site Joom Shopping 3.11.2

disable debug mode and update step to step

mysql errors - this is normal.

---

Aw: New Site Joom Shopping 3.11.2

Tried - No Luck and Since I just loaded it and it is new (Made for my future update) I just bit it and deleted the Store and Tables -

From Scratch one more time. Should know by tomorrow if I still have the error with a fresh install. Will post my findings then!

Thanks and stay posted!

Aw: New Site Joom Shopping 3.11.2

UPDATE

I got lucky since it was a fresh install. I deleted all Tables all files and started fresh! It appears to be working great. No issues as of yet.

Thank You and appreciate the help or at least pointing me in the right direction!

One thing I Did different though was regress to PHP 5.2 during the install then upgraded back to 5.3+