# Fehlermeldung bei Installation auf 1und1

**URL:** <https://forum.shopware.com/t/fehlermeldung-bei-installation-auf-1und1/61882>\
**Category:** Installation/Einstieg\
**Created:** [20. September 2019 um 08:16 UTC](https://forum.shopware.com/t/fehlermeldung-bei-installation-auf-1und1/61882 "2019-09-20T08:16:50Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Made\_by\_AmB](https://avatars.discourse-cdn.com/v4/letter/m/3ec8ea/32.png) [@Made\_by\_AmB](https://forum.shopware.com/u/Made_by_AmB)\
**Post date:** [20. September 2019 um 08:16 UTC](https://forum.shopware.com/t/fehlermeldung-bei-installation-auf-1und1/61882/1 "2019-09-20T08:16:50Z")

</div>

Hallo,

bin neu hier und bekomme bei der Installation folgende Fehlermeldung. 1und1 kann mir nicht weiter helfen, jemand hier vielleicht eine Idee?

&nbsp;

Error

Received the following error message:  
SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for ‘password\_change\_date’

Please try to fix this error and restart the update.

Response

```
 {"query":"CREATE TABLE `s_user` (\n `id` int(11) NOT NULL AUTO\_INCREMENT,\n `password` varchar(1024) COLLATE utf8\_unicode\_ci NOT NULL,\n `encoder` varchar(255) COLLATE utf8\_unicode\_ci NOT NULL DEFAULT 'md5',\n `email` varchar(70) COLLATE utf8\_unicode\_ci NOT NULL,\n `active` int(1) NOT NULL DEFAULT '0',\n `accountmode` int(11) NOT NULL,\n `confirmationkey` varchar(100) COLLATE utf8\_unicode\_ci NOT NULL,\n `paymentID` int(11) NOT NULL DEFAULT '0',\n `doubleOptinRegister` tinyint(1) DEFAULT '0',\n `doubleOptinEmailSentDate` datetime DEFAULT NULL,\n `doubleOptinConfirmDate` datetime DEFAULT NULL,\n `firstlogin` date NOT NULL DEFAULT '0000-00-00',\n `lastlogin` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\n `sessionID` varchar(128) COLLATE utf8\_unicode\_ci DEFAULT NULL,\n `newsletter` int(1) NOT NULL DEFAULT '0',\n `validation` varchar(255) COLLATE utf8\_unicode\_ci NOT NULL DEFAULT '0',\n `affiliate` int(10) NOT NULL DEFAULT '0',\n `customergroup` varchar(15) COLLATE utf8\_unicode\_ci NOT NULL,\n `paymentpreset` int(11) NOT NULL,\n `language` varchar(10) COLLATE utf8\_unicode\_ci NOT NULL,\n `subshopID` int(11) NOT NULL,\n `referer` varchar(255) COLLATE utf8\_unicode\_ci NOT NULL,\n `pricegroupID` int(11) unsigned DEFAULT NULL,\n `internalcomment` mediumtext COLLATE utf8\_unicode\_ci NOT NULL,\n `failedlogins` int(11) NOT NULL,\n `lockeduntil` datetime DEFAULT NULL,\n `default_billing_address_id` int(11) DEFAULT NULL,\n `default_shipping_address_id` int(11) DEFAULT NULL,\n `title` varchar(100) COLLATE utf8\_unicode\_ci DEFAULT NULL,\n `salutation` varchar(30) COLLATE utf8\_unicode\_ci DEFAULT NULL,\n `firstname` varchar(255) COLLATE utf8\_unicode\_ci DEFAULT NULL,\n `lastname` varchar(255) COLLATE utf8\_unicode\_ci DEFAULT NULL,\n `birthday` date DEFAULT NULL,\n `customernumber` varchar(30) COLLATE utf8\_unicode\_ci DEFAULT NULL,\n `login_token` varchar(250) COLLATE utf8\_unicode\_ci DEFAULT NULL,\n `changed` datetime DEFAULT NULL,\n `password_change_date` datetime NOT NULL DEFAULT CURRENT\_TIMESTAMP,\n `register_opt_in_id` int(11) DEFAULT NULL,\n PRIMARY KEY (`id`),\n KEY `email` (`email`),\n KEY `sessionID` (`sessionID`),\n KEY `firstlogin` (`firstlogin`),\n KEY `lastlogin` (`lastlogin`),\n KEY `pricegroupID` (`pricegroupID`),\n KEY `customergroup` (`customergroup`),\n KEY `validation` (`validation`),\n KEY `default_billing_address_id` (`default_billing_address_id`),\n KEY `default_shipping_address_id` (`default_shipping_address_id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8\_unicode\_ci","success":false,"offset":2300,"errorMsg":"SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'password\_change\_date'"}
```

---

<div class="post-metadata">

**Author:** ![msslovi0](https://avatars.discourse-cdn.com/v4/letter/m/b2d939/32.png) [@msslovi0](https://forum.shopware.com/u/msslovi0)\
**Post date:** [20. September 2019 um 09:14 UTC](https://forum.shopware.com/t/fehlermeldung-bei-installation-auf-1und1/61882/2 "2019-09-20T09:14:47Z")

</div>

> **CURRENT\_TIMESTAMP** &nbsp;is only acceptable on TIMESTAMP fields. DATETIME fields must be left either with a null&nbsp; **default value** , or no&nbsp; **default value** &nbsp;at all -&nbsp; **default values** &nbsp;must be a constant&nbsp; **value** , not the result of an expression.

Sieht nach nem Bug im Installer aus, da hilft nur manuelles bearbeiten der entsprechenden Datei und eröffnen eines Tickets, damit das gefixt wird.

Gruß

Matt
