Re: SQLite - unsupported file format
For reference purposes: http://jtauber.com/blog/2006/11/25/incompatible_sqlite_in_os_x_and_python On May 15, 9:17 pm, Panos Laganakos <[EMAIL PROTECTED]> wrote: > I haven't installed any pysqlite versions since I moved to 2.5 (from > OS X's default 2.3) Python, as sqlite3 is included in the lib module > by default. > > I uploaded the db on the production server though, and sqlite3 client: > 3.3.5 seems to open the file just fine. So as you mentioned it must be > a type mismatch? I'll if I can an updated binary of SQLite3 > 3.1.3 > for OS X. > > On May 15, 1:47 pm, Lars Stavholm <[EMAIL PROTECTED]> wrote: > > > Panos Laganakos wrote: > > > OS: Mac OS X - 10.4 > > > SQLite: 3.1.3 > > > Django: 0.96 > > > Python: 2.5 > > > > I've set the DATABASE_ENGINE to 'sqlite3', and the db gets created > > > when I call > > > > $manage.py syncdb > > > > And the project/apps all work fine. > > > > When I try to connect to it from the commandline 'sqlite3' tool, or > > > pipe manage.py clearsql [appname], etc. I get an 'error: unsupported > > > file format', when I try to execute any statement or view tables etc. > > > > Same thing happens if I try to pipe output into sqlite3, ie: > > > > $manage.py sqlclear [appname] | sqlite3 my.db > > > > Can't figure out what seems to be the problem here. > > > Version mismatch maybe? Try sqlite/sqlite2 on the created db. > > If that works, the db is sqlite version 2. > > What version of python sqlite bindings are you using? > > I have the following and it works just great: > > > SuSE Linux 10.2 > > sqlite 3.3.8 > > Django from SVN a week ago. > > Python 2.5 > > pysqlite 2.3.2 > > > Cheers > > /Lars --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~--~~~~--~~--~--~---
Re: SQLite - unsupported file format
I haven't installed any pysqlite versions since I moved to 2.5 (from OS X's default 2.3) Python, as sqlite3 is included in the lib module by default. I uploaded the db on the production server though, and sqlite3 client: 3.3.5 seems to open the file just fine. So as you mentioned it must be a type mismatch? I'll if I can an updated binary of SQLite3 > 3.1.3 for OS X. On May 15, 1:47 pm, Lars Stavholm <[EMAIL PROTECTED]> wrote: > Panos Laganakos wrote: > > OS: Mac OS X - 10.4 > > SQLite: 3.1.3 > > Django: 0.96 > > Python: 2.5 > > > I've set the DATABASE_ENGINE to 'sqlite3', and the db gets created > > when I call > > > $manage.py syncdb > > > And the project/apps all work fine. > > > When I try to connect to it from the commandline 'sqlite3' tool, or > > pipe manage.py clearsql [appname], etc. I get an 'error: unsupported > > file format', when I try to execute any statement or view tables etc. > > > Same thing happens if I try to pipe output into sqlite3, ie: > > > $manage.py sqlclear [appname] | sqlite3 my.db > > > Can't figure out what seems to be the problem here. > > Version mismatch maybe? Try sqlite/sqlite2 on the created db. > If that works, the db is sqlite version 2. > What version of python sqlite bindings are you using? > I have the following and it works just great: > > SuSE Linux 10.2 > sqlite 3.3.8 > Django from SVN a week ago. > Python 2.5 > pysqlite 2.3.2 > > Cheers > /Lars --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~--~~~~--~~--~--~---
Re: SQLite - unsupported file format
Panos Laganakos wrote: > OS: Mac OS X - 10.4 > SQLite: 3.1.3 > Django: 0.96 > Python: 2.5 > > I've set the DATABASE_ENGINE to 'sqlite3', and the db gets created > when I call > > $manage.py syncdb > > And the project/apps all work fine. > > When I try to connect to it from the commandline 'sqlite3' tool, or > pipe manage.py clearsql [appname], etc. I get an 'error: unsupported > file format', when I try to execute any statement or view tables etc. > > Same thing happens if I try to pipe output into sqlite3, ie: > > $manage.py sqlclear [appname] | sqlite3 my.db > > > Can't figure out what seems to be the problem here. Version mismatch maybe? Try sqlite/sqlite2 on the created db. If that works, the db is sqlite version 2. What version of python sqlite bindings are you using? I have the following and it works just great: SuSE Linux 10.2 sqlite 3.3.8 Django from SVN a week ago. Python 2.5 pysqlite 2.3.2 Cheers /Lars --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~--~~~~--~~--~--~---
SQLite - unsupported file format
OS: Mac OS X - 10.4 SQLite: 3.1.3 Django: 0.96 Python: 2.5 I've set the DATABASE_ENGINE to 'sqlite3', and the db gets created when I call $manage.py syncdb And the project/apps all work fine. When I try to connect to it from the commandline 'sqlite3' tool, or pipe manage.py clearsql [appname], etc. I get an 'error: unsupported file format', when I try to execute any statement or view tables etc. Same thing happens if I try to pipe output into sqlite3, ie: $manage.py sqlclear [appname] | sqlite3 my.db Can't figure out what seems to be the problem here. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~--~~~~--~~--~--~---