Установка модели | Forum | Django на русском

12 Dec. 2011, 1:59

paul.borog

Posts: 9

12 Dec. 2011, 1:59

paul.borog

Posts: 9

Делаю по переводу: http://djbook.ru/ch05s07.html

При команде python manage.py sqlall books: Traceback (most recent call last): File "manage.py", line 14, in execute_manager(settings) File "/usr/lib/python2.7/site-packages/django/core/management/init.py", line 438, in execute_manager utility.execute() File "/usr/lib/python2.7/site-packages/django/core/management/init.py", line 379, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File "/usr/lib/python2.7/site-packages/django/core/management/base.py", line 191, in run_from_argv self.execute(args, options.dict) File "/usr/lib/python2.7/site-packages/django/core/management/base.py", line 220, in execute output = self.handle(*args, options) File "/usr/lib/python2.7/site-packages/django/core/management/base.py", line 286, in handle app_output = self.handle_app(app, *options) File "/usr/lib/python2.7/site-packages/django/core/management/commands/sqlall.py", line 19, in handle_app return u'\n'.join(sql_all(app, self.style, connections[options.get('database', DEFAULT_DB_ALIAS)])).encode('utf-8') File "/usr/lib/python2.7/site-packages/django/core/management/sql.py", line 146, in sql_all return sql_create(app, style, connection) + sql_custom(app, style, connection) + sql_indexes(app, style, connection) File "/usr/lib/python2.7/site-packages/django/core/management/sql.py", line 26, in sql_create tables = connection.introspection.table_names() File "/usr/lib/python2.7/site-packages/django/db/backends/init.py", line 792, in table_names return self.get_table_list(cursor) File "/usr/lib/python2.7/site-packages/django/db/backends/sqlite3/introspection.py", line 51, in get_table_list ORDER BY name""") File "/usr/lib/python2.7/site-packages/django/db/backends/util.py", line 34, in execute return self.cursor.execute(sql, params) File "/usr/lib/python2.7/site-packages/django/db/backends/sqlite3/base.py", line 234, in execute return Database.Cursor.execute(self, query, params) django.db.utils.DatabaseError: file is encrypted or is not a database

Что не так?

Answer | 0

12 Dec. 2011, 3:10 alerion Posts: 5750 Location: Львов	12 Dec. 2011, 3:10 alerion Posts: 5750 Location: Львов Может быть настройки подключения к БД не верные. Никогда не использовал эту команду, может syncdb перед ней сделать, раз она к базе лезет. Фиксю баги по трейсбеку.
	Answer \| 0

12 Dec. 2011, 3:26

paul.borog

Posts: 9

12 Dec. 2011, 3:26

paul.borog

Posts: 9

У меня sqlite. При python manage.py syncdb: Traceback (most recent call last): File "manage.py", line 14, in execute_manager(settings) File "/usr/lib/python2.7/site-packages/django/core/management/init.py", line 438, in execute_manager utility.execute() File "/usr/lib/python2.7/site-packages/django/core/management/init.py", line 379, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File "/usr/lib/python2.7/site-packages/django/core/management/base.py", line 191, in run_from_argv self.execute(args, options.dict) File "/usr/lib/python2.7/site-packages/django/core/management/base.py", line 220, in execute output = self.handle(*args, options) File "/usr/lib/python2.7/site-packages/django/core/management/base.py", line 351, in handle return self.handle_noargs(*options) File "/usr/lib/python2.7/site-packages/django/core/management/commands/syncdb.py", line 59, in handle_noargs tables = connection.introspection.table_names() File "/usr/lib/python2.7/site-packages/django/db/backends/init.py", line 792, in table_names return self.get_table_list(cursor) File "/usr/lib/python2.7/site-packages/django/db/backends/sqlite3/introspection.py", line 51, in get_table_list ORDER BY name""") File "/usr/lib/python2.7/site-packages/django/db/backends/util.py", line 34, in execute return self.cursor.execute(sql, params) File "/usr/lib/python2.7/site-packages/django/db/backends/sqlite3/base.py", line 234, in execute return Database.Cursor.execute(self, query, params) django.db.utils.DatabaseError: file is encrypted or is not a database

Тоже самое, вроде как. А если python manage.py validate: 0 errors found

А так же python manage.py shell: >>> from django.db import connection >>> cursor = connection.cursor() >>>

Вроде с БД всё ок выходит.

Answer | 0

12 Dec. 2011, 15:10 alerion Posts: 5750 Location: Львов	12 Dec. 2011, 15:10 alerion Posts: 5750 Location: Львов То что sqlite и так понятно с "backends/sqlite3/base.py". Может вы лучше settings.DATABASES покажите. Фиксю баги по трейсбеку.
	Answer \| 0

12 Dec. 2011, 20:08

paul.borog

Posts: 9

12 Dec. 2011, 20:08

paul.borog

Posts: 9

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.sqlite3', # Add 'postgresql_psycopg2', 'postgresql', 'mysql', 'sqlite3' or 'oracle'.
        'NAME': '/home/user/code/mysite/sqlite.db',                      # Or path to database file if using sqlite3.
        '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.
    }
}

Answer | 0

12 Dec. 2011, 20:34 RaD Posts: 2826 Location: Снегири, МО	12 Dec. 2011, 20:34 RaD Posts: 2826 Location: Снегири, МО Покажите результат этих команд: `rm /home/user/code/mysite/sqlite.db python manage.py syncdb` Если ничего не помогает, прочтите документацию, наконец!
	Answer \| 0

12 Dec. 2011, 20:53

paul.borog

Posts: 9

12 Dec. 2011, 20:53

paul.borog

Posts: 9

python manage.py syncdb
Creating tables ...
Creating table books_publisher
Creating table books_author
Creating table books_book_authors
Creating table books_book
Installing custom SQL ...
Installing indexes ...
No fixtures found.

Спасибо!

Updated 12 Dec. 2011, 20:54 by paul.borog.

Answer | 0

13 Dec. 2011, 15:57 RaD Posts: 2826 Location: Снегири, МО	13 Dec. 2011, 15:57 RaD Posts: 2826 Location: Снегири, МО Теперь sqlall. Если ничего не помогает, прочтите документацию, наконец!
	Answer \| 0