Unable to generate players

[rfc5141]

When I try to generate players for a league I get this error
Database Query Error: Field 'vertrag_torpraemie' doesn't have a default value

If I try to add individual players to a club I get
Database Query Error: Field 'vertrag_gehalt' doesn't have a default value

I eventually found those files in the DB and tried other default values but nothing worked. Any advice please?

[dannyx93]

Reinstall

[Elessair]

hi. I have exact same issue, but no luck trying to solve. any advice?

[Elessair]

i read some documentatin and it is related to SQL Strict mode, already explained in these forums.
anyhow if there is an alternative solution would be nice.

[Elessair]

try this alternative solution:

in SQL... execute this: (under table _spieler)

ALTER TABLE _spieler MODIFY vertrag_torpraemie smallint(5) NOT NULL DEFAULT '0'

[nafbanap]

If you want to use the strict mode,you will probably have to do this for all lines of install/ws3_ddl_full.sql, where 'NOT NULL' is indicated and a default value as well as a auto increment command are missing.
After that, (re)install it.

[Elessair]

thanks for the explanation, is more clear and I think is better to reinstall
unfortunately i cannot change the strict mode because i'm not admin of the server where sql is running