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 [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
