Installation Error: MySQL-Error 1292

[koyner]

At the end of installation, I get the following error:

Setup Results
An error occured during installation. Please take a look at the file setuplog.txt (located in "contenido/logs/") for more information.

The log file reads:

Setup was unable to execute SQL. MySQL-Error: 1292, MySQL-Message: Incorrect date value: '' for column 'valid_from' at row 1, SQL-Statements:
INSERT INTO con_phplib_auth_user_md5 VALUES('48a365b4ce1e322a55ae9017f3daf0c0', 'sysadmin', '48a365b4ce1e322a55ae9017f3daf0c0', 'sysadmin', 'Systemadministrator', 'sysadmin@IhreSite.de', '', '', '', '', '', '1', '', '', '')

Any help appreciated.

Windows XP SP2
Apache 2.2.8
Contenido 4.8.1
PHP 5.2.5
MySQL 5.0.19

[timo.trautmann_4fb]

Please insert in file Setup\data\sysadmin\sysadmin1.sql:

Code: Alles auswählen

INSERT INTO !PREFIX!_phplib_auth_user_md5 VALUES('48a365b4ce1e322a55ae9017f3daf0c0', 'sysadmin', '48a365b4ce1e322a55ae9017f3daf0c0', 'sysadmin', 'Systemadministrator', 'sysadmin@IhreSite.de', '', '', '', '', '', '1', '0000-00-00', '0000-00-00', '0000-00-00 00:00:00');

Probably modify file Setup\data\client\client1.sql replace

Code: Alles auswählen

INSERT INTO !PREFIX!_phplib_auth_user_md5 VALUES ('21232f297a57a5a743894a0e4a801fc3', 'admin', '21232f297a57a5a743894a0e4a801fc3', 'admin[1]', 'Administrator Contenido Demo', 'admin_kunde@IhreSite.de', '', '', '', '', '', 1, '', '', '');

to

Code: Alles auswählen

INSERT INTO !PREFIX!_phplib_auth_user_md5 VALUES ('21232f297a57a5a743894a0e4a801fc3', 'admin', '21232f297a57a5a743894a0e4a801fc3', 'admin[1]', 'Administrator Contenido Demo', 'admin_kunde@IhreSite.de', '', '', '', '', '', 1, '0000-00-00', '0000-00-00', '0000-00-00 00:00:00');

Fix for new version exists.

[koyner]

Thanks, that got me to an 'installation successful' screen, so it looks promising.