SQLException from execute error for 'common_name'

[monogrant]

I'm getting an odd error after my upgrade to 8.71 (possibly before, but I didn't dig into the logs too deep).

I'm not sure how to diagnose or approach this error. It repeats every 1-5 minutes.

2013-07-23 10:10:35,476 [ERROR] [JAMFPreparedStatement    ] - SQLException from execute: java.sql.SQLException: Column 'common_name' cannot be null
2013-07-23 10:10:35,476 [ERROR] [puterInstalledCertificate] - Saving computer_installed_certificates: java.sql.SQLException: com.jamfsoftware.computer.mdmactions.ComputerInstalledCertificate.save: SQLException from execute: java.sql.SQLException: Column 'common_name' cannot be null

[scafide]

Hey monogrant,

Thanks for the post - it sounds like we might have Strict Mode enabled in mySQL - check out this article which should hopefully resolve our issue!

https://jamfnation.jamfsoftware.com/article.html?id=318

Have a great day!

Mike

[monogrant]

Thanks for the update Mike. I'm not finding the sql_mode pattern in my /etc/mysql/my.cnf file at all...

Other ideas?

Update:
I'm also running MySQL v 5.5

[bjbechd]

@monogrant][/url and @michael.scafide I have the exact same problem. Im running 5.5 as well. Any ideas?