Bad server response during export

[ciryaj]

I was exporting around 350K leads and every time I export bad server response shows up. I guess it would be something with the time out but I don't know where to configure.

[item]

Hello,
max time execution and so are in : php.ini file

But for me, with 350K, is better to do directly in database.

Regards

[ciryaj]

I prefer users to be able to do it on their own. I guess this is not on max_exec... I have tried changing this and it seems to time out in less than 60s or even 30s

[Maximus]

Hello,
is there something in the Espo and server error logs?

[item]

Hi,
just be realistic : 350K with a table like "Leads"... hum hum ....
I just look the table "leads" linked to :
user
email
phone
account
contact
opportunity
campaign

after that, you have not more table in the "EspoCRM" database
Sometime, you must choose...and with 350k record, you have no choose

[yuri]

In 5.6.0 memory usage will be optimized for export. But export to XLSX will still demand a lot of memory though.

[ciryaj]

In 5.6.0 memory usage will be optimized for export. But export to XLSX will still demand a lot of memory though.

Ohhh so this is not about the timeout but on the memory usage?

[yuri]

> Ohhh so this is not about the timeout but on the memory usage?
The answer for your case is in logs.

[ciryaj]

> Ohhh so this is not about the timeout but on the memory usage?
The answer for your case is in logs.

Saw it.

Espo.ERROR: Uncaught Exception PDOException: "SQLSTATE[HY000] [2002] No such file or directory" at /opt/lampp/htdocs/ntucrm/application/Espo/ORM/EntityManager.php line 157 {"exception":"[object] (PDOException(code: 2002)

Saw a solution.

https://forum.espocrm.com/forum/installation-and-upgrade-help/28874-bad-server-response

That was too stupid of me not to check on logs first.

But then got another error

Espo.ERROR: Uncaught Exception PDOException: "SQLSTATE[42S22]:

[item]

Column not found: 1054 Unknown column 'user.type'

Check Yuri post in the forum, .I have read info about that..if not forget, you must run a SQL query for create this field.
I think this field don't exist in expo 5.4 and exist in 5.5

[ciryaj]

Column not found: 1054 Unknown column 'user.type'

Check Yuri post in the forum, .I have read info about that..if not forget, you must run a SQL query for create this field.
I think this field don't exist in expo 5.4 and exist in 5.5

ohhh let me try updating it then. THANKS!

[ciryaj]

Tried the update but I still have the error. Can anyone help in this? I can't seem to find the thread regarding the 'user.type'

[Maximus]

Have you checked DB. Does 'user.type' field exist?