#60 Quiz activity doesn't work

[Chris_147]

I get following output in the commandline window:

D:\MyPrograms\Schoolsplay\Releases\childsplay-2.3.3>python childsplay.py
['childsplay.py']
No binary
<configparser.configparser instance="" at="" 0x01833580="">
DEBUG: parsing rc file D:\MyPrograms\Schoolsplay\Releases\childsplay-2.3.3\lib\S
PData\themes\childsplay\theme.rc
removed old logpath
2012-12-19 12:02:07,467 - childsplay.childsplay - ERROR - No pid for BTP
2012-12-19 12:02:07,858 - childsplay.SPMainCore.MainCoreGui - ERROR - Could not
load image "logo_bt_64x64.png"
Couldn't open D:\MyPrograms\Schoolsplay\Releases\childsplay-2.3.3\lib\SPData\th
emes\childsplay\logo_bt_64x64.png
C:\Python27\lib\site-packages\sqlalchemy\engine\default.py:506: SAWarning: Unico
de type received non-unicode bind param value.
param.append(processorskey)
'amixer' is not recognized as an internal or external command,
operable program or batch file.
('memory_sp.icon.png', 'memory_sp_ro.icon.png', (-1, -1), 'memory_sp', False, Tr
ue)
('soundmemory.icon.png', 'soundmemory_ro.icon.png', (-1, -1), 'soundmemory', Fal
se, True)
('simon_sp.icon.png', 'simon_sp_ro.icon.png', (-1, -1), 'simon_sp', False, True)</configparser.configparser>

('ichanger.icon.png', 'ichanger_ro.icon.png', (-1, -1), 'ichanger', False, True)

('billiard.icon.png', 'billiard_ro.icon.png', (-1, -1), 'billiard', False, True)

('fallingletters.icon.png', 'fallingletters_ro.icon.png', (-1, -1), 'fallinglett
ers', False, True)
('findsound.icon.png', 'findsound_ro.icon.png', (-1, -1), 'findsound', False, Tr
ue)
('packid.icon.png', 'packid_ro.icon.png', (-1, -1), 'packid', False, True)
('pong.icon.png', 'pong_ro.icon.png', (-1, -1), 'pong', False, True)
('fourrow.icon.png', 'fourrow_ro.icon.png', (-1, -1), 'fourrow', False, True)
('puzzle.icon.png', 'puzzle_ro.icon.png', (-1, -1), 'puzzle', False, True)
('findit_sp.icon.png', 'findit_sp_ro.icon.png', (-1, -1), 'findit_sp', False, Tr
ue)
('electro_sp.icon.png', 'electro_sp_ro.icon.png', (-1, -1), 'electro_sp', False,
True)
('numbers_sp.icon.png', 'numbers_sp_ro.icon.png', (-1, -1), 'numbers_sp', False,
True)
('quiz_math.icon.png', 'quiz_math_ro.icon.png', (-1, -1), 'quiz_math', False, Tr
ue)
('fishtank.icon.png', 'fishtank_ro.icon.png', (-1, -1), 'fishtank', False, True)

C:\Python27\lib\site-packages\sqlalchemy\engine\base.py:2142: SAWarning: Dialect
sqlite+pysqlite does not support Decimal objects natively, and SQLAlchemy mus
t convert from floating point - rounding errors and other issues may occur. Plea
se consider storing Decimal numbers as strings or integers on this platform for
lossless storage.
result_processor(dialect, coltype)
<sporms.game_quiztext object="" at="" 0x041a0f50="">
8920.0000000000
2012-12-19 12:02:16,296 - childsplay.SPMainCore.MainCoreGui - ERROR - Exception
in quiz_math next_level
Traceback (most recent call last):
File "D:\MyPrograms\Schoolsplay\Releases\childsplay-2.3.3\SPMainCore.py", line
787, in start_next_level
self.activity.post_next_level()
File "D:\MyPrograms\Schoolsplay\Releases\childsplay-2.3.3\lib\quiz.py", line 2
16, in post_next_level
self.quizengine.next_question()
File "D:\MyPrograms\Schoolsplay\Releases\childsplay-2.3.3\lib\quizengine.py",
line 827, in next_question
if not self._next_question():
File "D:\MyPrograms\Schoolsplay\Releases\childsplay-2.3.3\lib\quizengine.py",
line 854, in _next_question
exer = self.CF.get_exercise()
File "D:\MyPrograms\Schoolsplay\Releases\childsplay-2.3.3\lib\quizengine.py",
line 305, in get_exercise
self.served_content_session.commit()
File "C:\Python27\lib\site-packages\sqlalchemy\orm\session.py", line 614, in c
ommit
self.transaction.commit()
File "C:\Python27\lib\site-packages\sqlalchemy\orm\session.py", line 385, in c
ommit
self._prepare_impl()
File "C:\Python27\lib\site-packages\sqlalchemy\orm\session.py", line 369, in _
prepare_impl
self.session.flush()
File "C:\Python27\lib\site-packages\sqlalchemy\orm\session.py", line 1392, in
flush
self._flush(objects)
File "C:\Python27\lib\site-packages\sqlalchemy\orm\session.py", line 1473, in
_flush
flush_context.execute()
File "C:\Python27\lib\site-packages\sqlalchemy\orm\unitofwork.py", line 302, i
n execute
rec.execute(self)
File "C:\Python27\lib\site-packages\sqlalchemy\orm\unitofwork.py", line 446, i
n execute
uow
File "C:\Python27\lib\site-packages\sqlalchemy\orm\mapper.py", line 1884, in _
save_obj
execute(statement, params)
File "C:\Python27\lib\site-packages\sqlalchemy\engine\base.py", line 1191, in
execute
params)
File "C:\Python27\lib\site-packages\sqlalchemy\engine\base.py", line 1271, in
_execute_clauseelement
return self.__execute_context(context)
File "C:\Python27\lib\site-packages\sqlalchemy\engine\base.py", line 1302, in
__execute_context
context.parameters[0], context=context)
File "C:\Python27\lib\site-packages\sqlalchemy\engine\base.py", line 1401, in
_cursor_execute
context)
File "C:\Python27\lib\site-packages\sqlalchemy\engine\base.py", line 1394, in
_cursor_execute
context)
File "C:\Python27\lib\site-packages\sqlalchemy\engine\default.py", line 299, i
n do_execute
cursor.execute(statement, parameters)
InterfaceError: (InterfaceError) Error binding parameter 1 - probably unsupporte
d type. u'INSERT INTO served_content (user_id, "CID", game_theme_id, module, sta
rt_time, count_served, wrong) VALUES (?, ?, ?, ?, ?, ?, ?)' (1, Decimal('8920.00
00000000'), Decimal('49.0000000000'), '', '2012-12-19 12:02:16.296000', 1, '')
2012-12-19 12:02:16,530 - childsplay.SPMainCore.MainCoreGui - ERROR - Exception
raised in the activity quiz_math: (InterfaceError) Error binding parameter 1 - p
robably unsupported type. u'INSERT INTO served_content (user_id, "CID", game_the
me_id, module, start_time, count_served, wrong) VALUES (?, ?, ?, ?, ?, ?, ?)' (1
, Decimal('8920.0000000000'), Decimal('49.0000000000'), '', '2012-12-19 12:02:16
.296000', 1, '')</sporms.game_quiztext>