Ask Your Question

OperationalError at /account/signin/

asked 2012-08-24 15:25:25 -0600

Pepe's avatar

Hi there, I'm getting this error when trying to sign in the first user right after installing askbot. Do you know what is it about?

OperationalError at /account/signin/

(1054, "Unknown column 'askbot_anonymousanswer.question_id' in 'field list'")

Request Method:     GET
Request URL:
Django Version:     1.3.1
Exception Type:     OperationalError
Exception Value:    

(1054, "Unknown column 'askbot_anonymousanswer.question_id' in 'field list'")

Exception Location:     /usr/lib/python2.7/dist-packages/MySQLdb/ in defaulterrorhandler, line 36
Python Executable:  /usr/bin/python
Python Version:     2.7.3
edit retag flag offensive close merge delete


Forgot to run migrations? Try "python migrate --list". Do you have any migrations that were not applied? If so, run "python migrate".

Evgeny's avatar Evgeny  ( 2012-08-24 15:29:48 -0600 )edit

Thanks for your quick response. I already did that. I've tried to run it again but it did not solve the problem. Any other suggestion?

Pepe's avatar Pepe  ( 2012-08-24 15:39:15 -0600 )edit

Hey people, I'm still stuck with this... Any help?

Pepe's avatar Pepe  ( 2012-08-26 08:59:26 -0600 )edit

Hi guys I am having the same problem and I can't install Posgres to solve the problem. Any other alternative?

Erich's avatar Erich  ( 2012-09-27 14:10:53 -0600 )edit

You must have forgotten to run python migrate

Evgeny's avatar Evgeny  ( 2012-09-27 15:54:59 -0600 )edit

2 Answers

Sort by ยป oldest newest most voted

answered 2012-11-01 11:53:21 -0600

sysko's avatar

updated 2012-11-01 12:00:21 -0600

It certainly due to the fact that before MySQL was using by default MyISAM as it's storage engine and the version 5.5 now use InnoDB, it seems to create some uncompatibility on altering table containing foreign key constraint (i.e it works with myisam but not innodb) so the migrate fails

doing this solve the issue for me (I know it's a work around, but it may helps to create a more generic solution)

open a MySQL shell (or phpmyadmin whatsoever) and run

 show create table askbot_anonymousanswer;

you should see a line that looks like this

CONSTRAINT `question_post_id_refs_id_648edfb25e596e3` FOREIGN KEY (`question_post_id`) REFERENCES `askbot_post` (`id`)

note the name of this question_post_id_refs_id_648edfb25e596e3

and then run

alter table askbot_anonymousanswer drop foreign key   question_post_id_refs_id_648edfb25e596e3 ;
alter table askbot_anonymousanswer change question_post_id question_id int(11) ;
edit flag offensive delete link more


It should be possible now to run Askbot on InnoDB if Haystack is used for search, but this has not been tested yet.

Evgeny's avatar Evgeny  ( 2012-11-01 12:35:32 -0600 )edit

how can we add this to a migration so when we run migration it will magically work :)

SocialQA's avatar SocialQA  ( 2013-10-22 19:00:18 -0600 )edit

answered 2012-08-27 10:13:09 -0600

Pepe's avatar

Ok, finally I fixed this by running Postgresql instead of Mysql to create the database. ;)

edit flag offensive delete link more


@Pepe, which version of MySQL did you have? Thank you.

Evgeny's avatar Evgeny  ( 2012-08-27 10:19:40 -0600 )edit

Current version, I think it is 5.5.27

Pepe's avatar Pepe  ( 2012-08-27 14:54:53 -0600 )edit

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Question Tools


Asked: 2012-08-24 15:25:25 -0600

Seen: 1,095 times

Last updated: Dec 12 '12