assistance with database error?

[Josh Quinnell]

I have searched for the strings " date>0" and "date>1" to find for years
below 1970 without any luck. Do you have any suggestions for finding a date
before 1970?

Thanks
Josh

On Sat, Jul 21, 2012 at 4:24 AM, John Ralls <jralls at ceridwen.us> wrote:

>
> On Jul 20, 2012, at 2:20 PM, jaq wrote:
>
> > Hello, I worked on a account for the first time in a few months. I saved
> it
> > and opened it a short while later to " There was an error parsing the
> > file..."
> >
> > I maintained the old file on ubuntu and this is the first edit on a
> 2.4.10
> > for windows. The file opened fine before these edits. Here is the trace:
> >
> >
> > * 19:59:06  WARN <qof.engine> [guid_init()] only got 1869 bytes.
> > The identifiers might not be very random.
> > * 19:59:30  WARN <gnc.app-utils> Could not spawn perl: Failed to execute
> > child process (No such file or directory)
> > * 22:30:26  CRIT <qof> qof_strftime: assertion `tm' failed
> > * 22:30:26  CRIT <gnc.import> [TransactionGetTokens()]
> TransactionGetTokens:
> > error, strftime failed
>
> Hmmph. I thought that usually worked the other way, where a file written
> in M$Win won't read in Linux.
>
> Anyway, the problem is more than likely that you have an out-of-range (as
> in before 1 Jan 1970) date in your database. Your best bet is to hand-edit
> the file (you might have to gunzip it first) and fix it. Work with a copy.
>
> Regards,
> John Ralls
>
>