bu-isciii / iskylims_core

iSkyLIMS home website for information and links purposes

BU-ISCIII

Our Wiki and main public documentation repository.

https://github.com/BU-ISCIII/BU-ISCIII/wiki

iskylims_core's Issues

json iSkyLIMS database backup is not loadable by Django in virgin database owing to "column cannot be null" error

Field "generated_at" within table iSkyLIMS_wetlab.nextSeqGraphicsStats does not allow "null" values.
When loading the json file the following error appears: "Could not load iSkyLIMS_wetlab.NextSeqGraphicsStats(pk=40): (108, "Column 'generated_at' cannot be null")

iSkyLIMS installation guide updated for alignment with issues #2 and #3. New versioning number scheme (1.1.1)

iSkyLIMS.urlsconf (== top level file urls.py) path changes added (iSkyLIMS_wetlab --> wetlab, iSkyLIMS_drylab--> drylab and so on)

Changes had been changed in local flavia urls.py file but not transfered to /conf/settings.py. This makes that potential users downloading iSkyLIMS for the first time will not be able to have a working application

File updated with the aforementioned changes

Prueba

Prueba

Tutorials pub times shown in UTC instead of Madrid TZ in 'admin' entries dashboard

[x] update settings.py with TIME_ZONE= 'Europe/Madrid'
[x] update of mysql (own) tables with time zone info (mysql_tzinfo_to_sql /usr/share/zoneinfo|mysql -u -p mysql)

admin "view on site" button leading to wrong URL

When editing an entry through the /admin interface, "view on site" button makes it easier to check the effect of introducted changes. Table 'django_site' attributes (domain, name) set to current machine values.

Introduction of files logo_bu_isciii.png , isciii_logo.png and support.png in configuration management (git)

json iSkyLIMS database backup is not loadable by Django in a new virgin database

./manage.py loaddata emits an error message:

File "/srv/iSkyLIMS/virtualenv/lib/python3.6/site-packages/django/core/serializers/pythpy", line 159, in Deserializer
raise base.DeserializationError.WithData(e, d['model'], d.get('pk'), field_value)
django.core.serializers.base.DeserializationError: Problem installing fixture '/srv/iSkyL/sql_iSkyLIMS_v1.1.2.json': ContentType matching query does not exist.: (admin.logentry:p) field_value was '['wetlab', 'runprocess']'

In the json file, searching for '"pk": 4,' there are file sections corresponding to "model": "admin.logentry". Within them, in subsection "fields"/"content_type", we find "wetlab" (old iSkyLIMS module name) instead of iSkyLIMS_wetlab (new name).
"django_admin_log" is a Django inner table; "content_type" is a foreign key to Django inner table "django_content_type" which contains the -current- iSkyLIMS module names