SQL Syntax Error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mype_search.B.cid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - From: SELECT B.cid,B.l1, B.l2, B.l3, B.l4, B.l5, B.l6, B.l7, B.l8, B.l9, B.l10, B.l11, B.l12, B.l13, B.l14, B.l15, B.l16, B.crosslinkid, A.* FROM links AS A, dirs AS B WHERE ((A.title like '%Biome%') or (A.description like '%Biome%') or (A.keywords like '%Biome%') or (A.url like '%Biome%') or (A.adress_cust like '%Biome%') or (A.phone_cust like '%Biome%') or (A.mobile_cust like '%Biome%') or (A.contact_cust like '%Biome%') or (A.special_cust like '%Biome%') ) AND ((B.catlock != 'H') OR (B.catlock IS NULL)) AND (A.cid = B.cid) AND ((A.newsubm = '') OR (A.newsubm IS NULL)) GROUP BY A.url at search.cgi line 760.
For help, please send mail to the webmaster (webmaster@mype.co.za), giving this error message and the time and date of the error.