Extracting Song Usage report crashes
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenLP |
Fix Released
|
Medium
|
Raoul Snyman |
Bug Description
Hello,
trunk r1708, archlinux
1) Go to "Tools -> Song Usage Tracking -> Extract Tracking Data"
2) Choose a directory to save the report
3) Try to extract the report.
It works, when I uncomment the order_by_ref argument. In the songusagedetailform
--- Exception Traceback ---
Traceback (most recent call last):
File "/home/
[SongUsageI
File "/home/
return query.order_
File "<string>", line 1, in <lambda>
File "/usr/lib/
fn(self, *args[1:], **kw)
File "/usr/lib/
criterion = self._adapt_
File "/usr/lib/
for o in cols
File "/usr/lib/
"SQL expression object or string expected."
ArgumentError: SQL expression object or string expected.
--- Library Versions ---
Python: 2.7.2
Qt4: 4.7.3
Phonon: 4.5.55
PyQt4: 4.8.5
SQLAlchemy: 0.7.1
BeautifulSoup: 3.2.0
lxml: 2.3.0
Chardet: 2.0.1
PyEnchant: 1.6.3
PySQLite: -
Related branches
- Andreas Preikschat (community): Approve
- Tim Bentley: Approve
-
Diff: 198 lines (+65/-45)5 files modifiedopenlp/core/lib/db.py (+3/-1)
openlp/plugins/songusage/forms/songusagedeletedialog.py (+17/-10)
openlp/plugins/songusage/forms/songusagedeleteform.py (+29/-20)
openlp/plugins/songusage/forms/songusagedetaildialog.py (+15/-14)
openlp/plugins/songusage/songusageplugin.py (+1/-0)
Changed in openlp: | |
assignee: | nobody → Raoul Snyman (raoul-snyman) |
status: | New → Fix Committed |
Changed in openlp: | |
status: | Fix Committed → Fix Released |
By the way, I am not sure if that is a dependency problem (which is why I attached the output of check_dependenc ies).