Loading...
 
Skip to main content

Architecture / Installation

Forum List Topic List

Forums » Architecture / Installation » Problem with PostgreSQL » Re: Problem with PostgreSQL
You are viewing a reply to Problem with PostgreSQL
 
Thread actions
Print this page
  • Print all pages

    • Re: Problem with PostgreSQL

    Posted by eru posts: 21 Netherlands
    Copy to clipboard
    SELECT * FROM users_grouppermissions ;

    returns empty set.

    You meant probably
    Copy to clipboard
    SELECT * FROM users_objectpermissions ;
    where I get:
    Copy to clipboard
    groupName  |       permName        | objectType |             objectId             
------------+-----------------------+------------+----------------------------------
 Registered | tiki_p_view           | wiki page  | 6d7f618fdb6590000b06a03865b40191
 Registered | tiki_p_edit           | wiki page  | 6d7f618fdb6590000b06a03865b40191
 Registered | tiki_p_lock           | wiki page  | 6d7f618fdb6590000b06a03865b40191
 Registered | tiki_p_admin_wiki     | wiki page  | 6d7f618fdb6590000b06a03865b40191

    I don't know how objectId translates to wiki page ID (which is 1 - HomePage), but it works as DB changes when I manipulate website.

    And, of course:
    Copy to clipboard
    select * from users_usergroups ;
    yields:
    Copy to clipboard
    userId | groupName  
--------+------------
      2 | Registered

    where 2 is my user id.
    So, database seems ok... strange, right? 😊
    A hint - maybe something with small/capital letters, as pgsql is case-sensitive? No other ideas here.

    Reads: 375
    There are no comments at this time.