Trying to do a new install of Calendar (0.0.8) in PHP3 (3.02). I followed the instructions and went back and double checked my work. All seems ok, however, when I try to set the permission in ACP (Permission Role->Admin Role (Edit)), to "YES" and press submit, the system accepts it and update the system "ROLE is successfully editted". However, when you go back into the role permission, it wasn't updated.
Secondly, when I try to update Users Role, I get an sql error for Duplicate entry.
Code: Select all
General Error SQL ERROR [ mysqli ] Duplicate entry '5-0' for key 1  SQL INSERT INTO bb_acl_roles_data (role_id, auth_option_id, auth_setting) VALUES (5, 86, 1), (5, 88, 1), (5, 93, 1), (5, 109, 1), (5, 114, 1), (5, 0, 1), (5, 0, 1), (5, 0, 1), (5, 0, 1), (5, 85, 1) BACKTRACE FILE: includes/db/mysqli.php LINE: 143 CALL: dbal->sql_error() FILE: includes/db/dbal.php LINE: 438 CALL: dbal_mysqli->sql_query() FILE: includes/acp/auth.php LINE: 966 CALL: dbal->sql_multi_insert() FILE: includes/acp/acp_permission_roles.php LINE: 214 CALL: auth_admin->acl_set_role() FILE: includes/functions_module.php LINE: 471 CALL: acp_permission_roles->main() FILE: adm/index.php LINE: 74 CALL: p_master->load_active()
If I delete the Primary Keys for bb_acl_roles_data, the system reports that Users Permission were updated successfully, however, nothing is updated.
I still cannot figure out why this is not working and could not find any answers to this problem in the bulletin board (only problems...)
Any help would be appreciated.
1) I didn't use the drop down tabs in the ACP to select Calendar MODS. Need to drop use the drop down. However, they will not appear until you clear your cache. (BTW - I am an idiot because its not the browser cache, its the ACP (General) cache. Then all the permission worked fine. The instruction manual needs to be a bit clearer on these steps.