search

isohuntto / openbay

Other
3.53k stars 903 forks source link

CDbCommand failed to execute the SQL #99

Open liskl opened 9 years ago

liskl commented 9 years ago

CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1064 index opbtorrents: sort-by attribute 'weight' not found. The SQL statement executed was: SELECT id FROM opbtorrents WHERE MATCH('@tags \"Anime\"') AND torrent_status = 1 ORDER BY weight() DESC, id DESC LIMIT 0, 5 OPTION ranker=SPH04

http://pastebin.com/bZ628ViL my config.php http://pastebin.com/FWMGFGBi my sphinx.conf

I've ran a indexer --all

and the sphinx daemon is running.

TPBT-OFFICIAL commented 9 years ago

Is this fixed yet? because the fix for me was installing the beta version of sphinx and trying again