Windows Server, IIS, Cacti, Strict Mode, Thold

[BoatingBot]

I'm running Cacti on a windows server and we have weather maps and thold sending alerts.

But when trying to view the thold tab within cacti this errors appears: You are running MySQL in Strict Mode, which is not supported by Thold.

Everything else is working and Thold can be configured from config > settings > Thresholds page.

Anyone run into this issue?

[cigamit]

Have you disabled mysql strict mode?

[BoatingBot]

I've tried changing the mode in the my.ini file to no sucess.

[cigamit]

Was MySQL restarted afterwards?

You can disable it this way
https://my.kayako.com/Knowledgebase/Art ... trict-mode
or via setting the global variable.
SET GLOBAL sql_mode="";

You might also check and ensure there isn't multiple my.cfg files on the server. Setting the global should tell you immediately if it worked without restarting mysql.
http://bugs.mysql.com/bug.php?id=68643

[BoatingBot]

Got it working.

Looks like I just had to restart the service after applying the fix.