Error using sqlite and Roles/Permissions

June 24, 2020, 07:33:51 PM

Bug using Roles/Permissions in Sqlite database.

I believe the buildQuery function in PDOFb.php has a bug.

When using sqlite database and using the Roles/Permssions, the query is

SELECT CONCAT(page_name, '/', action_name) AS page FROM role_permissions WHERE role_id = ?

For mysql that would be fine, however for sqlite the concatenate function is || so the query should be:

SELECT page_name ||' /' || action_name AS page FROM role_permissions WHERE role_id = ?

Can that be fixed so the sqlite database can be used with the Roles/Permissions??

Please fix...

Re: Error using sqlite and Roles/Permissions

Reply #1 – June 24, 2020, 08:24:41 PM

The problem stems from line 2034 in the pageactiondetails.xml file that's used to create the ACL.php file.

Does someone know if that could be changed to look at the database type (mysql or sqlite) and create the appropriate php code??? That would be a nice short term solution until an updated release could be made.

I don't know if the database type is exposed anywhere when that xml file is processed.