SmartCJ Support Forum

Code: Select all

ERROR: index 'domainscom_index_scj_search': sql_query: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'domaincom.rot_search_queries.sq_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (DSN=mysql://dom:***@localhost:3306/domaincom).

Code: Select all

source domain_scj_search
{
    type                        = mysql
    sql_host                    = localhost
    sql_user                    = user
    sql_pass                    = pwd
    sql_db                      = domain
    sql_port                    = 3306
    sql_query_pre               = SET NAMES utf8
    sql_query                   = SELECT sq_id, search_query, hits, items_found FROM rot_search_queries WHERE hits > 0 GROUP BY search_query
    sql_attr_uint               = hits
    sql_attr_uint               = items_found
}