there lots of mysql issues unfortunately.
On Apr 29, 7:08 am, Hans <johann.scheibelho...@easytouch-edv.com> wrote: > Update: I've found that its a mysql issue not a web2py one. > > On Apr 28, 4:52 pm, Hans <johann.scheibelho...@easytouch-edv.com> > wrote: > > > 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 -~----------~----~----~----~------~----~------~--~---
