View Issue Details

IDProjectCategoryView StatusLast Update
0020314phpList 3 applicationSubscriber Exportpublic13-01-21 17:43
Reportercjfsyntropy Assigned To 
PrioritynormalSeverityminorReproducibilityhave not tried
Status newResolutionopen 
Product Version3.5.5-RC1 
Target Version3.5.9-RC1 
Summary0020314: Export subscribers fails to create popup (just spins and then eventually leaves me on the export page)
DescriptionOn one of my v3.5.8 phpList systems, exporting works fine. On another system with 4006 subscribers in total, the export just spins and silently fails leaving me on the export page.

I checked the database with dbcheck on the command line and from the web interface. I determined that the urlhash column in the phplist_linktrack_forward was missing. So ran this database query to fix it:
alter table phplist_linktrack_forward add column urlhash char(32) default null;

The problem persists. Nothing is showing up in the Apache error log. I followed all the advice at https://www.phplist.org/manual/books/phplist-manual/page/troubleshooting-techniques and was unable to generate any errors in the Apache error log nor in the web interface.

I tried selecting one year date ranges for export instead of exporting all subscribers, but the behavior is the same. So I cannot see how to work around the issue.

I tried running 'show full processlist;' repeatedly after clicking 'export', and I see no evidence of any database query that last long enough notice running on the system. So I don't think it is a database slowness or failure issue.

When I search subscribers, I do see that the database connection seems to be working. The subscribers are visible.

If I search for gmail.com users, I find 259 of them. Yes: the database is working. Only part that isn't working is export subscribers.

The system is running on PHP 7.0.

At minimum the bug is to not give any clues when something is wrong even when all debugging options are thrown at the problem.
TagsNo tags attached.

Activities

michiel

22-12-20 09:44

administrator   ~0063669

I've seen that happen with systems with a lot of subscribers, a million or more. That's why we added the export on commandline option.

Can you try to see if using the commandline export works? I'm not entirely sure which version you need for that, but the latest one will have it.

Also, check the permissions of your tmp folder. Is anything showing in the browser console?

mariana

23-12-20 11:54

administrator   ~0063672

@cjfsyntropy you might want to share this at the community forum. The forum is full of phpList admins and someone might have a solution that might work for you. Simply copy and paste the text above.

Community forum: https://discuss.phplist.org/

michiel

13-01-21 17:43

administrator   ~0063697

I just encountered this on a test system:

Database error 1194 while doing query Table 'phplist_user_user' is marked as crashed and should be repaired

Maybe that's the same for you, and repairing the DB will fix it?