PDOException: SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'civilsim_CivSim.lnsc.last_comment_timestamp' which is not in SELECT list; this is incompatible with DISTINCT: SELECT ncs.last_comment_timestamp AS last_comment_timestamp, ncs.last_comment_uid AS last_comment_uid, n.nid AS nid, n.title AS title, n.type AS type, CASE ncs.last_comment_uid WHEN 0 THEN ncs.last_comment_name ELSE u.name END AS last_comment_name FROM {node} n INNER JOIN (SELECT DISTINCT lnsc.nid AS nid FROM {node_comment_statistics} lnsc ORDER BY last_comment_timestamp DESC LIMIT 1000 OFFSET 0) lastnodes ON n.nid = lastnodes.nid INNER JOIN {forum_index} f ON n.nid = f.nid AND f.tid = :tid INNER JOIN {node_comment_statistics} ncs ON n.nid = ncs.nid INNER JOIN {users} u ON ncs.last_comment_uid = u.uid WHERE (n.status = :db_condition_placeholder_0) ORDER BY last_comment_timestamp DESC LIMIT 1 OFFSET 0; Array ( [:db_condition_placeholder_0] => 1 [:tid] => 26 ) in advanced_forum_forum_load() (line 226 of /home/civilsimian/public_html/sites/all/modules/advanced_forum/includes/core-overrides.inc).
PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '2147483647' for key 'PRIMARY': INSERT INTO {watchdog} (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9); Array ( [:db_insert_placeholder_0] => 0 [:db_insert_placeholder_1] => php [:db_insert_placeholder_2] => %type: !message in %function (line %line of %file). [:db_insert_placeholder_3] => a:6:{s:5:"%type";s:12:"PDOException";s:8:"!message";s:1019:"SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'civilsim_CivSim.lnsc.last_comment_timestamp' which is not in SELECT list; this is incompatible with DISTINCT: SELECT ncs.last_comment_timestamp AS last_comment_timestamp, ncs.last_comment_uid AS last_comment_uid, n.nid AS nid, n.title AS title, n.type AS type, CASE ncs.last_comment_uid WHEN 0 THEN ncs.last_comment_name ELSE u.name END AS last_comment_name FROM {node} n INNER JOIN (SELECT DISTINCT lnsc.nid AS nid FROM {node_comment_statistics} lnsc ORDER BY last_comment_timestamp DESC LIMIT 1000 OFFSET 0) lastnodes ON n.nid = lastnodes.nid INNER JOIN {forum_index} f ON n.nid = f.nid AND f.tid = :tid INNER JOIN {node_comment_statistics} ncs ON n.nid = ncs.nid INNER JOIN {users} u ON ncs.last_comment_uid = u.uid WHERE (n.status = :db_condition_placeholder_0) ORDER BY last_comment_timestamp DESC LIMIT 1 OFFSET 0; Array ( [:db_condition_placeholder_0] => 1 [:tid] => 26 ) ";s:9:"%function";s:27:"advanced_forum_forum_load()";s:5:"%file";s:90:"/home/civilsimian/public_html/sites/all/modules/advanced_forum/includes/core-overrides.inc";s:5:"%line";i:226;s:14:"severity_level";i:3;} [:db_insert_placeholder_4] => 3 [:db_insert_placeholder_5] => [:db_insert_placeholder_6] => http://www.civilsimian.com/forums/other [:db_insert_placeholder_7] => [:db_insert_placeholder_8] => 44.222.134.250 [:db_insert_placeholder_9] => 1728220280 ) in dblog_watchdog() (line 160 of /home/civilsimian/public_html/modules/dblog/dblog.module).