SQL error SQLSTATE[42000]

MainServerGuard

Hello,

I got an error during my installation. I installed Flarum with Composer on Shared Host (SSH) and filled my information about database. I got the following error:
SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'notifications_read_time' (SQL: ALTER TABLE c_users CHANGE notification_read_time notifications_read_time DATETIME DEFAULT 'NULL')
Prefix is c_.

Thank you,
Chris van Chip
Chief Executive Officer and developer Main Server Guard

jordanjay29

What database software is your host running? And what version?

MainServerGuard

jordanjay29 Database software: MYSQL with PhpMyAdmin.
Hosting: Hostinger with Premium package.

MainServerGuard

I don't know the version.

Prosperous

Please try not to simply mention/tag developers in your posts to get their attention. They do frequent the forum and will get to your discussion when they can. 🙂

iconia

MainServerGuard I get the same issue, because you use Mariadb. this will be fix as they say in beta 8. here the discussion.

https://discuss.flarum.org/d/17496-flarum-0-1-0-beta-7-2-released/26

jordanjay29

MainServerGuard Please run mysql -V via SSH.