AnsweredAssumed Answered

LEAD: Mass Update Error

Question asked by community-support on Jan 13, 2014
Latest reply on Jan 13, 2014 by community-support
Hi, ich have a problem while assigning some LEADs to a user using the MASS UPDATE funktion.

After selecting the LEADs a want to assign, is filled in the Informations using the MASS UPDATE funktion.

Yesterday i worked great, today i get this error:

'Database failure. Please refer to sugarcrm.log for details.'

Will be great if you can help me. Thanks

The LOG FILE Says: 

Sat Nov 30 16:00:23 2013 [2750][c700a5c6-4cfe-a602-e3f0-52974883bda8][FATAL] Error updating table: leads: Query Failed: UPDATE leads

      SET date_modified='2013-11-30 15:00:21',modified_user_id='c700a5c6-4cfe-a602-e3f0-52974883bda8',created_by='16de0dc0-80d4-d8b5-1142-52974c12acd8',description=NULL,assigned_user_id='521ae445-b836-c208-2fb6-52976173674e',salutation=NULL,first_name='Galerie',last_name='Auf Zeit',title=NULL,department=NULL,do_not_call=0,phone_home=NULL,phone_mobile=NULL,phone_work='0176 - 34 96 83 36',phone_other=NULL,phone_fax=NULL,primary_address_street='SchweinsbrŸcke 11',primary_address_city='Wismar',primary_address_state=NULL,primary_address_postalcode='23966',primary_address_country='Germany',alt_address_street=NULL,alt_address_city=NULL,alt_address_state=NULL,alt_address_postalcode=NULL,alt_address_country=NULL,assistant=NULL,assistant_phone=NULL,converted=0,refered_by=NULL,lead_source='Self Generated',lead_source_description=NULL,status='Assigned',status_description=NULL,reports_to_id='',account_name='Galerie Auf Zeit',account_description=NULL,contact_id='',account_id='',opportunity_id='',opportunity_name=NULL,opportunity_amount=NULL,campaign_id='',birthdate=NULL,portal_name=NULL,portal_app=NULL,website='http://www.kristine-hamann.de/',=NULL

       WHERE  leads.id = '111da963-52df-5155-a096-5299d9ca6cd2' 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

       WHERE  leads.id = '111da963-52df-5155-a096-5299d9ca6cd2' AND deleted' at line 2

(from Tobi_germ)

Outcomes