Impossible to export data on frontend

[Tiko]

Hi everyone

A client's website has a weird issue. Since few weeks, she can't export data from frontend:
- the XLS option has gone
- the CSV option returns a file with no data

Configuration
- Joomla : 2.5.28
- Fabrik : 3.0.7

Thanks in advance for your help and support.
Best
Daniel

 

[troester]

These are pretty outdated versions, with heavy security issues and not longer supported.
If you didn't change anything maybe your host has updated the php version and the code is not longer working.
You may check for error or warning messages in the network response (with your browser's dev console), which will break the export.

 

[cheyennemtnman]

I am actually having the same problem in the latest versions can't export... gets stuck and not showing elements in the list when marked show in list

 

[troester]

JS errors`?

 

[cheyennemtnman]

Did not see anything pop up.. just sits there..

 

[jeanl]

I have been experiencing this issue for some time now. I do however get this popup message:

cant write file /home/"mydomain"/public_html/tmp/services_report_view-export.csv

 

[troester]

Sounds like a folder access issue.

 

[jeanl]

Sounds like a folder access issue.

Thanks Troester. As in permissions? What should permissions for that folder be set to?

 

[troester]

tmp needs write access (0755 on unix server)

 

[jeanl]

tmp needs write access (0755 on unix server)

Troester, I checked and the tmp folder is perm 755. Yet I still get the same issue.

 

[troester]

Is this the folder which is set in the Joomla config/Server?
What does it display in System Information/Folder settings?

 

[jeanl]

Is this the folder which is set in the Joomla config/Server?
What does it display in System Information/Folder settings?

"writeable"

 

[troester]

Which Joomla/Fabrik/php version?
Is it with all lists?
Is it also if you e.g. filter your list (and csv is set to include filters), i.e. a different number of rows to export?

 

[jeanl]

Which Joomla/Fabrik/php version?
Is it with all lists?
Is it also if you e.g. filter your list (and csv is set to include filters), i.e. a different number of rows to export?

Troester

Joomla 3.9.19
Fabrik 3.9.2
PHP 7.2.34

I have checked permissions, path etc, and still cannot make it export csv. I urgently require assistance to fix so I can generate reports. Can you please advise?

 

[troester]

Is it with all lists?
Is it also if you e.g. filter your list (and csv is set to include filters), i.e. a different number of rows to export?

Is it working in the backend?
With/without "Frontend select"?
Which export settings?

 

[jeanl]

Is it working in the backend?
With/without "Frontend select"?
Which export settings?

Troester

It has the same problem in backend.
These are the settings as per attached image.

 

[jeanl]

friendly bump

 

[troester]

If it's in front- and it doesn't seem to be template or user related.

Is it with all your lists or only a special one?

Did you try to change the "Export step"?

Do you have 3rd-party plugins which may prevent writing/folder acesse ... (like e.g.admintools)?

 

[jeanl]

If it's in front- and it doesn't seem to be template or user related.

Is it with all your lists or only a special one? All

Did you try to change the "Export step"? Yes, reduced to smaller number, but still cannot

Do you have 3rd-party plugins which may prevent writing/folder acesse ... (like e.g.admintools)? Yes, admintools installed. I checked tmp permissions in admintools and it is 755.

 

[jeanl]

Troester, I found the issue. Not Fabrik related. It was an issue with how much space I had available on the server. I deleted some old backups to clear up space, and now I can export csv.