| 22 | | * Setting a Parent to a GIS Location causes an error on MySQL/Python25 (sqlite on Python26 fine) |
| 23 | | {{{ |
| 24 | | Traceback (most recent call last): |
| 25 | | File "gluon/restricted.py", line 186, in restricted |
| 26 | | exec ccode in environment |
| 27 | | File "/home/web2py/applications/eden/controllers/gis.py", line 1672, in <module> |
| 28 | | File "gluon/globals.py", line 96, in <lambda> |
| 29 | | self._caller = lambda f: f() |
| 30 | | File "/home/web2py/applications/eden/controllers/gis.py", line 491, in location |
| 31 | | output = shn_rest_controller(module, resource) |
| 32 | | File "/home/web2py/applications/eden/models/01_crud.py", line 1891, in shn_rest_controller |
| 33 | | res, req = s3xrc.parse_request(module, resource, session, request, response) |
| 34 | | File "applications/eden/modules/s3xrc.py", line 2798, in parse_request |
| 35 | | debug=self.debug) |
| 36 | | File "applications/eden/modules/s3xrc.py", line 2780, in request |
| 37 | | debug=self.debug) |
| 38 | | File "applications/eden/modules/s3xrc.py", line 1755, in __init__ |
| 39 | | self.resource.load() |
| 40 | | File "applications/eden/modules/s3xrc.py", line 600, in load |
| 41 | | self.__set = self.__db(self.__query).select(self.table.ALL, limitby=limitby) |
| 42 | | File "gluon/sql.py", line 3214, in select |
| 43 | | rows = response(query) |
| 44 | | File "gluon/sql.py", line 3209, in response |
| 45 | | db._execute(query) |
| 46 | | File "gluon/sql.py", line 978, in <lambda> |
| 47 | | self._execute = lambda *a, **b: self._cursor.execute(*a, **b) |
| 48 | | File "/var/lib/python-support/python2.5/MySQLdb/cursors.py", line 166, in execute |
| 49 | | self.errorhandler(self, exc, value) |
| 50 | | File "/var/lib/python-support/python2.5/MySQLdb/connections.py", line 35, in defaulterrorhandler |
| 51 | | raise errorclass, errorvalue |
| 52 | | ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near |
| 53 | | }}} |
| | 23 | Nothing special :) |