16 Apr
2020
16 Apr
'20
12:48 p.m.
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
--
Openstrike - improving business through open source
https://www.openstrike.co.uk/ or call 01722 770036