Re: Migrating from 1.3.30 to 1.5.3

Subject: Re: Migrating from 1.3.30 to 1.5.3

From: bill Ott <..hidden..>

Date: Mon, 27 Feb 2017 14:27:10 -0500

Hi, Erik. Apparently I am not migrating this properly. The version from the SQl select command was 1.3.30.

I moved the database by doing "pg_dumpall -c > dumpdata" from the 1.3.30 system but using the pg_dumpall program from the 1.5.3 system. I then issued "psql -f dumpdata postgres" on the 1.5.3 system. Then logging into the 1.5.3 system with psql and executing a "\l" shows all of the databases. BUT, the version field from default is 1.3.30

Very odd the every select I tried on the database works correctly even though the version is the old version.

How should I proceed? Can I just use SQl to modify the version field, or would that just be making things worse?

Regards,
Bill Ott

Home: 919-363-0031
Cell: 919-434-7589
Email: Mailto:..hidden..
Website: http://www.theotts.org
Profile: http://www.linkedin.com/in/wbott

On 02/27/2017 01:10 PM, Erik Huelsmann wrote:

Hi Bill,

On Mon, Feb 27, 2017 at 6:28 PM, bill Ott <..hidden..> 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
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users

------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot