Jørn Wildt

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.




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



edited by: papamac, Feb 12, 2008 - 11:28 AM

The group membership problem has something to do with PN .8 code I introduced. Please add as a bug-report on SourceForge.