Aimeos Upgrade Errors
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!
Aimeos Upgrade Errors
Hi, ive tried to update Aimeos
TYPO3 CMS Version: 8.7.9
Start aimeos Version: 18.4.1
Target aimeos Version: 18.7.1
I habe updated the extension via extension Manager in TYPO3, deleted and added the TS Template, Cleared all Caches (OP, APC and normal TYPO3 caches via Install Tool) and getting various of SQL Errors now:
1) Opening the Aimeos Backend:
2) Opening Shop frontend:
3) Using update script from aimeos:
Any idea what ive done wrong?
TYPO3 CMS Version: 8.7.9
Start aimeos Version: 18.4.1
Target aimeos Version: 18.7.1
I habe updated the extension via extension Manager in TYPO3, deleted and added the TS Template, Cleared all Caches (OP, APC and normal TYPO3 caches via Install Tool) and getting various of SQL Errors now:
1) Opening the Aimeos Backend:
Code: Select all
Fehler SQLSTATE[42S22]: Column not found: 1054 Unknown column 'mordbase.currencyid' in 'field list', /var/www/vhosts/***/staging.***.com/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/lib/mwlib/src/MW/DB/Statement/PDO/Simple.php:98
Code: Select all
A non-recoverable error occured
Code: Select all
An exception occurred while executing 'ALTER TABLE fe_users_address ADD CONSTRAINT fk_t3feuad_pid FOREIGN KEY (parentid) REFERENCES fe_users (uid) ON UPDATE CASCADE ON DELETE CASCADE':
SQLSTATE[HY000]: General error: 1005 Can't create table 'staging-***.#sql-59e_1b36f' (errno: 150)
#0 /var/www/vhosts/***-***.com/staging.***-***.com/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/lib/mwlib/src/MW/Setup/Task/Base.php(127): Aimeos\MW\DB\Statement\DBAL\Simple->execute()
#1 /var/www/vhosts/***-***.com/staging.***-***.com/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/lib/mshoplib/setup/TablesCreateMShop.php(194): Aimeos\MW\Setup\Task\Base->executeList(Array, 'db-customer')
#2 /var/www/vhosts/***-***.com/staging.***-***.com/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/lib/mshoplib/setup/TablesCreateMShop.php(107): Aimeos\MW\Setup\Task\TablesCreateMShop->setupSchema(Array)
#3 /var/www/vhosts/***-***.com/staging.***-***.com/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/lib/mwlib/src/MW/Setup/Manager/Multiple.php(190): Aimeos\MW\Setup\Task\TablesCreateMShop->migrate()
#4 /var/www/vhosts/***-***.com/staging.***-***.com/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/lib/mwlib/src/MW/Setup/Manager/Multiple.php(186): Aimeos\MW\Setup\Manager\Multiple->migrateTasks(Array, Array)
#5 /var/www/vhosts/***-***.com/staging.***-***.com/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/lib/mwlib/src/MW/Setup/Manager/Multiple.php(112): Aimeos\MW\Setup\Manager\Multiple->migrateTasks(Array)
#6 /var/www/vhosts/***-***.com/staging.***-***.com/typo3conf/ext/aimeos/Classes/Setup.php(74): Aimeos\MW\Setup\Manager\Multiple->migrate()
#7 /var/www/vhosts/***-***.com/staging.***-***.com/typo3temp/var/transient/ext_update9db0a92204a53e69894c4bc712cd3591.php(47): Aimeos\Aimeos\Setup::execute()
#8 /var/www/vhosts/***-***.com/staging.***-***.com/typo3_src-8.7.9/typo3/sysext/extensionmanager/Classes/Utility/UpdateScriptUtility.php(39): ext_update9db0a92204a53e69894c4bc712cd3591->main()
#9 /var/www/vhosts/***-***.com/staging.***-***.com/typo3_src-8.7.9/typo3/sysext/extensionmanager/Classes/Controller/UpdateScriptController.php(53): TYPO3\CMS\Extensionmanager\Utility\UpdateScriptUtility->executeUpdateIfNeeded('aimeos')
#10 [internal function]: TYPO3\CMS\Extensionmanager\Controller\UpdateScriptController->showAction('aimeos')
#11 /var/www/vhosts/***-***.com/staging.***-***.com/typo3_src-8.7.9/typo3/sysext/extbase/Classes/Mvc/Controller/ActionController.php(316): call_user_func_array(Array, Array)
#12 /var/www/vhosts/***-***.com/staging.***-***.com/typo3_src-8.7.9/typo3/sysext/extbase/Classes/Mvc/Controller/ActionController.php(176): TYPO3\CMS\Extbase\Mvc\Controller\ActionController->callActionMethod()
#13 /var/www/vhosts/***-***.com/staging.***-***.com/typo3_src-8.7.9/typo3/sysext/extbase/Classes/Mvc/Dispatcher.php(85): TYPO3\CMS\Extbase\Mvc\Controller\ActionController->processRequest(Object(TYPO3\CMS\Extbase\Mvc\Web\Request), Object(TYPO3\CMS\Extbase\Mvc\Web\Response))
#14 /var/www/vhosts/***-***.com/staging.***-***.com/typo3_src-8.7.9/typo3/sysext/extbase/Classes/Mvc/Web/BackendRequestHandler.php(32): TYPO3\CMS\Extbase\Mvc\Dispatcher->dispatch(Object(TYPO3\CMS\Extbase\Mvc\Web\Request), Object(TYPO3\CMS\Extbase\Mvc\Web\Response))
#15 /var/www/vhosts/***-***.com/staging.***-***.com/typo3_src-8.7.9/typo3/sysext/extbase/Classes/Core/Bootstrap.php(199): TYPO3\CMS\Extbase\Mvc\Web\BackendRequestHandler->handleRequest()
#16 /var/www/vhosts/***-***.com/staging.***-***.com/typo3_src-8.7.9/typo3/sysext/extbase/Classes/Core/Bootstrap.php(186): TYPO3\CMS\Extbase\Core\Bootstrap->handleRequest()
#17 /var/www/vhosts/***-***.com/staging.***-***.com/typo3_src-8.7.9/typo3/sysext/backend/Classes/Http/BackendModuleRequestHandler.php(182): TYPO3\CMS\Extbase\Core\Bootstrap->run('', Array)
#18 /var/www/vhosts/***-***.com/staging.***-***.com/typo3_src-8.7.9/typo3/sysext/backend/Classes/Http/BackendModuleRequestHandler.php(89): TYPO3\CMS\Backend\Http\BackendModuleRequestHandler->dispatchModule('tools_Extension...')
#19 /var/www/vhosts/***-***.com/staging.***-***.com/typo3_src-8.7.9/typo3/sysext/core/Classes/Core/Bootstrap.php(315): TYPO3\CMS\Backend\Http\BackendModuleRequestHandler->handleRequest(Object(TYPO3\CMS\Core\Http\ServerRequest))
#20 /var/www/vhosts/***-***.com/staging.***-***.com/typo3_src-8.7.9/typo3/sysext/backend/Classes/Http/Application.php(92): TYPO3\CMS\Core\Core\Bootstrap->handleRequest(Object(TYPO3\CMS\Core\Http\ServerRequest))
#21 /var/www/vhosts/***-***.com/staging.***-***.com/typo3_src-8.7.9/typo3/sysext/backend/Resources/Private/Php/backend.php(24): TYPO3\CMS\Backend\Http\Application->run()
#22 /var/www/vhosts/***-***.com/staging.***-***.com/typo3_src-8.7.9/typo3/sysext/backend/Resources/Private/Php/backend.php(25): {closure}()
#23 /var/www/vhosts/***-***.com/staging.***-***.com/typo3_src-8.7.9/typo3/index.php(3): require('/var/www/vhosts...')
Re: Aimeos Upgrade Errors
First you should use the new 18.7.2 release because 18.7.1 will only work on platforms with PHP 7.1/7.2 installed. The problem was introduced by upgrading our build platform to PHP 7.2 and composer then upgrades all packages to the latest versions which don't work with PHP 5.6 any more.
The second problem is we renamed a signal/slot method name from "executeOnSignal" to "signal" only and learned that this is a really bad idea because TYPO3 caches the ext_tables.php. This leads now to an error message for everyone upgrading Aimeos until the deactivate and activate the Aimeos extension.
The third problem is we introduced a foreign key constraint between the fe_users and the depending fe_users_* tables. That's seems to make problems on some systems. Do you have access to the MySQL server and can execute
There may be something like "last foreign key error" which we would need. Can you please post the output of "SHOW CREATE TABLE fe_users"?
The second problem is we renamed a signal/slot method name from "executeOnSignal" to "signal" only and learned that this is a really bad idea because TYPO3 caches the ext_tables.php. This leads now to an error message for everyone upgrading Aimeos until the deactivate and activate the Aimeos extension.
The third problem is we introduced a foreign key constraint between the fe_users and the depending fe_users_* tables. That's seems to make problems on some systems. Do you have access to the MySQL server and can execute
Code: Select all
SHOW ENGINE INNODB STATUS
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: Aimeos Upgrade Errors
Hi, thanks for the fast reply.
I have now updated from 18.7.1 to 18.7.2, the PHP Version was already on 7.1.21, still getting the exact same errors.
Results from "SHOW ENGINE INNODB STATUS"
I am very confused why this query is that short..?
Generell Informations to my SQL Server:
Server: Localhost via UNIX socket
Server-Typ: MySQL
Server-Version: 5.5.61-0ubuntu0.14.04.1 - (Ubuntu)
Protokoll-Version: 10
Server-Zeichensatz: UTF-8 Unicode (utf8)
I have now updated from 18.7.1 to 18.7.2, the PHP Version was already on 7.1.21, still getting the exact same errors.
Results from "SHOW ENGINE INNODB STATUS"
Code: Select all
InnoDB
=====================================
180824 12:1...
Generell Informations to my SQL Server:
Server: Localhost via UNIX socket
Server-Typ: MySQL
Server-Version: 5.5.61-0ubuntu0.14.04.1 - (Ubuntu)
Protokoll-Version: 10
Server-Zeichensatz: UTF-8 Unicode (utf8)
Re: Aimeos Upgrade Errors
- Now updated TYPO3 CMS Version: 8.7.9 to 8.7.19 (No changes)
- Reinstalled Aimeos via EM (I did not delete the tables)
- Inspected tabled from error messages: "fe_users_address" which is empty.
Any idea to get this work? Just say a word if you need more informations.
- Reinstalled Aimeos via EM (I did not delete the tables)
- Inspected tabled from error messages: "fe_users_address" which is empty.
Any idea to get this work? Just say a word if you need more informations.
Re: Aimeos Upgrade Errors
Can you please post the output of those SQL statements?
Code: Select all
SHOW CREATE TABLE fe_users
SHOW CREATE TABLE fe_users_address
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: Aimeos Upgrade Errors
SHOW CREATE TABLE fe_users
SHOW CREATE TABLE fe_users_address
Code: Select all
Table,Create Table
fe_users,"CREATE TABLE `fe_users` (
`tx_extbase_type` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT '0',
`uid` int(11) unsigned NOT NULL AUTO_INCREMENT,
`pid` int(11) unsigned NOT NULL DEFAULT '0',
`tstamp` int(11) unsigned NOT NULL DEFAULT '0',
`username` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT '',
`password` varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT '',
`usergroup` tinytext CHARACTER SET latin1,
`disable` smallint(5) unsigned NOT NULL DEFAULT '0',
`starttime` int(11) unsigned NOT NULL DEFAULT '0',
`endtime` int(11) unsigned NOT NULL DEFAULT '0',
`name` varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT '',
`first_name` varchar(50) CHARACTER SET latin1 NOT NULL DEFAULT '',
`middle_name` varchar(50) CHARACTER SET latin1 NOT NULL DEFAULT '',
`last_name` varchar(50) CHARACTER SET latin1 NOT NULL DEFAULT '',
`address` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT '',
`telephone` varchar(30) CHARACTER SET latin1 NOT NULL DEFAULT '',
`fax` varchar(30) CHARACTER SET latin1 NOT NULL DEFAULT '',
`email` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT '',
`crdate` int(11) unsigned NOT NULL DEFAULT '0',
`cruser_id` int(11) unsigned NOT NULL DEFAULT '0',
`lockToDomain` varchar(50) CHARACTER SET latin1 NOT NULL DEFAULT '',
`deleted` smallint(5) unsigned NOT NULL DEFAULT '0',
`uc` blob,
`title` varchar(40) CHARACTER SET latin1 NOT NULL DEFAULT '',
`zip` varchar(20) CHARACTER SET latin1 NOT NULL DEFAULT '',
`city` varchar(50) CHARACTER SET latin1 NOT NULL DEFAULT '',
`country` varchar(40) CHARACTER SET latin1 NOT NULL DEFAULT '',
`www` varchar(80) CHARACTER SET latin1 NOT NULL DEFAULT '',
`company` varchar(80) CHARACTER SET latin1 NOT NULL DEFAULT '',
`image` tinytext CHARACTER SET latin1,
`TSconfig` text CHARACTER SET latin1,
`lastlogin` int(10) unsigned NOT NULL DEFAULT '0',
`is_online` int(10) unsigned NOT NULL DEFAULT '0',
`felogin_redirectPid` tinytext CHARACTER SET latin1,
`felogin_forgotHash` varchar(80) CHARACTER SET latin1 DEFAULT '',
`description` text CHARACTER SET latin1,
`siteid` int(11) DEFAULT NULL,
`static_info_country` varchar(3) CHARACTER SET latin1 NOT NULL DEFAULT '',
`zone` varchar(45) CHARACTER SET latin1 NOT NULL DEFAULT '',
`language` varchar(2) CHARACTER SET latin1 NOT NULL DEFAULT '',
`gender` int(10) unsigned NOT NULL DEFAULT '99',
`date_of_birth` int(11) NOT NULL DEFAULT '0',
`vatid` varchar(32) CHARACTER SET latin1 NOT NULL DEFAULT '',
`longitude` decimal(8,6) DEFAULT NULL,
`latitude` decimal(8,6) DEFAULT NULL,
`vdate` date DEFAULT NULL,
PRIMARY KEY (`uid`),
KEY `parent` (`pid`,`username`),
KEY `username` (`username`),
KEY `is_online` (`is_online`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8"
Code: Select all
Table,Create Table
fe_users_address,"CREATE TABLE `fe_users_address` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`siteid` int(11) DEFAULT NULL,
`parentid` int(10) unsigned NOT NULL,
`company` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`vatid` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`salutation` varchar(8) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`title` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`firstname` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`lastname` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`address1` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`address2` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`address3` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`postal` varchar(16) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`city` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`state` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`langid` varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`countryid` char(2) DEFAULT NULL,
`telephone` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`email` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`telefax` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`website` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`longitude` decimal(8,6) DEFAULT NULL,
`latitude` decimal(8,6) DEFAULT NULL,
`flag` int(11) NOT NULL,
`pos` smallint(6) NOT NULL,
`mtime` datetime NOT NULL,
`ctime` datetime NOT NULL,
`editor` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `idx_t3feuad_pid` (`parentid`),
KEY `idx_t3feuad_last_first` (`lastname`,`firstname`),
KEY `idx_t3feuad_post_addr1` (`postal`,`address1`),
KEY `idx_t3feuad_post_city` (`postal`,`city`),
KEY `idx_t3feuad_address1` (`address1`),
KEY `idx_t3feuad_city` (`city`),
KEY `idx_t3feuad_email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8"
Re: Aimeos Upgrade Errors
The problem seems to be the difference in the column definition (int 10 and 11):
Not sure how it's possible to create an unsigned int(11) ...
Code: Select all
`uid` int(11) unsigned NOT NULL AUTO_INCREMENT,
Code: Select all
`parentid` int(10) unsigned NOT NULL,
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: Aimeos Upgrade Errors
We removed the foreign key constraints to fe_users table again because there are column differences in many TYPO3 installations. Can you install this pre-release?
https://aimeos.org/fileadmin/download/a ... 3-pre1.zip
https://aimeos.org/fileadmin/download/a ... 3-pre1.zip
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: Aimeos Upgrade Errors
Hi aimeos,
thanks for the pre-patch. Works way better at this point.
Backend working fine, installation worked fine but the update script is still ending in SQL Errors
Update, after clearing the caches und update database structure the Update / Install script is throwing this error:
Update 2
Saving products isnt possible since i cant run the install script like mentioned here:
laravel-package-f18/error-no-item-found ... t1110.html
thanks for the pre-patch. Works way better at this point.
Backend working fine, installation worked fine but the update script is still ending in SQL Errors
Code: Select all
An exception occurred while executing 'ALTER TABLE mshop_catalog_list ADD CONSTRAINT fk_mscatli_pid FOREIGN KEY (parentid) REFERENCES mshop_catalog (id) ON UPDATE CASCADE ON DELETE CASCADE':
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails ("staging-***"."#sql-59e_73762", CONSTRAINT "fk_mscatli_pid" FOREIGN KEY ("parentid") REFERENCES "mshop_catalog" ("id") ON DELETE CASCADE ON UPDATE CASCADE)
#0 /var/www/vhosts/***.com/staging.***.com/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/lib/mwlib/src/MW/Setup/Task/Base.php(127): Aimeos\MW\DB\Statement\DBAL\Simple->execute()
#1 /var/www/vhosts/***.com/staging.***.com/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/lib/mshoplib/setup/TablesCreateMShop.php(194): Aimeos\MW\Setup\Task\Base->executeList(Array, 'db-catalog')
#2 /var/www/vhosts/***.com/staging.***.com/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/lib/mshoplib/setup/TablesCreateMShop.php(107): Aimeos\MW\Setup\Task\TablesCreateMShop->setupSchema(Array)
#3 /var/www/vhosts/***.com/staging.***.com/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/lib/mwlib/src/MW/Setup/Manager/Multiple.php(190): Aimeos\MW\Setup\Task\TablesCreateMShop->migrate()
#4 /var/www/vhosts/***.com/staging.***.com/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/lib/mwlib/src/MW/Setup/Manager/Multiple.php(186): Aimeos\MW\Setup\Manager\Multiple->migrateTasks(Array, Array)
#5 /var/www/vhosts/***.com/staging.***.com/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/lib/mwlib/src/MW/Setup/Manager/Multiple.php(112): Aimeos\MW\Setup\Manager\Multiple->migrateTasks(Array)
#6 /var/www/vhosts/***.com/staging.***.com/typo3conf/ext/aimeos/Classes/Setup.php(74): Aimeos\MW\Setup\Manager\Multiple->migrate()
#7 /var/www/vhosts/***.com/staging.***.com/typo3temp/var/transient/ext_update9db0a92204a53e69894c4bc712cd3591.php(47): Aimeos\Aimeos\Setup::execute()
#8 /var/www/vhosts/***.com/staging.***.com/typo3_src-8.7.19/typo3/sysext/extensionmanager/Classes/Utility/UpdateScriptUtility.php(39): ext_update9db0a92204a53e69894c4bc712cd3591->main()
#9 /var/www/vhosts/***.com/staging.***.com/typo3_src-8.7.19/typo3/sysext/extensionmanager/Classes/Controller/UpdateScriptController.php(53): TYPO3\CMS\Extensionmanager\Utility\UpdateScriptUtility->executeUpdateIfNeeded('aimeos')
#10 [internal function]: TYPO3\CMS\Extensionmanager\Controller\UpdateScriptController->showAction('aimeos')
#11 /var/www/vhosts/***.com/staging.***.com/typo3_src-8.7.19/typo3/sysext/extbase/Classes/Mvc/Controller/ActionController.php(316): call_user_func_array(Array, Array)
#12 /var/www/vhosts/***.com/staging.***.com/typo3_src-8.7.19/typo3/sysext/extbase/Classes/Mvc/Controller/ActionController.php(176): TYPO3\CMS\Extbase\Mvc\Controller\ActionController->callActionMethod()
#13 /var/www/vhosts/***.com/staging.***.com/typo3_src-8.7.19/typo3/sysext/extbase/Classes/Mvc/Dispatcher.php(85): TYPO3\CMS\Extbase\Mvc\Controller\ActionController->processRequest(Object(TYPO3\CMS\Extbase\Mvc\Web\Request), Object(TYPO3\CMS\Extbase\Mvc\Web\Response))
#14 /var/www/vhosts/***.com/staging.***.com/typo3_src-8.7.19/typo3/sysext/extbase/Classes/Mvc/Web/BackendRequestHandler.php(32): TYPO3\CMS\Extbase\Mvc\Dispatcher->dispatch(Object(TYPO3\CMS\Extbase\Mvc\Web\Request), Object(TYPO3\CMS\Extbase\Mvc\Web\Response))
#15 /var/www/vhosts/***.com/staging.***.com/typo3_src-8.7.19/typo3/sysext/extbase/Classes/Core/Bootstrap.php(199): TYPO3\CMS\Extbase\Mvc\Web\BackendRequestHandler->handleRequest()
#16 /var/www/vhosts/***.com/staging.***.com/typo3_src-8.7.19/typo3/sysext/extbase/Classes/Core/Bootstrap.php(186): TYPO3\CMS\Extbase\Core\Bootstrap->handleRequest()
#17 /var/www/vhosts/***.com/staging.***.com/typo3_src-8.7.19/typo3/sysext/backend/Classes/Http/BackendModuleRequestHandler.php(182): TYPO3\CMS\Extbase\Core\Bootstrap->run('', Array)
#18 /var/www/vhosts/***.com/staging.***.com/typo3_src-8.7.19/typo3/sysext/backend/Classes/Http/BackendModuleRequestHandler.php(89): TYPO3\CMS\Backend\Http\BackendModuleRequestHandler->dispatchModule('tools_Extension...')
#19 /var/www/vhosts/***.com/staging.***.com/typo3_src-8.7.19/typo3/sysext/core/Classes/Core/Bootstrap.php(316): TYPO3\CMS\Backend\Http\BackendModuleRequestHandler->handleRequest(Object(TYPO3\CMS\Core\Http\ServerRequest))
#20 /var/www/vhosts/***.com/staging.***.com/typo3_src-8.7.19/typo3/sysext/backend/Classes/Http/Application.php(92): TYPO3\CMS\Core\Core\Bootstrap->handleRequest(Object(TYPO3\CMS\Core\Http\ServerRequest))
#21 /var/www/vhosts/***.com/staging.***.com/typo3_src-8.7.19/typo3/sysext/backend/Resources/Private/Php/backend.php(24): TYPO3\CMS\Backend\Http\Application->run()
#22 /var/www/vhosts/***.com/staging.***.com/typo3_src-8.7.19/typo3/sysext/backend/Resources/Private/Php/backend.php(25): {closure}()
#23 /var/www/vhosts/***.com/staging.***.com/typo3_src-8.7.19/typo3/index.php(3): require('/var/www/vhosts...')
Code: Select all
Processing product demo data removed
Processing catalog demo data removed
Processing service demo data removed
Processing customer demo data
An exception occurred while executing '
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."username" LIKE 'demo-%' ESCAPE '#' )
AND t3feu."deleted" = 0
GROUP BY t3feu."uid", t3feu."siteid", t3feu."name", t3feu."gender",
t3feu."username", t3feu."title", t3feu."company", t3feu."vatid",
t3feu."first_name", t3feu."last_name", t3feu."address", t3feu."zip",
t3feu."city", t3feu."zone", tsc."cn_iso_2", t3feu."language",
t3feu."telephone", t3feu."email", t3feu."fax", t3feu."www",
t3feu."longitude", t3feu."latitude", t3feu."password", t3feu."date_of_birth",
t3feu."usergroup", t3feu."pid", t3feu."disable", t3feu."crdate", t3feu."tstamp"
LIMIT 100 OFFSET 0
':
SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='
#0 /var/www/vhosts/***.com/staging.***.com/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/lib/mshoplib/src/MShop/Common/Manager/Base.php(882): Aimeos\MW\DB\Statement\DBAL\Simple->execute()
#1 /var/www/vhosts/***.com/staging.***.com/typo3conf/ext/aimeos/Resources/Private/Extensions/ai-typo3/lib/custom/src/MShop/Customer/Manager/Typo3.php(545): Aimeos\MShop\Common\Manager\Base->searchItemsBase(Object(Aimeos\MW\DB\Connection\DBAL), Object(Aimeos\MW\Criteria\SQL), 'mshop/customer/...', 'mshop/customer/...', Array, NULL, 3, Array)
#2 /var/www/vhosts/***.com/staging.***.com/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/lib/mshoplib/setup/default/DemoAddCustomerData.php(61): Aimeos\MShop\Customer\Manager\Typo3->searchItems(Object(Aimeos\MW\Criteria\SQL))
#3 /var/www/vhosts/***.com/staging.***.com/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/lib/mwlib/src/MW/Setup/Manager/Multiple.php(190): Aimeos\MW\Setup\Task\DemoAddCustomerData->migrate()
#4 /var/www/vhosts/***.com/staging.***.com/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/lib/mwlib/src/MW/Setup/Manager/Multiple.php(112): Aimeos\MW\Setup\Manager\Multiple->migrateTasks(Array)
#5 /var/www/vhosts/***.com/staging.***.com/typo3conf/ext/aimeos/Classes/Setup.php(74): Aimeos\MW\Setup\Manager\Multiple->migrate()
#6 /var/www/vhosts/***.com/staging.***.com/typo3temp/var/transient/ext_update9db0a92204a53e69894c4bc712cd3591.php(47): Aimeos\Aimeos\Setup::execute()
#7 /var/www/vhosts/***.com/staging.***.com/typo3_src-8.7.19/typo3/sysext/extensionmanager/Classes/Utility/UpdateScriptUtility.php(39): ext_update9db0a92204a53e69894c4bc712cd3591->main()
#8 /var/www/vhosts/***.com/staging.***.com/typo3_src-8.7.19/typo3/sysext/extensionmanager/Classes/Controller/UpdateScriptController.php(53): TYPO3\CMS\Extensionmanager\Utility\UpdateScriptUtility->executeUpdateIfNeeded('aimeos')
#9 [internal function]: TYPO3\CMS\Extensionmanager\Controller\UpdateScriptController->showAction('aimeos')
#10 /var/www/vhosts/***.com/staging.***.com/typo3_src-8.7.19/typo3/sysext/extbase/Classes/Mvc/Controller/ActionController.php(316): call_user_func_array(Array, Array)
#11 /var/www/vhosts/***.com/staging.***.com/typo3_src-8.7.19/typo3/sysext/extbase/Classes/Mvc/Controller/ActionController.php(176): TYPO3\CMS\Extbase\Mvc\Controller\ActionController->callActionMethod()
#12 /var/www/vhosts/***.com/staging.***.com/typo3_src-8.7.19/typo3/sysext/extbase/Classes/Mvc/Dispatcher.php(85): TYPO3\CMS\Extbase\Mvc\Controller\ActionController->processRequest(Object(TYPO3\CMS\Extbase\Mvc\Web\Request), Object(TYPO3\CMS\Extbase\Mvc\Web\Response))
#13 /var/www/vhosts/***.com/staging.***.com/typo3_src-8.7.19/typo3/sysext/extbase/Classes/Mvc/Web/BackendRequestHandler.php(32): TYPO3\CMS\Extbase\Mvc\Dispatcher->dispatch(Object(TYPO3\CMS\Extbase\Mvc\Web\Request), Object(TYPO3\CMS\Extbase\Mvc\Web\Response))
#14 /var/www/vhosts/***.com/staging.***.com/typo3_src-8.7.19/typo3/sysext/extbase/Classes/Core/Bootstrap.php(199): TYPO3\CMS\Extbase\Mvc\Web\BackendRequestHandler->handleRequest()
#15 /var/www/vhosts/***.com/staging.***.com/typo3_src-8.7.19/typo3/sysext/extbase/Classes/Core/Bootstrap.php(186): TYPO3\CMS\Extbase\Core\Bootstrap->handleRequest()
#16 /var/www/vhosts/***.com/staging.***.com/typo3_src-8.7.19/typo3/sysext/backend/Classes/Http/BackendModuleRequestHandler.php(182): TYPO3\CMS\Extbase\Core\Bootstrap->run('', Array)
#17 /var/www/vhosts/***.com/staging.***.com/typo3_src-8.7.19/typo3/sysext/backend/Classes/Http/BackendModuleRequestHandler.php(89): TYPO3\CMS\Backend\Http\BackendModuleRequestHandler->dispatchModule('tools_Extension...')
#18 /var/www/vhosts/***.com/staging.***.com/typo3_src-8.7.19/typo3/sysext/core/Classes/Core/Bootstrap.php(316): TYPO3\CMS\Backend\Http\BackendModuleRequestHandler->handleRequest(Object(TYPO3\CMS\Core\Http\ServerRequest))
#19 /var/www/vhosts/***.com/staging.***.com/typo3_src-8.7.19/typo3/sysext/backend/Classes/Http/Application.php(92): TYPO3\CMS\Core\Core\Bootstrap->handleRequest(Object(TYPO3\CMS\Core\Http\ServerRequest))
#20 /var/www/vhosts/***.com/staging.***.com/typo3_src-8.7.19/typo3/sysext/backend/Resources/Private/Php/backend.php(24): TYPO3\CMS\Backend\Http\Application->run()
#21 /var/www/vhosts/***.com/staging.***.com/typo3_src-8.7.19/typo3/sysext/backend/Resources/Private/Php/backend.php(25): {closure}()
#22 /var/www/vhosts/***.com/staging.***.com/typo3_src-8.7.19/typo3/index.php(3): require('/var/www/vhosts...')
Saving products isnt possible since i cant run the install script like mentioned here:
laravel-package-f18/error-no-item-found ... t1110.html
Code: Select all
No item found for conditions: Array ( [attribute.code] => custom [attribute.domain] => product [attribute.type.code] => price [attribute.type.domain] => product )
Re: Aimeos Upgrade Errors
Update #3
Changing "static_countries" table to unicode_general_ci solved the problem.
Thank you very much for your help aimeos! When this project is done i will submit an donation.
Changing "static_countries" table to unicode_general_ci solved the problem.
Thank you very much for your help aimeos! When this project is done i will submit an donation.