On Tue, Sep 18, 2012 at 4:22 PM, Antoine Beaupré <[email protected]>wrote:
> Hi,
>
> I am trying to upgrade from 1.2.25 to 1.3.18-2 (the Debian package). I
> have encountered significant issues.
>
> Here is the procedure I followed:
>
> https://wiki.koumbit.net/LedgerSmbUpgrade#A1.2.25_to_1.3.18
>
> Basically, I am creating a dumb database from scratch, dropping it and
> recreating it with the data from the other install, as I am working
> accross database servers on a completely separated install.
>
> What is happening, after the painful invoice rename process (can't those
> be sorted by invoice number ffs??), is that all tables are completely
> empty:
>
> koumbit12=# select * from acc_trans;
> [...]
> (0 row)
>
> All tables. I fail to understand how this can happen, especially since
> the upgrade script prompts me for actual data.
>
> For what it's worth, the second I hit "upgrade" on that last screen, it
> had already flushed all tables in the database, which can explain why
> the tables end up being empty.
>
> This is a major blocker for us, any ideas?
>
> yeah. This happens when the upgrade fails. The upgrade is
non-destructive but so is the downgrade, so you can run
sql/upgrade/1.3-1.2.sql to undo the upgrade. Then we can find the problem,
fix it, and try again.
The error message is probably in your /tmp/ledgersmb/dblog file. If you
could review it and possibly send it to me that would be helpful.
Best wishes,
Chris Travers
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Ledger-smb-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
