First time here? Check out the FAQ!

Revision history  [back]

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

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

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

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

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

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

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

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.existing.

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

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

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!