Recent Changes - Search:

Get GNU Solfege at SourceForge.net. Fast, secure and Free Open Source software downloads


SITS-Incoming /

GuessingNotesErrorInDb

www.solfege.org
AllRecentChanges
RecentChanges
Wiki front page
Backlinks
(edit menu)

STATUS_DONE: Fixed in 3.16.2

(Edit Section ↓)

Guessing notes error in db

Submitter: romaasis ,, gmail ,, com
Long desciption: installation on gentoo gives error sqlite3.InterfaceError: Error binding parameter 1 - probably unsupported type

Solfege version3.16.1
Bzr revision infobranch_nick: build-branch
revno: 1552
revision_id: tca@gnu.org-20100409184954-p4qodmrqmo1cel9d
clean: False
gtk.pygtk_version(2, 16, 0)
gtk<module 'gtk' from '/usr/lib64/python2.6/site-packages/gtk-2.0/gtk/__init__.pyc'>
sys.version_info(2, 6, 5, 'final', 0)
sys.version2.6.5 (r265:79063, Apr 23 2010, 17:08:29) [GCC 4.4.3]
sys.prefix/usr
sys.platformlinux2
windowsversion(not running ms windows)

Message from stderr: 

 
Traceback (most recent call last):
  File "/usr/share/solfege/solfege/mainwin.py", line 399, in on_link_clicked
    solfege.app.practise_lessonfile(filename)
  File "/usr/share/solfege/solfege/application.py", line 309, in practise_lessonfile
    solfege.win.box_dict[module].on_start_practise()
  File "/usr/share/solfege/solfege/exercises/idtone.py", line 309, in on_start_practise
    self.set_percentage_label()
  File "/usr/share/solfege/solfege/exercises/idtone.py", line 272, in set_percentage_label
    self.g_percentage.set_text("%.1f %%" % (self.m_t.m_statistics.get_percentage_correct()))
  File "/usr/share/solfege/solfege/statistics.py", line 535, in get_percentage_correct
    num_correct = solfege.db.conn.execute("select sum(count) from sessions where answerkey=guessed and timestamp=? and fileid=?", (self.m_timestamp, fileid)).fetchone()[0]
sqlite3.InterfaceError: Error binding parameter 1 - probably unsupported type.
Traceback (most recent call last):
  File "/usr/share/solfege/solfege/exercises/idtone.py", line 229, in new_question
    self.set_percentage_label()
  File "/usr/share/solfege/solfege/exercises/idtone.py", line 272, in set_percentage_label
    self.g_percentage.set_text("%.1f %%" % (self.m_t.m_statistics.get_percentage_correct()))
  File "/usr/share/solfege/solfege/statistics.py", line 535, in get_percentage_correct
    num_correct = solfege.db.conn.execute("select sum(count) from sessions where answerkey=guessed and timestamp=? and fileid=?", (self.m_timestamp, fileid)).fetchone()[0]
sqlite3.InterfaceError: Error binding parameter 1 - probably unsupported type.
Traceback (most recent call last):
  File "/usr/share/solfege/solfege/mainwin.py", line 1031, in on_key_press_event
    self.get_view().on_key_press_event(widget, event)
  File "/usr/share/solfege/solfege/abstract.py", line 570, in on_key_press_event
    self.m_key_bindings[s]()
  File "/usr/share/solfege/solfege/exercises/idtone.py", line 206, in <lambda>
    = lambda self=self, k=k: self.on_answer_from_user(k)
  File "/usr/share/solfege/solfege/exercises/idtone.py", line 264, in on_answer_from_user
    self.set_percentage_label()
  File "/usr/share/solfege/solfege/exercises/idtone.py", line 272, in set_percentage_label
    self.g_percentage.set_text("%.1f %%" % (self.m_t.m_statistics.get_percentage_correct()))
  File "/usr/share/solfege/solfege/statistics.py", line 535, in get_percentage_correct
    num_correct = solfege.db.conn.execute("select sum(count) from sessions where answerkey=guessed and timestamp=? and fileid=?", (self.m_timestamp, fileid)).fetchone()[0]
sqlite3.InterfaceError: Error binding parameter 1 - probably unsupported type.
Traceback (most recent call last):
  File "/usr/share/solfege/solfege/exercises/idtone.py", line 229, in new_question
    self.set_percentage_label()
  File "/usr/share/solfege/solfege/exercises/idtone.py", line 272, in set_percentage_label
    self.g_percentage.set_text("%.1f %%" % (self.m_t.m_statistics.get_percentage_correct()))
  File "/usr/share/solfege/solfege/statistics.py", line 535, in get_percentage_correct
    num_correct = solfege.db.conn.execute("select sum(count) from sessions where answerkey=guessed and timestamp=? and fileid=?", (self.m_timestamp, fileid)).fetchone()[0]
sqlite3.InterfaceError: Error binding parameter 1 - probably unsupported type.
Traceback (most recent call last):
  File "/usr/share/solfege/solfege/mainwin.py", line 1031, in on_key_press_event
    self.get_view().on_key_press_event(widget, event)
  File "/usr/share/solfege/solfege/abstract.py", line 570, in on_key_press_event
    self.m_key_bindings[s]()
  File "/usr/share/solfege/solfege/exercises/idtone.py", line 206, in <lambda>
    = lambda self=self, k=k: self.on_answer_from_user(k)
  File "/usr/share/solfege/solfege/exercises/idtone.py", line 264, in on_answer_from_user
    self.set_percentage_label()
  File "/usr/share/solfege/solfege/exercises/idtone.py", line 272, in set_percentage_label
    self.g_percentage.set_text("%.1f %%" % (self.m_t.m_statistics.get_percentage_correct()))
  File "/usr/share/solfege/solfege/statistics.py", line 535, in get_percentage_correct
    num_correct = solfege.db.conn.execute("select sum(count) from sessions where answerkey=guessed and timestamp=? and fileid=?", (self.m_timestamp, fileid)).fetchone()[0]
sqlite3.InterfaceError: Error binding parameter 1 - probably unsupported type.
Traceback (most recent call last):
  File "/usr/share/solfege/solfege/mainwin.py", line 1031, in on_key_press_event
    self.get_view().on_key_press_event(widget, event)
  File "/usr/share/solfege/solfege/abstract.py", line 570, in on_key_press_event
    self.m_key_bindings[s]()
  File "/usr/share/solfege/solfege/exercises/idtone.py", line 206, in <lambda>
    = lambda self=self, k=k: self.on_answer_from_user(k)
  File "/usr/share/solfege/solfege/exercises/idtone.py", line 264, in on_answer_from_user
    self.set_percentage_label()
  File "/usr/share/solfege/solfege/exercises/idtone.py", line 272, in set_percentage_label
    self.g_percentage.set_text("%.1f %%" % (self.m_t.m_statistics.get_percentage_correct()))
  File "/usr/share/solfege/solfege/statistics.py", line 535, in get_percentage_correct
    num_correct = solfege.db.conn.execute("select sum(count) from sessions where answerkey=guessed and timestamp=? and fileid=?", (self.m_timestamp, fileid)).fetchone()[0]
sqlite3.InterfaceError: Error binding parameter 1 - probably unsupported type.
Traceback (most recent call last):
  File "/usr/share/solfege/solfege/mainwin.py", line 1031, in on_key_press_event
    self.get_view().on_key_press_event(widget, event)
  File "/usr/share/solfege/solfege/abstract.py", line 570, in on_key_press_event
    self.m_key_bindings[s]()
  File "/usr/share/solfege/solfege/exercises/idtone.py", line 206, in <lambda>
    = lambda self=self, k=k: self.on_answer_from_user(k)
  File "/usr/share/solfege/solfege/exercises/idtone.py", line 264, in on_answer_from_user
    self.set_percentage_label()
  File "/usr/share/solfege/solfege/exercises/idtone.py", line 272, in set_percentage_label
    self.g_percentage.set_text("%.1f %%" % (self.m_t.m_statistics.get_percentage_correct()))
  File "/usr/share/solfege/solfege/statistics.py", line 535, in get_percentage_correct
    num_correct = solfege.db.conn.execute("select sum(count) from sessions where answerkey=guessed and timestamp=? and fileid=?", (self.m_timestamp, fileid)).fetchone()[0]
sqlite3.InterfaceError: Error binding parameter 1 - probably unsupported type.
Traceback (most recent call last):
  File "/usr/share/solfege/solfege/exercises/idtone.py", line 229, in new_question
    self.set_percentage_label()
  File "/usr/share/solfege/solfege/exercises/idtone.py", line 272, in set_percentage_label
    self.g_percentage.set_text("%.1f %%" % (self.m_t.m_statistics.get_percentage_correct()))
  File "/usr/share/solfege/solfege/statistics.py", line 535, in get_percentage_correct
    num_correct = solfege.db.conn.execute("select sum(count) from sessions where answerkey=guessed and timestamp=? and fileid=?", (self.m_timestamp, fileid)).fetchone()[0]
sqlite3.InterfaceError: Error binding parameter 1 - probably unsupported type.
Traceback (most recent call last):
  File "/usr/share/solfege/solfege/mainwin.py", line 1031, in on_key_press_event
    self.get_view().on_key_press_event(widget, event)
  File "/usr/share/solfege/solfege/abstract.py", line 570, in on_key_press_event
    self.m_key_bindings[s]()
  File "/usr/share/solfege/solfege/exercises/idtone.py", line 206, in <lambda>
    = lambda self=self, k=k: self.on_answer_from_user(k)
  File "/usr/share/solfege/solfege/exercises/idtone.py", line 264, in on_answer_from_user
    self.set_percentage_label()
  File "/usr/share/solfege/solfege/exercises/idtone.py", line 272, in set_percentage_label
    self.g_percentage.set_text("%.1f %%" % (self.m_t.m_statistics.get_percentage_correct()))
  File "/usr/share/solfege/solfege/statistics.py", line 535, in get_percentage_correct
    num_correct = solfege.db.conn.execute("select sum(count) from sessions where answerkey=guessed and timestamp=? and fileid=?", (self.m_timestamp, fileid)).fetchone()[0]
sqlite3.InterfaceError: Error binding parameter 1 - probably unsupported type.
Traceback (most recent call last):
  File "/usr/share/solfege/solfege/mainwin.py", line 399, in on_link_clicked
    solfege.app.practise_lessonfile(filename)
  File "/usr/share/solfege/solfege/application.py", line 309, in practise_lessonfile
    solfege.win.box_dict[module].on_start_practise()
  File "/usr/share/solfege/solfege/exercises/idtone.py", line 309, in on_start_practise
    self.set_percentage_label()
  File "/usr/share/solfege/solfege/exercises/idtone.py", line 272, in set_percentage_label
    self.g_percentage.set_text("%.1f %%" % (self.m_t.m_statistics.get_percentage_correct()))
  File "/usr/share/solfege/solfege/statistics.py", line 535, in get_percentage_correct
    num_correct = solfege.db.conn.execute("select sum(count) from sessions where answerkey=guessed and timestamp=? and fileid=?", (self.m_timestamp, fileid)).fetchone()[0]
sqlite3.InterfaceError: Error binding parameter 1 - probably unsupported type.
Edit - History - Print - Recent Changes - Search
Page last modified on May 05, 2010, at 11:16 PM