Description: Connection with mariaDB does not work with LO 6.3. Entering query results in: The data content could not be loaded Unknown column type when fetching result Using LO 6.3 with opensuse Leap 15.0 and "native" connector. It works fine with LO 6.2. Steps to Reproduce: 1.Open database 2.Run query 3.Error msg Actual Results: Error msg: The data content could not be loaded Unknown column type when fetching result Expected Results: Value from database Reproducible: Always User Profile Reset: Yes Additional Info:
@Bojan : we need more information than what you have provided. A sample DDL/DML statement with the problematic table and/or query is required. Am guessing (from past experience) that the unknown column type is a date/time/datetime/timestamp field ?
@Robert : I believe that you run an OpenSuse setup, perhaps you have a better idea of what might be going wrong ?
Could be it is a duplicate of bug 126799 . Please have a look at the type of the column, which will be shown in the detailed error message. Try a test with the daily master from here: https://dev-builds.libreoffice.org/daily/ Bug 126799 has been fixed with that build ...
*** This bug has been marked as a duplicate of bug 126799 ***
The date issue described is not fixed in version 6.4.7.2 on Ubuntu Linux. The error message gives no detail of why the error is occurring or how to resolve it. The field I am trying to access is year with NULL as default value. From phpmyadmin: # Name Type Collation Attributes Null Default 20 per_BirthYear year Yes NULL Error Details Description: Error code: 1 Unknown column type when fetching result
(In reply to David Fuller from comment #5) > The date issue described is not fixed in version 6.4.7.2 on Ubuntu Linux. > The error message gives no detail of why the error is occurring or how to > resolve it. > The field I am trying to access is year with NULL as default value. > From phpmyadmin: > # Name Type Collation Attributes Null Default > 20 per_BirthYear year Yes NULL > > Error Details Description: > Error code: 1 > > Unknown column type when fetching result There is no description for a field type in this bug. This bug has been set as duplicate, because there has been reported another bug for field type "Text". Please open a new bug for field type "Year", but test it with a current version like LO 7.6 or LO 24.2 to reproduce. LO 6.4 is very old and not supported any more. *** This bug has been marked as a duplicate of bug 126799 ***
(In reply to David Fuller from comment #5) > The date issue described is not fixed in version 6.4.7.2 on Ubuntu Linux. > The error message gives no detail of why the error is occurring or how to > resolve it. > The field I am trying to access is year with NULL as default value. > From phpmyadmin: > # Name Type Collation Attributes Null Default > 20 per_BirthYear year Yes NULL > > Error Details Description: > Error code: 1 > > Unknown column type when fetching result Hi David, As Robert has suggested, you need to try this with a current version of LibreOffice - the version you reported has been end of life since November 30th, 2020. Unless your distro is backporting from current release or master branch to 6.4.x under some kind of maintenance scheme, no more fixes will be incoming for that branch of LibreOffice, in which case, you would need to take it up with the distro maintenance team.
By the way: Tested a new created table under LO 24.2 with fields for type "Text" and type "Year". No problem to open this table. No problem to save data. Both fields are shown in phpMyAdmin with right field type. Table couldn't be opened with LO 7.2.5.1 here (might be unknown field type is "Year" - had been fixed later), but could be opened with LO 7.3.6.2 (and newer versions) on OpenSUSE 15.4 64bit rpm Linux.