openlp-core team mailing list archive
-
openlp-core team
-
Mailing list archive
-
Message #11297
[Bug 825809] Re: Extrating Song Usage report crashes
** Attachment added: "check_dependencies.py output"
https://bugs.launchpad.net/bugs/825809/+attachment/2274620/+files/dependencies
** Description changed:
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.
- --- Exception Traceback ---
+ 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."
+ 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: -
--
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:
Extrating 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
References