On Feb 26, 9:25 am, spa...@gmail.com wrote: > Have you tried updating the DB path in settings.py and creating a new db > file? > > > > > > > > > > On Sat, Feb 26, 2011 at 2:30 AM, Andre Terra <andrete...@gmail.com> wrote: > > Try appending the custom location to the beginning of your PYTHONPATH. > > > Sincerely, > > Andre Terra > > > On Fri, Feb 25, 2011 at 5:28 PM, Tim <jtim.arn...@gmail.com> wrote: > > >> hi, > >> I'm using Django 1.2.3 and I have a new sqlite (3.7.5) installed in a > >> custom location. > >> There is an old sqlite (3.6.23.1) installed in /usr/local/bin/. > > >> How do I tell Django to use the new sqlite? I'm on FreeBSD 8.0. > > >> thanks, > >> --Tim Arnold > > >> -- > >> 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 > >> django-users+unsubscr...@googlegroups.com. > >> For more options, visit this group at > >>http://groups.google.com/group/django-users?hl=en. > > > -- > > 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 > > django-users+unsubscr...@googlegroups.com. > > For more options, visit this group at > >http://groups.google.com/group/django-users?hl=en. > > --http://spawgi.wordpress.com > We can do it and do it better.
hi, I converted my original mysql database to sqlite3. Firefox sqlite extension can view the database and it looks okay. It looks like the Django settings are okay to me--here they are: DATABASES = { 'default': { 'ENGINE': 'django.db.backends.sqlite3', 'NAME': '/Apps/web/myproject.sqlite', 'USER': '', 'PASSWORD': '', 'HOST': '', 'PORT': '', } } And here are the dir permissions of /Apps/web: drwxrwxrwx 4 tiarno wheel 4096 Feb 25 14:54 ./ drwxr-xr-x 8 tiarno wheel 4096 Feb 23 17:24 ../ drwxrwxrwx 5 tiarno wheel 4096 Feb 25 15:16 django/ drwxr-xr-x 2 tiarno wheel 4096 Sep 17 15:45 home/ -rwxrwxrwx 1 tiarno wheel 1588224 Feb 25 13:51 myproject.sqlite* I run validate and get '0 errors found'. I run syncdb and get this: python manage.py syncdb Traceback (most recent call last): File "manage.py", line 11, in <module> execute_manager(settings) File "/usr/local/lib/python2.7/site-packages/django/core/management/ __init__.py", line 438, in execute_manager utility.execute() File "/usr/local/lib/python2.7/site-packages/django/core/management/ __init__.py", line 379, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File "/usr/local/lib/python2.7/site-packages/django/core/management/ base.py", line 191, in run_from_argv self.execute(*args, **options.__dict__) File "/usr/local/lib/python2.7/site-packages/django/core/management/ base.py", line 220, in execute output = self.handle(*args, **options) File "/usr/local/lib/python2.7/site-packages/django/core/management/ base.py", line 351, in handle return self.handle_noargs(**options) File "/usr/local/lib/python2.7/site-packages/django/core/management/ commands/syncdb.py", line 55, in handle_noargs tables = connection.introspection.table_names() File "/usr/local/lib/python2.7/site-packages/django/db/backends/ __init__.py", line 498, in table_names return self.get_table_list(cursor) File "/usr/local/lib/python2.7/site-packages/django/db/backends/ sqlite3/introspection.py", line 51, in get_table_list ORDER BY name""") File "/usr/local/lib/python2.7/site-packages/django/db/backends/ util.py", line 15, in execute return self.cursor.execute(sql, params) File "/usr/local/lib/python2.7/site-packages/django/db/backends/ sqlite3/base.py", line 200, in execute return Database.Cursor.execute(self, query, params) django.db.utils.DatabaseError: disk I/O error thanks for any ideas, --Tim -- 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 django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.