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
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
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,
Openstrike - improving business through open source
or call 01722 770036