Hi Bill,
On Mon, Feb 27, 2017 at 6:28 PM, bill Ott <bill...@theotts.org> wrote:
> I have successfully moved the database from ledgersmb 1.3.30 (postgresql
> 9.1.7) to ledgersmb 1.5.3 (postgresql 9.5.6). I can do SQL selects in
> either and get the same results.
>
Great news! Thanks for sharing!
> When I attempt to access the database from ledgersmb 1.5.3 I get an
> error saying that the is a Database mismatch.
>
"database mismatch" (or rather database match) is determined by looking at
the value in the output column if you run this query:
SELECT * FROM defaults WHERE setting_key = 'version';
What is the output this statement in your setup?
> The documentation hints "Please reload the templates into the database
> after upgrading to 1.5. The database maintenance utility setup.pl offers
> this functionality through it's "Load Templates" button. I cannot find the
> referenced button. Any help appreciated.
>
While this advice is correct, it's not helpful in your case. It's talking
about the templates in the database from which invoices are printed. These
used to be stored on disk and now have to be loaded in the database. The
upgrade process *should* take care of that.
The advice you're looking for is that you can log in into your database
through setup.pl and click the "Rebuild" button. That *should* resolve your
issue, but I'm still very interested in hearing what the version number is
that the query above reports.
--
Bye,
Erik.
http://efficito.com -- Hosted accounting and ERP.
Robust and Flexible. No vendor lock-in.
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
