Installation error of TYPO3 9.5 and aimeos 20.7 (composer)
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!
Always add your TYPO3, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Installation error of TYPO3 9.5 and aimeos 20.7 (composer)
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):
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...)
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 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...)
Re: Installation error of TYPO3 9.5 and aimeos 20.7 (composer)
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?
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, give us a star
If you like Aimeos, give us a star
Re: Installation error of TYPO3 9.5 and aimeos 20.7 (composer)
Thank you!
After that I could overwrite and remove the demo products.
After that I could overwrite and remove the demo products.