OperationalError at /account/signin/
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: http://127.0.1.1:8000/account/signin/?next=/
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/connections.py in defaulterrorhandler, line 36
Python Executable: /usr/bin/python
Python Version: 2.7.3
Comments
2 Answers
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) ;
Comments
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-08-24 15:25:25 -0500
Seen: 144 times
Last updated: Dec 12 '12
Forgot to run migrations? Try "python manage.py migrate --list". Do you have any migrations that were not applied? If so, run "python manage.py migrate".
Evgeny ( 2012-08-24 15:29:48 -0500 )editThanks 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 ( 2012-08-24 15:39:15 -0500 )editHey people, I'm still stuck with this... Any help?
Pepe ( 2012-08-26 08:59:26 -0500 )editHi guys I am having the same problem and I can't install Posgres to solve the problem. Any other alternative?
Erich ( 2012-09-27 14:10:53 -0500 )editYou must have forgotten to run
Evgeny ( 2012-09-27 15:54:59 -0500 )editpython manage.py migrate