chinese search while using sphinx + mysql
 
   
  
 
 
I want to enable chinese full text search, so I installed sphinx. 
 
I found that sphinx is only for mysql, but when I tried to use mysql as main database, "syncdb" or "migrate" always return some errors. It seems like can't use innodb engine in mysql??
 
Error message: askbot_thread is InnoDB - using workarounds !!!
...
ValueError: Cannot find a FOREIGN KEY constraint on table askbot_thread, column accepted_answer_post_id
 
BTW:Does askbot support sphinx for postgreSQL??
 
 
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)
  
 
 
 
 
 
 jqy3222089's avatar

      17
    
 
 
 
 jqy3222089 
 
 
    asked 12 years ago,
        
    updated 12 years ago 
 
 
 
 
        
 
 
 
Comments
 
 
 
  see more comments