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
 
 
To enter a block of code:
 
     
  • enter empty line after your previous text
    •  
  • paste or type the code
    •  
  • select the code and press the  button above
    •  
 
Preview: (hide)
  
 
 
 
 
 
 ibrahima's avatar

      11
    
 
 
 
 ibrahima 
 
 
    asked 13 years ago,
        
    updated 13 years ago 
 
 
 
 
        
 
 
 
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's avatar ibrahima (13 years ago)   
 
 
  
 
  see more comments