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

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.

1.1k

Fitoria

answered 11 years ago

link

Comments

Thank you Fitoria, it worked fine!

marin (11 years ago)

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 (11 years ago)

see more comments

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

Comments

1 Answer

Comments

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