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

To enter a block of code:

  • enter empty line after your previous text
  • paste or type the code
  • select the code and press the button above
Preview: (hide)
marin's avatar
3
marin
asked 11 years ago

Comments

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.

To enter a block of code:

  • enter empty line after your previous text
  • paste or type the code
  • select the code and press the button above
Preview: (hide)
Fitoria's avatar
1.1k
Fitoria
answered 11 years ago
link

Comments

Thank you Fitoria, it worked fine!

marin's avatar 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's avatar marin (11 years ago)
see more comments