#156 Topic access fails under PHP5/MySQL5

[Andy Alm]

I just upgraded my server from PHP4 to PHP5 and MySQL4 to MySQL5, and topic access started failing, with the following error. Disabling topic access made the error go away, but also removed editing privileges for those who need them :-( Running PostNuke .764, Pagesetter 6.3.0.0.

Any suggestions? Looks like a bug to me.

Andy

"getPub" failed: Unknown column 'pn_group_membership.pn_gid' in 'on clause' while executing: SELECT pubTable.pg_id, pubTable.pg_pid, pubTable.pg_approvalState, pubTable.pg_online, pubTable.pg_revision, pubTable.pg_topic, pn_topics.pn_topicname as core_topic_name, pn_topics.pn_topictext as core_topic_text, pn_topics.pn_topicimage as core_topic_image, pubTable.pg_showInMenu, pubTable.pg_showInList, pubTable.pg_author, pubTable.pg_creator, UNIX_TIMESTAMP(pubTable.pg_created) as pg_created, pn_pagesetter_pubheader.pg_hitcount, UNIX_TIMESTAMP(pubTable.pg_lastUpdatedDate) as pg_lastUpdatedDate, UNIX_TIMESTAMP(pubTable.pg_publishDate) as pg_publishDate, UNIX_TIMESTAMP(pubTable.pg_expireDate) as pg_expireDate, pubTable.pg_language , pg_field7, pg_field8, pg_field9, pg_field10, pg_field11 FROM pn_pagesetter_pubdata2 as pubTable LEFT JOIN pn_topics AS AccessTopic ON AccessTopic.pn_topicid = pg_topic JOIN pn_topicaccess ON tpa_topic = pg_topic AND tpa_module = 'pagesetter' AND tpa_category = 'Pages' AND tpa_access = 'read' AND ( tpa_groupid >= 0 AND pn_group_membership.pn_gid IS NOT NULL OR tpa_groupid < 0 AND pn_group_membership.pn_gid IS NULL) OR AccessTopic.pn_topicid IS NULL LEFT JOIN pn_group_membership ON ( pn_group_membership.pn_gid = tpa_groupid AND pn_group_membership.pn_uid = 0) LEFT JOIN pn_topics ON pubTable.pg_topic = pn_topics.pn_topicid LEFT JOIN pn_pagesetter_pubheader ON pubTable.pg_pid = pn_pagesetter_pubheader.pg_pid AND pg_tid = 2 WHERE pubTable.pg_pid = 4 AND (pg_publishDate <= NOW() || pg_publishDate IS NULL)AND (NOW() < pg_expireDate || pg_expireDate IS NULL) AND pg_online AND NOT pg_indepot