Hello,
Relatively new user running CE Version 6.1.2 (Build 5555) on Windows with MySQL. I've run into an error that I cannot figure out. I have searched the forums and I have found others getting the same error but in slightly different scenarios.

I have been making several changes to the LEADS and CALL modules lately as that is about all we use right now.

My most recent change was to build a logic hook using help found on these boards (thank you very much.) This hook updates two custom fields in a LEADS record whenever a call is created for that lead. I have no idea if that has anything to do with my current issue, but it was my last big change.

Today I noticed that I get an error when creating a new custom field in the LEADS module in Studio. After the error pops up in Studio, I then return to the listing of the fields in the LEADS module and the new field is there. The same is happening when I try to delete the field. Error...but field is gone.

My SugarCRM.LOG file shows the following info.


05/02/11 16:19:44 [2452][cb50395b-3ebf-8f10-4011-4d56077a244d][INFO] Query:ALTER TABLE leads modify column account_id NULL
05/02/11 16:19:44 [2452][cb50395b-3ebf-8f10-4011-4d56077a244d][INFO] Query Execution Time:0.00011086463928223
05/02/11 16:19:44 [2452][cb50395b-3ebf-8f10-4011-4d56077a244d][FATAL] MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1
05/02/11 16:19:44 [2452][cb50395b-3ebf-8f10-4011-4d56077a244d][DEBUG] Calling DBManager::disconnect()


Any help would be greatly appreciated.

Thanks.