Team creation error

Message boards : Number crunching : Team creation error
Message board moderation

To post messages, you must log in.

AuthorMessage
Rymorea

Send message
Joined: 21 Mar 17
Posts: 3
Credit: 25,152
RAC: 0
Message 1837 - Posted: 22 Mar 2017, 10:11:13 UTC
Last modified: 22 Mar 2017, 10:13:32 UTC

What is the team creation requirement ? When I try to new one server give this error
Database Error
Field 'total_credit' doesn't have a default value


So how much credit do I need for this ? or wait for database gives me permission ?

Any advise thanks
ID: 1837 · Rating: 0 · rate: Rate + / Rate - Report as offensive     Reply Quote
Profile Eric Driver
Project administrator
Project developer
Project tester
Project scientist

Send message
Joined: 8 Jul 11
Posts: 944
Credit: 102,325,297
RAC: 68,078
Message 1838 - Posted: 22 Mar 2017, 15:50:55 UTC - in response to Message 1837.  

I think that's a side effect of php7. It throws that error when a field in the database doesn't have a default value; this didn't happen with previous versions of php.

I set default values in the team table, so I think it should work now. Let me know what happens. Thanks!
ID: 1838 · Rating: 0 · rate: Rate + / Rate - Report as offensive     Reply Quote
Rymorea

Send message
Joined: 21 Mar 17
Posts: 3
Credit: 25,152
RAC: 0
Message 1839 - Posted: 22 Mar 2017, 17:09:57 UTC

thanks I create the team
But upper side of the page gives this error maybe you can find the problem

Database Error
Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'NumberFields.team_delta.timestamp' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by


Good days
ID: 1839 · Rating: 0 · rate: Rate + / Rate - Report as offensive     Reply Quote
Profile Eric Driver
Project administrator
Project developer
Project tester
Project scientist

Send message
Joined: 8 Jul 11
Posts: 944
Credit: 102,325,297
RAC: 68,078
Message 1840 - Posted: 23 Mar 2017, 6:28:35 UTC - in response to Message 1839.  

I'm not sure if that error message is related to what I changed. The problem may have always been there (since upgrading php). I notice it happens for some of the teams, but not all. I'll look into it this weekend when I have some time. At least people can create teams now.
ID: 1840 · Rating: 0 · rate: Rate + / Rate - Report as offensive     Reply Quote

Message boards : Number crunching : Team creation error


Main page · Your account · Message boards


Copyright © 2019 Arizona State University