phplist

NOTE:: Before reporting an issue, make sure you are running the latest version, currently 3.3.1


View Issue Details Jump to Notes ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0017484phplist applicationSubscriber Exportpublic21-10-14 11:3721-10-14 14:39
Reporterduncanc 
PriorityhighSeverityminorReproducibilityalways
StatusresolvedResolutionfixed 
PlatformOSOS Version
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.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0055476)
michiel (manager)
21-10-14 12:09

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?
(0055477)
duncanc (developer)
21-10-14 12:18
edited on: 21-10-14 12:19

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.

(0055478)
michiel (manager)
21-10-14 12:22

ah, good, that should allow tracking it down. Thanks
(0055479)
michiel (manager)
21-10-14 12:36

the listid is only set after the clause for ownership.

Am running some tests to make sure


Copyright © 2000 - 2017 MantisBT Team
Powered by Mantis Bugtracker