0
Not a bug

Mysql error during installation

kingdom computer0 11 months ago updated by Vlad R 11 months ago 1

Hi, I'm trying to installa fileurn on my centos server but when i connect to my ip for finish the installation, after set database name, mysql user and password and click next i get this error

MySQL error: SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'created', in: CREATE TABLE `df_collections` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `type` ENUM('regular','album') NOT NULL DEFAULT 'regular', `uid` mediumint(9) NOT NULL, `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

Anyone know how can i solve it? 
Thanks

Answer

Answer
Not a bug

Old MySQL version. Use at least 5.7

Answer
Not a bug

Old MySQL version. Use at least 5.7