DB: Set SQL_MODE to required state on each connect.

sql_mode is by default strict mode (STRICT_TRANS_TABLE) that is unfriendly to some db operations.

Set to preferable mode in the code.

Status changed to closed by commit 2874d3c6

Related to #1640 (closed) probably too.

mentioned in issue #1027 (closed)