Issues with "date format" in MySQL if "strict mode" is active

jmueller17 / Aixada

Aixada helps self-managed consumption cooperatives to organize their flow of products, money, and information.

Other

33 stars 37 forks source link

Closed mbenito closed 4 years ago

mbenito commented 5 years ago

Some hosts are activating the strict mode in the MySQL server and many problems with date format are being prompted.

jorix commented 5 years ago

Try using the current master with the recent PR #257

jorix commented 5 years ago

@mbenito Please report the result of current master if it has been positive.
( otherwise, too, of course! )

mbenito commented 5 years ago

Great! It works! I have applied this solution:

$this->mysqli->query("SET @@SQL_MODE = ' ';");
$this->mysqli->query("SET @@group_concat_max_len = 255;");

Thanks a lot for you help and your contribution!