Problem after fresh installation on typo3 9.5.3

red-seadog · Post by **red-seadog** » 19 Jan 2019, 20:34

Hi,

I tried to install an aimeos version but none of the versions I tried seem to work. I tried aimeos 18.10.2 / .3 / .4 but none of these run properly. I installed these in a fresh installation of typo3 9.5.3.
After installing I get the following error when I start the aimeos admin:

Oops, an error occurred!
No item found for conditions: Array ( [locale.site.code] => default )

I noticed that the update script does not run correctly. It stops with the following message:
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes
#0 /var/www/orange/aimeos/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/lib/mwlib/src/MW/Setup/Task/Base.php(153): Aimeos\MW\DB\Statement\DBAL\Simple->execute()
#1 /var/www/orange/aimeos/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/lib/mshoplib/setup/TablesCreateMShop.php(197): Aimeos\MW\Setup\Task\Base->executeList(Array, 'db-attribute')
.....
.....
....

Do I need to configure something extra? Did I miss something?
Can you help?
Kind regards,
erwin

Post by **aimeos** » 21 Jan 2019, 09:26

Your MySQL database version doesn't support long indexes required for utf8mb4 which is used by default in TYPO3 v9. Please change your database connection settings in your ./typo3conf/LocalConfiguration.php to:

Code: Select all

'DB' => [
	'Connections' => [
			'tableoptions' => [
				'charset' => 'utf8',
				'collate' => 'utf8_bin',
			],
		],
	],
],

red-seadog · Post by **red-seadog** » 21 Jan 2019, 18:12

Ok, did so. This does not change anything. Still an error message when starting the adminconsole:

Oops, an error occurred!
No item found for conditions: Array ( [locale.site.code] => default )

And no console shows up.

Any other ideas are much appreciated.
Regards,
erwin

Post by **aimeos** » 22 Jan 2019, 13:09

You have to remove the Aimeos tables and run the setup again so they will be created with the new table options configured.

red-seadog · Post by **red-seadog** » 22 Jan 2019, 13:55

Ok, done that. Installation now totally crashed and typo3 refuses to run at all. We will make a new installation and try again. Will keep you updated.
Kind regards,
erwin

ThomasD · Post by **ThomasD** » 28 Jan 2019, 12:30

I had the same problem some time ago.
In typo3 you have to change the LocalConfiguration.php to

Code: Select all

 'DB' => [
        'Connections' => [
            'Default' => [
                'charset' => 'utf8',
                'dbname' => 'YOUR_DATABASENAME',
                'driver' => 'mysqli',
                'host' => 'YOUR_HOST',
                'password' => 'YOUR_PASSWORD',
                'port' => 3306,
                'tableoptions' => [
                    'charset' => 'utf8 ',
                    'collate' => 'utf8_unicode_ci',
                ],
                'user' => 'YOUR_DB_USERNAME',
            ],
        ],
    ],

After that you can run the setup from the extension section in the backend.

Additionally you can alter the databse with some short sql lines.
After that, for me everything works fine.

red-seadog · Post by **red-seadog** » 30 Jan 2019, 15:42

Hi ThomasD,

thank you for this information. I applied these changes and it works now!
Thank you very much.
Kind regards,
erwin

Help for Aimeos

Problem after fresh installation on typo3 9.5.3

Problem after fresh installation on typo3 9.5.3

Re: Problem after fresh installation on typo3 9.5.3

Re: Problem after fresh installation on typo3 9.5.3

Re: Problem after fresh installation on typo3 9.5.3

Re: Problem after fresh installation on typo3 9.5.3

Re: Problem after fresh installation on typo3 9.5.3

Re: Problem after fresh installation on typo3 9.5.3

Connect with your social network account