I
I
Igor Karachentsev2016-09-15 10:58:18
Sphinx
Igor Karachentsev, 2016-09-15 10:58:18

Why did yiisoft\yii2-sphinx start building queries strangely?

Until recently, everything worked great. And suddenly it is not clear why strange things began to happen. That's exactly what I b32afc71080b57e1549bfccf719c23c7.png
'm looking for

$query = new yii\sphinx\Query();
$query->from('siteSearch');
$query->match(new Expression(':match', [
    'match' => 'aaaa',
]));

everything is as stated in the yiisoft/yii2-sphinx
documentation. The result is everything as in the screenshot, no matter what line I substitute. What could be the problem? Why does sql truncate the searched string like this?
upd: I tried to manually set a query with match in phpmyadmin gives the following 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 ''aaaa') LIMIT 0, 30' at line 1
as you can see, sql itself works wonders for some kind of goblin

Answer the question

In order to leave comments, you need to log in

1 answer(s)
P
Puma Thailand, 2016-09-15
@opium

Well, just look at what changed before it stopped working normally.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question