Friday, September 2, 2011

Re: problem with syncdb and MyQSL

I'm curious, maybe someone knows this who has actually seen the code behind the scenes, but is this actually true?  When Django says "Creating tables ...           Creating table polls_poll", does that mean it's already connected to the database and working on it or is it a message that's produced before actually connecting?

John, do you have a way of finding out for sure if your mysql database is being connected to and a database is being created by django?  Did you actually look in the database and verify that this is the case?

On Fri, Sep 2, 2011 at 12:46 PM, John Boudreau <johnhboudreau@gmail.com> wrote:
Yes I have. When I run the syncdb command it starts creating the tables then hangs....

So it is connecting to the MySql DB I created...


On Fri, Sep 2, 2011 at 12:43 PM, chandrakant kumar <k.03chandra@gmail.com> wrote:
On 9/2/11, John <johnhboudreau@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.
>
>

Have you created the database in mysql? use mysqladmin to create
databse that you entered in settings.py
--

Chandrakant Kumar
irc - k03chandra @ #freenode

--
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.

--
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