<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - MYSQL/MariaDB native connector: Unknown Column Type 'year' when opening table" href="https://bugs.documentfoundation.org/show_bug.cgi?id=132515#c6">Comment # 6</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - MYSQL/MariaDB native connector: Unknown Column Type 'year' when opening table" href="https://bugs.documentfoundation.org/show_bug.cgi?id=132515">bug 132515</a> from <a class="email" href="mailto:jphorst@sciencebridge.de" title="hojp <jphorst@sciencebridge.de>"> hojp</a> <pre>We switched from ODBC to a native LO Base - Mysql connection sometime in 2012 and have been using this including the year column ever since without problems. To my recollection ubuntu always had the libreoffice-mysql-connector (maybe under a different name in earlier version) in its main repositories. 18.04 currently uses "1.0.2+LibO6.0.7-0". We never used a connector separately installed as an extension. Addressing and editing the year(4) column with LO 6.0.7 and earlier natively has never been a problem since 2012. The newer version of Base or the connector seem to be the problem. The same error also occurs under Manjaro 20 with LO 6.3.5-4 or LO-fresh 6.4.3-1.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>