Re: Problem re-creating SQLite database with manage.py...

[Ramiro Morales]

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.

Re: Problem re-creating SQLite database with manage.py...

[eldo]

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.