Benvenuto,
Ospite
|
ARGOMENTO:
VirtueMart 2.0.22 11 Anni 9 Mesi fa #23
|
Abbiamo verificato la compatibilità delle procedure bindCommerce, Tutto ok !
Ing. Paolo Tateo
CEO bindCommerce |
Si prega Accedi a partecipare alla conversazione. |
VirtueMart 2.0.22 11 Anni 9 Mesi fa #18
|
E' uscita oggi la versione 2.0.22 di VirtueMart e stiamo valutando gli impatti.
Vi anticipiamo il listato delle modifiche che vengono apportate al database durante l'aggiornamento (non sono proprio pochine): alterTable CHANGE #_virtuemart_categories.limit_list_step : ALTER TABLE `#_virtuemart_categories` CHANGE COLUMN `limit_list_step` `limit_list_step` CHAR(32) alterTable ADD #_virtuemart_customs.show_title : ALTER TABLE `#_virtuemart_customs` ADD show_title tinyint(1) NOT NULL DEFAULT '1' FIRST alterTable CHANGE #_virtuemart_medias.file_lang : ALTER TABLE `#_virtuemart_medias` CHANGE COLUMN `file_lang` `file_lang` VARCHAR(500) NOT NULL alterTable ADD #_virtuemart_migration_oldtonew_ids.attributes : ALTER TABLE `#_virtuemart_migration_oldtonew_ids` ADD attributes longblob FIRST alterTable ADD #_virtuemart_migration_oldtonew_ids.relatedproducts : ALTER TABLE `#_virtuemart_migration_oldtonew_ids` ADD relatedproducts longblob AFTER attributes alterTable ADD #_virtuemart_orders.customer_number : ALTER TABLE `#_virtuemart_orders` ADD customer_number char(32) FIRST alterTable ADD #_virtuemart_orders.order_language : ALTER TABLE `#_virtuemart_orders` ADD order_language char(7) AFTER customer_number alterTable ADD #_virtuemart_order_items.product_priceWithoutTax : ALTER TABLE `#_virtuemart_order_items` ADD product_priceWithoutTax decimal(15,5) FIRST alterTable ADD #_virtuemart_order_items.product_discountedPriceWithoutTax : ALTER TABLE `#_virtuemart_order_items` ADD product_discountedPriceWithoutTax decimal(15,5) AFTER product_priceWithoutTax alterTable CHANGE #_virtuemart_order_userinfos.last_name : ALTER TABLE `#_virtuemart_order_userinfos` CHANGE COLUMN `last_name` `last_name` CHAR(48) alterTable CHANGE #_virtuemart_order_userinfos.first_name : ALTER TABLE `#_virtuemart_order_userinfos` CHANGE COLUMN `first_name` `first_name` CHAR(48) alterTable CHANGE #_virtuemart_order_userinfos.middle_name : ALTER TABLE `#_virtuemart_order_userinfos` CHANGE COLUMN `middle_name` `middle_name` CHAR(48) alterTable CHANGE #_virtuemart_order_userinfos.phone_1 : ALTER TABLE `#_virtuemart_order_userinfos` CHANGE COLUMN `phone_1` `phone_1` CHAR(32) alterTable CHANGE #_virtuemart_order_userinfos.phone_2 : ALTER TABLE `#_virtuemart_order_userinfos` CHANGE COLUMN `phone_2` `phone_2` CHAR(32) alterTable CHANGE #_virtuemart_order_userinfos.fax : ALTER TABLE `#_virtuemart_order_userinfos` CHANGE COLUMN `fax` `fax` CHAR(32) alterTable CHANGE #_virtuemart_order_userinfos.city : ALTER TABLE `#_virtuemart_order_userinfos` CHANGE COLUMN `city` `city` CHAR(64) NOT NULL DEFAULT '' alterTable CHANGE #_virtuemart_order_userinfos.email : ALTER TABLE `#_virtuemart_order_userinfos` CHANGE COLUMN `email` `email` CHAR(128) alterTable CHANGE #_virtuemart_products.product_in_stock : ALTER TABLE `#_virtuemart_products` CHANGE COLUMN `product_in_stock` `product_in_stock` INT(1) NOT NULL DEFAULT '0' alterTable CHANGE #_virtuemart_products.product_ordered : ALTER TABLE `#_virtuemart_products` CHANGE COLUMN `product_ordered` `product_ordered` INT(1) NOT NULL DEFAULT '0' alterTable CHANGE #_virtuemart_products.low_stock_notification : ALTER TABLE `#_virtuemart_products` CHANGE COLUMN `low_stock_notification` `low_stock_notification` INT(1) UNSIGNED NOT NULL DEFAULT '0' alterTable CHANGE #_virtuemart_products.product_sales : ALTER TABLE `#_virtuemart_products` CHANGE COLUMN `product_sales` `product_sales` INT(1) UNSIGNED NOT NULL DEFAULT '0' alterTable CHANGE #_virtuemart_products.pordering : ALTER TABLE `#_virtuemart_products` CHANGE COLUMN `pordering` `pordering` MEDIUMINT(2) UNSIGNED NOT NULL DEFAULT '0' alterTable CHANGE #_virtuemart_userinfos.last_name : ALTER TABLE `#_virtuemart_userinfos` CHANGE COLUMN `last_name` `last_name` CHAR(48) alterTable CHANGE #_virtuemart_userinfos.first_name : ALTER TABLE `#_virtuemart_userinfos` CHANGE COLUMN `first_name` `first_name` CHAR(48) alterTable CHANGE #_virtuemart_userinfos.middle_name : ALTER TABLE `#_virtuemart_userinfos` CHANGE COLUMN `middle_name` `middle_name` CHAR(48) alterTable CHANGE #_virtuemart_userinfos.phone_1 : ALTER TABLE `#_virtuemart_userinfos` CHANGE COLUMN `phone_1` `phone_1` CHAR(32) alterTable CHANGE #_virtuemart_userinfos.phone_2 : ALTER TABLE `#_virtuemart_userinfos` CHANGE COLUMN `phone_2` `phone_2` CHAR(32) alterTable CHANGE #_virtuemart_userinfos.fax : ALTER TABLE `#_virtuemart_userinfos` CHANGE COLUMN `fax` `fax` CHAR(32) alterTable CHANGE #_virtuemart_userinfos.city : ALTER TABLE `#_virtuemart_userinfos` CHANGE COLUMN `city` `city` CHAR(64) NOT NULL DEFAULT '' alterTable ADD #_virtuemart_vendors.metarobot : ALTER TABLE `#_virtuemart_vendors` ADD metarobot char(20) FIRST alterTable ADD #_virtuemart_vendors.metaauthor : ALTER TABLE `#_virtuemart_vendors` ADD metaauthor char(64) AFTER metarobot alterTable ADD #_virtuemart_vendors_it_it.vendor_letter_css : ALTER TABLE `#_virtuemart_vendors_it_it` ADD vendor_letter_css text NOT NULL FIRST alterTable ADD #_virtuemart_vendors_it_it.vendor_letter_header_html : ALTER TABLE `#_virtuemart_vendors_it_it` ADD vendor_letter_header_html varchar(8000) NOT NULL DEFAULT ' {vm:vendorname} {vm:vendoraddress} ' AFTER vendor_letter_css alterTable ADD #_virtuemart_vendors_it_it.vendor_letter_footer_html : ALTER TABLE `#_virtuemart_vendors_it_it` ADD vendor_letter_footer_html varchar(8000) NOT NULL DEFAULT ' {vm:vendorlegalinfo} Page {vm:pagenum}/{vm:pagecount} ' AFTER vendor_letter_header_html alterTable ADD #_virtuemart_vendors_it_it.metadesc : ALTER TABLE `#_virtuemart_vendors_it_it` ADD metadesc varchar(400) NOT NULL DEFAULT '' AFTER vendor_letter_footer_html alterTable ADD #_virtuemart_vendors_it_it.metakey : ALTER TABLE `#_virtuemart_vendors_it_it` ADD metakey varchar(400) NOT NULL DEFAULT '' AFTER metadesc alterTable ADD #_virtuemart_vendors_it_it.customtitle : ALTER TABLE `#_virtuemart_vendors_it_it` ADD customtitle char(255) NOT NULL DEFAULT '' AFTER metakey alterTable CHANGE #_virtuemart_categories_it_it.category_description : ALTER TABLE `#_virtuemart_categories_it_it` CHANGE COLUMN `category_description` `category_description` VARCHAR(19000) NOT NULL DEFAULT '' alterTable CHANGE #_virtuemart_manufacturers_it_it.mf_desc : ALTER TABLE `#_virtuemart_manufacturers_it_it` CHANGE COLUMN `mf_desc` `mf_desc` VARCHAR(19000) NOT NULL DEFAULT '' alterTable CHANGE #_virtuemart_manufacturercategories_it_it.mf_category_desc : ALTER TABLE `#_virtuemart_manufacturercategories_it_it` CHANGE COLUMN `mf_category_desc` `mf_category_desc` VARCHAR(19000) NOT NULL DEFAULT '' alterTable CHANGE #_virtuemart_paymentmethods_it_it.payment_desc : ALTER TABLE `#_virtuemart_paymentmethods_it_it` CHANGE COLUMN `payment_desc` `payment_desc` VARCHAR(19000) NOT NULL DEFAULT '' alterTable CHANGE #_virtuemart_shipmentmethods_it_it.shipment_desc : ALTER TABLE `#_virtuemart_shipmentmethods_it_it` CHANGE COLUMN `shipment_desc` `shipment_desc` VARCHAR(19000) NOT NULL DEFAULT '' alterTable ADD #_virtuemart_vendors_en_gb.vendor_letter_css : ALTER TABLE `#_virtuemart_vendors_en_gb` ADD vendor_letter_css text NOT NULL FIRST alterTable ADD #_virtuemart_vendors_en_gb.vendor_letter_header_html : ALTER TABLE `#_virtuemart_vendors_en_gb` ADD vendor_letter_header_html varchar(8000) NOT NULL DEFAULT ' {vm:vendorname} {vm:vendoraddress} ' AFTER vendor_letter_css alterTable ADD #_virtuemart_vendors_en_gb.vendor_letter_footer_html : ALTER TABLE `#_virtuemart_vendors_en_gb` ADD vendor_letter_footer_html varchar(8000) NOT NULL DEFAULT ' {vm:vendorlegalinfo} Page {vm:pagenum}/{vm:pagecount} ' AFTER vendor_letter_header_html alterTable ADD #_virtuemart_vendors_en_gb.metadesc : ALTER TABLE `#_virtuemart_vendors_en_gb` ADD metadesc varchar(400) NOT NULL DEFAULT '' AFTER vendor_letter_footer_html alterTable ADD #_virtuemart_vendors_en_gb.metakey : ALTER TABLE `#_virtuemart_vendors_en_gb` ADD metakey varchar(400) NOT NULL DEFAULT '' AFTER metadesc alterTable ADD #_virtuemart_vendors_en_gb.customtitle : ALTER TABLE `#_virtuemart_vendors_en_gb` ADD customtitle char(255) NOT NULL DEFAULT '' AFTER metakey alterTable CHANGE #_virtuemart_categories_en_gb.category_description : ALTER TABLE `#_virtuemart_categories_en_gb` CHANGE COLUMN `category_description` `category_description` VARCHAR(19000) NOT NULL DEFAULT '' alterTable CHANGE #_virtuemart_manufacturers_en_gb.mf_desc : ALTER TABLE `#_virtuemart_manufacturers_en_gb` CHANGE COLUMN `mf_desc` `mf_desc` VARCHAR(19000) NOT NULL DEFAULT '' alterTable CHANGE #_virtuemart_manufacturercategories_en_gb.mf_category_desc : ALTER TABLE `#_virtuemart_manufacturercategories_en_gb` CHANGE COLUMN `mf_category_desc` `mf_category_desc` VARCHAR(19000) NOT NULL DEFAULT '' alterTable CHANGE #_virtuemart_paymentmethods_en_gb.payment_desc : ALTER TABLE `#_virtuemart_paymentmethods_en_gb` CHANGE COLUMN `payment_desc` `payment_desc` VARCHAR(19000) NOT NULL DEFAULT '' alterTable CHANGE #_virtuemart_shipmentmethods_en_gb.shipment_desc : ALTER TABLE `#_virtuemart_shipmentmethods_en_gb` CHANGE COLUMN `shipment_desc` `shipment_desc` VARCHAR(19000) NOT NULL DEFAULT '' Taking config from file Table updated: Tablename #_virtuemart_categories dropped: 0 altered: 1 added: 0 Table updated: Tablename #_virtuemart_customs dropped: 0 altered: 0 added: 1 Table updated: Tablename #_virtuemart_medias dropped: 0 altered: 1 added: 0 Table updated: Tablename #_virtuemart_migration_oldtonew_ids dropped: 0 altered: 0 added: 2 Table updated: Tablename #_virtuemart_orders dropped: 0 altered: 0 added: 2 Table updated: Tablename #_virtuemart_order_items dropped: 0 altered: 0 added: 2 Table updated: Tablename #_virtuemart_order_userinfos dropped: 0 altered: 8 added: 0 Table updated: Tablename #_virtuemart_products dropped: 0 altered: 5 added: 0 Table updated: Tablename #_virtuemart_userinfos dropped: 0 altered: 7 added: 0 Table updated: Tablename #_virtuemart_vendors dropped: 0 altered: 0 added: 2 Table updated: Tablename #_virtuemart_vendors_it_it dropped: 0 altered: 0 added: 6 Table updated: Tablename #_virtuemart_categories_it_it dropped: 0 altered: 1 added: 0 Table updated: Tablename #_virtuemart_manufacturers_it_it dropped: 0 altered: 1 added: 0 Table updated: Tablename #_virtuemart_manufacturercategories_it_it dropped: 0 altered: 1 added: 0 Table updated: Tablename #_virtuemart_paymentmethods_it_it dropped: 0 altered: 1 added: 0 Table updated: Tablename #_virtuemart_shipmentmethods_it_it dropped: 0 altered: 1 added: 0 Table updated: Tablename #_virtuemart_vendors_en_gb dropped: 0 altered: 0 added: 6 Table updated: Tablename #_virtuemart_categories_en_gb dropped: 0 altered: 1 added: 0 Table updated: Tablename #_virtuemart_manufacturers_en_gb dropped: 0 altered: 1 added: 0 Table updated: Tablename #_virtuemart_manufacturercategories_en_gb dropped: 0 altered: 1 added: 0 Table updated: Tablename #_virtuemart_paymentmethods_en_gb dropped: 0 altered: 1 added: 0 Table updated: Tablename #_virtuemart_shipmentmethods_en_gb dropped: 0 altered: 1 added: 0 componente installato correttamente com_virtuemart_allinoneInstallerScript:: VirtueMart2 update #__virtuemart_payment_plg_standard com_virtuemart_allinoneInstallerScript:: VirtueMart2 update #__virtuemart_payment_plg_paypal com_virtuemart_allinoneInstallerScript:: VirtueMart2 update #__virtuemart_shipment_plg_weight_countries componente installato correttamente Ing. Paolo Tateo
CEO bindCommerce |
Si prega Accedi a partecipare alla conversazione. |
Tempo creazione pagina: 0.041 secondi