#35819: sqlite3.ProgrammingError while python manage.py dumpdata > dump.json
-------------------------------------+-------------------------------------
Reporter: DragonwolfAside | Type: Bug
Status: new | Component: Core
| (Management commands)
Version: 5.1 | Severity: Normal
Keywords: dumpdata | Triage Stage:
| Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Python 3.12.4 Django 5.1.1
Having difficulty dumping sql with pipe
{{{
C:\Users\Admin\Desktop\Projects\django-project>python manage.py dumpdata >
dump.json
CommandError: Unable to serialize database: 'gbk' codec can't encode
character '\xa0' in position 70: illegal multibyte sequence
Exception ignored in: <generator object cursor_iter at 0x000001FA8E382020>
Traceback (most recent call last):
File "C:\Users\Admin\AppData\Local\Programs\Python\Python312\Lib\site-
packages\django\db\models\sql\compiler.py", line 2115, in cursor_iter
cursor.close()
sqlite3.ProgrammingError: Cannot operate on a closed database.
}}}
but following command runs well
{{{
C:\Users\Admin\Desktop\Projects\django-project>python manage.py dumpdata
[{"model": "admin.logentry", "pk": 1, "fields": {"action_time":
"2024-10-06T20:31:44.362", "user": 1, "content_type": 6, "object_id": "1",
...
}}}
chcp 65001 also didn't work, perhaps Chinese language system make the
default encoding to gbk, leading to a serialize error, then the cursor
closes.
--
Ticket URL: <https://code.djangoproject.com/ticket/35819>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/010701926755a0ac-8bd35e86-d796-4934-bfdf-5f8192f35bf7-000000%40eu-central-1.amazonses.com.
