change 'NAME': 'E:/Users/python/mysite/mysite.db', to 'NAME': 'mysite.db', and then try. If that does not work, delete the database file and do python manage.py syncdb again.
On Fri, Oct 19, 2012 at 11:22 AM, Hamed Tohidloo <[email protected]>wrote: > I am getting the exact same error . did you find out what was wrong ? > > On Friday, 25 March 2011 21:51:24 UTC+11, kpk wrote: >> >> I was trying out the tutorial "Writing your first Django app, part 1" >> at >> http://docs.djangoproject.com/**en/1.3/intro/tutorial01/<http://docs.djangoproject.com/en/1.3/intro/tutorial01/>. >> >> >> The configuration is as follows: Windows XP SP2, Python 2.5.2, >> Django 1.3. >> >> The tutorial succeeded up to the stage of creating a project and >> demonstration the "Welcome to Django" page. >> But when it came to database setup I am having the following problem. >> >> I have modified the settings.py file with the following entries: >> >> 'ENGINE': 'django.db.backends.sqlite3', >> 'NAME': 'E:/Users/python/mysite/ >> mysite.db', >> >> Now when I run >> python manage.py syncdb >> I get an error DatabaseError: unable to open database file >> But the file mysite.db is created in the folder. >> The file and folder has write permission for all users. >> The full output of the command is as follows: >> >> >> E:\Users\python\mysite>python manage.py syncdb >> Traceback (most recent call last): >> File "manage.py", line 14, in <module> >> execute_manager(settings) >> File "D:\Program Files\Python25\Lib\site-**packages\django\core >> \management\__ini >> t__.py", line 438, in execute_manager >> utility.execute() >> File "D:\Program Files\Python25\Lib\site-**packages\django\core >> \management\__ini >> t__.py", line 379, in execute >> self.fetch_command(subcommand)**.run_from_argv(self.argv) >> File "D:\Program Files\Python25\Lib\site-**packages\django\core >> \management\base. >> py", line 191, in run_from_argv >> self.execute(*args, **options.__dict__) >> File "D:\Program Files\Python25\Lib\site-**packages\django\core >> \management\base. >> py", line 220, in execute >> output = self.handle(*args, **options) >> File "D:\Program Files\Python25\Lib\site-**packages\django\core >> \management\base. >> py", line 351, in handle >> return self.handle_noargs(**options) >> File "D:\Program Files\Python25\Lib\site-**packages\django\core >> \management\comma >> nds\syncdb.py", line 59, in handle_noargs >> tables = connection.introspection.**table_names() >> File "D:\Program Files\Python25\Lib\site-**packages\django\db\backends >> \__init__. >> py", line 792, in table_names >> return self.get_table_list(cursor) >> File "D:\Program Files\Python25\Lib\site-**packages\django\db\backends >> \sqlite3\i >> ntrospection.py", line 51, in get_table_list >> ORDER BY name""") >> File "D:\Program Files\Python25\Lib\site-**packages\django\db\backends >> \util.py", >> line 34, in execute >> return self.cursor.execute(sql, params) >> File "D:\Program Files\Python25\Lib\site-**packages\django\db\backends >> \sqlite3\b >> ase.py", line 234, in execute >> return Database.Cursor.execute(self, query, params) >> django.db.utils.DatabaseError: unable to open database file >> >> >> Can you pls help? Thanks in advance. >> > -- > You received this message because you are subscribed to the Google Groups > "Django users" group. > To view this discussion on the web visit > https://groups.google.com/d/msg/django-users/-/Gip5B3e_fhgJ. > To post to this group, send email to [email protected]. > 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. > -- Thanks & Regards ---------------------------- Amyth [Admin - Techstricks] Email - [email protected], [email protected] Twitter - @mytharora http://techstricks.com/ -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to [email protected]. 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.
