#165 topicaccess + pagesetter = getPubList failed: Unkown column

[Anonymous]

Hi all,

i have a PN.764 with the newest pagesetter version and it works fine!
My publication based on the Standard PN-News because the migration of the 1500 PN News. So far so good.

All the articles are bundled with the topics and after the little topic hack (changing names pagesetter <> News in the modules/Topics/index.php) the topics shows all the correct articles.

Quoteold= a href="index.php?name=news&catid=&topic='. pnVarPrepForDIsplay($topicid).;

new = a href="index.php?name=pagesetter&catid=&topic='. pnVarPrepForDIsplay($topicid).;

I set the permissions in this way that only some usergroups have success to see the special topics. This works fine and without the topicaccess modul. (a logged in user, can´t see the special topics!)

But......i don´t see the topics (thats correct) but when i´m searching, the system found all the articles inclusive the articles which must be hidden by the special hidden topics.
Ok, i´m thinking this is only possible with the topicacces module! Right ??

I installed the module topicaccess like the manual and set the permissions for the topics and the groups. (up to this point, it works!)

But when I login with my testUser, i get the following errormessage:

[quote]"getPubList" failed: Unknown column 'pn_group_membership.pn_gid' in 'on clause' while executing: SELECT DISTINCT pn_pagesetter_pubdata3.pg_id, pn_pagesetter_pubdata3.pg_pid, pg_author, UNIX_TIMESTAMP(pg_created) as pg_created, pg_approvalState, pn_topics.pn_topicname, pg_revision, pg_online, pg_field12 FROM pn_pagesetter_pubdata3 LEFT JOIN pn_topics ON pg_topic = pn_topics.pn_topicid LEFT JOIN pn_pagesetter_pubheader ON pg_tid = 3 AND pn_pagesetter_pubheader.pg_pid = pn_pagesetter_pubdata3.pg_pid 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 = 'PN-News' 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 = 125) 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 = 'deu' OR pg_language = 'x_all') AND NOT pg_indepot ORDER BY pg_created DESC, pg_lastUpdatedDate DESC, pg_field12, pg_revision
--------------------------------------------------------------------------------
[/quote]

Here are some informations about my system:
(the system ist only available in our intranet)
Apache/2.2.6 (Fedora)
PHP/5.1.6
MySQL Client API version 5.0.27
register_globals = off
safe_mode = off

Whats the problem ??
How can i fix the problem??
For my knowledgebase it isn´t possible to work without topicaccess.

please help !

peter (papamac)