First time here? Check out the FAQ!
Ask Your Question
1

MYSQL issue with migration 22 on install [fixed]
 
   
  
 
 
manage.py migrate askbot gives the following error:
 
_mysql_exceptions.ProgrammingError: (1146, "Table 'graeme_investmentqa.pg_language' doesn't exist")

 
I managed to install by only migrating up to migration 21. This seems to be an acceptable workaround for the moment - at least it seems to work (I have some issues, but they are probably extra config needed for my host).
 
Also, the documentation does not mention that you also need to migrate askbot.deps.django_authopenid
 
 
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)
  
 
 
 
 
 
 Evgeny's avatar

      13.2k
    
 
 
 
 Evgeny 
 
 
    updated 14 years ago 
 
 
 
 
 graeme's avatar

      319
    
 
 
 
 graeme 
 
 
    asked 14 years ago 
 
 
 
 
        
 
 
 
Comments
 
 
 
  see more comments  
 
 
 
 
 
 1 Answer
  
  
   
 
 
 
 
0
 
 
  
 
 
 
 
 
 
Thanks, fixed this. Next time the migration 22 will work (it will actually be a do-nothing) for MySQL as it should.
 
 
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)
  
 
 
 
 
 
 Evgeny's avatar

      13.2k
    
 
 
 
 Evgeny 
 
 
    answered 14 years ago 
 
 
 
 
     link   
 
 
 
Comments
 
 
 
 
  
 
 

        Thanks Evgeny. You are very helpful and you seem to fix problems very fast. Askbot is very easy to install (I used pip install in a virtualenv). The docs could be improved, but they are better than whats available for the alternatives.
      
 
 graeme's avatar graeme (14 years ago)   
 
 
  
 
 
  
 
 

        Graeme, you are welcome. Feel free to ask if you have any issues with your site or suggestions.
      
 
 Evgeny's avatar Evgeny (14 years ago)   
 
 
  
 
 
  
 
 

        I'm installing askbot 0.6.79 with MySQL (MyISAM).  Migration 22 is still failing.  I see that there is a condition in the migration code to only apply to postgresql.  But, may be it is still expecting to see the pg_language table?  Error: .../MySQLdb/connections.py", line 36, in defaulterrorhandler
django.db.utils.DatabaseError: (1146, "Table 'askbot.pg_language' doesn't exist"
      
 
 codedigger's avatar codedigger (13 years ago)   
 
 
  
 
 
  
 
 

        Your setting DATABASE_ENGINE must be incorrect..... no? Is it "mysql" or "postgresql_psycopg2"? With "mysql" this migration must pass through without doing anything.
      
 
 Evgeny's avatar Evgeny (13 years ago)   
 
 
  
 
 
  
 
 

        OK, that was the problem!  Even through I override settings.py with my settings_local.py with DATABASES = {...}, I guess DATABASE_ENGINE is a DIFFERENT setting, so it worked as far as db connection goes, but the migration script was still picking up DATABASE_ENGINE.  Now all migrations worked.  Thanks!
      
 
 codedigger's avatar codedigger (13 years ago)   
 
 
  
 
  see more comments