Zikula Community

• **unknown user**
  
  

  • Rank: Freshman
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 81

  Posted: Mar 01, 2008 - 04:49 PM

  I had Pagesetter before with no problems.
  Now, after redoing my site, I installed Pagesetter, set the perms to admins pagesetter:: :: admin, all groups pagesetter:: :: read. Have topicaccess set to allow users to read and write.
  Admins can get to Pagesetter using the link in the menu with no problem. Users get - "getPubList" failed: Unknown column 'pn_group_membership.pn_gid' in 'on clause' while executing: SELECT DISTINCT pn_pagesetter_pubdata5.pg_id, pn_pagesetter_pubdata5.pg_pid, pg_author, UNIX_TIMESTAMP(pg_created) as pg_created, pg_approvalState, pn_topics.pn_topicname, pg_revision, pg_online, pg_field18 FROM pn_pagesetter_pubdata5 LEFT JOIN pn_topics ON pg_topic = pn_topics.pn_topicid LEFT JOIN pn_pagesetter_pubheader ON pg_tid = 5 AND pn_pagesetter_pubheader.pg_pid = pn_pagesetter_pubdata5.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 = 'NewHamNews' 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 = 3) WHERE (pg_publishDate

  • 
  •  
• DavidJ
  
  

  • Rank: Softmore
  • Registered: Jan 22, 2008
  • Last visit: Apr 04, 2010
  • Posts: 130

  Posted: Mar 01, 2008 - 10:59 PM

  This may help,similar problem and resolution here
  
  --
  David
  

  • 
  •  
•  
•  

Users on-line

• michiel,
• rgasch

This list is based on users active over the last 60 minutes.