django-silk icon indicating copy to clipboard operation
django-silk copied to clipboard

django.db.utils.IntegrityError on Oracle for silk.models.Request.

Open danizen opened this issue 6 years ago • 3 comments

django 1.11.16 django-silk 3.0.1

Oracle makes no difference between '' and BLANK, and so the file field in silk.models.Request does not work properly. The field is declared as: prof_file = FileField(max_length=300, blank=True, storage=silk_storage)

On the oracle level, I have the following constraint for this field: PROF_FILE NVARCHAR2(300) default NULL not null

Since you are just using django's FileField you may call it a Django error. But you should track it, anyway.

My solution may be on local to use my database router to route silk to an sqlite3 database. This solution, provided it worked, could be documented somewhere.

danizen avatar Dec 20 '18 18:12 danizen

Using a local sqlite3 database via a database router addresses this issue, but it is worth fixing.

danizen avatar Dec 20 '18 20:12 danizen

Hi @danizen Can you please attach a minimal app producing the error?

nasirhjafri avatar Jan 22 '19 19:01 nasirhjafri

Should be solved by #258

SebCorbin avatar Oct 27 '22 12:10 SebCorbin