First time here? Check out the FAQ!
0

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

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

marin's avatar
3
marin
asked 2013-10-28 14:36:16 -0500
edit flag offensive 0 remove flag close merge delete

Comments

add a comment see more comments

1 Answer

0

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.

Fitoria's avatar
1.1k
Fitoria
answered 2013-10-28 15:07:56 -0500
edit flag offensive 0 remove flag delete link

Comments

Thank you Fitoria, it worked fine!

marin's avatar marin (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's avatar marin (2013-10-29 10:40:36 -0500) edit
add a comment see more comments