search

Azareal / Gosora

Gosora is an ultra-fast and secure forum software written in Go that balances usability with functionality.
https://gosora-project.com/
GNU General Public License v3.0
164 stars 16 forks source link

Linux-Install Error #3

Closed SUP3RIA closed 6 years ago

SUP3RIA commented 6 years ago

Creating the admin user Error 1364: Field 'oldestItemLikedCreatedAt' doesn't have a default value Aborting installation...

SUP3RIA commented 6 years ago

Ok, SQL has to be in unstrict mode.

Azareal commented 6 years ago

Yeah, MySQL can be a little fussy, I've noted that down, although it seems to work on my machine and this is the one where I usually get errors like that.

wtl420 commented 6 years ago

I just encountered this same error. Looks like I had to disable STRICT_TRANS_TABLES in my sql_mode; my guess that's something Fedora has set for MariaDB by default.

Azareal commented 6 years ago

https://github.com/Azareal/Gosora/issues/40 One thing which might help to solve this is Docker, that doesn't work quite yet though.

I'll see if I can hunt down that specific setting and see what I can wrangle to get rid of this problem. Unfortunately, Travis doesn't seem to set that flag for the database for the automated tests, so it's easy for this slip through.

wtl420 commented 6 years ago

I saw this was closed and gave this a shot with STRICT_TRANS_TABLES enabled and got this new error:

Executing query #33
INSERT INTO `menu_items`(`mid`,`htmlID`,`cssClass`,`position`,`tmplName`,`order`) VALUES (1,'general_alerts','menu_alerts','right','menu_alerts',2);                                         
Error 1364: Field 'name' doesn't have a default value
Aborting installation...

If I disable it again, the install goes through fine, so I believe there's a few more queries that don't play nice with this.

Azareal commented 6 years ago

Oops, it looks like I forgot to push some bits.

Azareal commented 6 years ago

@wtl420 It should work now.