[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

What database version for LedgerSMB 1.2.17, please?



Hi there,

I've just grabbed ledgersmb-1.2.17 from sourceforge & grappled with my package manager & the (new?) Perl dependencies.

1.2.17 is the latest stable, right?

What is the correct database version, please?

I was previously on LedgerSMB 1.2.8:

  # SELECT value from defaults where setting_key = 'version';
  value
  -------
   1.2.0
  (1 row)

  # \q

I don't know if this was the correct database version for that version of LedgerSMB, but if I look in the sql/legacy/ directory I see:

# ls -v1 /usr/local/ledgersmb/sql/legacy/
Pg-upgrade-1.2.6-1.2.7.sql
Pg-upgrade-1.2.7-1.4.0.sql
Pg-upgrade-1.4.0-1.6.0.sql
Pg-upgrade-1.6.0-1.8.0.sql
Pg-upgrade-1.8.0-1.8.4.sql
Pg-upgrade-1.8.4-1.8.5.sql
Pg-upgrade-1.8.5-2.0.0.sql
Pg-upgrade-2.0.0-2.0.8.sql
Pg-upgrade-2.0.8-2.2.0.sql
Pg-upgrade-2.2.0-2.3.0.sql
Pg-upgrade-2.3.0-2.3.1.sql
Pg-upgrade-2.3.1-2.3.3.sql
Pg-upgrade-2.3.3-2.3.4.sql
Pg-upgrade-2.3.4-2.3.5.sql
Pg-upgrade-2.3.5-2.3.6.sql
Pg-upgrade-2.3.6-2.3.7.sql
Pg-upgrade-2.3.7-2.3.8.sql
Pg-upgrade-2.3.8-2.3.9.sql
Pg-upgrade-2.3.9-2.4.2.sql
Pg-upgrade-2.4.2-2.4.3.sql
Pg-upgrade-2.4.3-2.4.4.sql
Pg-upgrade-2.4.4-2.5.0.sql
Pg-upgrade-2.5.0-2.5.2.sql
Pg-upgrade-2.5.2-2.6.0.sql
Pg-upgrade-2.6.0-2.6.1.sql
Pg-upgrade-2.6.1-2.6.2.sql
Pg-upgrade-2.6.2-2.6.3.sql
Pg-upgrade-2.6.3-2.6.4.sql
Pg-upgrade-2.6.4-2.6.7.sql
Pg-upgrade-2.6.7-2.6.12.sql
Pg-upgrade-2.6.12-2.6.17.sql
Pg-upgrade-2.6.17-2.6.18.sql
Pg-upgrade-2.6.18-2.6.19.sql
# ls -v1 /usr/local/ledgersmb/sql/legacy/ | wc -l
33
#

If I'm reading this correctly then all 33 files are greater-numbered than my current database.

It surely cannot be that I've to run them all to become current?

Are databases >= 1.4 for unstable releases of LedgerSMB, or have I f'd- up badly at some point in the past?

Thanks in advance for all suggestions,

Stroller.