Extracting Song Usage report crashes

[Andreas Preikschat]

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/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: -

[Andreas Preikschat (googol-deactivatedaccount)]

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

[Raoul Snyman (raoul-snyman)]

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

[Andreas Preikschat (googol-deactivatedaccount)]

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

[Raoul Snyman (raoul-snyman)]

$ ./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)]

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