Hey All, I was walking through the tutorial part 1 on polls. When i executed "*python manage.py sql polls*" i got this stack trace * * *Traceback (most recent call last):* * File "manage.py", line 10, in <module>* * execute_from_command_line(sys.argv)* * File "/Library/Python/2.7/site-packages/django/core/management/__init__.py", line 443, in execute_from_command_line* * utility.execute()* * File "/Library/Python/2.7/site-packages/django/core/management/__init__.py", line 382, in execute* * self.fetch_command(subcommand).run_from_argv(self.argv)* * File "/Library/Python/2.7/site-packages/django/core/management/base.py", line 196, in run_from_argv* * self.execute(*args, **options.__dict__)* * File "/Library/Python/2.7/site-packages/django/core/management/base.py", line 232, in execute* * output = self.handle(*args, **options)* * File "/Library/Python/2.7/site-packages/django/core/management/base.py", line 304, in handle* * app_output = self.handle_app(app, **options)* * File "/Library/Python/2.7/site-packages/django/core/management/commands/sql.py", line 19, in handle_app* * return u'\n'.join(sql_create(app, self.style, connections[options.get('database')])).encode('utf-8')* * File "/Library/Python/2.7/site-packages/django/core/management/sql.py", line 26, in sql_create* * tables = connection.introspection.table_names()* * File "/Library/Python/2.7/site-packages/django/db/backends/__init__.py", line 910, in table_names* * return self.get_table_list(cursor)* * File "/Library/Python/2.7/site-packages/django/db/backends/mysql/introspection.py", line 33, in get_table_list* * cursor.execute("SHOW TABLES")* * File "/Library/Python/2.7/site-packages/django/db/backends/util.py", line 40, in execute* * return self.cursor.execute(sql, params)* * File "/Library/Python/2.7/site-packages/django/db/backends/mysql/base.py", line 114, in execute* * return self.cursor.execute(query, args)* * File "/Library/Python/2.7/site-packages/MySQL_python-1.2.4b4-py2.7-macosx-10.8-intel.egg/MySQLdb/cursors.py", line 202, in execute* * self.errorhandler(self, exc, value)* * File "/Library/Python/2.7/site-packages/MySQL_python-1.2.4b4-py2.7-macosx-10.8-intel.egg/MySQLdb/connections.py", line 36, in defaulterrorhandler* * raise errorclass, errorvalue* *django.db.utils.DatabaseError: (1046, 'No database selected')*
I've been googling and everyone says that i don't have access to the mysql database for "polls" but i was able to access the database when i entered *mysql -u root -h localhost polls* This is how my settings.py looks like for database: *DATABASES = {* * 'default': {* * 'ENGINE': 'django.db.backends.mysql', # Add 'postgresql_psycopg2', 'mysql', 'sqlite3' or 'oracle'.* * 'NAME': '', # Or path to database file if using sqlite3.* * 'USER': 'root', # Not used with sqlite3.* * 'PASSWORD': '', # Not used with sqlite3.* * 'HOST': 'localhost', # Set to empty string for localhost. Not used with sqlite3.* * 'PORT': '', # Set to empty string for default. Not used with sqlite3.* * }* *}* Also, here is to show that i actually selected the database *mysql> use test* *Database changed* *mysql> GRANT ALL ON test.* TO 'testuser'@'localhost';* *Query OK, 0 rows affected (0.08 sec)* * * *mysql> quit* *Bye* my mac has been finicky with databases on RoR and so i am trying to switch to django. Does anyone know where the problem is? -Praveen -- You received this message because you are subscribed to the Google Groups "Django users" group. To view this discussion on the web visit https://groups.google.com/d/msg/django-users/-/Z_jpiK5Q894J. 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.