Zikula: A Flexible Open Source Content Management System
home | forum | contact us

Dizkus

Bottom
pagesetter errors
  • Posted: 02.03.2008, 09:49
     
    Melinda
    rank:
    Helper Helper
    registered:
     October 2007
    Status:
    offline
    last visit:
    26.07.08
    Posts:
    101
    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
  • Posted: 02.03.2008, 15:59
     
    DavidJ
    rank:
    Softmore Softmore
    registered:
     January 2008
    Status:
    offline
    last visit:
    09.09.08
    Posts:
    75
    This may help,similar problem and resolution here

    --
    David

Main Menu

Extensions Database

Documentation

Development

Login

Donate to Zikula