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.
_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
