Ask Your Question
0

Installing askbot - 1054, "Unknown column 'auth_user.tag_filter_setting' in 'field list'

asked 2013-10-28 14:36:16 -0500

marin gravatar image

Hi there,

I have installed askbot inside vritualenv using pip install askbot and I am using MySQL database.

When I ran python manage.py migrate askbot - migration failed with error: DatabaseError: (1054, "Unknown column 'auth_user.tag_filter_setting' in 'field list'")

When running server and opening page in browser app breaks with error: (1146, "Table 'askbot.askbot_thread' doesn't exist")

I was fallowing install documentation all the way. What can I do to fix this issues?

Thank you for the assistance.

Best regards, Marin

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
0

answered 2013-10-28 15:07:56 -0500

Hi,

It seems that the migrations weren't applied you can try the following command

python manage.py syncdb --all
python manage.py migrate --fake

The first command will sync the database as if there are no migrations at all, the second command will apply migrations by faking them on the database record but not actually altering the database structure.

edit flag offensive delete link more

Comments

Thank you Fitoria, it worked fine!

marin gravatar imagemarin ( 2013-10-28 18:06:58 -0500 )edit

There seems to be more problems after all. When I go to SIGN IN app breaks with error- (1054, "Unknown column 'askbot_anonymousquestion.is_anonymous' in 'field list'"). I added boolean field in database manually so it worked but when I go to create new user account via url http://127.0.0.1:8000/account/signup/?login_provider=local app breaks with database error: (1364, "Field 'response_count' doesn't have a default value"). Same thing heppens if I go and add user manualy via: python manage.py add_askbot_user

marin gravatar imagemarin ( 2013-10-29 10:40:36 -0500 )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

1 follower

Stats

Asked: 2013-10-28 14:36:16 -0500

Seen: 2,292 times

Last updated: Oct 28 '13