Fatal Error Exporting Contacts

[don6558]

I’m not sure if this is supposed to be here or under Installations. I’ve just installed, worked through some issues so it now is somewhat working. I’m trying to learn CRM at the same time.

I’m trying to export all of the demo contacts. The page clears and remains blank. I can select 1 page and save/export and it works fine.

I checked my SuiteCRM log and I have the following error:

Error exporting Leads:
.SELECT
leads.,
email_addresses.email_address email_address,
‘’ email_addresses_non_primary, users.user_name as assigned_user_name ,leads_cstm.jjwg_maps_address_c,leads_cstm.jjwg_maps_geocode_status_c,leads_cstm.jjwg_maps_lat_c,leads_cstm.jjwg_maps_lng_c FROM leads LEFT JOIN users
ON leads.assigned_user_id=users.id LEFT JOIN email_addr_bean_rel on leads.id = email_addr_bean_rel.bean_id and email_addr_bean_rel.bean_module = ‘Leads’ and email_addr_bean_rel.deleted = 0 and email_addr_bean_rel.primary_address = 1 LEFT JOIN email_addresses on email_addresses.id = email_addr_bean_rel.email_address_id LEFT JOIN leads_cstm ON leads.id = leads_cstm.id_c WHERE () AND leads.deleted=0 Query Failed: SELECT
leads.,
email_addresses.email_address email_address,
‘’ email_addresses_non_primary, users.user_name as assigned_user_name ,leads_cstm.jjwg_maps_address_c,leads_cstm.jjwg_maps_geocode_status_c,leads_cstm.jjwg_maps_lat_c,leads_cstm.jjwg_maps_lng_c FROM leads LEFT JOIN users
ON leads.assigned_user_id=users.id LEFT JOIN email_addr_bean_rel on leads.id = email_addr_bean_rel.bean_id and email_addr_bean_rel.bean_module = ‘Leads’ and email_addr_bean_rel.deleted = 0 and email_addr_bean_rel.primary_address = 1 LEFT JOIN email_addresses on email_addresses.id = email_addr_bean_rel.email_address_id LEFT JOIN leads_cstm ON leads.id = leads_cstm.id_c WHERE () AND leads.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 ‘) AND leads.deleted=0’ at line 5
04/08/17 06:35:56 [2452][1][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.

There are other problems with CRM as well like:
The theme won’t change when I make change in admin Theme settings.
I cannot Add a tab.

Neither of these problems show up in the SuitCRM.log

Any ideas?

[pgr]

Please share your versions of OS, database, web server, PHP, and SuiteCRM…

The last time I saw someone complaining of something like this on these forums, they had just finished installing a 10 year-old stack with outdated MySQL and PHP : - )

Also, your other issues indicate permissions problems. You should reset your permissions.

[mjpires]

I have faced the same issue when trying to export 6200+ leads where I got the same SQL Error at suitecrm.log.

SuiteCRM version is 7.8.2 runnig php 5.4.33, mysql 5.5 and apache 2.4.

I have fixed the issue on file include/SugarObjects/templates/person/Person.php changing line 321

from:

               if ($where !== '') {

to:
if ($where !== ‘’ && $where !== NULL) {