Thank You Huppy! The code worked!
Quote:
|
Sometimes that update script is not so reliable. Just recently, I had to backdate the db_version (on a fresh 9196 peqdb), so it would check for more missing updates/tables/columns. Sometimes, I've had to manually install the updates individually. If you copy and paste the following into an sql query, it will get rid of that error.
|
So I guess I was doing the right steps, just that the codes might not have been updated correctly/fully. Thanks again for the tips. Unfortunately I was never a DB guy, hopefully I won't run into similar issues again....
On a side note, I installed the server, and subsequently restored an old database on Ubuntu 22.04 LTS, and it seems to be running fine for the time being. It has only been running for an hour or so, so it is still too early to decide, but it seems fine.
Thanks again.