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 :) |