search

osuripple / cheesegull

CheeseGull is an osu! mirror developed for Ripple.
MIT License
14 stars 8 forks source link

Error when request from "api/search" #16

Closed Helloyunho closed 6 years ago

Helloyunho commented 6 years ago

If I search for something to cheesegull API(ex: freedom), This error has occurred.

2018/06/17 22:55:17 Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''freedom') AND ranked_status IN (1,2)  ORDER BY WEIGHT() DESC, id DESC  LIMIT 0' at line 1

Am I doing something wrong? or just cheesegull's error?

MaxKruse commented 6 years ago

Well, do you have the correct database structure + data? whats the full Query? try sending it manually and see what happens

Helloyunho commented 6 years ago

@MaxKruse I don't know what is the Query but database is fine

MaxKruse commented 6 years ago

log the query itself and check it manually then

Helloyunho commented 6 years ago

I just add fmt.Println(setsQuery) on 'set_search.go' file but nothing shows up

thehowl commented 6 years ago

You'll need to use Sphinx to make search work. MySQL/MariaDB won't suffice because it lacks the fullsearch capabilities we need. There is a sample config in the README

Helloyunho commented 6 years ago

Now running with Sphinx but still get the same error

thehowl commented 6 years ago

It means you haven't changed your Search DSN to be that of sphinx, probably. Taking guesses here.

Helloyunho commented 6 years ago

Thanks! It worked!