Ask Your Question

Error While Setting Up AskBot

asked 2012-03-27 12:48:18 -0500

Chetan Patil gravatar image


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

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

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

What could be the possible issue ?


edit retag flag offensive close merge delete


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 gravatar image Evgeny  ( 2012-03-27 17:52:28 -0500 )edit

@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

Chetan Patil gravatar image Chetan Patil  ( 2012-03-28 03:39:41 -0500 )edit

2 Answers

Sort by ยป oldest newest most voted

answered 2012-04-04 22:32:13 -0500

updated 2012-04-09 10:19:56 -0500


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 syncdb --all
python migrate --all --fake


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.

edit flag offensive delete link more


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

Evgeny gravatar image Evgeny  ( 2012-04-05 13:59:33 -0500 )edit

@Evgeny: updated answer.

Fitoria gravatar image Fitoria  ( 2012-04-05 22:52:14 -0500 )edit

answered 2012-03-30 16:29:02 -0500

Chetan Patil gravatar image


May anyone suggest possible solution to this question please?


edit flag offensive delete link more


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

Evgeny gravatar image Evgeny  ( 2012-03-30 16:34:39 -0500 )edit

@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 gravatar image Chetan Patil  ( 2012-03-30 16:36:58 -0500 )edit

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 gravatar image Evgeny  ( 2012-03-30 16:41:24 -0500 )edit

@Evgeny : Agreed.

Chetan Patil gravatar image Chetan Patil  ( 2012-03-30 16:46:11 -0500 )edit

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

Evgeny gravatar image Evgeny  ( 2012-03-30 16:50:16 -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


Asked: 2012-03-27 12:48:18 -0500

Seen: 769 times

Last updated: Apr 09 '12