Could not execute query

[SELECT TEXT, DATE FROM PC7_SEARCH WHERE TEXT <> '' AND TEXT NOT LIKE '%.asp%' AND TEXT NOT LIKE '%.cfm%' AND TEXT NOT LIKE '%.php%' GROUP BY TEXT ORDER BY DATE DESC LIMIT 0,100] - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'shopilapc10.PC7_SEARCH.DATE' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by -
- error in file include/include_db.php on line # 0 : executeQuery
- error in file recent_searches.php on line # 45 : preparedQuery Recent searches on Shopila UK

Recent Searches

Timezone : GMT (0:00GMT)