SmartCJ Support Forum

Code: Select all

source my
{
	type = mysql
	sql_host = localhost
	sql_user = db_user
	sql_pass = db_pass
	sql_db = db_name
	sql_query_pre = SET NAMES utf8
	sql_query_pre = UPDATE rot_settings SET value = (SELECT MAX(gallery_id) FROM rot_gallery_info) WHERE name = 'sphinx_max_gallery_id'
	sql_query  = SELECT gi.gallery_id, UNIX_TIMESTAMP(gi.activation_date) as date, gd.alt, gd.description, gi.duration, gi.sponsor_id, gs.total_ctr, gi.content_type, rot_sponsors.sponsor_name, rot_sponsors.sponsor_site, (SELECT group_concat(tag_id) FROM rot_gal2tag g2t WHERE g2t.gallery_id = gi.gallery_id) as tag_ids, (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(name) FROM rot_groups WHERE rot_groups.id in (SELECT group_id FROM rot_gallery_stats1 WHERE rot_gallery_stats1.gallery_id = gi.gallery_id AND group_id != 0)) as group_names, (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_sponsors on rot_sponsors.sponsor_id = gi.sponsor_id 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 AND gs.group_id NOT IN (SELECT group_id FROM rot_groups_data WHERE status != 1)
	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_multi = uint tag_ids from field 
	sql_attr_multi = uint categories from field;
}

index my_index
{
	source = my
	path /path_to_index/my_index
	morphology = stem_en
}

Code: Select all

WARNING: key 'mva_updates_pool' was permanently removed from Sphinx configuration. Refer to documentation for details.
indexing index 'my_index'...
collected 6105 docs, 0.5 MB
sorted 0.1 Mhits, 100.0% done
total 6105 docs, 496.8 Kb
total 0.2 sec, 2.099 Mb/sec, 25800 docs/sec

Code: Select all

A bunch of legacy things were removed:

    removed ..., mva_updates_pool, ...