Forgot to write that the code works in mysql and sqlite.
On Oct 12, 5:45 pm, SergeyPo <ser...@zarealye.com> wrote:
> The following statement gives strange error with Oracle. This has
> something to do with oracle_fix in gluon/sql.py
>
> many_to_many = (db.c_h.cart_id==db.carts.id)
> db(db.carts.id>0).select(db.carts.ALL, db.c_h.cart_id.count(),
> left=db.c_h.on(many_to_many),
> groupby=db.carts.ALL,
> orderby=carts_orderby,
> limitby = session.carts_limitby)
>
> Traceback (most recent call last):
> File "C:\web2py\gluon\restricted.py", line 176, in restricted
> exec ccode in environment
> File "C:\web2py\applications\advantage/controllers/cart.py", line
> 164, in <module>
> File "C:\web2py\gluon\globals.py", line 103, in <lambda>
> self._caller = lambda f: f()
> File "C:\web2py\applications\advantage/controllers/cart.py", line
> 13, in new_cart
> carts, search_form, pages = prepare_carts_table('filter_by_cart')
> File "C:\web2py\applications\advantage/controllers/cart.py", line
> 158, in prepare_carts_table
> limitby = session.carts_limitby),
> File "C:\web2py\gluon\sql.py", line 2146, in select
> r = response(query)
> File "C:\web2py\gluon\sql.py", line 2141, in response
> self._db._execute(query)
> File "C:\web2py\gluon\sql.py", line 777, in <lambda>
> oracle_fix_execute(a,self._cursor.execute)
> File "C:\web2py\gluon\sql.py", line 471, in oracle_fix_execute
> return execute(command[:-1], args)
> DatabaseError: ORA-00979: not a GROUP BY expression
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
