I upgrade from 2.0.20b (all was OK) to 2.0.22
First I see that some items have no category route in path and some items works ok.
Before update all items in category "cat1" has addreses like this
http://site.com/shop/cat1/item5Now some items have addreses like this
http://site.com/item5I insert
print_r($product);
before each item in category themplate and see, that some products have no some data:
================================================================
stdClass Object ( [virtuemart_manufacturer_id] => 8 [mf_name] => Квант-Эфир [slug] => kvant-efir-aru-01-indoor-white [mf_email] => fff@gmail.com [mf_desc] => [virtuemart_manufacturercategories_id] => 0 [mf_url] =>
http://newhd.com.ua [published] => 1 [_pkey:protected] => virtuemart_product_id [_pkeyForm:protected] => [_obkeys:protected] => Array ( [product_name] => Название товара отсутствует! Не удается сохранить запись без Название товара. [slug] => Данная SEF псевдоним уже существует. ) [_unique:protected] => 1 [_unique_name:protected] => Array ( [slug] => Данная SEF псевдоним уже существует. ) [_orderingKey:protected] => ordering [_slugAutoName:protected] => product_name [_slugName:protected] => slug [_loggable:protected] => 1 [_xParams:protected] => product_params [_varsToPushParam:protected] => Array ( [min_order_level] => Array (
- => [1] => float ) [max_order_level] => Array (
- => [1] => float ) [step_order_level] => Array (
- => [1] => float ) [product_box] => Array (
- => [1] => float ) ) [_translatable] => 1 [_translatableFields:protected] => Array (
- => product_name [1] => product_s_desc [2] => product_desc [3] => metadesc [4] => metakey [5] => customtitle [slug] => slug ) [_langTag:protected] => ru_ru [_tbl_lang:protected] => #__virtuemart_products_ru_ru [_updateNulls:protected] => 1 [_tablePreFix] => p. [_tbl:protected] => #__virtuemart_products [_tbl_key:protected] => virtuemart_product_id [_db:protected] => JDatabaseMySQLi Object ( [name] => mysqli [nameQuote:protected] => ` [nullDate:protected] => 0000-00-00 00:00:00 [dbMinimum:protected] => 5.0.4 [_database:JDatabase:private] => 1hd [connection:protected] => mysqli Object ( [affected_rows] => 0 [client_info] => mysqlnd 5.0.8-dev - 20102224 - $Id: 65fe78e70ce53d27a6cd578597722950e490b0d0 $ [client_version] => 50008 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [field_count] => 7 [host_info] => localhost via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.5.25 [server_version] => 50525 [stat] => Uptime: 29291 Threads: 1 Questions: 29202 Slow queries: 1 Opens: 22956 Flush tables: 1 Open tables: 4 Queries per second avg: 0.996 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 241 [warning_count] => 0 ) [count:protected] => 0 [cursor:protected] => mysqli_result Object
Warning: print_r() [function.print-r]: Couldn't fetch mysqli_result in Z:\home\1hd.loc\www\templates\gk_yourshop\html\com_virtuemart\category\default.php on line 188
Warning: print_r() [function.print-r]: Couldn't fetch mysqli_result in Z:\home\1hd.loc\www\templates\gk_yourshop\html\com_virtuemart\category\default.php on line 188
Warning: print_r() [function.print-r]: Property access is not allowed yet in Z:\home\1hd.loc\www\templates\gk_yourshop\html\com_virtuemart\category\default.php on line 188
Warning: print_r() [function.print-r]: Couldn't fetch mysqli_result in Z:\home\1hd.loc\www\templates\gk_yourshop\html\com_virtuemart\category\default.php on line 188
Warning: print_r() [function.print-r]: Property access is not allowed yet in Z:\home\1hd.loc\www\templates\gk_yourshop\html\com_virtuemart\category\default.php on line 188
( [current_field] => [field_count] => [lengths] => [num_rows] => [type] => ) [debug:protected] => [limit:protected] => 0 [log:protected] => Array ( ) [offset:protected] => 0 [sql:protected] => SELECT L.* FROM `#__virtuemart_categories_ru_ru` as L JOIN `#__virtuemart_categories` as C using (`virtuemart_category_id`) LEFT JOIN `#__virtuemart_category_categories` as CC on C.`virtuemart_category_id` = CC.`category_child_id`WHERE CC.`category_parent_id` = 15 AND C.`virtuemart_vendor_id` = 1 AND C.`published` = 1 ORDER BY C.`ordering`, L.`category_name` ASC [tablePrefix:protected] => ahqb3_ [utf:protected] => 1 [errorNum:protected] => 0 [errorMsg:protected] => [hasQuoted:protected] => [quoted:protected] => Array ( ) ) [_trackAssets:protected] => [_rules:protected] => [_locked:protected] => [_errors:protected] => Array ( ) [created_on] => 2013-06-22 16:46:30 [created_by] => 464 [modified_on] => 2013-06-22 16:48:28 [modified_by] => 464 [virtuemart_product_id] => 48 [virtuemart_vendor_id] => 1 [product_parent_id] => 0 [product_sku] => ankea1iw [product_name] => Квант-эфир ARU-01 внутренняя белая [product_s_desc] => [product_desc] => [product_weight] => 0.0000 [product_weight_uom] => KG [product_length] => 0.0000 [product_width] => 0.0000 [product_height] => 0.0000 [product_lwh_uom] => MM [product_url] => kvant-efir-aru-01-indoor-white [product_in_stock] => 999 [product_ordered] => 1 [low_stock_notification] => 0 [product_available_date] => 2013-06-22 00:00:00 [product_availability] => [product_special] => 0 [pordering] => 0 [product_sales] => 0 [product_unit] => KG [product_packaging] => 0.0000 [product_params] => min_order_level=""|max_order_level=""|step_order_level=""|product_box=""| [intnotes] => [customtitle] => [metadesc] => [metakey] => [metarobot] => [metaauthor] => [layout] => 0 [min_order_level] => [max_order_level] => [step_order_level] => [product_box] => [virtuemart_customfield_id] => 744 [virtuemart_media_id] => Array (
- => 181 ) [shoppergroups] => Array ( ) [product_price] => 120.00000 [product_override_price] => 0.00000 [override] => 0 [virtuemart_product_price_id] => 93 [virtuemart_shoppergroup_id] => [product_price_publish_up] => 0000-00-00 00:00:00 [product_price_publish_down] => 0000-00-00 00:00:00 [price_quantity_start] => 0 [price_quantity_end] => 0 [prices] => Array ( [costPrice] => 120.00000 [basePrice] => 120 [basePriceVariant] => 120 [basePriceWithTax] => 0 [discountedPriceWithoutTax] => 120 [priceBeforeTax] => 120 [salesPrice] => 120 [taxAmount] => 0 [salesPriceWithDiscount] => 0 [salesPriceTemp] => 120 [unitPrice] => 0 [discountAmount] => -0 [priceWithoutTax] => 120 [variantModification] => 0 [DBTax] => Array ( ) [Tax] => Array ( ) [VatTax] => Array ( ) [DATax] => Array ( ) ) [product_tax_id] => 0 [product_discount_id] => 0 [product_currency] => 191 [categories] => Array (
- => 15 ) [canonCatLink] => kvant-efir-aru-01-indoor-white [virtuemart_category_id] => kvant-efir-aru-01-indoor-white [ordering] => 0 [id] => [category_name] => [packaging] => 0 [box] => 0 [customfields] => Array ( ) [customfieldsRelatedCategories] => Array ( ) [customfieldsRelatedProducts] => Array (
- => stdClass Object ( [virtuemart_custom_id] => 1 [custom_parent_id] => 0 [admin_only] => 0 [custom_title] => COM_VIRTUEMART_RELATED_PRODUCTS [custom_tip] => COM_VIRTUEMART_RELATED_PRODUCTS_TIP [value] => [custom_field_desc] => COM_VIRTUEMART_RELATED_PRODUCTS_DESC [field_type] => R [is_list] => 0 [is_hidden] => 0 [published] => 1 [virtuemart_customfield_id] => 744 [custom_value] => 35 [custom_param] => [custom_price] => [ordering] => 0 [display] =>
Strong SRT-8500 вид спереди
Strong SRT-8500 (T2) ) [1] => stdClass Object ( [virtuemart_custom_id] => 1 [custom_parent_id] => 0 [admin_only] => 0 [custom_title] => COM_VIRTUEMART_RELATED_PRODUCTS [custom_tip] => COM_VIRTUEMART_RELATED_PRODUCTS_TIP [value] => [custom_field_desc] => COM_VIRTUEMART_RELATED_PRODUCTS_DESC [field_type] => R [is_list] => 0 [is_hidden] => 0 [published] => 1 [virtuemart_customfield_id] => 745 [custom_value] => 36 [custom_param] => [custom_price] => [ordering] => 0 [display] =>
Strong SRT-8502 вид спереди
Strong SRT-8502 (T2) ) [2] => stdClass Object ( [virtuemart_custom_id] => 1 [custom_parent_id] => 0 [admin_only] => 0 [custom_title] => COM_VIRTUEMART_RELATED_PRODUCTS [custom_tip] => COM_VIRTUEMART_RELATED_PRODUCTS_TIP [value] => [custom_field_desc] => COM_VIRTUEMART_RELATED_PRODUCTS_DESC [field_type] => R [is_list] => 0 [is_hidden] => 0 [published] => 1 [virtuemart_customfield_id] => 746 [custom_value] => 37 [custom_param] => [custom_price] => [ordering] => 0 [display] =>
Strong Irdeto T2 CA-Модуль
Strong Irdeto CI+ (T2) ) [3] => stdClass Object ( [virtuemart_custom_id] => 1 [custom_parent_id] => 0 [admin_only] => 0 [custom_title] => COM_VIRTUEMART_RELATED_PRODUCTS [custom_tip] => COM_VIRTUEMART_RELATED_PRODUCTS_TIP [value] => [custom_field_desc] => COM_VIRTUEMART_RELATED_PRODUCTS_DESC [field_type] => R [is_list] => 0 [is_hidden] => 0 [published] => 1 [virtuemart_customfield_id] => 747 [custom_value] => 38 [custom_param] => [custom_price] => [ordering] => 0 [display] =>
Trimax TR-2012HD основной вид
Trimax TR-2012HD (T2) ) [4] => stdClass Object ( [virtuemart_custom_id] => 1 [custom_parent_id] => 0 [admin_only] => 0 [custom_title] => COM_VIRTUEMART_RELATED_PRODUCTS [custom_tip] => COM_VIRTUEMART_RELATED_PRODUCTS_TIP [value] => [custom_field_desc] => COM_VIRTUEMART_RELATED_PRODUCTS_DESC [field_type] => R [is_list] => 0 [is_hidden] => 0 [published] => 1 [virtuemart_customfield_id] => 748 [custom_value] => 42 [custom_param] => [custom_price] => [ordering] => 0 [display] =>
Optibox Raptor вид спереди
OptiBox Raptor (S2+T2) ) ) [customfieldsCart] => Array ( ) [customsChilds] => Array ( ) [orderable] => 1 [amount] => 1 [quantity] => 1 [product_template] => [canonical] => /kvant-efir-aru-01-indoor-white-detail [link] => /kvant-efir-aru-01-indoor-white-detail [images] => Array (
- => VmImage Object ( [media_attributes] => 0 [setRole] => [file_name] => kvant-efir-aru-01-dvb-t2-antenna-white [file_extension] => png [virtuemart_media_id] => 181 [_foldersToTest:VmMediaHandler:private] => Array (
- => Z:\home\1hd.loc\www\vm\p\ [1] => Z:\home\1hd.loc\www\vm\p\resized\ ) [_actions:VmMediaHandler:private] => Array ( ) [_mLocation:VmMediaHandler:private] => Array ( ) [_hidden:VmMediaHandler:private] => Array ( ) [theme_url] => http://1hd.loc/components/com_virtuemart/ [virtuemart_vendor_id] => 1 [file_title] => kvant-efir-aru-01-dvb-t2-antenna-white.png [file_description] => Антенна эфирная DVB-T2 Квант-эфир [file_meta] => Антенна эфирная DVB-T2 Квант-эфир [file_mimetype] => image/png [file_type] => product [file_url] => vm/p/kvant-efir-aru-01-dvb-t2-antenna-white.png [file_url_thumb] => vm/p/resized/kvant-efir-aru-01-dvb-t2-antenna-white_150x150.png [published] => 1 [file_is_downloadable] => 0 [file_is_forSale] => 0 [file_is_product_image] => 0 [shared] => 0 [file_params] => [file_lang] => [_translatable] => [_tablePreFix] => [created_on] => 0000-00-00 00:00:00 [created_by] => 0 [modified_on] => 2013-06-22 16:48:00 [modified_by] => 464 [file_url_folder] => vm/p/ [file_path_folder] => vm\p\ [file_url_folder_thumb] => vm/p/resized/ [media_role] => file_is_displayable ) ) [file_url_thumb] => vm/p/resized/kvant-efir-aru-01-dvb-t2-antenna-white_150x150.png [file_url] => vm/p/kvant-efir-aru-01-dvb-t2-antenna-white.png [stock] => stdClass Object ( [stock_tip] => У нас достаточный запас данного товара [stock_level] => normalstock ) )
===============================================================
continue in next msg