KamloopsCity.com - The Internet home page for the people of Kamloops

"getPubList" failed: Unknown column 'pg_field396_table' in 'order clause' while executing: SELECT nuke_pagesetter_pubdata52.pg_id, nuke_pagesetter_pubdata52.pg_pid, pg_author, UNIX_TIMESTAMP(pg_created) as pg_created, pg_approvalState, pn_topicname, pg_revision, pg_online, pg_field393 FROM nuke_pagesetter_pubdata52 LEFT JOIN nuke_topics ON pg_topic = pn_topicid LEFT JOIN nuke_pagesetter_pubheader ON pg_tid = 52 AND nuke_pagesetter_pubheader.pg_pid = nuke_pagesetter_pubdata52.pg_pid LEFT JOIN nuke_pagesetter_listitems as pg_field396_table ON pg_field396_table.pg_id = pg_field396 LEFT JOIN nuke_pagesetter_listitems as listTable1 ON listTable1.pg_id = 435 WHERE (pg_publishDate <= NOW() || pg_publishDate IS NULL) AND (NOW() < pg_expireDate || pg_expireDate IS NULL) AND pg_online AND pg_showInList AND (pg_language = 'eng' OR pg_language = 'x_all') AND ((pg_field396_table.pg_lval >= listTable1.pg_lval AND pg_field396_table.pg_rval <= listTable1.pg_rval)) AND NOT pg_indepot ORDER BY pg_field396_table, pg_field393, pg_revision