Probleme mit MySQL strict mode
- Frische QUIQQER-Installation (unter
dev-master
installiert, aber dann aufdev-dev
gewechselt) - Benutzer gespeichert
- 500er:
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] => ,663328350,1,
[setv2] =>
[setv3] =>
[setv4] =>
[setv5] => 0000-00-00
[setv6] => peat@pcsg.de
[setv7] =>
[setv8] => 1
[setv9] => {"quiqqer.erp.euVatId":false,"quiqqer.erp.taxId":false,"quiqqer.erp.address":false,"quiqqer.erp.isNettoUser":2,"quiqqer.license.licenses":false,"quiqqer.set.new.password":false,"qui-bookmarks":false}
[setv10] => de
[setv11] => 2017-08-01 10:27:58
[setv12] => 0000-00-00 00:00:00
[setv13] =>
[setv14] => 0
[setv15] => 0
[setv16] =>
[setv17] =>
[setv18] => []
[wherev0] => 376441859
)
)
SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '0000-00-00 00:00:00' for column 'expire' 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] => ,663328350,1,
[setv2] =>
[setv3] =>
[setv4] =>
[setv5] => 2017-08-10
[setv6] => peat@pcsg.de
[setv7] =>
[setv8] => 1
[setv9] => {"quiqqer.erp.euVatId":false,"quiqqer.erp.taxId":false,"quiqqer.erp.address":false,"quiqqer.erp.isNettoUser":2,"quiqqer.license.licenses":false,"quiqqer.set.new.password":false,"qui-bookmarks":false}
[setv10] => de
[setv11] => 2017-08-01 10:30:15
[setv12] => 0000-00-00 00:00:00
[setv13] =>
[setv14] => 0
[setv15] => 0
[setv16] =>
[setv17] =>
[setv18] => []
[wherev0] => 376441859
)
)
#0 /var/www/html/paketStore/packages/quiqqer/utils/src/QUI/Database/DB.php(444): QUI\Database\DB->exec(Array)
#1 /var/www/html/paketStore/packages/quiqqer/quiqqer/lib/QUI/Users/User.php(1476): QUI\Database\DB->update('users', Array, Array)
#2 /var/www/html/paketStore/packages/quiqqer/quiqqer/admin/ajax/users/save.php(32): QUI\Users\User->save()
#3 [internal function]: {closure}('376441859', Array)
#4 /var/www/html/paketStore/packages/quiqqer/quiqqer/lib/QUI/Ajax.php(336): call_user_func_array(Object(Closure), Array)
#5 /var/www/html/paketStore/packages/quiqqer/quiqqer/lib/QUI/Ajax.php(204): QUI\Ajax->callRequestFunction('ajax_users_save')
#6 /var/www/html/paketStore/packages/quiqqer/quiqqer/admin/ajax.php(118): QUI\Ajax->call()
#7 {main}
{
"request": "https:\/\/store.quiqqer.com\/admin\/ajax.php",
"errorFilename": false,
"userId": "376441859",
"username": "admin"
}
Hinweis: Das war auf @michael.daniel s Rechner