Bugs item #1733085, was opened at 2007-06-07 23:36 Message generated for change (Comment added) made by loewis You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=105470&aid=1733085&group_id=5470
Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Extension Modules Group: Platform-specific Status: Open Resolution: None Priority: 5 Private: No Submitted By: Oinopion (oinopion) >Assigned to: Anthony Baxter (anthonybaxter) Summary: sqlite3 module trigger problem Initial Comment: I and my team are building sqlite3 app and when used on Windows XP on Python 2.5.1 we get such an error: File "D:\studia\!bazy_projekt\svn2\src\muzzyk.py", line 39, in __init__ cur.executescript(scheme) OperationalError: near "NOT": syntax error while parsing http://muzzyk.googlecode.com/svn/trunk/src/scheme.sql Bug is about those triggers at the end of file. On linux or with pysqlite2 imported instead of sqlite3 everything is OK. ---------------------------------------------------------------------- >Comment By: Martin v. Löwis (loewis) Date: 2007-06-08 19:15 Message: Logged In: YES user_id=21627 Originator: NO I don't know whether it is acceptable for 2.5.x to provide new features through the underlying DLL. That's for the release manager to decide. Anthony? ---------------------------------------------------------------------- Comment By: Gerhard Häring (ghaering) Date: 2007-06-08 10:19 Message: Logged In: YES user_id=163326 Originator: NO If so, I'll do the necessary steps of course. ---------------------------------------------------------------------- Comment By: Gerhard Häring (ghaering) Date: 2007-06-08 10:19 Message: Logged In: YES user_id=163326 Originator: NO That's because the SQLite3.DLL in Windows is at version 3.3.4, which doesn't support that language construct, yet. As a workaround, just download the SQLite3.DLL from http://sqlite.org and copy it over the one in your Python installation. The real solution for Python is to update the SQLite3.DLL. Martin, can we update the SQLite3.DLL for the 2.5 branch? ---------------------------------------------------------------------- Comment By: Neal Norwitz (nnorwitz) Date: 2007-06-08 06:05 Message: Logged In: YES user_id=33168 Originator: NO Gerhard, could you take a look? I don't have windows. ---------------------------------------------------------------------- Comment By: Oinopion (oinopion) Date: 2007-06-07 23:57 Message: Logged In: YES user_id=1282560 Originator: YES File Added: scheme.sql ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=105470&aid=1733085&group_id=5470 _______________________________________________ Python-bugs-list mailing list Unsubscribe: http://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com