View Issue Details

IDProjectCategoryView StatusLast Update
0017484phplist applicationSubscriber Exportpublic21-10-14 14:39
Reporterduncanc 
PriorityhighSeverityminorReproducibilityalways
Status resolvedResolutionfixed 
Product Version3.0.9 
Target Version3.0.10Fixed in Version3.0.10 
Summary0017484: Export subscribers repeatedly fails
DescriptionA report in the user forum that the subscriber export does not work in release 3.0.9. http://forums.phplist.com/viewtopic.php?f=13&t=41728

I have also tried a few tests and all fail in the same way.
The pageaction URL http://www.xxx.org/lists/admin/?page=pageaction&action=export&ajaxed=true&tk=51c928c45641 returns the word "failed". Here is the complete response

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd" > <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" dir="ltr"> <head> <meta http-equiv="pragma" content="no-cache" /> <meta http-equiv="Cache-Control" content="no-cache, must-revalidate" /> <meta name="Powered-By" content="phplist version 3.0.9" /> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> </head><body> <script type="text/javascript"> var parentJQuery = window.parent.jQuery; parentJQuery("#progressbar").updateProgress("0,0"); parentJQuery("#busyimage").hide(); parentJQuery("#progresscount").html("All done"); </script><script type="text/javascript"> document.location = document.location; </script>failed</body></html>

I can see the temporary export file but it has a length of 0.

This is on phplist upgraded from release 3.0.8 to 3.0.9.
TagsNo tags attached.

Activities

michiel

21-10-14 12:09

manager   ~0055476

The updateProgress("0,0"); indicates that the $todo (total to export) variable is 0

which would mean, there's nothing to export.

What is the request set for it?

duncanc

21-10-14 12:18

developer   ~0055477

Last edited: 21-10-14 12:19

View 2 revisions

I had another go and this time there was an error message embedded in the ajax response

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd" > <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" dir="ltr"> <head> <meta http-equiv="pragma" content="no-cache" /> <meta http-equiv="Cache-Control" content="no-cache, must-revalidate" /> <meta name="Powered-By" content="phplist version 3.0.9" /> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> </head><body> <div id="dberror">Database error 1054 while doing query Unknown column 'listuser.userid' in 'where clause'</div><script type="text/javascript"> var parentJQuery = window.parent.jQuery; parentJQuery("#progressbar").updateProgress("-1,-1"); parentJQuery("#busyimage").hide(); parentJQuery("#progresscount").html("All done"); </script><script type="text/javascript"> document.location = document.location; </script>failed</body></html>

But that error message is immediately overwritten by the export file column headers.

I am exporting a list, with a date range for the signed-up date.

michiel

21-10-14 12:22

manager   ~0055478

ah, good, that should allow tracking it down. Thanks

michiel

21-10-14 12:36

manager   ~0055479

the listid is only set after the clause for ownership.

Am running some tests to make sure