vue-people icon indicating copy to clipboard operation
vue-people copied to clipboard

Error binding parameter 19 - probably unsupported type.

Open pythonwood opened this issue 3 years ago • 1 comments

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

pythonwood avatar Oct 23 '20 02:10 pythonwood

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 ?

pythonwood avatar Oct 23 '20 02:10 pythonwood