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

askbot_badgedata does not during initial database migration?
 
   
  
 
 
When I run my initial syncdb and then my migrations, both migrations give the following error:
 
relation "askbot_badgedata" does not exist
LINE 1: ..."."slug", "askbot_badgedata"."awarded_count" FROM "askbot_ba...

 
This is with askbot 0.7.29.
 
Is this expected? Why does this happen?
 
 
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)
  
 
 
 
 
 
 Joseph's avatar

      353
    
 
 
 
 Joseph 
 
 
    asked 13 years ago 
 
 
 
 
        
 
 
 
Comments
 
 
 
 
  
 
 
 
Are you on mysql? could you pls give more details about your database? Thanks!
 
 
 Evgeny's avatar Evgeny (13 years ago)   
 
 
  
 
  see more comments  
 
 
 
 
 
 1 Answer
  
  
   
 
 
 
 
0
 
 
  
 
 
 
 
 
 
Turns out there are known issues with MySQL on InnoDB and the South migration system.
 
http://south.aeracode.org/ticket/666
 
This is something that may be fixed within the South project, but we are definitely not touching it.
 
Please switch to using either PostgresQL or configure MySQL to use InnoDB storage engine.
 
We are now discussing a possibility to explicitly raising an exception when people use InnoDB and tell them to switch - at least until the bug is fixed.
 
 
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 13 years ago 
 
 
 
 
     link   
 
 
 
Comments
 
 
 
 
  
 
 
 
Actually, I am using postgres.
 
 
 Joseph's avatar Joseph (13 years ago)   
 
 
  
 
 
  
 
 
 
I am also using postgres and having the same issue
 
 
 jeroenbourgois's avatar jeroenbourgois (12 years ago)   
 
 
  
 
 
  
 
 
 
Same for me. I'm using postgres too. Anyone solve this problem ?
 
 
 Léo LEFEBVRE's avatar Léo LEFEBVRE (11 years ago)   
 
 
  
 
 
  
 
 
 
I got the same issue today.
 
 
 Chankey Pathak's avatar Chankey Pathak (11 years ago)   
 
 
  
 
 
  
 
 
 
I also got this error, even using postgresql.
 
 
 tkdchen's avatar tkdchen (11 years ago)   
 
 
  
 
  see more comments