TCMS Can not connect to Sphinx....

Постим сюда все найденые ошибки
minihooker
Posts: 54
Joined: Tue Apr 08, 2014 9:40 am

TCMS Can not connect to Sphinx....

Post by minihooker »

Build 201508061939
После апдейта TCMS стал при поиске выдавать:
Can not connect to Sphinx....
При этом Sphinx настроен не был.

Установили Sphinx (во время установки был build 201507242146)

Админы пишут:
При индексации есть варнинги вида.
WARNING: attribute 'gallery_id' not found - IGNORING

конфиг:
source my_sql_base
{
type = mysql

sql_host = localhost
sql_user = my_sql_user
sql_pass = my_sql_pass
sql_db = my_sql_base
sql_port = 3306 # optional, default is 3306

sql_query_pre = SET NAMES utf8


sql_query = SELECT gi.gallery_id, UNIX_TIMESTAMP(gi.activation_date) as date, alt, description, gi.duration, sponsor_id, gs.total_ctr, gi.content_type, \
(SELECT group_concat(tag_name) FROM rot_gal2tag g2t \
LEFT JOIN rot_tags as t on t.tag_id = g2t.tag_id \
WHERE g2t.gallery_id = gi.gallery_id) as tags, \
(SELECT group_concat(gss.group_id) FROM rot_gallery_stats1 as gss \
WHERE gss.gallery_id = gi.gallery_id AND group_id != 0) as categories \
FROM rot_gallery_info AS gi \
JOIN rot_gallery_data1 AS gd ON gi.gallery_id = gd.gallery_id \
JOIN rot_gallery_stats1 AS gs ON gs.gallery_id = gi.gallery_id \
WHERE gallery_status = 'active' and gallery_type = 0 \
and gs.best_thumb = 'yes' and gs.group_id = 0


sql_attr_timestamp = date
sql_attr_uint = duration
sql_attr_uint = sponsor_id
sql_attr_float = total_ctr
sql_attr_uint = content_type
sql_attr_uint = gallery_id
sql_attr_multi = uint categories from field;


sql_query_info = SELECT * FROM rot_gallery_info WHERE gallery_id=$id
}


index my_sql_base_index
{
source = my_sql_base
path = /path_to_index
docinfo = extern
morphology = stem_en
charset_type = utf-8

}

Задал настройки подключения в Rotation, Settings, Sphinx Search
ошибка Can not connect to Sphinx.... никуда не делась
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: TCMS Can not connect to Sphinx....

Post by admin »

Думаю из 51 скопирована часть тк

http://smartcj.com/wiki/doku.php?id=ru:tcms_install

тут нет gallery_id параметра

По коннекту

Надо внести изменения в секцию

searchd
{
listen = your_port:mysql41
Don't forget to run script update
minihooker
Posts: 54
Joined: Tue Apr 08, 2014 9:40 am

Re: TCMS Can not connect to Sphinx....

Post by minihooker »

gallery_id есть тут:
http://smartcj.com/wiki/doku.php?id=ru: ... inx_config

админ отвечает:
> в searchd добавил
> listen = 9312:mysql41
> закомментировал sql_attr_uint = gallery_id


Варгнинг пропал. Проблема не решилась. При пустых настройках sphinx в админке, и при заполненных - Can not connect to Sphinx....
Куку поставил, кеш сбрасывал.
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: TCMS Can not connect to Sphinx....

Post by admin »

listen = your_port:mysql41


точно есть в конфиге ?
Don't forget to run script update
minihooker
Posts: 54
Joined: Tue Apr 08, 2014 9:40 am

Re: TCMS Can not connect to Sphinx....

Post by minihooker »

точно есть
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: TCMS Can not connect to Sphinx....

Post by admin »

Тогда не знаю, скидывайте шел и где смотреть, я проверю
Don't forget to run script update
minihooker
Posts: 54
Joined: Tue Apr 08, 2014 9:40 am

Re: TCMS Can not connect to Sphinx....

Post by minihooker »

отправил в pm 31.08
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: TCMS Can not connect to Sphinx....

Post by admin »

Вроде решили ж этот вопрос?
Don't forget to run script update
minihooker
Posts: 54
Joined: Tue Apr 08, 2014 9:40 am

Re: TCMS Can not connect to Sphinx....

Post by minihooker »

да, все ок, спасибо
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: TCMS Can not connect to Sphinx....

Post by admin »

ok, NP
Don't forget to run script update
Post Reply