No Data returned in Contacts after import

[greenteam]

Hello,
I recently did a contacts import and now whenever I go to view the contacts via the "Contacts" Module at the top no data is returned no matter what I do. I did some searches and found out that I needed to output the query and then try that query in phpMyAdmin. I tried that, no errors were returned, but now rows were returned either. The contacts exist because I can view them directly from the activity stream and they appear in the database. I have tried repairing from the admin panel but with no luck.

Also, it appears that users can view all the contacts ONE time. Once ONE search is done, the contacts cannot be viewed on that account. Even on separate computers, that account can never view any contacts on the ViewList.

What is going on here and how can we fix it?
Ben

[andopes]

Can you kindly let us know which customization did you apply and which packages did you install?
Which SugarCRM version?
Follow my tips here.

Regards

[greenteam]

Hello andopes,
I have followed those tips as I found a similar thread with your exact suggestion! After running my sql statement through phpMyAdmin, it returned an empty set and no errors.

This was the query:
SELECT contacts.id ,contacts_cstm.clientpriority_c, TRIM(CONCAT(IFNULL(contacts.first_name,''),' ',IFNULL(contacts.last_name,''))) as name, contacts.first_name , contacts.last_name , contacts.salutation , accounts.name account_name, jtl0.account_id account_id, contacts.phone_mobile , contacts.phone_work , TRIM(CONCAT(IFNULL(jt1.first_name,''),' ',IFNULL(jt1.last_name,''))) assigned_user_name , jt1.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, contacts.phone_fax , contacts.assigned_user_id FROM contacts LEFT JOIN contacts_cstm ON contacts.id = contacts_cstm.id_c LEFT JOIN accounts_contacts jtl0 ON contacts.id=jtl0.contact_id AND jtl0.deleted=0 LEFT JOIN accounts accounts ON accounts.id=jtl0.account_id AND accounts.deleted=0 AND accounts.deleted=0 LEFT JOIN users jt1 ON jt1.id= contacts.assigned_user_id AND jt1.deleted=0 AND jt1.deleted=0 where ((contacts.id IN (SELECT eabr.bean_id FROM email_addr_bean_rel eabr JOIN email_addresses ea ON (ea.id = eabr.email_address_id) WHERE eabr.deleted=0 AND ea.email_address LIKE 'CURRENT USERS EMAIL%'))) AND contacts.deleted=0 ORDER BY name ASC

CURRENT USERS EMAIL is the current logged in user's email that I have redacted.

We are using CE 6.2.0 and the only customizations we have made were custom fields in the contact module. We have also enabled/disabled select modules.

Thanks,
Ben

[andopes]

What happen if you run this query in database, like phpMyAdmin? Does that return an error?

Regards

[greenteam]

I have said two times already:
After running my sql statement through phpMyAdmin, it returned an empty set and no errors.

Thanks,
Ben

[greenteam]

Hello? This problem is still greatly affecting our business and is a top priority.