Invalid QueryFile: /home3/sabryn/public_html/fusionbb/includes/user_class.php Line: 5313 SQL Error: Expression #1 of ORDER BY clause is not in SELECT list, references column 'sabryn_fusionbb.t2.show_topic' which is not in SELECT list; this is incompatible with DISTINCT SQL Error #: 3065 SQL Query:
SELECT DISTINCT(t1.id), t1.field_name
FROM fbb_reg_fields as t1,
fbb_show_fields as t2
WHERE t1.id = t2.reg_id
AND t2.group_id IN ('5')
AND t2.show_topic > 0
order by case t2.show_topic when 0 then 1 else 0 end, t2.show_topic
Invalid QueryFile: /home3/sabryn/public_html/fusionbb/includes/user_class.php Line: 5313 SQL Error: Expression #1 of ORDER BY clause is not in SELECT list, references column 'sabryn_fusionbb.t2.show_topic' which is not in SELECT list; this is incompatible with DISTINCT SQL Error #: 3065 SQL Query:
SELECT DISTINCT(t1.id), t1.field_name
FROM fbb_reg_fields as t1,
fbb_show_fields as t2
WHERE t1.id = t2.reg_id
AND t2.group_id IN ('5')
AND t2.show_topic > 0
order by case t2.show_topic when 0 then 1 else 0 end, t2.show_topic
Invalid QueryFile: /home3/sabryn/public_html/fusionbb/includes/user_class.php Line: 5313 SQL Error: Expression #1 of ORDER BY clause is not in SELECT list, references column 'sabryn_fusionbb.t2.show_topic' which is not in SELECT list; this is incompatible with DISTINCT SQL Error #: 3065 SQL Query:
SELECT DISTINCT(t1.id), t1.field_name
FROM fbb_reg_fields as t1,
fbb_show_fields as t2
WHERE t1.id = t2.reg_id
AND t2.group_id IN ('5')
AND t2.show_topic > 0
order by case t2.show_topic when 0 then 1 else 0 end, t2.show_topic
Attachment: 