Hi I having problems to create the database
on my local enromento works ok
but when i go to production i having this error
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Invalid default value for ‘CREATE_TS’
Hi I having problems to create the database
on my local enromento works ok
but when i go to production i having this error
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Invalid default value for ‘CREATE_TS’
We had a similar issue with DB creation on SQL.
In our case, the problem was in the regional settings of the SQL administrator login on whose behalf the database was created on the new server.
On the new server, the SQL administrator login (SA) was set to a different default language than English.
This gave an incorrect understanding of the data format for date columns.
Try to look this way.