| 23 | | Nothing special :) |
| 24 | | |
| | 23 | Adding a local name fails on MySQL (sqlite fine): |
| | 24 | {{{ |
| | 25 | Traceback (most recent call last): |
| | 26 | File "gluon/restricted.py", line 186, in restricted |
| | 27 | exec ccode in environment |
| | 28 | File "/home/web2py/applications/eden/controllers/gis.py", line 1673, in <module> |
| | 29 | File "gluon/globals.py", line 96, in <lambda> |
| | 30 | self._caller = lambda f: f() |
| | 31 | File "/home/web2py/applications/eden/controllers/gis.py", line 492, in location |
| | 32 | output = shn_rest_controller(module, resource) |
| | 33 | File "/home/web2py/applications/eden/models/01_crud.py", line 1892, in shn_rest_controller |
| | 34 | output = res.execute_request(req, **attr) |
| | 35 | File "applications/eden/modules/s3xrc.py", line 893, in execute_request |
| | 36 | output = handler(r, **attr) |
| | 37 | File "/home/web2py/applications/eden/models/01_crud.py", line 1159, in shn_list |
| | 38 | next=r.there()) |
| | 39 | File "gluon/tools.py", line 2811, in create |
| | 40 | deletable=False, |
| | 41 | File "gluon/tools.py", line 2764, in update |
| | 42 | callback(onaccept,form,table._tablename) |
| | 43 | File "gluon/tools.py", line 48, in callback |
| | 44 | [action(form) for action in actions] |
| | 45 | File "/home/web2py/applications/eden/models/01_crud.py", line 1145, in <lambda> |
| | 46 | onaccept(form) |
| | 47 | File "/home/web2py/applications/eden/models/03_gis.py", line 503, in gis_location_onaccept |
| | 48 | name_dummy_element.onaccept(db, session.rcvars.gis_location, request) |
| | 49 | File "applications/eden/modules/widgets.py", line 217, in onaccept |
| | 50 | json_request = json_request ) |
| | 51 | File "applications/eden/modules/widgets.py", line 321, in _process_json |
| | 52 | id = json_table.insert(**json_record) |
| | 53 | File "gluon/sql.py", line 2003, in insert |
| | 54 | self._db._execute(query) |
| | 55 | File "gluon/sql.py", line 978, in <lambda> |
| | 56 | self._execute = lambda *a, **b: self._cursor.execute(*a, **b) |
| | 57 | File "/var/lib/python-support/python2.5/MySQLdb/cursors.py", line 166, in execute |
| | 58 | self.errorhandler(self, exc, value) |
| | 59 | File "/var/lib/python-support/python2.5/MySQLdb/connections.py", line 35, in defaulterrorhandler |
| | 60 | raise errorclass, errorvalue |
| | 61 | IntegrityError: (1452, 'Cannot add or update a child row: a foreign key constraint fails (`sahana/gis_location_name`, CONSTRAINT `gis_location_name_ibfk_1` |
| | 62 | }}} |
