Updating fro Joomla 3 to 4

I can see you are using a lot of time on these extensions so I am happy to make a donation if I can get help to sort this out and make the update work.

SQL file - it is simple text file. You can open it by any text editor.

I found "url_template" in the file 8.23.04.18.sql. So I should remove that line in just that file?

Should I do something after the upload/update (if it works)? You wrote something about editing the table I remove, which I did not understand. Where, in the component backend?

As I wrote, save lines, which you removed in separate file (not in extension folder)
And when you get it work, just tell me how many lines you removed, and I will suggest you next steps.

The update did not work but I may think why. "url_template" is also found in the file install.mysql.utf8.sql in com_zhosmmap\admin\sql

Should I remove the line in that file as well? Is that ok?

No. install file do not change.

And now what error do you get when you rollback, migrate and after that upload new package version (without this line)?