[Qgis-user] SQL QGIS offline plugin issue

[Franklin, Chris - Perth.]

Hi,

Im using QGIS 3.4.4 on windows, it's have issue when using the offline tool using either GeoPackage or SQLite , dates are producing this error:

2019-01-30T10:15:41     WARNING    Offline Editing Plugin : FEATREL: Unknown data type QDate. Not using type affinity for the field.
2019-01-30T10:15:41     WARNING    Offline Editing Plugin : ATTRREL: Unknown data type QDate. Not using type affinity for the field.
2019-01-30T10:15:41     WARNING    Offline Editing Plugin : CREATED: Unknown data type QDate. Not using type affinity for the field.
2019-01-30T10:15:42     WARNING    Offline Editing Plugin : RETIRED: Unknown data type QDate. Not using type affinity for the field.
2019-01-30T10:15:49     WARNING    Offline Editing Plugin : ERROR: 101905 feature(s) not added - geometry type is not compatible with the current layer.
2019-01-30T10:15:49     WARNING    Offline Editing Plugin : DateCollected: Unknown data type QDate. Not using type affinity for the field.
2019-01-30T10:15:49     WARNING    Offline Editing Plugin : DateModified: Unknown data type QDate. Not using type affinity for the field.
2019-01-30T10:15:50     WARNING    Offline Editing Plugin : ERROR: 10 feature(s) not added - geometry type is not compatible with the current layer.
2019-01-30T10:15:50     WARNING    Offline Editing Plugin : Reg_Date: Unknown data type QDateTime. Not using type affinity for the field.
2019-01-30T10:15:50     WARNING    Offline Editing Plugin : Reg_Renew_Date: Unknown data type QDateTime. Not using type affinity for the field.
2019-01-30T10:15:50     WARNING    Offline Editing Plugin : Rep_Date: Unknown data type QDateTime. Not using type affinity for the field.
2019-01-30T10:15:50     WARNING    Offline Editing Plugin : Ann_Exp_Date: Unknown data type QDateTime. Not using type affinity for the field.
2019-01-30T10:15:50     WARNING    Offline Editing Plugin : Start_Date: Unknown data type QDate. Not using type affinity for the field.
2019-01-30T10:15:50     WARNING    Offline Editing Plugin : Start_Time: Unknown data type QTime. Not using type affinity for the field.
2019-01-30T10:15:50     WARNING    Offline Editing Plugin : End_Date: Unknown data type QDate. Not using type affinity for the field.
2019-01-30T10:15:50     WARNING    Offline Editing Plugin : End_Time: Unknown data type QTime. Not using type affinity for the field.
2019-01-30T10:15:50     WARNING    Offline Editing Plugin : Grant_Date: Unknown data type QDate. Not using type affinity for the field.
2019-01-30T10:15:50     WARNING    Offline Editing Plugin : Grant_Time: Unknown data type QTime. Not using type affinity for the field.
2019-01-30T10:15:51     WARNING    Offline Editing Plugin : Load_Date: Unknown data type QDateTime. Not using type affinity for the field.
2019-01-30T10:15:51     WARNING    Offline Editing Plugin : Modified_Date: Unknown data type QDateTime. Not using type affinity for the field.
2019-01-30T10:15:51     WARNING    Offline Editing Plugin : Expiry_Date: Unknown data type QDateTime. Not using type affinity for the field.
2019-01-30T10:17:15     WARNING    Commit errors : Could not commit changes to layer tblSPAUSTRoadNetwork (offline)

In the DB Manager I can see the dates are missing type in the table structure


The source for this data is MSSQL 2012.

Kind Regards

[RDG-Logo-Tagline]

Chris Franklin
Senior GIS Officer
Level 2, Australia Place, 15 - 17 William Street
Perth, Western Australia 6000
T: +61 8 9261 6100  |  D: +61 8 9261 6127 |  M: +61 420 665660
www.rml.com.au<http://www.rml.com.au/>


Please consider the environment before printing this email.
This email and any attached files are confidential and may be legally privileged. If you are not the intended recipient, any disclosure, reproduction, copying, distribution, or other dissemination or use of this communication is strictly prohibited. If you have received this transmission in error, please notify the sender immediately and then delete this email. Email transmission cannot be guaranteed to be secure or error free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore is in no way liable for any errors or omissions in the content of this message, which may arise as a result of email transmission. If verification is required, please request a hard copy.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20190130/a4886d03/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 5219 bytes
Desc: image001.jpg
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20190130/a4886d03/attachment.jpg>