Loading...
 
Skip to main content

Development

Forum List Topic List

 
Thread actions
Print this page
  • Print all pages

    • setting permissions file gallery

    Posted by bschelst

    I downloaded the CVS version today, but I think there is a small bug in that version.
    When you try to update the permissions of a file gallery I always receive:

    'Permission denied you cannot assign permissions for this page '

    Of course I'm the admin and I had access before.


    B

    Reads: 1565
    Posted by bschelst

    > I downloaded the CVS version today, but I think there is a small bug in that version.
    > When you try to update the permissions of a file gallery I always receive:
    >
    > 'Permission denied you cannot assign permissions for this page '
    >
    > Of course I'm the admin and I had access before.
    >
    >
    > B

    Same for newsletters 😢


    Posted by Gary Cunningham-Lee

    Make sure your Tiki database's users_permissions table is up to date. (Maybe you updated your files but didn't update the database.) Specifically, tiki_p_admin_objects might be missing.

    -- Gary

    Posted by bschelst

    > Make sure your Tiki database's users_permissions table is up to date. (Maybe you updated your files but didn't update the database.) Specifically, tiki_p_admin_objects might be missing.
    >
    > — Gary

    Hey,

    I did run the tiki_1.9to1.10.sql script.

    Posted by bschelst

    > Make sure your Tiki database's users_permissions table is up to date. (Maybe you updated your files but didn't update the database.) Specifically, tiki_p_admin_objects might be missing.
    >
    > — Gary

    By the way, the 1.9to1.10 script doesn't contain any modifications for 'tiki_p_admin_objects'

    Posted by Gary Cunningham-Lee

    > > Make sure your Tiki database's users_permissions table is up to date. (Maybe you updated your files but didn't update the database.) Specifically, tiki_p_admin_objects might be missing.
    > >
    > > — Gary
    >
    > By the way, the 1.9to1.10 script doesn't contain any modifications for 'tiki_p_admin_objects'

    Well, I suppose 1.9to1.10 assumes all the ->1.9 upgrades have already been done without omissions, which may or may not be a good assumption. Coincidentally, I was trying to set a permission on a tracker in a 1.9.4 install about the time you posted and I got an error that specifically mentioned tiki_p_admin_objects so I looked at the 1.9.4 archive. There's a /db/userpermissions-1.9.4.sql that includes this line: insert into users_permissions (permName,permDesc,level,type) values ('tiki_p_admin_objects','Can edit object permissions', 'admin', 'tiki');. This is also in the 1.8to1.9.sql file but apparently got skipped when I upgraded. I'm just thinking if you are getting permission errors, this may be relevant.

    -- Gary - zukakakina.comQuestion

    Posted by bschelst

    >
    > Well, I suppose 1.9to1.10 assumes all the ->1.9 upgrades have already been done without omissions, which may or may not be a good assumption. Coincidentally, I was trying to set a permission on a tracker in a 1.9.4 install about the time you posted and I got an error that specifically mentioned tiki_p_admin_objects so I looked at the 1.9.4 archive. There's a /db/userpermissions-1.9.4.sql that includes this line: insert into users_permissions (permName,permDesc,level,type) values ('tiki_p_admin_objects','Can edit object permissions', 'admin', 'tiki');. This is also in the 1.8to1.9.sql file but apparently got skipped when I upgraded. I'm just thinking if you are getting permission errors, this may be relevant.
    >
    > — Gary - zukakakina.comQuestion

    Euh, there is no 1.9.4 script. Not in the official release, neither in the CVS.
    I just downloaded the official 1.9.4 release, and this are the contents of the db dir:

    ------
    Makefile dbg_console.sql structure_fix_1.7to1.8.sql tiki-1.9-sybase.sql tiki-secdb_pre_1.7_mysql.sql tiki_1.9to1.9.2.sql tiki_postgresql.sql
    README.txt fulltext.sql tiki-1.9-mysql.sql tiki-db.php tiki.sql tiki_ddl.sql tiki_sqlite.sql
    _htaccess index.php tiki-1.9-oci8.sql tiki-secdb_1.7.X_mysql.sql tiki_1.7to1.8.sql tiki_mysql.sql tiki_sybase.sql
    case_patch.php oracle tiki-1.9-pgsql.sql tiki-secdb_1.8.X_mysql.sql tiki_1.8to1.9.sql tiki_oracle.err.sql
    comments_fix_1.7to1.8.sql profiles tiki-1.9-sqlite.sql tiki-secdb_1.9_mysql.sql tiki_1.9.1to1.9.2.sql tiki_oracle.sql
    ------

    And this is the content of the db in the CVS version:

    ------
    CVS convert_nulls_to_non_nulls.sql profiles tiki-db.php tiki_1.7to1.8.sql tiki_mysql.sql
    Makefile convertscripts structure_fix_1.7to1.8.sql tiki-secdb_1.10_mysql.sql tiki_1.8to1.9.sql tiki_oracle.err.sql
    README.txt dbg_console.sql tiki-1.10-mysql.sql tiki-secdb_1.7.X_mysql.sql tiki_1.9.1to1.9.2.sql tiki_oracle.sql
    _htaccess fulltext.sql tiki-1.10-oci8.sql tiki-secdb_1.8.X_mysql.sql tiki_1.9to1.10.sql tiki_postgresql.sql
    case_patch.php index.php tiki-1.10-pgsql.sql tiki-secdb_1.9_mysql.sql tiki_1.9to1.9.1.sql tiki_sqlite.sql
    comments_fix_1.7to1.8.sql oracle tiki-1.10-sqlite.sql tiki-secdb_pre_1.7_mysql.sql tiki_1.9to1.9.2.sql tiki_sybase.sql
    convert_nulls_to_non_nulls.php pgsql tiki-1.10-sybase.sql tiki.sql tiki_ddl.sql
    ------

    Maybe I'm starting to get blind or so 😊


    B

    Posted by Gary Cunningham-Lee

    > Euh, there is no 1.9.4 script. Not in the official release, neither in the CVS.
    > I just downloaded the official 1.9.4 release, and this are the contents of the db dir:
    >
    > ....

    Hmm. I also downloaded the official release for this (tikiwiki-1.9.4.zip), and have that file (but was actually a little surprised to see it since its name doesn't follow the usual Tiki sql file pattern). Did you download the zip file, or one of the others — tar.bz2 or tar.gz? Sometimes they aren't exactly the same, it seems. (Also, the permission is in the tiki_1.8to1.9.sql upgrade file, IIRC.)

    > Maybe I'm starting to get blind or so 😊

    Let's hope there's another explanation. 😉

    -- Gary

    Posted by bschelst

    > Hmm. I also downloaded the official release for this (tikiwiki-1.9.4.zip), and have that file (but was actually a little surprised to see it since its name doesn't follow the usual Tiki sql file pattern). Did you download the zip file, or one of the others — tar.bz2 or tar.gz? Sometimes they aren't exactly the same, it seems. (Also, the permission is in the tiki_1.8to1.9.sql upgrade file, IIRC.)
    >
    > > Maybe I'm starting to get blind or so 😊
    >
    > Let's hope there's another explanation. 😉
    >


    I used the tar.gz file

    Posted by bschelst

    > > Euh, there is no 1.9.4 script. Not in the official release, neither in the CVS.
    > > I just downloaded the official 1.9.4 release, and this are the contents of the db dir:
    > >
    > > ....
    >
    > Hmm. I also downloaded the official release for this (tikiwiki-1.9.4.zip), and have that file (but was actually a little surprised to see it since its name doesn't follow the usual Tiki sql file pattern). Did you download the zip file, or one of the others — tar.bz2 or tar.gz? Sometimes they aren't exactly the same, it seems. (Also, the permission is in the tiki_1.8to1.9.sql upgrade file, IIRC.)
    >

    I did run the permission manually , which was in the 1.8to1.9 script:

    INSERT INTO users_permissions (permName,permDesc,level,type) values ('tiki_p_admin_rssmodules','Can admin rss modules', 'admin', 'tiki');
    insert into users_permissions (permName,permDesc,level,type) values ('tiki_p_admin_polls','Can admin polls', 'admin', 'tiki');
    insert into users_permissions (permName,permDesc,level,type) values ('tiki_p_admin_objects','Can edit object permissions', 'admin', 'tiki');


    still the same problem.
    But I don't think this can be the problem, because I had 1.9.3 running before without any problems. So if the 1.8 to 1.9 failed in the past, I should had the same problem in 1.9.3 , and that wasn't the case.