openlp-core team mailing list archive

[Raoul Snyman <raoul.snyman@xxxxxxxxxxxxxxxxxxxxxxxx>]

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

-- 
You received this bug notification because you are a member of OpenLP
Core, which is subscribed to OpenLP.
https://bugs.launchpad.net/bugs/825809

Title:
  Extracting Song Usage report crashes

Status in OpenLP - Worship Presentation Software:
  New

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

To manage notifications about this bug go to:
https://bugs.launchpad.net/openlp/+bug/825809/+subscriptions