Welcome to the Greencastle Wiki! On the Wiki you will find a range of information relating from Payroll, Marketing, HR news and more. The Intranet will keep you up to date with any news, deadlines or important information. If you have any content or suggestions you would like to appear on the Intranet then please feel free to email helpdesk@greencastlesolutions.co.uk and they will deal with your request.
Query Error in 'CPSetSelection::execute' method in '/mnt/ccd-vhost-data/www/vhosts/testwiki.wiki.greencastle.systems/httpdocs/class.cp_sets.php' on line 8748, You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND table1.cpda_meta_val = 1 AND (table2.cpda_meta_val = 2408854 OR table2....' at line 1 Full query: SELECT mainTable.cpda_id FROM cp_data AS mainTable LEFT OUTER JOIN cp_data AS table0 ON table0.cpda_meta_id = mainTable.cpda_id AND table0.cpda_meta_key = '711' LEFT OUTER JOIN cp_data AS table1 ON table1.cpda_meta_id = mainTable.cpda_id AND table1.cpda_meta_key = '755' LEFT OUTER JOIN cp_data AS table2 ON table2.cpda_meta_id = mainTable.cpda_id AND table2.cpda_meta_key = '716' WHERE mainTable.cpda_meta_id = 700 AND mainTable.cpda_meta_key = 'set_element_stub' AND mainTable.cpda_active = 1 AND table0.cpda_meta_val IN () AND table1.cpda_meta_val = 1 AND (table2.cpda_meta_val = 2408854 OR table2.cpda_meta_val IS NULL) ORDER BY mainTable.cpda_seq, mainTable.cpda_id LIMIT 0, 2