Zurmo, creating your own report through SQL

I’m having an issue with the execution time of the scripts in Zurmo so I have created the following SQL statement to extract the data I need: SELECT `contact`.`id` contactid, `contact`.`companyname` companyname, `person`.`firstname` firstname, `person`.`lastname` lastname, `email`.`emailaddress` emailaddress, `address`.`state` state FROM `contact` INNER JOIN `person` ON `person`.`id` = `contact`.`person_id` INNER JOIN `email` ON `email`.`id` = … Read more

Issue exporting Zurmo report, maximum execution time exceeded

I have an issue with Zurmo and I still have not been able to fix it. The issue occurs when I try to export a big report into .CSV file. It returns this error: Fatal error: Maximum execution time of 30 seconds exceeded in /home/username/public_html/ws/app/protected/core/models/RedBeanModel.php on line 1279 I have done the following steps below … Read more