Ask Your Question
1

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

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

ibrahima gravatar image ibrahima
11 1 4

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

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

delete close flag offensive retag edit

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 ( 2012-04-09 00:23:47 -0500 )edit

Be the first one to answer this question!

Please start posting your answer anonymously - your answer will be saved within the current session and published after you log in or create a new account. Please try to give a substantial answer, for discussions, please use comments and please do remember to vote (after you log in)!

[hide preview]

Reliable Askbot Hosting

Create your Q&A site at askbot.com. Managed Askbot hosting at just $15/mo. Dedicated hosting, support contracts, consulting services.

create your Q&A site
30 days free trial

Question tools

Follow
1 follower

subscribe to rss feed

Stats

Asked: 2012-04-08 21:15:47 -0500

Seen: 193 times

Last updated: Apr 08 '12