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.

Chetan Patil's avatar
41
Chetan Patil
asked 2012-03-27 12:48:18 -0600
edit flag offensive 0 remove flag close merge delete

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 (2012-03-27 17:52:28 -0600) 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 askbot.com

Chetan Patil's avatar Chetan Patil (2012-03-28 03:39:41 -0600) edit
add a comment 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.

Fitoria's avatar
1.1k
Fitoria
answered 2012-04-04 22:32:13 -0600, updated 2012-04-09 10:19:56 -0600
edit flag offensive 0 remove flag delete link

Comments

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

Evgeny's avatar Evgeny (2012-04-05 13:59:33 -0600) edit

@Evgeny: updated answer.

Fitoria's avatar Fitoria (2012-04-05 22:52:14 -0600) edit
add a comment see more comments
0

Hi,

May anyone suggest possible solution to this question please?

Thanks

Chetan Patil's avatar
41
Chetan Patil
answered 2012-03-30 16:29:02 -0600
edit flag offensive 0 remove flag delete 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 (2012-03-30 16:34:39 -0600) 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 -0600) edit
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 (2012-03-30 16:41:24 -0600) edit

@Evgeny : Agreed.

Chetan Patil's avatar Chetan Patil (2012-03-30 16:46:11 -0600) 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 -0600) edit
add a comment see more comments