NOT NULL constraint failed: task_task.create_time
行号: 43 - NOT NULL constraint failed: task_task.create_time ***********, ************, 0, title{/html/head/title/text()} keywords{/html/head/meta[3]/@content} description{/html/head/meta[2]/@content}, title:{title} keywords:{keywords} description:{description}, 0, 10, , 1, , , Traceback (most recent call last): File "/usr/local/lib/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute return self.cursor.execute(sql, params) File "/usr/local/lib/python3.6/site-packages/django/db/backends/sqlite3/base.py", line 384, in execute return Database.Cursor.execute(self, query, params) sqlite3.IntegrityError: NOT NULL constraint failed: task_task.create_time
The above exception was the direct cause of the following exception:
Traceback (most recent call last): File "/usr/local/lib/python3.6/site-packages/import_export/resources.py", line 530, in import_row self.save_instance(instance, using_transactions, dry_run) File "/usr/local/lib/python3.6/site-packages/import_export/resources.py", line 323, in save_instance instance.save() File "/root/WebMonitor/task/models.py", line 175, in save super(Task, self).save(*args, **kwargs) File "/usr/local/lib/python3.6/site-packages/django/db/models/base.py", line 741, in save force_update=force_update, update_fields=update_fields) File "/usr/local/lib/python3.6/site-packages/django/db/models/base.py", line 779, in save_base force_update, using, update_fields, File "/usr/local/lib/python3.6/site-packages/django/db/models/base.py", line 851, in _save_table forced_update) File "/usr/local/lib/python3.6/site-packages/django/db/models/base.py", line 900, in _do_update return filtered._update(values) > 0 File "/usr/local/lib/python3.6/site-packages/django/db/models/query.py", line 760, in _update return query.get_compiler(self.db).execute_sql(CURSOR) File "/usr/local/lib/python3.6/site-packages/django/db/models/sql/compiler.py", line 1469, in execute_sql cursor = super().execute_sql(result_type) File "/usr/local/lib/python3.6/site-packages/django/db/models/sql/compiler.py", line 1140, in execute_sql cursor.execute(sql, params) File "/usr/local/lib/python3.6/site-packages/django/db/backends/utils.py", line 99, in execute return super().execute(sql, params) File "/usr/local/lib/python3.6/site-packages/django/db/backends/utils.py", line 67, in execute return self._execute_with_wrappers(sql, params, many=False, executor=self._execute) File "/usr/local/lib/python3.6/site-packages/django/db/backends/utils.py", line 76, in _execute_with_wrappers return executor(sql, params, many, context) File "/usr/local/lib/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute return self.cursor.execute(sql, params) File "/usr/local/lib/python3.6/site-packages/django/db/utils.py", line 89, in exit raise dj_exc_value.with_traceback(traceback) from exc_value File "/usr/local/lib/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute return self.cursor.execute(sql, params) File "/usr/local/lib/python3.6/site-packages/django/db/backends/sqlite3/base.py", line 384, in execute return Database.Cursor.execute(self, query, params) django.db.utils.IntegrityError: NOT NULL constraint failed: task_task.create_time
csv导入数据的时候,字段task_task.create_time为空,批量导入的时候,每次都会有几个或者一堆类似的提示,然后少的话按照提示删除掉提示的行,再次导入,一切正常,字段task_task.create_time就算填充也会报错,报错几率更高,索性为空。。。