First time here? Check out the FAQ!
1

Problems installing with mysql

Hi all,

I want to install latest version (7.40) using "mysql"

Why not postgresql? Because my project is using mysql, I want to integrate askbot to it soon

What I did so far?

git clone git://github.com/ASKBOT/askbot-devel.git askbot_deploy
cd askbot_deploy
virtualenv .
python setup.py develop
created a database named "askbot"
askbot-setup, and I have answered questions
set DATABASE_ENGINE = mysql, save and exit
python manage.py syncdb

--- I got a warning here: (1146, "Table 'askbot.askbot_badgedata' doesn't exist"))

python manage.py migrate

--- I got error here:_mysql_exceptions.OperationalError: (1061, "Duplicate key name 'askbot_badgedata_56ae2a2a'")

I have read this thread: http://askbot.org/en/question/3170/askbot_badgedata-does-not-during-initial-database

I tried this scenario using InnoDB and MyIsam as default storage engines.

Here are the logs for those operations: http://pastebin.me/bc23773578d79a55882d7ced4e13751d

My Question: Is askbot 7.40 broken for MySQL? If so, are there any specific version that I can use with MySQL?

Thanks for making this great project open-source.

anonymous user
asked 2012-04-17 06:29:20 -0600, updated 2012-04-17 06:37:59 -0600
edit flag offensive 0 remove flag close merge delete

Comments

add a comment see more comments

1 Answer

0

The current south version is broken with mysql and adding unique keys, please install south from their repository.

Fitoria's avatar
1.1k
Fitoria
answered 2012-04-17 11:35:15 -0600
edit flag offensive 0 remove flag delete link

Comments

Em, isn't askbot do pip install from mercury-repo of South? I mean it requires mercury and setuptools-hg in order to install..

Olloff's avatar Olloff (2012-04-17 11:47:44 -0600) edit

pip install hg+https://bitbucket.org/andrewgodwin/south or clone it from https://bitbucket.org/andrewgodwin/south/ and then python setup.py install

Fitoria's avatar Fitoria (2012-04-17 11:57:34 -0600) edit
add a comment see more comments