MySql Strict: Passwort ändern
Das ändern des Passworts in der Adminoberfläche via Profil
-> Passwort ändern
erzeugt eine MySql Fehlermeldung, wenn der strict mode aktiviert ist.
Das Passwort wird allerdings trotzdem geändert.
SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect date value: '0000-00-00' for column 'birthday' at row 1Array
(
[query] => UPDATE `users` SET `username` = :setv0, `usergroup` = :setv1, `firstname` = :setv2, `lastname` = :setv3, `usertitle` = :setv4, `birthday` = :setv5, `email` = :setv6, `avatar` = :setv7, `su` = :setv8, `extra` = :setv9, `lang` = :setv10, `lastedit` = :setv11, `expire` = :setv12, `shortcuts` = :setv13, `address` = :setv14, `company` = :setv15, `toolbar` = :setv16, `assigned_toolbar` = :setv17, `authenticator` = :setv18 WHERE `id` = :wherev0
[prepare] => Array
(
[setv0] => admin
[setv1] => ,582488275,1,
[setv2] =>
[setv3] =>
[setv4] =>
[setv5] => 0000-00-00
[setv6] =>
[setv7] =>
[setv8] => 1
[setv9] => {"quiqqer.set.new.password":0,"qui-bookmarks":false}
[setv10] => de
[setv11] => 2017-08-07 11:08:00
[setv12] => 0000-00-00 00:00:00
[setv13] =>
[setv14] => 0
[setv15] => 0
[setv16] =>
[setv17] =>
[setv18] => []
[wherev0] => 668094660
)
)