Versuche Shopware 5.6 zu installieren. Erstinstallation auf leerem Webspace. Egal ob mit dem Installer oder per Zip & FTP, mitten im Anlegen der Tabellen geht er auf die Nase.
Hat jemand eine Idee was da wirklich der Fehler sein könnte?
THX vorab, Otmar
//================================================================
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 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‘“}
//================================================================