We recently upgraded our test site to 3.13.2 for testing before release to our production server.
We had some issues with the site details admin screen and the user roles configuration screens not saving the updates to the database, although the message back was saying the save was successful. I did some investigation and it looked like some of the database queries were not having the table prefix applied so the dtabase data was not updating correctly.
I found the following (the line numbers may be off slightly as I had to add debug code to identify the issues) -
* in website_code/php/management/modify_roles.php at line #24 I changed to
$query = "select distinct roleid from {$xerte_toolkits_site->database_table_prefix}role where name in ({$questionMarks})";
* in website_code/php/management/modify_roles.php at line #34 I changed to
$query = "select distinct roleid from {$xerte_toolkits_site->database_table_prefix}logindetailsrole where userid=?";
* in website_code/php/management/modify_roles.php at line #81 I changed to
$query = "delete from {$xerte_toolkits_site->database_table_prefix}logindetailsrole where userid=? and roleid in ({$questionMarks})";
* in website_code/php/management/modify_roles.php at line #81 I changed to
$query = "insert into {$xerte_toolkits_site->database_table_prefix}logindetailsrole (userid, roleid) values " . $questionMarks;
* in website_code/php/user_library.php at line #373 I changed to
$query = "select name from {$prefix}role join {$prefix}logindetailsrole on {$prefix}role.roleid={$prefix}logindetailsrole.roleid where {$prefix}logindetailsrole.userid=?;";
I hope this helps anyone who has similar issues.
PS I like the new feature to give admin roles to more users.
