There hasn't database file?

asked 2010-12-09 00:58:18 -0600

suyu8776
11 ●3 ●2 ●3

There isn't whole database dump file in the project. I used script "manage.py syncdb" couldn't dump all tables.

answered 2010-12-09 01:20:56 -0600

Evgeny

13137 ●57 ●107 ●219 http://askbot.org/

updated 2010-12-09 02:27:45 -0600

Hello there. In addition to syncdb please run

python manage.py migrate

That will complete the database initialization. It is actually described in the manual. There is a link "install/docs" above in the header.

Tables for "askbot" and the login app "django_authopenid" are managed by the database migration system called "South" which provides management command migrate.

This greatly helps in upgrading the database schema.

Note that if you have other apps under the same migration system you might want to instead specify which application to migrate.

edit flag offensive delete link

Comments

Yes,i use "manage.py migrate",and then another error occur:_mysql_exceptions.OperationalError: (1025, "Error on rename of '.\\cnprog\\#sql-b4c_a0' to '.\\cnprog\\django_authopenid_userassociation' (errno: 150)")

suyu8776 ( 2010-12-09 02:29:52 -0600 )edit

Just guessing - maybe your MySQL uses InnoDB backend? I have not tested with that. Will try tomorrow. Could you try MyISAM storage? With InnoDB and others there will be problems with the full text search. Can you please also post entire stacktrace and the version of MySQL? And you could also try PostgreSQL, it is actually better.