[ledgersmb-users] Re: Migrating from 1.3 to 1.8

Hi All,

BTW, there's a CentOS/RH-based SysV init script here: https://github.com/ledgersmb/LedgerSMB/tree/master/doc/conf/sysvinit hopefully that helps to (quickly) build one for LFS. I'd be happy to include such an script in our repository for use by others or even just for reference.

The LFS boot scripts are much more "bare bones" but this will be an excellent starting point, thanks!

The "entry_id" column of table "acc_trans" is just sequential numbers, as far as I can tell. Maybe I misunderstand.

That's interesting. If there are no rows where "amount" is null in acc_trans, then why does this query fail:

select trans_id, chart_id, transdate from acc_trans WHERE amount IS NULL

This may be simpler than it looks. Trying to use it directly from psql, I'm running into an access problem.

For the information of the mailing list: This discussion didn't peter out without a solution; instead, Victor and I exchanged some screenshots of the problems he was looking at, privately. With his help, I was able to create the 1.8.12 release, which has allowed him to migrate (as far as I know) the books of two companies.

Bye,

Erik.

http://efficito.com -- Hosted accounting and ERP.

Robust and Flexible. No vendor lock-in.