vue-people
vue-people copied to clipboard
Error binding parameter 19 - probably unsupported type.
ub18 + Django 2.2 + sqlite + SpatiaLite
when adding people in /admin/people/person/add/ page
django debug page:
site-packages/django/db/backends/utils.py in _execute
def _execute(self, sql, params, *ignored_wrapper_args):
self.db.validate_no_broken_transaction()
with self.db.wrap_database_errors:
if params is None:
return self.cursor.execute(sql)
else:
return self.cursor.execute(sql, params) # <= this line
def _executemany(self, sql, param_list, *ignored_wrapper_args):
self.db.validate_no_broken_transaction()
with self.db.wrap_database_errors:
return self.cursor.executemany(sql, param_list)
Local vars
Variable | Value
-- | --
ignored_wrapper_args | (False, {'connection': <django.contrib.gis.db.backends.spatialite.base.DatabaseWrapper object at 0x7f9e6aae3400>, 'cursor': <django.db.backends.utils.CursorDebugWrapper object at 0x7f9e6a837278>})
params | [None, 'aaaaa', None, None, '', None, None, 'https://github.com/xxxxxxx', None, None, None, None, 1, '2020-10-23 02:23:28.637068', '2020-10-23 02:23:28.637100', True, True, True, True, <django.contrib.postgres.fields.jsonb.JsonAdapter object at 0x7f9e6a8377b8>]
self | <django.db.backends.utils.CursorDebugWrapper object at 0x7f9e6a837278>
sql | ('INSERT INTO "people_person" ("user_id", "bio", "company", "hireable", ' '"github_login", "github_created", "github_updated", "github_url", ' '"twitter_url", "website_url", "avatar_url", "location", "type_id", ' '"created", "modified", "public_email", "feature_updates", "upcoming_events", ' '"job_opportunities", "settings") VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, ' '%s, %s, GeomFromText(%s,4326), %s, %s, %s, %s, %s, %s, %s, %s)')
I think key error is <django.contrib.postgres.fields.jsonb.JsonAdapter object at 0x7f9e6a8377b8>. so use postgis can pass this error. howerver, should sqlite3 backend be supported ?