Problem re-creating SQLite database with manage.py...
I'm trying to re-create my SQLite database from scratch. I am now receiving the following error message from: *(foobarr)jmarcedwards@jmelinux:~/git/django-nimbis/projects/dev$ python ./manage.py syncdb Syncing... Traceback (most recent call last): File "./manage.py", line 11, in execute_manager(settings) File "/home/jmarcedwards/foobarr/local/lib/python2.7/site-packages/django/core/management/__init__.py", line 438, in execute_manager utility.execute() File "/home/jmarcedwards/foobarr/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 "/home/jmarcedwards/foobarr/local/lib/python2.7/site-packages/django/core/management/base.py", line 191, in run_from_argv self.execute(*args, **options.__dict__) File "/home/jmarcedwards/foobarr/local/lib/python2.7/site-packages/django/core/management/base.py", line 220, in execute output = self.handle(*args, **options) File "/home/jmarcedwards/foobarr/local/lib/python2.7/site-packages/django/core/management/base.py", line 351, in handle return self.handle_noargs(**options) File "/home/jmarcedwards/foobarr/local/lib/python2.7/site-packages/South-0.7.3-py2.7.egg/south/management/commands/syncdb.py", line 87, in handle_noargs db.connection_init() File "/home/jmarcedwards/foobarr/local/lib/python2.7/site-packages/South-0.7.3-py2.7.egg/south/db/mysql.py", line 38, in connection_init cursor = self._get_connection().cursor() File "/home/jmarcedwards/foobarr/local/lib/python2.7/site-packages/django/db/backends/dummy/base.py", line 15, in complain raise ImproperlyConfigured("You haven't set the database ENGINE setting yet.") django.core.exceptions.ImproperlyConfigured: You haven't set the database ENGINE setting yet. (foobarr)jmarcedwards@jmelinux:~/git/django-nimbis/projects/dev$ ls celerybeat-schedule fixtures __init__.pycmanage.py requirements.txt settings.py static urls.pyc env.sh __init__.py local_tests.py manage.pyc run_server.sh settings.pyc urls.py (foobarr)jmarcedwards@jmelinux:~/git/django-nimbis/projects/dev$ * sys.path.insert(0, PROJDIR) sys.path.insert(0, APPSDIR) # sqlite database for testing DATABASES = { 'default': { 'ENGINE': 'django.db.backends.sqlite3', 'NAME': os.path.join(PROJDIR, 'db.sqlite'), } } SOUTH_DATABASE_ADAPTERS = { 'default': "south.db.mysql" } I am working from within the directory where my manage.py and settings.py are located. It seems that perhaps my settings.py file is not being picked up from the same directory. I'm getting the same error inside of my Eclipse Django PyDev environment. Are there any more direct, manual process for invoking the syncdb with the settings.py and generating my database? Regards, Marc -- J. Marc Edwards Lead Architect - Semiconductor Design Portals Nimbis Services, Inc. Skype: (919) 747-3775 Cell: (919) 345-1021 Fax: (919) 882-8602 marc.edwa...@nimbisservices.com www.nimbisservices.com -- 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. <>
Re: Problem re-creating SQLite database with manage.py...
may be you shold change the settings become like this one in settings.py file == DATABASES = { 'default': { 'ENGINE': 'sqlite3', <-- change it to sqlite3 'NAME': '/home/[linux_user]/[django_project]/[database_name].db', <- change the value to your project location with dbname 'USER': '', # Not used with sqlite3. 'PASSWORD': '', # Not used with sqlite3. 'HOST': '', # Set to empty string for localhost. Not used with sqlite3. 'PORT': '', # Set to empty string for default. Not used with sqlite3. } } == hope it solve your problem bro On Sat, 17 Dec 2011 03:44:56 +0700, J. Marc Edwards wrote: I'm trying to re-create my SQLite database from scratch. I am now receiving the following error message from: *(foobarr)jmarcedwards@jmelinux:~/git/django-nimbis/projects/dev$ python ./manage.py syncdb Syncing... Traceback (most recent call last): File "./manage.py", line 11, in execute_manager(settings) File "/home/jmarcedwards/foobarr/local/lib/python2.7/site-packages/django/core/management/__init__.py", line 438, in execute_manager utility.execute() File "/home/jmarcedwards/foobarr/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 "/home/jmarcedwards/foobarr/local/lib/python2.7/site-packages/django/core/management/base.py", line 191, in run_from_argv self.execute(*args, **options.__dict__) File "/home/jmarcedwards/foobarr/local/lib/python2.7/site-packages/django/core/management/base.py", line 220, in execute output = self.handle(*args, **options) File "/home/jmarcedwards/foobarr/local/lib/python2.7/site-packages/django/core/management/base.py", line 351, in handle return self.handle_noargs(**options) File "/home/jmarcedwards/foobarr/local/lib/python2.7/site-packages/South-0.7.3-py2.7.egg/south/management/commands/syncdb.py", line 87, in handle_noargs db.connection_init() File "/home/jmarcedwards/foobarr/local/lib/python2.7/site-packages/South-0.7.3-py2.7.egg/south/db/mysql.py", line 38, in connection_init cursor = self._get_connection().cursor() File "/home/jmarcedwards/foobarr/local/lib/python2.7/site-packages/django/db/backends/dummy/base.py", line 15, in complain raise ImproperlyConfigured("You haven't set the database ENGINE setting yet.") django.core.exceptions.ImproperlyConfigured: You haven't set the database ENGINE setting yet. (foobarr)jmarcedwards@jmelinux:~/git/django-nimbis/projects/dev$ ls celerybeat-schedule fixtures __init__.pycmanage.py requirements.txt settings.py static urls.pyc env.sh __init__.py local_tests.py manage.pyc run_server.sh settings.pyc urls.py (foobarr)jmarcedwards@jmelinux:~/git/django-nimbis/projects/dev$ * sys.path.insert(0, PROJDIR) sys.path.insert(0, APPSDIR) # sqlite database for testing DATABASES = { 'default': { 'ENGINE': 'django.db.backends.sqlite3', 'NAME': os.path.join(PROJDIR, 'db.sqlite'), } } SOUTH_DATABASE_ADAPTERS = { 'default': "south.db.mysql" } I am working from within the directory where my manage.py and settings.py are located. It seems that perhaps my settings.py file is not being picked up from the same directory. I'm getting the same error inside of my Eclipse Django PyDev environment. Are there any more direct, manual process for invoking the syncdb with the settings.py and generating my database? Regards, Marc -- Using Opera's revolutionary email client: http://www.opera.com/mail/ -- 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.
Re: Problem re-creating SQLite database with manage.py...
On Fri, Dec 16, 2011 at 5:44 PM, J. Marc Edwards wrote: > > # sqlite database for testing > DATABASES = { > 'default': { > 'ENGINE': 'django.db.backends.sqlite3', > 'NAME': os.path.join(PROJDIR, 'db.sqlite'), > } > } > > SOUTH_DATABASE_ADAPTERS = { > 'default': "south.db.mysql" > } You are: * Telling Django to use the SQLite3 backend * South to use its MySQL support code. * Getting the following text in the next to last line of the traceback: File "/home/jmarcedwards/foobarr/local/lib/python2.7/site-packages/South-0.7.3-py2.7.egg/south/db/mysql.py", line 38, in connection_init cursor = self._get_connection().cursor() Note the python module it mentions is /south/db/mysql.py, that's what tracebacks are great for, if you read them you quickly can get clues about what's wrong with your setup. -- Ramiro Morales -- 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.