First time here? Check out the FAQ!
1

Error While Setting Up AskBot
 

Hi,

I've successfully configured everything till this command : python manage.py syncdb

However when I execute next command : python manage.py migrate askbot then I get following error :

1091, "Can't DROP 'multiple'; check that column/key exists")

What could be the possible issue ?

Thanks.

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)
Chetan Patil's avatar
41
Chetan Patil
asked 13 years ago

Comments

Chetan, could you give more details, please? Which database are you using, version of Python and Django, also where did you get source code for askbot? Thanks.

Evgeny's avatar Evgeny (13 years ago)

@Evgeny : (1) Database : Mysql 5.5.21 (2) Python 2.7.2 (3) Django 1.3.1 (4) I didn't compile/configured using the source code. This time around "pip install askbot" worked. So I followed the documentation given in askbot.com

Chetan Patil's avatar Chetan Patil (13 years ago)
see more comments

2 Answers

1

Hi.

Reproduced the bug, the issue is with migration number 32. Will deliver a fix soon.

EDIT 3: This is solved installing south trunk version from their repository not from pypi.

EDIT: A quick workaround do the following:

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

EDIT 2:

The issue is with south's delete_unique method that does not works on some MySQL versions

I'll patch the repository tomorrow, I need to run some extra tests to make sure.

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 13 years ago, updated 13 years ago
link

Comments

Why is this happening? Is this specific to the database version or linux?

Evgeny's avatar Evgeny (13 years ago)

@Evgeny: updated answer.

Fitoria's avatar Fitoria (13 years ago)
see more comments
0

Hi,

May anyone suggest possible solution to this question please?

Thanks

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)
Chetan Patil's avatar
41
Chetan Patil
answered 13 years ago
link

Comments

Hmm, it is possible that there are issues with the version 5.5 of mysql. Works with 5.0 and 5.1.

Evgeny's avatar Evgeny (13 years ago)

@Evgeny : Mysql will get new version in regular interval and Askbot can't just say use 5.0 only. Please let me know if there is any solution?

Chetan Patil's avatar Chetan Patil (13 years ago)
2

Chetan, I understand this, but supporting multiple databases at once takes work and our bandwidth is limited. Askbot is an open source project and the user community is welcome to submit patches. We will look into this issue, but I cannot tell when unless someone decides to fund this work, in which case we can do it much sooner.

Evgeny's avatar Evgeny (13 years ago)

@Evgeny : Agreed.

Chetan Patil's avatar Chetan Patil (13 years ago)

Sorry, what linux distribution do you have, did I ask you before, can't remember.

Evgeny's avatar Evgeny (13 years ago)
see more comments