Benvenuto, Ospite
Nome utente: Password: Ricordami
  • Pagina:
  • 1

ARGOMENTO:

VirtueMart 2.0.22 10 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 10 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.

  • Pagina:
  • 1
Tempo creazione pagina: 0.090 secondi

bindCommerce

bindCommerce s.r.l.

Partita IVA IT07798861212 - SDI M5UXCR1
Registro imprese di Napoli - REA: NA - 910618
Capitale Sociale € 20.000,00 interamente versato
Tel: +39 011 089 122 0
E-mail: [email protected]

PON 2014>20 Riaccendiamo lo sviluppo