Typo3 Upgrade Wizard

Questions around the TYPO3 integration and plugins
Forum rules
Always add your TYPO3, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
tenkraD
Advanced
Posts: 110
Joined: 25 Jul 2017, 08:38

Typo3 Upgrade Wizard

Post by tenkraD » 20 Apr 2019, 11:43

Hello Again,
I upgrade my Typo3 Version with the upgrade wizzard and it Alters Mshop Tables.
I'm now unsure if this was wrong, if yes i will import my backup to regenerate these altered Tables.

The Typo3 Upgrade wizard changed these Tables:
ALTER TABLE mshop_attribute DROP FOREIGN KEY fk_msatt_typeid
ALTER TABLE mshop_attribute_list DROP FOREIGN KEY fk_msattli_pid
ALTER TABLE mshop_attribute_list DROP FOREIGN KEY fk_msattli_typeid
ALTER TABLE mshop_attribute_property DROP FOREIGN KEY fk_msattpr_pid
ALTER TABLE mshop_catalog_list DROP FOREIGN KEY fk_mscatli_pid
ALTER TABLE mshop_catalog_list DROP FOREIGN KEY fk_mscatli_typeid
ALTER TABLE mshop_coupon_code DROP FOREIGN KEY fk_mscouco_parentid
ALTER TABLE mshop_customer_address DROP FOREIGN KEY fk_mscusad_parentid
ALTER TABLE mshop_customer_list DROP FOREIGN KEY fk_mscusli_pid
ALTER TABLE mshop_customer_list DROP FOREIGN KEY fk_mscusli_typeid
ALTER TABLE mshop_customer_property DROP FOREIGN KEY fk_mcuspr_pid
ALTER TABLE mshop_locale DROP FOREIGN KEY fk_msloc_currid
ALTER TABLE mshop_locale DROP FOREIGN KEY fk_msloc_langid
ALTER TABLE mshop_locale DROP FOREIGN KEY fk_msloc_siteid
ALTER TABLE mshop_locale CHANGE currencyid `currencyid` VARCHAR(3) NOT NULL
ALTER TABLE mshop_locale_currency DROP FOREIGN KEY fk_msloccu_siteid
ALTER TABLE mshop_locale_currency CHANGE id `id` VARCHAR(3) NOT NULL
ALTER TABLE mshop_locale_language DROP FOREIGN KEY fk_mslocla_siteid
ALTER TABLE mshop_media DROP FOREIGN KEY fk_msmed_typeid
ALTER TABLE mshop_media_list DROP FOREIGN KEY fk_msmedli_pid
ALTER TABLE mshop_media_list DROP FOREIGN KEY fk_msmedli_typeid
ALTER TABLE mshop_media_property DROP FOREIGN KEY fk_msmedpr_pid
ALTER TABLE mshop_order DROP FOREIGN KEY fk_msord_baseid
ALTER TABLE mshop_order_base_address DROP FOREIGN KEY fk_msordbaad_baseid
ALTER TABLE mshop_order_base_coupon DROP FOREIGN KEY fk_msordbaco_baseid
ALTER TABLE mshop_order_base_coupon DROP FOREIGN KEY fk_msordbaco_ordprodid
ALTER TABLE mshop_order_base_product DROP FOREIGN KEY fk_msordbapr_baseid
ALTER TABLE mshop_order_base_product_attr DROP FOREIGN KEY fk_msordbaprat_ordprodid
ALTER TABLE mshop_order_base_service DROP FOREIGN KEY fk_msordbase_baseid
ALTER TABLE mshop_order_base_service_attr DROP FOREIGN KEY fk_msordbaseat_ordservid
ALTER TABLE mshop_order_status DROP FOREIGN KEY fk_msordst_pid
ALTER TABLE mshop_plugin DROP FOREIGN KEY fk_msplu_typeid
ALTER TABLE mshop_price DROP FOREIGN KEY fk_mspri_typeid
ALTER TABLE mshop_price_list DROP FOREIGN KEY fk_msprili_pid
ALTER TABLE mshop_price_list DROP FOREIGN KEY fk_msprili_typeid
ALTER TABLE mshop_product DROP FOREIGN KEY fk_mspro_typeid
ALTER TABLE mshop_product_list DROP FOREIGN KEY fk_msproli_pid
ALTER TABLE mshop_product_list DROP FOREIGN KEY fk_msproli_typeid
ALTER TABLE mshop_product_property DROP FOREIGN KEY fk_mspropr_pid
ALTER TABLE mshop_product_property DROP FOREIGN KEY fk_mspropr_typeid
ALTER TABLE mshop_service DROP FOREIGN KEY fk_msser_typeid
ALTER TABLE mshop_service_list DROP FOREIGN KEY fk_msserli_pid
ALTER TABLE mshop_service_list DROP FOREIGN KEY fk_msserli_typeid
ALTER TABLE mshop_stock DROP FOREIGN KEY fk_mssto_typeid
ALTER TABLE mshop_supplier_address DROP FOREIGN KEY fk_mssupad_pid
ALTER TABLE mshop_supplier_list DROP FOREIGN KEY fk_mssupli_pid
ALTER TABLE mshop_supplier_list DROP FOREIGN KEY fk_mssupli_typeid
ALTER TABLE mshop_tag DROP FOREIGN KEY fk_mstag_typeid
ALTER TABLE mshop_text DROP FOREIGN KEY fk_mstex_typeid
ALTER TABLE mshop_text_list DROP FOREIGN KEY fk_mstexli_pid
ALTER TABLE mshop_text_list DROP FOREIGN KEY fk_mstexli_typeid
ALTER TABLE fe_users_list DROP FOREIGN KEY fk_t3feuli_typeid
ALTER TABLE fe_users_property DROP FOREIGN KEY fk_t3feupr_typeid
ALTER TABLE madmin_cache_tag DROP FOREIGN KEY fk_macac_tid_tsid

Thanks in advance

User avatar
aimeos
Administrator
Posts: 7866
Joined: 01 Jan 1970, 00:00

Re: Typo3 Upgrade Wizard

Post by aimeos » 21 Apr 2019, 15:13

If you update to 19.4 it's correct because Aimeos uses type codes instead of type IDs in the latest version
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

tenkraD
Advanced
Posts: 110
Joined: 25 Jul 2017, 08:38

Re: Typo3 Upgrade Wizard

Post by tenkraD » 23 Apr 2019, 09:33

I cant update to version 19 cause i use aimeos_payments extension which only exist in 18.
I think im gona rebuild these tables from backup.

Thanks

Post Reply