Page 5 of 5
Re: Mysql error 1064
Posted: Thu Nov 28, 2019 6:24 am
by admin
сорри мой баг, поправил
Re: Mysql error 1064
Posted: Sat Nov 30, 2019 9:22 am
by ulan
Mysql error 1064: index _tcms_index: syntax error, unexpected '|' near '| অরন্যে শাড়ি || Monalisa Yellow Saree || Saree Lover || bangal Beauty'' (SELECT id FROM `_tcms_index` WHERE match ('@(alt,custom_var3,description,tags,group_names,group_names) \'Aranye Saree || অরন্যে শাড়ি || Monalisa Yellow Saree || Saree Lover || bangal Beauty\'') AND id NOT IN (92417,84003,78854,93327,76454,55269,73659,83329,58361,67081,55470,58706,75545,74806,69339,88350,71502,77168,71939,79866,86782,55215,55332,67995) LIMIT 0, 54 OPTION max_matches=20000)
Re: Mysql error 1064
Posted: Sat Nov 30, 2019 2:28 pm
by admin
fixed
Re: Mysql error 1064
Posted: Fri Dec 13, 2019 7:10 pm
by ulan
Mysql error 1064: index _com_scj_index: syntax error, unexpected '|' near ' '| Kerala'' (SELECT id FROM `_scj_index` WHERE match ('@(alt,custom_var3,description,tags,group_names,group_names) \'| Kerala\'') LIMIT 0, 54 OPTION max_matches=20000)
Re: Mysql error 1064
Posted: Sat Dec 14, 2019 7:18 am
by admin
да, сфинкс забавный,
| Kerala
так нельзя
так можно
Kerala |
test | Kerala
\\| Kerala\
и так тоже
добавил обработку этой ситуации