Aimeos Upgrade Errors

yacms · Post by **yacms** » 23 Aug 2018, 11:13

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:

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

2) Opening Shop frontend:

Code: Select all

A non-recoverable error occured

3) Using update script from aimeos:

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...')

Any idea what ive done wrong?

Post by **aimeos** » 23 Aug 2018, 19:10

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

Code: Select all

SHOW ENGINE INNODB STATUS

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"?

yacms · Post by **yacms** » 24 Aug 2018, 10:11

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"

Code: Select all

InnoDB

=====================================
180824 12:1...

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)

yacms · Post by **yacms** » 27 Aug 2018, 10:33

- 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.

Post by **aimeos** » 28 Aug 2018, 10:45

Can you please post the output of those SQL statements?

Code: Select all

SHOW CREATE TABLE fe_users
SHOW CREATE TABLE fe_users_address

yacms · Post by **yacms** » 28 Aug 2018, 11:03

SHOW CREATE TABLE fe_users

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"

SHOW CREATE TABLE fe_users_address

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"

Post by **aimeos** » 29 Aug 2018, 20:53

The problem seems to be the difference in the column definition (int 10 and 11):

Code: Select all

`uid` int(11) unsigned NOT NULL AUTO_INCREMENT,

Code: Select all

`parentid` int(10) unsigned NOT NULL,

Not sure how it's possible to create an unsigned int(11) ...

Post by **aimeos** » 01 Sep 2018, 14:54

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

yacms · Post by **yacms** » 11 Sep 2018, 10:03

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

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...')

Update, after clearing the caches und update database structure the Update / Install script is throwing this error:

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...')

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

Code: Select all

No item found for conditions: Array ( [attribute.code] => custom [attribute.domain] => product [attribute.type.code] => price [attribute.type.domain] => product )

yacms · Post by **yacms** » 11 Sep 2018, 11:21

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.

Help for Aimeos

Aimeos Upgrade Errors

Aimeos Upgrade Errors

Re: Aimeos Upgrade Errors

Re: Aimeos Upgrade Errors

Re: Aimeos Upgrade Errors

Re: Aimeos Upgrade Errors

Re: Aimeos Upgrade Errors

Re: Aimeos Upgrade Errors

Re: Aimeos Upgrade Errors

Re: Aimeos Upgrade Errors

Re: Aimeos Upgrade Errors

Connect with your social network account