No Typo3like Database definition

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!
mantik
Posts: 89
Joined: 23 Oct 2017, 05:56

No Typo3like Database definition

Post by mantik » 23 Oct 2017, 05:58

Hello guys
just one hint: in Typo3 you have to declare ALL tables in the SQL File (aimeos/ext_tables.sql). If you don't do that the Installtool will delete the whole tables on next DB-compare.

Here are some examples from my DB-Compare:
ALTER TABLE mshop_attribute RENAME zzz_deleted_mshop_attribute;
Records in table: 14
ALTER TABLE mshop_attribute_list RENAME zzz_deleted_mshop_attribute_list;
Records in table: 57
ALTER TABLE mshop_attribute_list_type RENAME zzz_deleted_mshop_attribute_list_type;
Records in table: 8

(First rename - next step will be delete)

Comparing is needed if someone adds a new field on some extensions or make a typo3-major update so i think it will be better to update this things.

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

Re: No Typo3like Database definition

Post by aimeos » 23 Oct 2017, 11:46

Aimeos database setup works differently because it supports not only TYPO3 and duplicating table definitions won't work with 3rd party extensions. We still try to convince the TYPO3 people so we can hide our own tables:
https://github.com/aimeos/aimeos-typo3/issues/7
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

Post Reply