Page 1 of 1

Installation and upgrade fails

Posted: 19 Feb 2016, 20:17
by goerch
I have a problem installing the new Version 16.1.2. On my local system the upgrade fails from 2.4.3, testing on a new typo3 - installation (not local) the installation 16.1.2 fails. The database update - script stopped with an error "failed: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_german1_ci,IMPLICIT) for operation '='" and following a list of items and scripts from #0 to #21
like #0 "/mnt/webf/d2/64/5287964/htdocs/xxx/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/lib/mshoplib/src/MShop/Common/Manager/Base.php(914): Aimeos\MW\DB\Statement\PDO\Simple->execute()"

Testing system: T3 6.2.15, PHP 5.5.32, MySQL 5.5.45

What can i do? The idea was to upgrade from 2.4.3, because i need a tax feature (prices without tax) for a b2b shop.

Re: Installation and upgrade fails

Posted: 20 Feb 2016, 00:30
by aimeos
Can you please check the collation of your fe_users and the static info tables? These are the only ones that Aimeos is joining in certain queries. I guess the collation is different from the Aimeos mshop/madmin tables (utf8_general_ci).

Re: Installation and upgrade fails

Posted: 22 Feb 2016, 10:58
by goerch
Thank you, it seems to be the problem. Changing the collation to utf8_general_ci in the table "fe_user" AND the fields in "fe_user" solve the problem in one test installation. On local installation i can't see the backend. This could maybe a caching problem, the update script goes well, but the backend module shows only a blank page. I am looking for a solution and then i will report.

Re: Installation and upgrade fails

Posted: 22 Feb 2016, 11:18
by aimeos
goerch wrote:On local installation i can't see the backend. This could maybe a caching problem, the update script goes well, but the backend module shows only a blank page. I am looking for a solution and then i will report.
Can you please have a look into the error log of your web server if there's something wrong?
You should also check in the web console of your browser if there's any Javascript error.

Re: Installation and upgrade fails

Posted: 24 Feb 2016, 11:04
by goerch
So, the local installation: Installation is ok, but starting aimeos backend displays the following error: "Parse error: syntax error, unexpected 'class' (T_CLASS), expecting identifier (T_STRING) or variable (T_VARIABLE) or '{' or '$' in xxx\typo3conf\ext\aimeos\Resources\Libraries\zendframework\zend-servicemanager\src\ServiceManager.php on line 281"

Local system: T3 6.2.9, XAMPP on Windows, PHP 5.4.27, MySQL 5.5.36

Re: Installation and upgrade fails

Posted: 24 Feb 2016, 13:58
by aimeos
Unfortunately, the used Zend component pushed the required PHP version up to 5.5. We already replaced Zend in the latest code base with a low resource implementation which only requires PHP 5.4. You can give it a try by downloading it from this URL:
https://aimeos.org/fileadmin/download/a ... 2.0-b1.zip

Re: Installation and upgrade fails

Posted: 24 Feb 2016, 14:19
by goerch
Thank you i will try it.

But the next error is installing Version 2.4.3: Update-Script breaks with
"Executing statement "CREATE INDEX "idx_t3feuad_refid" ON "fe_users_address" ("refid");
" failed: SQLSTATE[42000]: Syntax error or access violation: 1072 Key column 'refid' doesn't exist in table".

T3 6.2.9

Re: Installation and upgrade fails

Posted: 24 Feb 2016, 14:36
by goerch
First report: Version 6.2.0 b works fine for me. No problems with installation. This solves also the problem with the update script.