New Site Joom Shopping 3.11.2

02.10.2012 19:35
#1
jmil
Joomshopping forum user no avatar
Name: Jim Miller
19.09.2011
Posts: 89
Quote
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'


Joomla: 2.5.4
JoomShopping: 3.11.2
PHP: 5.3.13

Letzte Änderung: 02.10.2012 19:41
 
02.10.2012 20:08
#2
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16513
Quote
Aw: New Site Joom Shopping 3.11.2

missing update.

Need update step to step.

 
02.10.2012 20:41
#3
jmil
Joomshopping forum user no avatar
Name: Jim Miller
19.09.2011
Posts: 89
Quote
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!


Letzte Änderung: 02.10.2012 20:42
 
02.10.2012 21:43
#4
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16513
Quote
Aw: New Site Joom Shopping 3.11.2

disable debug mode and update step to step

mysql errors - this is normal.


Letzte Änderung: 02.10.2012 21:44
 
02.10.2012 21:47
#5
jmil
Joomshopping forum user no avatar
Name: Jim Miller
19.09.2011
Posts: 89
Quote
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!

 
02.10.2012 23:56
#6
jmil
Joomshopping forum user no avatar
Name: Jim Miller
19.09.2011
Posts: 89
Quote
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+

 
Copyrights MAXXmarketing GmbH. All Rights Reserved