# Installation 4.2.1: MySQL hängt an NO\_AUTO\_VALUE\_ON\_ZERO

**URL:** <https://forum.shopware.com/t/installation-4-2-1-mysql-hangt-an-no-auto-value-on-zero/18645>\
**Category:** Shopware 3.5\
**Tags:** installation--gettin\
**Created:** [24. Februar 2014 um 13:35 UTC](https://forum.shopware.com/t/installation-4-2-1-mysql-hangt-an-no-auto-value-on-zero/18645 "2014-02-24T13:35:38Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![inco\_7](https://avatars.discourse-cdn.com/v4/letter/i/b9bd4f/32.png) [@inco\_7](https://forum.shopware.com/u/inco_7)\
**Post date:** [24. Februar 2014 um 13:35 UTC](https://forum.shopware.com/t/installation-4-2-1-mysql-hangt-an-no-auto-value-on-zero/18645/1 "2014-02-24T13:35:38Z")

</div>

Hallo, ich bekomme beim Versuch, die DB zu installieren folgende Fehlermeldung mit MySQL 5.6 [quote] {“code”:“42000”,“message”:“SQLSTATE[42000]: Syntax error or access violation: 1231 Variable ‘sql\_mode’ can’t be set to the value of ‘NO\_AUTO\_VALUE\_ON\_ZERO’”,“file”:"/media/sf\_htdocs/install/src/app.php",“line”:352,“trace”:" #0 /media/sf\_htdocs/install/src/app.php(352): PDO-\>query(‘SET SQL\_MODE="N…’)\n #1 [internal function]: {closure}()\n #2 /media/sf\_htdocs/engine/Library/Slim/Router.php(172): call\_user\_func\_array(Object(Closure), Array)\n #3 /media/sf\_htdocs/engine/Library/Slim/Slim.php(1225): Slim\Router-\>dispatch(Object(Slim\Route))\n #4 /media/sf\_htdocs/engine/Library/Slim/Middleware/Flash.php(86): Slim\Slim-\>call()\n #5 /media/sf\_htdocs/engine/Library/Slim/Middleware/MethodOverride.php(94): Slim\Middleware\Flash-\>call()\n #6 /media/sf\_htdocs/engine/Library/Slim/Middleware/PrettyExceptions.php(67): Slim\Middleware\MethodOverride-\>call()\n #7 /media/sf\_htdocs/engine/Library/Slim/Slim.php(1176): Slim\Middleware\PrettyExceptions-\>call()\n #8 /media/sf\_htdocs/install/index.php(59): Slim\Slim-\>run()\n #9 {main}" }[/quote] `sql\_mode=NO\_AUTO\_CREATE\_USER,NO\_ENGINE\_SUBSTITUTION,NO\_AUTO\_VALUE\_ON\_ZERO ` in my.cnf half nicht. Stehe auf dem Schlauch… Wer kann mir helfen?

---

<div class="post-metadata">

**Author:** ![inco\_7](https://avatars.discourse-cdn.com/v4/letter/i/b9bd4f/32.png) [@inco\_7](https://forum.shopware.com/u/inco_7)\
**Post date:** [24. Februar 2014 um 15:20 UTC](https://forum.shopware.com/t/installation-4-2-1-mysql-hangt-an-no-auto-value-on-zero/18645/2 "2014-02-24T15:20:53Z")

</div>

Neu an der Installationsroutine ist die Umwandlung von /install/php/Index.php zu /src/app.php in app.php kommt u.a. eine Variable $preSql hinzu, welche einige Server-Systemvariablen setzt (die in sw4\_clean.sql ohnehin gesetzt werden): [code]$preSql = \<\<