How to correctly sync database with Askbot app?
Hi,
I followed the tutorial on installing Askbot:
http://askbot.org/doc/initialize-database-tables.html
When I run "python manage.py syncdb", I get the following message in my terminal:
Not synced (use migrations): - askbot.deps.django_authopenid - askbot
I then ran the two following commands:
- python manage.py migrate askbot
- python manage.py migrate django_authopenid
But my tables are not up to date. If I try to login in my local Askbot web application, I get an error message saying "Unknown column 'askbot_anonymousanswer.question_id".
Looking at this table in MySQL, the field is named "question_post_id". My feeling is that Askbot hasn't created the right database schema.
But I don't know any alternative. Does somebody know what I did wrong? How do I know the database version is sync with the application? I couldn't find a table with the database version.
Thanks for your help
Comments
Know someone who can answer? Share a link to this question via Twitter, Facebook, LinkedIn, Identi.ca, or email.
Reliable Askbot Hosting
Create your Q&A site at askbot.com. Managed Askbot hosting at just $15/mo. Dedicated hosting, support contracts, consulting services.
create your Q&A site30 days free trial
Stats
Asked: 2012-07-15 16:41:14 -0500
Seen: 93 times
Last updated: Jul 15 '12
Please give details about your database and version. Also you could try:
And then, if you are on postgresql:
Evgeny ( 2012-07-15 16:44:34 -0500 )editWhich version of MySQL are you on? My postgres comments won't help you.
Evgeny ( 2012-07-16 22:44:06 -0500 )editThanks Evgeny for the fast answer. Unfortunately, it did not work. I'm using the community edition of MySQL. It's version is 5.5.25a. Sorry for the multiple comments. Each time I press the Enter key, it posts the comment to Askbot.
Louis-Philippe ( 2012-07-16 22:45:30 -0500 )editIn which migration do you get error? Please post traceback into your question. Also I can recommend switching to MyISAM storage engine. In the case you are using InnoDB, askbot will not work, because search relies on the MyISAM feature. Yes, enter key auto-posts the comment, try "shift enter" to add empty lines.
Evgeny ( 2012-07-16 22:48:17 -0500 )editThe database client version is libmysql - mysqlnd 5.0.8-dev - 20102224 - $Revision: 321634$
Louis-Philippe ( 2012-07-16 22:49:32 -0500 )edit