Extracting Song Usage report crashes

Bug #825809 reported by Andreas Preikschat on 2011-08-13
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Raoul Snyman

Bug Description


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/andreas/Projekte/openlp/trunk/openlp/plugins/songusage/forms/songusagedetailform.py", line 114, in accept
    [SongUsageItem.usagedate, SongUsageItem.usagetime])
  File "/home/andreas/Projekte/openlp/trunk/openlp/core/lib/db.py", line 227, in get_all_objects
    return query.order_by(order_by_ref).all()
  File "<string>", line 1, in <lambda>
  File "/usr/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 50, in generate
    fn(self, *args[1:], **kw)
  File "/usr/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 1054, in order_by
    criterion = self._adapt_col_list(criterion)
  File "/usr/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 205, in _adapt_col_list
    for o in cols
  File "/usr/lib/python2.7/site-packages/sqlalchemy/sql/expression.py", line 1279, in _literal_as_text
    "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 (googol) wrote :
description: updated
Andreas Preikschat (googol) wrote :

By the way, I am not sure if that is a dependency problem (which is why I attached the output of check_dependencies).

summary: - Extrating Song Usage report crashes
+ Extracting Song Usage report crashes
Changed in openlp:
importance: Undecided → Medium
Raoul Snyman (raoul-snyman) wrote :

Just tried to reproduce this bug on trunk rev1710, but can't. Perhaps you didn't have any song usage data?

Andreas Preikschat (googol) wrote :

I am pretty sure that this is a dependency or version problem. Note, I had this traceback on arch.

Raoul Snyman (raoul-snyman) wrote :

$ ./check_dependencies.py
  Python >= 2.6 ... 2.7.1.final.0
Checking for modules...
  PyQt4... OK
  PyQt4.QtCore... OK
  PyQt4.QtGui... OK
  PyQt4.QtNetwork... OK
  PyQt4.QtOpenGL... OK
  PyQt4.QtSvg... OK
  PyQt4.QtTest... OK
  PyQt4.QtWebKit... OK
  PyQt4.phonon... OK
  sqlalchemy... OK
  sqlite3... OK
  lxml... OK
  chardet... OK
  enchant... OK
  BeautifulSoup... OK
  mako... OK
Checking for optional modules...
  sqlite (SQLite 2 support)... OK
  MySQLdb (MySQL support)... FAIL
  psycopg2 (PostgreSQL support)... FAIL
Verifying version of modules...
  PyQt4 >= 4.6 ... 4.8.3
  Qt4 >= 4.6 ... 4.7.2
  sqlalchemy >= 0.5 ... 0.6.4
  enchant >= 1.3 ... 1.5.3
Qt4 image formats...
  read: bw, eps, epsf, epsi, exr, pcx, psd, ras, rgb, rgba, sgi, tga, xcf, bmp, bw, dds, eps, epsf, epsi, exr, gif, ico, jp2, jpeg, jpg, mng, pbm, pcx, pgm, pic, png, ppm, psd, ras, rgb, rgba, sgi, svg, svgz, tga, tif, tiff, xbm, xcf, xpm, xv
  write: bw, eps, epsf, epsi, pcx, rgb, rgba, sgi, tga, bmp, bw, eps, epsf, epsi, ico, jp2, jpeg, jpg, pcx, pic, png, ppm, rgb, rgba, sgi, tga, tif, tiff, xbm, xpm, xv
Enchant (spell checker)...
  available backends: ispell, hspell, myspell, aspell
  available languages: en_US, en_CA, en_GB, en_AU, en_ZA, en

Raoul Snyman (raoul-snyman) wrote :

Maybe it's the version of SQLAlchemy. Let me try installing 0.7.

Changed in openlp:
assignee: nobody → Raoul Snyman (raoul-snyman)
status: New → Fix Committed
Changed in openlp:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers