Hello,

I'm trying to upgrade an ancient LSMB (1.2.26) to a slightly less ancient one (1.3.47) and the upgrade is not going smoothly, as you might imagine.

This error is present in the database log:

2020-04-16 11:42:42 BST ERROR: role "lsmb_<?lsmb dbname ?>__part_edit" does not exist 2020-04-16 11:42:42 BST STATEMENT: GRANT "lsmb_testbooks__file_read" TO "lsmb_<?lsmb dbname ?>__part_edit";

which seems to relate to line 707 in sql/modules/Roles.sql:

GRANT "lsmb_<?lsmb dbname ?>__file_read" TO "lsmb_<?lsmb dbname ?>__part_edit";

So, it looks like the substitution of the second dbname token in that line is not happening.

Can you suggest any reason why that might be and how/where I should go about fixing it?

Thanks very much,

Pete