Friday, September 2, 2011

Re: problem with syncdb and MyQSL

On Sep 2, 12:37 pm, "Yves S. Garret" <yoursurrogate...@gmail.com>
wrote:
> Show me your settings.py file, just post all of it.
>

Please see my settings.py file below. I "X's" out the password etc....

DEBUG = True
TEMPLATE_DEBUG = DEBUG

ADMINS = (
# ('Your Name', 'your_email@example.com'),
)

MANAGERS = ADMINS

DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql', # Add
'postgresql_psycopg2', 'postgresql', 'mysql', 'sqlite3' or 'oracle'.
'NAME': 'XXXXXXXXXX', # Or path to
database file if using sqlite3.
'USER': 'XXXXXXX', # Not used with
sqlite3.
'PASSWORD': 'XXXXXXXXX', # Not used with
sqlite3.
'HOST': 'XXX', # Set to empty string for
localhost. Not used with sqlite3.
'PORT': 'XXX', # Set to empty string for
default. Not used with sqlite3.
}
}

# Local time zone for this installation. Choices can be found here:
# http://en.wikipedia.org/wiki/List_of_tz_zones_by_name
# although not all choices may be available on all operating systems.
# On Unix systems, a value of None will cause Django to use the same
# timezone as the operating system.
# If running in a Windows environment this must be set to the same as
your
# system time zone.
TIME_ZONE = 'America/New_York'

# Language code for this installation. All choices can be found here:
# http://www.i18nguy.com/unicode/language-identifiers.html
LANGUAGE_CODE = 'en-us'

SITE_ID = 1

# If you set this to False, Django will make some optimizations so as
not
# to load the internationalization machinery.
USE_I18N = True

# If you set this to False, Django will not format dates, numbers and
# calendars according to the current locale
USE_L10N = True

# Absolute filesystem path to the directory that will hold user-
uploaded files.
# Example: "/home/media/media.lawrence.com/media/"
MEDIA_ROOT = ''

# URL that handles the media served from MEDIA_ROOT. Make sure to use
a
# trailing slash.
# Examples: "http://media.lawrence.com/media/", "http://example.com/
media/
"
MEDIA_URL = ''

# Absolute path to the directory static files should be collected to.
# Don't put anything in this directory yourself; store your static
files
# in apps' "static/" subdirectories and in STATICFILES_DIRS.
# Example: "/home/media/media.lawrence.com/static/"
STATIC_ROOT = ''

# URL prefix for static files.
# Example: "http://media.lawrence.com/static/"
STATIC_URL = '/static/'

# URL prefix for admin static files -- CSS, JavaScript and images.
# Make sure to use a trailing slash.
# Examples: "http://foo.com/static/admin/", "/static/admin/".
ADMIN_MEDIA_PREFIX = '/static/admin/'

# Additional locations of static files
STATICFILES_DIRS = (
# Put strings here, like "/home/html/static" or "C:/www/django/
static".
# Always use forward slashes, even on Windows.
# Don't forget to use absolute paths, not relative paths.
)

# List of finder classes that know how to find static files in
# various locations.
STATICFILES_FINDERS = (
'django.contrib.staticfiles.finders.FileSystemFinder',
'django.contrib.staticfiles.finders.AppDirectoriesFinder',
# 'django.contrib.staticfiles.finders.DefaultStorageFinder',
)

# Make this unique, and don't share it with anybody.
SECRET_KEY = 'wd1j5w0mku10#eycqlb)1f4gj8)1o*wqi=il2uobpb_(s5ncps'

# List of callables that know how to import templates from various
sources.
TEMPLATE_LOADERS = (
'django.template.loaders.filesystem.Loader',
'django.template.loaders.app_directories.Loader',
# 'django.template.loaders.eggs.Loader',
)

MIDDLEWARE_CLASSES = (
'django.middleware.common.CommonMiddleware',
'django.contrib.sessions.middleware.SessionMiddleware',
'django.middleware.csrf.CsrfViewMiddleware',
'django.contrib.auth.middleware.AuthenticationMiddleware',
'django.contrib.messages.middleware.MessageMiddleware',
)

ROOT_URLCONF = 'mysite2.urls'

TEMPLATE_DIRS = (
# Put strings here, like "/home/html/django_templates" or "C:/www/
django/templates".
# Always use forward slashes, even on Windows.
# Don't forget to use absolute paths, not relative paths.
)

INSTALLED_APPS = (
#'django.contrib.auth',
#'django.contrib.contenttypes',
#'django.contrib.sessions',
#'django.contrib.sites',
#'django.contrib.messages',
#'django.contrib.staticfiles',
'polls'
# Uncomment the next line to enable the admin:
# 'django.contrib.admin',
# Uncomment the next line to enable admin documentation:
# 'django.contrib.admindocs',
)

# A sample logging configuration. The only tangible logging
# performed by this configuration is to send an email to
# the site admins on every HTTP 500 error.
# See http://docs.djangoproject.com/en/dev/topics/logging for
# more details on how to customize your logging configuration.
LOGGING = {
'version': 1,
'disable_existing_loggers': False,
'handlers': {
'mail_admins': {
'level': 'ERROR',
'class': 'django.utils.log.AdminEmailHandler'
}
},
'loggers': {
'django.request': {
'handlers': ['mail_admins'],
'level': 'ERROR',
'propagate': True,
},
}
}
>
>
>
>
>
> On Fri, Sep 2, 2011 at 11:38 AM, John <johnhboudr...@gmail.com> wrote:
> > I am a total noob so forgive my ignorance, but I have been going
> > through the Django tutorial -
> >https://docs.djangoproject.com/en/1.3/intro/tutorial01/
>
> > I am at the point in the tutorial where I run the following command:
>
> > C:\Python27>python c:\python27\mysite2\manage.py syncdb
> > Creating tables ...
> > Creating table polls_poll
> > Traceback (most recent call last):
> >  File "c:\python27\mysite2\manage.py", line 14, in <module>
> >    execute_manager(settings)
> >  File "C:\Python27\lib\site-packages\django\core\management
> > \__init__.py", line
> > 438, in execute_manager
> >    utility.execute()
> >  File "C:\Python27\lib\site-packages\django\core\management
> > \__init__.py", line
> > 379, in execute
> >    self.fetch_command(subcommand).run_from_argv(self.argv)
> >  File "C:\Python27\lib\site-packages\django\core\management\base.py",
> > line 191,
> >  in run_from_argv
> >    self.execute(*args, **options.__dict__)
> >  File "C:\Python27\lib\site-packages\django\core\management\base.py",
> > line 220,
> >  in execute
> >    output = self.handle(*args, **options)
> >  File "C:\Python27\lib\site-packages\django\core\management\base.py",
> > line 351,
> >  in handle
> >    return self.handle_noargs(**options)
> >  File "C:\Python27\lib\site-packages\django\core\management\commands
> > \syncdb.py"
> > , line 101, in handle_noargs
> >    cursor.execute(statement)
> >  File "C:\Python27\lib\site-packages\django\db\backends\util.py",
> > line 34, in e
> > xecute
> >    return self.cursor.execute(sql, params)
> >  File "C:\Python27\lib\site-packages\django\db\backends\mysql
> > \base.py", line 86
> > , in execute
> >    return self.cursor.execute(query, args)
> >  File "C:\Python27\lib\site-packages\MySQLdb\cursors.py", line 174,
> > in execute
> >    self.errorhandler(self, exc, value)
> >  File "C:\Python27\lib\site-packages\MySQLdb\connections.py", line
> > 36, in defau
> > lterrorhandler
> >    raise errorclass, errorvalue
> > _mysql_exceptions.InterfaceError: (-1, 'error totally whack')
>
> > Can someone help?
>
> > I really appreciate it.
>
> > --
> > 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+unsubscribe@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+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.

No comments:

Post a Comment