Text only | Text with Images

KonaKart Community Forum

Installation / Configuration => Programming of KonaKart => Topic started by: Irina on June 23, 2011, 03:07:12 pm

Title: SQLException on sorting by Price in Product item
Post by: Irina on June 23, 2011, 03:07:12 pm
Hello ,

when I select a Product item in Product menu and sort them by Price I get next error:
(org.apache.torque.TorqueException) - java.sql.SQLException: ORDER BY items must appear in the select list if SELECT DISTINCT is specified.

I can specify full error message if you need.

Thanks,
Irina
Title: Re: SQLException on sorting by Price in Product item
Post by: julie on June 23, 2011, 03:22:34 pm
Can you reproduce it on our online demo or after a default installation ?
Title: Re: SQLException on sorting by Price in Product item
Post by: Irina on June 23, 2011, 03:53:30 pm
Sorry I forgot to add that tis is reproduced in administration part.
Yes the error reproduced for default installation also.

Regards,
Irina
Title: Re: SQLException on sorting by Price in Product item
Post by: trevor on June 23, 2011, 03:59:08 pm
I can't reproduce it when I sort the products in the admin app by price. What database are you using?
Title: Re: SQLException on sorting by Price in Product item
Post by: Irina on June 23, 2011, 05:19:53 pm
We are using MSSQL 2008 RC2.
Title: Re: SQLException on sorting by Price in Product item
Post by: Irina on July 04, 2011, 07:25:01 am
Hi Trevor,

do you have any idea why this error has happened? Will you suggest me something?

Regards,
Irina
Title: Re: SQLException on sorting by Price in Product item
Post by: kate on July 08, 2011, 08:26:50 am
It's a problem when using MS SQL Server but has been fixed in the next release (v5.5.0.0).
Text only | Text with Images