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.

Reply via email to