Elxis CMS Forum

Support => Database => Topic started by: def on November 19, 2010, 13:29:26

Title: Oracle error on the first page (Tab "Logged") with 2009.2
Post by: def on November 19, 2010, 13:29:26

Hi.
We use 2009.2 version and oracle 11g.
After logon in tab "Logged" this error:

oci8 Error [979] : EXECUTE
URI: index2.php?option=com_admin&mylang=english
Message: ORA-00979: not a GROUP BY expression
select * from (SELECT /*+FIRST_ROWS*/ username, time, userid, usertype, gid, ip FROM elx_session GROUP BY ip ORDER BY time DESC) where rownum <= :adodb_offset

Title: Re: Oracle error on the first page (Tab "Logged") with 2009.2
Post by: datahell on November 19, 2010, 18:38:58

Use of Oracle in Elxis 2009.x is experimental. We focus on making Elxis fully Oracle compatible on the 2011.0 release.

Title: Re: Oracle error on the first page (Tab "Logged") with 2009.2
Post by: def on November 20, 2010, 00:16:19

Thank you for your reply.
When the planned output 2011.0 release?

Title: Re: Oracle error on the first page (Tab "Logged") with 2009.2
Post by: datahell on November 20, 2010, 08:36:37

It is too early to tell an exact date right now. It will surely be ready at least after 4-5 months.