Merge Contacts show sql error

[hheckner]

When I try to merge 2 duplicate contacts I get the following error:

Query Failed: ::MySQL error 1065: Query was empty

Any tips on this one?

I use 4.5.0b

[softsysgrp]

I have the same issue and if you try the OS demo from the main web site, you will see that has the same issue.

[agupta]

I randomly selected 2 contacts and merged them but did not see any errors, If you can reproduce this consistently on your instance please help me debug it. here are the step, set the logging level to debug , run your use case and send me the log file (sugarcrm.log).

To change the logging level to debug, open log4php.properties in a editor and uncomment the last line in that file. The file is in the root of sugar installation, the log file will be generated in the same directory.

Thanks,
Ajay

[j0hn]

4.5.0c - I also have this exact error. LAMP - upgraded data - was on 4.2.1 - I will try logging and post results.

[agupta]

4.5.0c - I also have this exact error. LAMP - upgraded data - was on 4.2.1 - I will try logging and post results.

The immediate fix is to comment these lines out from vardefs.php in contacts module folder.

'products' => array (
'name' => 'products',
'type' => 'link',
'relationship' => 'contact_products',
'source' => 'non-db',
'vname' => 'LBL_PRODUCTS_TITLE',

),

This will be addressed in the 450d patch.

-Ajay

[j0hn]

Heres how mine looks -..




Wed Oct 4 08:20:48 2006,907 [2167] DEBUG SugarCRM - Processing many-to-many.
Wed Oct 4 08:20:48 2006,907 [2167] DEBUG SugarCRM - Link Query=SELECT emails.id FROM emails INNER JOIN emails_contacts ON (emails.id=emails_contacts.email_id AND emails_contacts.contact_id='6113c6f0-b7f3-bfa9-8af5-43cbc743cd3f') WHERE emails_contacts.deleted=0 AND emails.deleted=0
Wed Oct 4 08:20:48 2006,907 [2167] INFO SugarCRM - Query:SELECT emails.id FROM emails INNER JOIN emails_contacts ON (emails.id=emails_contacts.email_id AND emails_contacts.contact_id='6113c6f0-b7f3-bfa9-8af5-43cbc743cd3f') WHERE emails_contacts.deleted=0 AND emails.deleted=0
Wed Oct 4 08:20:48 2006,908 [2167] INFO SugarCRM - Query Execution Time:0.00028699999999993
Wed Oct 4 08:20:48 2006,908 [2167] DEBUG SugarCRM - SugarBean.load_relationships, Loading relationship (emails).
Wed Oct 4 08:20:48 2006,908 [2167] DEBUG SugarCRM - Link Constructor, relationship name: emails_contacts_rel
Wed Oct 4 08:20:48 2006,909 [2167] DEBUG SugarCRM - Link Constructor, Table name:
Wed Oct 4 08:20:48 2006,909 [2167] DEBUG SugarCRM - Link Constructor, Key name:
Wed Oct 4 08:20:48 2006,909 [2167] DEBUG SugarCRM - Link Constructor, _bean_table_name: contacts
Wed Oct 4 08:20:48 2006,910 [2167] DEBUG SugarCRM - Link Constructor, _bean_key_name: id
Wed Oct 4 08:20:48 2006,910 [2167] DEBUG SugarCRM - Link Constructor, relationship record found.
Wed Oct 4 08:20:48 2006,910 [2167] DEBUG SugarCRM - SugarBean.load_relationships, Loading relationship (leads).
Wed Oct 4 08:20:48 2006,910 [2167] DEBUG SugarCRM - Link Constructor, relationship name: contact_leads
Wed Oct 4 08:20:48 2006,911 [2167] DEBUG SugarCRM - Link Constructor, Table name:
Wed Oct 4 08:20:48 2006,911 [2167] DEBUG SugarCRM - Link Constructor, Key name:
Wed Oct 4 08:20:48 2006,911 [2167] DEBUG SugarCRM - Link Constructor, _bean_table_name: contacts
Wed Oct 4 08:20:48 2006,912 [2167] DEBUG SugarCRM - Link Constructor, _bean_key_name: id
Wed Oct 4 08:20:48 2006,912 [2167] DEBUG SugarCRM - Link Constructor, relationship record found.
Wed Oct 4 08:20:48 2006,912 [2167] DEBUG SugarCRM - getQuery, Bean is LHS: 1
Wed Oct 4 08:20:48 2006,912 [2167] DEBUG SugarCRM - getQuery, Relationship type=one-to-many
Wed Oct 4 08:20:48 2006,912 [2167] DEBUG SugarCRM - getQuery, Relationship role column name=
Wed Oct 4 08:20:48 2006,913 [2167] DEBUG SugarCRM - Processing one-to-many.
Wed Oct 4 08:20:48 2006,913 [2167] DEBUG SugarCRM - Link Query=SELECT id FROM leads WHERE leads.contact_id= '6113c6f0-b7f3-bfa9-8af5-43cbc743cd3f' AND leads.deleted=0
Wed Oct 4 08:20:48 2006,913 [2167] INFO SugarCRM - Query:SELECT id FROM leads WHERE leads.contact_id= '6113c6f0-b7f3-bfa9-8af5-43cbc743cd3f' AND leads.deleted=0
Wed Oct 4 08:20:48 2006,914 [2167] INFO SugarCRM - Query Execution Time:0.00031300000000001
Wed Oct 4 08:20:48 2006,914 [2167] DEBUG SugarCRM - SugarBean.load_relationships, Loading relationship (leads).
Wed Oct 4 08:20:48 2006,914 [2167] DEBUG SugarCRM - Link Constructor, relationship name: contact_leads
Wed Oct 4 08:20:48 2006,915 [2167] DEBUG SugarCRM - Link Constructor, Table name:
Wed Oct 4 08:20:48 2006,915 [2167] DEBUG SugarCRM - Link Constructor, Key name:
Wed Oct 4 08:20:48 2006,915 [2167] DEBUG SugarCRM - Link Constructor, _bean_table_name: contacts
Wed Oct 4 08:20:48 2006,916 [2167] DEBUG SugarCRM - Link Constructor, _bean_key_name: id
Wed Oct 4 08:20:48 2006,916 [2167] DEBUG SugarCRM - Link Constructor, relationship record found.
Wed Oct 4 08:20:48 2006,916 [2167] DEBUG SugarCRM - SugarBean.load_relationships, Loading relationship (products).
Wed Oct 4 08:20:48 2006,916 [2167] DEBUG SugarCRM - Link Constructor, relationship name: contact_products
Wed Oct 4 08:20:48 2006,917 [2167] DEBUG SugarCRM - Link Constructor, Table name:
Wed Oct 4 08:20:48 2006,917 [2167] DEBUG SugarCRM - Link Constructor, Key name:
Wed Oct 4 08:20:48 2006,917 [2167] FATAL SugarCRM - Error fetching relationship from cache contact_products
Wed Oct 4 08:20:48 2006,917 [2167] DEBUG SugarCRM - Link Constructor, _bean_table_name: contacts
Wed Oct 4 08:20:48 2006,918 [2167] DEBUG SugarCRM - Link Constructor, _bean_key_name: id
Wed Oct 4 08:20:48 2006,918 [2167] DEBUG SugarCRM - Link Constructor, No relationship record.
Wed Oct 4 08:20:48 2006,918 [2167] DEBUG SugarCRM - getQuery, Bean is LHS:
Wed Oct 4 08:20:48 2006,918 [2167] DEBUG SugarCRM - getQuery, Relationship type=
Wed Oct 4 08:20:48 2006,919 [2167] DEBUG SugarCRM - getQuery, Relationship role column name=
Wed Oct 4 08:20:48 2006,919 [2167] DEBUG SugarCRM - Link Query=
Wed Oct 4 08:20:48 2006,919 [2167] INFO SugarCRM - Query:
Wed Oct 4 08:20:48 2006,919 [2167] INFO SugarCRM - Query Execution Time:8.7999999999977E-05
Wed Oct 4 08:20:48 2006,920 [2167] FATAL SugarCRM - MySQL error 1065: Query was empty