Installation error of TYPO3 9.5 and aimeos 20.7 (composer)

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!
rowild

Installation error of TYPO3 9.5 and aimeos 20.7 (composer)

Post by rowild » 01 Sep 2020, 08:08

I installed a TYPO3 9.5 (php 7.2) with aimeos 20.7 on a shared hosting (all-inkl) via composer. TYPO3 works fine, but the table creation of aimeos fails, because it cannot find a table called "t3feu.gender" (during demo data installation, as it seems):

Code: Select all

Adding default code data for site "default"                           
  Checking "customer/group" codes                                     OK
Processing customer demo data                                         
SQLSTATE[42S22]: Column not found: 1054 Unknown column 't3feu.gender' in 'field list': 
					SELECT 
						t3feu."uid" AS "customer.id", t3feu."siteid" AS "customer.siteid",
						t3feu."name" AS "customer.label", t3feu."gender",
						t3feu."username" AS "customer.code", t3feu."title" AS "customer.title",
						t3feu."company" AS "customer.company", t3feu."vatid" AS "customer.vatid",
						t3feu."first_name" AS "customer.firstname", t3feu."last_name" AS "customer.lastname",
						t3feu."address" AS "customer.address1", t3feu."zip" AS "customer.postal",
						t3feu."city" AS "customer.city", t3feu."zone" AS "customer.state",
						tsc."cn_iso_2" AS "customer.countryid", t3feu."language" AS "customer.languageid",
						t3feu."telephone" AS "customer.telephone", t3feu."email" AS "customer.email",
						t3feu."fax" AS "customer.telefax", t3feu."www" AS "customer.website",
						t3feu."longitude" AS "customer.longitude", t3feu."latitude" AS "customer.latitude",
						t3feu."password" AS "customer.password", t3feu."date_of_birth",
						t3feu."usergroup" as "groups", t3feu."pid" AS "typo3.pageid",
						t3feu."disable", t3feu."crdate", t3feu."tstamp"
					FROM "fe_users" as t3feu
					LEFT JOIN "static_countries" AS tsc ON t3feu."static_info_country" = tsc."cn_iso_3"
					
					WHERE ( ( t3feu."siteid" = '1.' OR t3feu."siteid" = '' ) AND t3feu."username" = 'demo@example.com' ) AND t3feu."deleted" = 0
					GROUP BY t3feu."uid",  t3feu."uid", tsc."cn_iso_2"
					ORDER BY t3feu."uid" ASC
					LIMIT 100 OFFSET 0
				
#0 /[path-to-folder]/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Common/Manager/Base.php(553): Aimeos\MW\DB\Statement\DBAL\Simple->execute()
I added the required post.installation scripts to the composer.json.
I also updated static-info-tables (which reports that no new tables were created).
The error repeats (ext config is set to "Updates demo data" => "Overwrite").

Am I doing something wrong or is this a bug?
(I think, in "fe_users_address" the field "gender" was renamed to "salutation"? At least I cannot find a table "gender" there...)

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

Re: Installation error of TYPO3 9.5 and aimeos 20.7 (composer)

Post by aimeos » 01 Sep 2020, 20:34

The "gender" column is defined in the ext_tables.sql of the Aimeos extension and it seems it wasn't added automatically.
Can you please deactive and activate the Aimeos extension in den extension manager again?
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

rowild

Re: Installation error of TYPO3 9.5 and aimeos 20.7 (composer)

Post by rowild » 02 Sep 2020, 10:15

Thank you!
After that I could overwrite and remove the demo products.

Post Reply