I'm trying to modify an app I wrote a few months ago, but now it dies on startup (it worked before). The app loads the SQLite Media Monkey database, and crashes on its first query (when I try to get the number of podcasts). At the end of this post is a reduced version of the problem (which produces the same error).
Oh, this is Python 2.5 on Windows. The following is the traceback for the reduced version: Traceback (most recent call last): File "C:\projects\podcasts\podstrand-mm\temp.py", line 16, in <module> cursor.execute("select count(*) as count from songs") OperationalError: malformed database schema - near "VIRTUAL": syntax error It's the same error I get while running this code in context. The major change is that I upgraded version of MediaMonkey, and I'd think that might cause problems-- although all of my non-Python SQLite support apps have no problem (including running the same query). Unfortunately, if pysqlite's been upgraded, I can't find it -- pysqlite.org has been down the past 2 days. -Wm ------------ import os import sqlite3 # Find the mediamonkey database. conn = sqlite3.connect( os.path.join(os.environ['USERPROFILE'], 'Local Settings', 'Application Data', 'MediaMonkey', 'MM.DB') ) conn.row_factory = sqlite3.Row # provide named columns in results # Ask mediamonkey for its data. cursor = conn.cursor() # Get the total number of songs. cursor.execute("select count(*) as count from songs") track_estimate = cursor.fetchall()[0]['count'] -- http://mail.python.org/mailman/listinfo/python-list