I'm experiencing a strange behavior within the code below. I tried to
split the problem in the smallest pieces which I'm able to debug. My
interpretation of the findings is that most likely I run into a web2py
internal variable length issue/limitation. Let me tell you why I think
that:
The tables ips1, ips2, ips3, ips4 and ips5 are identical aliases of
db.ipst.
There code works without error like it is below (watch the 3 commented
lines!).
The code also works without error if I comment out *ANY 3* out of the
db.ipst.id and its 5 aliases.
Each code line below (also the 3 commented ones) works without error
as long as any 3 other lines from db.ipst.id and its 5 aliases are
commented out - all combinations work.
The problem only occurs if I have less than 3 of the lines below
commented out.
Unfortunately I'm not able to debug into web2py framework code - and
despite hours of finding a solution for that I could not find one. And
based on the tools I have I'm at the end of all ideas I had.
If it helps I can also send you login information (and instructions to
get to the function with the issue) for the development server via
personal email upon request.
I'm using MySQL and Web2Py 1.61.1.
records=SQLTABLE(db(db.model_master.id==mid).select(
db.model_master.code,
db.subsidary.name,
db.ipst.id,
ips1.id,
# ips2.id,
# ips3.id,
# ips4.id,
ips5.id,
left=[db.ipst.on(rows_ipst),
ips1.on(rows_ips1),
ips2.on(rows_ips2),
ips3.on(rows_ips3),
ips4.on(rows_ips4),
ips5.on(rows_ips5)
],
orderby=db.model_master.code|db.subsidary.line),
headers=headers)
Error traceback
Traceback (most recent call last):
File "/usr/lib/web2py/gluon/restricted.py", line 98, in restricted
exec ccode in environment
File "/usr/lib/web2py/applications/ips/controllers/default.py", line
657, in <module>
File "/usr/lib/web2py/gluon/globals.py", line 75, in <lambda>
self._caller = lambda f: f()
File "/usr/lib/web2py/applications/plugin_t2/modules/t2.py", line
1188, in h
return f(*a,**b)
File "/usr/lib/web2py/applications/ips/controllers/default.py", line
537, in fcc
orderby=db.model_master.code|db.subsidary.line),
File "/usr/lib/web2py/gluon/sql.py", line 1977, in select
r = response(query)
File "/usr/lib/web2py/gluon/sql.py", line 1972, in response
self._db._execute(query)
File "/usr/lib/web2py/gluon/sql.py", line 691, in <lambda>
self._execute = lambda *a, **b: self._cursor.execute(*a,**b)
File "/var/lib/python-support/python2.5/MySQLdb/cursors.py", line
166, in execute
self.errorhandler(self, exc, value)
File "/var/lib/python-support/python2.5/MySQLdb/connections.py",
line 35, in defaulterrorhandler
raise errorclass, errorvalue
OperationalError: (1054, "Unknown column 'subsidary.id' in 'on
clause'")
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" 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
-~----------~----~----~----~------~----~------~--~---
