绑定参数14出错（类型不支持），SQLite3员工档案保存代码排查求助

Hey there! Let's break down this SQLite3 error and your save method code to figure out what's going wrong.

First, that error message tells us SQLite can't handle the data type you're trying to pass for the 14th parameter (field) in your database query. Let's go through the most likely culprits:

1. Mismatched Field Type in Your Model #

SQLite maps Python types to database types strictly, so start by identifying the 14th field in your StaffProfile model (count fields in the order you defined them). Check what type you assigned to that field (e.g., IntegerField, DateField, CharField) and compare it to the value you set on the instance before calling save().

Examples of common mismatches:

• A BooleanField receiving a string like "True" instead of an actual boolean (True/False)
• A DateTimeField getting a string date like "2024-05-20" instead of a datetime.datetime object
• A ForeignKey being assigned an ID number instead of a model instance (unless you use the _id suffix, e.g., department_id=5)

2. Unsupported Python Types Being Passed #

SQLite can't store arbitrary Python objects. If you're assigning something like a list, set, or a custom class instance to any model field, SQLite will throw this error.

Add a quick debug step before calling save() to inspect all field values and their types:

# Right before saving your StaffProfile instance
for field in StaffProfile._meta.fields:
    value = getattr(your_instance, field.name)
    print(f"Field: {field.name}, Value: {value}, Type: {type(value)}")

Look for any non-standard types (anything that's not str, int, float, datetime.datetime, bool, or a model instance for foreign keys).

3. Minor Gotcha in Your Image Handling Code #

While this isn't the direct cause of the parameter binding error, there's a small improvement you can make for new instances:
When creating a new StaffProfile (not updating an existing one), calling super().save() first is correct (it generates the image file path), but add a check to ensure an image is actually attached before trying to open it:

def save(self, *args, **kwargs):
    super(StaffProfile, self).save(*args, **kwargs)
    # Only process if an image exists
    if self.image:
        img = Image.open(self.image.path)
        if img.height > 300 or img.width > 300:
            output_size = (300, 300)
            img.thumbnail(output_size)
            img.save(self.image.path)

Quick Recap #

The most likely fix is tracking down that 14th field and ensuring the value you're passing matches the model's field type. SQLite is picky about type compatibility, so even a small mismatch (like a string instead of an integer) will trigger this error.

内容的提问来源于stack exchange，提问作者Muhuri.JSON