Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Linux-Install Error #3

Closed
SUP3RIA opened this issue May 7, 2018 · 7 comments
Closed

Linux-Install Error #3

SUP3RIA opened this issue May 7, 2018 · 7 comments
Labels

Comments

@SUP3RIA
Copy link

SUP3RIA commented May 7, 2018

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

@SUP3RIA
Copy link
Author

SUP3RIA commented May 7, 2018

Ok, SQL has to be in unstrict mode.

@SUP3RIA SUP3RIA closed this as completed May 7, 2018
@Azareal
Copy link
Owner

Azareal commented May 11, 2018

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.

@Azareal Azareal added the bug label May 12, 2018
@wtl420
Copy link

wtl420 commented Sep 27, 2018

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
Copy link
Owner

Azareal commented Sep 27, 2018

#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.

@Azareal Azareal reopened this Sep 27, 2018
@Azareal Azareal closed this as completed in 644bba3 Oct 6, 2018
@wtl420
Copy link

wtl420 commented Oct 7, 2018

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
Copy link
Owner

Azareal commented Oct 7, 2018

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

Azareal added a commit that referenced this issue Oct 7, 2018
@Azareal
Copy link
Owner

Azareal commented Oct 7, 2018

@wtl420 It should work now.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

3 participants