Hi, Iām about to migrate from Owncloud to Nextcloud, so Iām new here; please bear with me.
My brand new installation (18.0.1) uses PostgreSQL. On importing an ICS file, exported from Owncloud, I get error messages as follows:
An exception occurred while executing āINSERT INTO āoc_calendarobjects_propsā (ācalendaridā, ācalendartypeā, āobjectidā, ānameā, āparameterā, āvalueā) VALUES(?, ?, ?, ?, ?, ?)ā with params [6, 0, 1045, āDESCRIPTIONā, null, āAus der Ank\u00fcndigung:\nTord Gustavsen ist mit Sicherheit Norwegens herausragendster Jazzpianist. Er verbindet wie kein anderer die Geschichte des Jazz mit tiefen Wurzeln im Gospel und Blues mit den f\u00fcr uns so typischen Kl\u00e4ngen seiner norwegischen Heimat, dā]: SQLSTATE[22001]: String data, right truncated: 7 ERROR: value too long for type character varying(255)
The root cause is clear: oc_calendarobjects_props.value is varchar(255) and descriptions shall be stored in it, many calendar descriptions may be longer. After enlarging this column, the import succeeded without any error.
Interestingly, even with the error message, the calendar event was successfully imported and I could export it completely without any error. Thus, storing the description in oc_calendarobjects_props seems not to be a crucial functionality. It is stored somewhere else. (Incidentially, I tried to find out where it is stored and I didnāt succeed. I neither found this description in the DB, nor in any file in the data area. Anyhow, I digress.)
The error message about the DB exception and the truncation is very irritating; especially since the actual import seems to work. In addition, the column type in this table should (IMNSHO, obviously) be changed to accomodate longer values.
So, eventually, my question:
What is the proper way to report such (minor) issues?
Here in the forum, on some issue tracker (where)?
If it is on an issue tracker, I would appreciate experience reports if the development team reacts to such minor issues reports, when no code patches are attached. For me, it works now; Iāll only invest the time to create a proper problem ticket with demo data and logs, if thereās a reasonable chance that somebody reacts to it.
Cheers,
Joachim