Log in | Register | Lost password

Bottom
SQL-Error when calling "Access" menu (v2.0.0 beta 1)
  • Posted: 31.08.2006, 23:00
     
    Converted
    rank:
    12
    registered:
     March 2009
    Status:
    offline
    last visit:
    Posts:
    0
    Hi,

    I get this error message when I call the menu "Access":

    Code

    pn/modules/mediashare/pneditapi.php(1102):

    "getAccessSettings" failed: Unknown table 'mbr.pn_group_membership'

    in field list while executing:

    Code

    SELECT mbr.pn_group_membership.pn_gid, grp.pn_groups.pn_name,

    CASE WHEN ISNULL(msa_access) THEN 0 ELSE msa_access END

    FROM pn_group_membership mbr

    INNER JOIN pn_groups grp ON grp.pn_groups.pn_gid = mbr.pn_group_membership.pn_gid

    LEFT JOIN pn_mediashare_access ON msa_groupid = mbr.pn_group_membership.pn_gid

    AND msa_albumid = 1 UNION SELECT -1, 'Everybody',

    CASE WHEN ISNULL(msa_access) THEN 0

    ELSE msa_access END FROM pn_mediashare_access

    WHERE msa_groupid = -1 AND msa_albumid = 1


    MySQL-Version 4.0




    edited by: Gouli, Sep 01, 2006 - 12:02 AM
    Top

Template courtesy of Designs By Darren.