The foundation for your business
Fork me on GitHub
[ledgersmb-users] Replacement of tokens in SQL files
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[ledgersmb-users] Replacement of tokens in SQL files


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 ?>__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,

Openstrike - improving business through open source
https://www.openstrike.co.uk/ or call 01722 770036
users mailing list -- ..hidden..
To unsubscribe send an email to ..hidden..