Urchin Q and A: Fixing Daylight Savings Error

Question: Ever since daylight savings, we get the following error when Urchin tries to process logs:

ERROR: (9003-942-883) Failed to query the database
DETAIL: Incorrect datetime value: '2009-03-08 02:59:50' for column 'utpt_data_start_time' at row 1

How do we fix this?

Answer: Reconfigure your MySQL installation and uncheck the checkbox for Enable Strict Mode.

Then, stop and restart the Urchin service.

If that doesn't work, from the MySQL Command Line
Prompt enter the following command:

mysql>SET @@global.sql_mode='MYSQL40'