Upgrade from 1.6.8 to 1.8.0 issues

[Michael B. <mi...@di...>]

Hi Everyone:

I upgraded from version 1.6.8 to 1.8.0 and now I am getting the error
below when trying to do an AR Aging report.  Yes, I did run the upgrade
script.



Error!


ERROR: For SELECT DISTINCT, ORDER BY expressions must appear in target
list



I was able to fix the invoice printing issues by deleting my account and
reentering it.


Any ideas on the AR Aging report error?

Merry Christmas,

Mike Bush
-- 

Digital Minds International
E-Mail:	Mi...@Di...
Web:	http://www.DigitalMinds.net
Tel:	(615) 661-7900
Fax:	(615) 661-7949





Date: Sun, 23 Dec 2001 14:41:15 -0600 (CST)
From: Michael Bush <mi...@di...>
To: Dieter Simader <dsi...@sq...>
Subject: Re: SQL-Ledger Version 1.8.0

Hey Dieter:

Upgraded from Version 1.6.8 to 1.8.0 and now when trying to do an AR Aging
report I get the following error message:

----------------------

Error!


ERROR: For SELECT DISTINCT, ORDER BY expressions must appear in target
list


----------------------

When printing invoices I get:

Content-Type: text/html
Error!

No such file or directory: invoice.html


------------------------


I ran the upgrade UPGRADE-1.6-1.8 sql script with no errors.

Any ideas?

Merry Christmas,

Mike Bush

--

Digital Minds International
E-Mail: Mi...@Di...
Web:    http://www.DigitalMinds.net
Tel:    (615) 661-7900
Fax:    (615) 661-7949