AnsweredAssumed Answered

MySQL query error referencing "=NULL" when trying to save a record

Question asked by kyuchukovv kyuchukovv on Mar 5, 2014
Latest reply on Mar 6, 2014 by kyuchukovv kyuchukovv
When i try to update my custom module it gives me an error "Database failure. Please refer to sugarcrm.log for details."
When i look into the log:
---------------------------------------------------------------------------------------
Wed Mar  5 10:56:13 2014
[18567][b4bec493-9c22-4117-2cca-527976cd62f2][FATAL] Error updating
table: techs_techs: Query Failed: UPDATE techs_techs
               
    SET name='Mr. cvdvdfv vdfvdfvd',date_modified='2014-03-05
08:56:13',modified_user_id='b4bec493-9c22-4117-2cca-527976cd62f2',created_by='70f5db44-5d7b-7c62-c61b-527961322e78',description=NULL,assigned_user_id='70f5db44-5d7b-7c62-c61b-527961322e78',=NULL,=NULL,=NULL,=NULL,=NULL,=NULL,=NULL,=NULL,=NULL
   
                   WHERE  techs_techs.id =
'a44c934b-e6b0-fa4d-7945-53165fad60be' AND deleted=0: 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,=NULL,=NULL,=NULL,=NULL,=NULL,=NULL,=NULL,=NULL
                     WHERE  techs_techs.i' at line 2
---------------------------------------------------------------------------------------

And on line 2 (  WHERE  techs_techs.i' ) is supposed to be  WHERE  techs_techs.id

I think it missed the ID or something. How can i repair this error.








Outcomes