Errors during installation process (migration) with Postgresql 8.4 and 9.1

asked 2012-04-08 21:15:47 -0600

ibrahima gravatar image

updated 2012-04-08 23:01:17 -0600

Hi,

I'm just trying to get set up with askbot. I followed the instructions, using Postgresql, created a new database, ran syncdb, and up to this point I had no errors. Then I ran python migrate.py askbot and I get a lot of errors about tables already existing. Here are the outputs of migrate.py on two different machines with slightly different configurations.

https://gist.github.com/5b3ec37f8e75aec9b4aa Postgres 9.1.3, Python 2.7.2, Django 1.3.1, psycopg2 2.4.5, Ubuntu 11.10

https://gist.github.com/06cd8aa9404cd7174f25 Postgres 8.4.11, Python 2.6.6, Django 1.3.1, psycopg2 2.4.5, Ubuntu 10.10

I'm also getting an error upon trying to view the installation (using python manage.py runserver):

DatabaseError at /questions/

relation "askbot_thread" does not exist LINE 1: SELECT COUNT(DISTINCT "askbot_thread"."id") FROM "askbot_thr...

Any help would be greatly appreciated!

Edit: tried to run the migration in askbot/search/postgresql/thread_and_post_models_01162012.plsql, got this

https://gist.github.com/3f7110fc38a3ccc7edcb

edit retag flag offensive close merge delete

Comments

It seems like this can be resolved with the same solution from http://askbot.org/en/question/6902/error-while-setting-up-askbot but I'm not sure why.

ibrahima gravatar imageibrahima ( 2012-04-09 00:23:47 -0600 )edit