Error exporting contacts

[buratz]

Hi, I have approx 700 Contacts loaded into Espo. When I try to export all contacts I get an Error 414. If I export only small selections I don't get an error. Where can I see a log for the Error?

Thanks

[yuri]

Hi

414 means Request is too long.

This error will not appear when we implement the ability to Select All records on list view.

[buratz]

When do you expect that to be? Can you tell me how to get the results directly from MYSQL?

[yuri]

SELECT contact.id AS `id`, TRIM(CONCAT(IFNULL(contact.first_name, ''), ' ', IFNULL(contact.last_name, ''))) AS `name`, contact.salutation_name AS `salutationName`, contact.first_name AS `firstName`, contact.last_name AS `lastName`, contact.account_id AS `accountId`, accountContact.role AS `title`, contact.description AS `description`, email_address.name AS `emailAddress`, phone_number.name AS `phoneNumber`, contact.do_not_call AS `doNotCall`, contact.address_street AS `addressStreet`, contact.address_city AS `addressCity`, contact.address_state AS `addressState`, contact.address_country AS `addressCountry`, contact.address_postal_code AS `addressPostalCode`, account.type AS `accountType`, contact.created_at AS `createdAt`, contact.modified_at AS `modifiedAt`, contact.deleted AS `deleted`, account.name AS `accountName`, TRIM(CONCAT(assigned_user.first_name, ' ', assigned_user.last_name)) AS `assignedUserName`, contact.assigned_user_id AS `assignedUserId`, TRIM(CONCAT(modified_by.first_name, ' ', modified_by.last_name)) AS `modifiedByName`, contact.modified_by_id AS `modifiedById`, TRIM(CONCAT(created_by.first_name, ' ', created_by.last_name)) AS `createdByName`, contact.created_by_id AS `createdById` FROM `contact` LEFT JOIN `account` AS `account` ON contact.account_id = account.id LEFT JOIN `user` AS `assigned_user` ON contact.assigned_user_id = assigned_user.id LEFT JOIN `user` AS `modified_by` ON contact.modified_by_id = modified_by.id LEFT JOIN `user` AS `created_by` ON contact.created_by_id = created_by.id 
            LEFT JOIN `account_contact` AS accountContact
            ON accountContact.contact_id = contact.id AND accountContact.account_id = contact.account_id AND accountContact.deleted = 0
         LEFT JOIN `entity_email_address` ON contact.id = entity_email_address.entity_id AND entity_email_address.deleted = '0' AND entity_email_address.primary = '1' AND entity_email_address.entity_type = 'Contact' LEFT JOIN `email_address` ON email_address.id = entity_email_address.email_address_id AND email_address.deleted = '0' LEFT JOIN `entity_phone_number` ON contact.id = entity_phone_number.entity_id AND entity_phone_number.deleted = '0' AND entity_phone_number.primary = '1' AND entity_phone_number.entity_type = 'Contact' LEFT JOIN `phone_number` ON phone_number.id = entity_phone_number.phone_number_id AND phone_number.deleted = '0' WHERE contact.deleted = '0' ORDER BY contact.first_name ASC 

[buratz]

Excellent, thanks for your help, much appreciated.