Friday, September 2, 2011

Re: problem with syncdb and MyQSL

Great. Yes, when I first experienced the issue (prior to creating the polls app, with those APPS un-commented), I logged into the database and found the following tables had been created:

Table Rows Type Size Comments
auth_group_permissions 0 Xeround 0 B
auth_permission 0 Xeround 0 B
2 tables 0 -- 0 B


So it looks like it began creating the tables for the auth app and stopped....

On Fri, Sep 2, 2011 at 12:56 PM, Yves S. Garret <yoursurrogategod@gmail.com> wrote:
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.

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