Ask Your Question

Error While Setting Up AskBot

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

Chetan Patil's avatar


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's avatar 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's avatar 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's avatar Evgeny  ( 2012-04-05 13:59:33 -0500 )edit

@Evgeny: updated answer.

Fitoria's avatar Fitoria  ( 2012-04-05 22:52:14 -0500 )edit

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

Chetan Patil's avatar


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

@Evgeny : Agreed.

Chetan Patil's avatar 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's avatar 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: 857 times

Last updated: Apr 09 '12