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

Why does South migration 4 failed?
 
   
  
 
 
I'm new to askbot.  Trying to set up askbot 0.6.79 with MySQL.  When running python manage.py migrate askbot, at for 0040_delete_old_tag_filter_strategies. I'm getting this error:
 
.../MySQLdb/connections.py", line 36, in defaulterrorhandler
_mysql_exceptions.OperationalError: (1214, "The used table type doesn't support FULLTEXT indexes")
 
What's wrong?
 
 
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)
  
 
 
 
 
 
 codedigger's avatar

      41
    
 
 
 
 codedigger 
 
 
    updated 13 years ago,
        
    asked 13 years ago 
 
 
 
 
        
 
 
 
Comments
 
 
 
 
  
 
 

        It is migration 40, the last one. In this case django runs migrations as one transaction, since one of the migrations failed, the whole transaction fails, therefore it reports an error on transaction 40.
      
 
 Evgeny's avatar Evgeny (13 years ago)   
 
 
  
 
  see more comments  
 
 
 
 
 
 1 Answer
  
  
   
 
 
 
 
0
 
 
  
 
 
 
 
 
 
Askbot will only work with MyISAM storage engine of MySQL, because it is the only one that supports full text search, looks like the engine you are using currently is different (probably InnoDB).
 
If at all possible - please use postgresql, it is much better.
 
 
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
 
 
 
 
  
 
 

        Ah, thanks for the quick response.  What if I have a Django site already using MySQL InnoDB with 100+ tables?  Should I keep askbot in a different db, or you still strongly recommend I migrate the whole db to Postgre?
      
 
 codedigger's avatar codedigger (13 years ago)   
 
 
  
 
 
  
 
 

        It will be better to migrate to postgres, if your existing site will work with postgresql. Is it possible?
      
 
 Evgeny's avatar Evgeny (13 years ago)   
 
 
  
 
  see more comments