ajaxStardust
New member
Hello all. Hope you are well.
Please have a look at this screenshot. I'm trying to fix this error, but the error doesn't make sense to me. At first, I thought I had it-- as the database field was Int, and the app is passing an alphnum string. I changed the field from int, text which didn't work, then to varchar, which also doesn't work.
https://i.imgur.com/7KbU5V0.png
I suspect it has to do with the[ GeoLib framework they're using ](http://geotonics.com/doc/geolib/). (same org, if i've posted about the apple farm here in the past... ugh... )
I haven't figured out where in that library it might be thinking that needs to be a datetime field. This thing is crazy: they have it set up w/ an MS Access DB on a PC in their office where they can scan pallet label barcodes into their .mdb prior to shipping. Then, once they update the local .mdb, it's setup to send a query to their MySQL... get this... wordpress database, remote. And they're using that GeoLib thing to do the database abstraction, though the docs explicitly state it has no abstraction layer. (don't ask, 'cause i have no idea. lol')
I just need to figure out why it's throwing that datatime error. I'm not a PDO expert, so your help is greatly appreciated.
Please have a look at this screenshot. I'm trying to fix this error, but the error doesn't make sense to me. At first, I thought I had it-- as the database field was Int, and the app is passing an alphnum string. I changed the field from int, text which didn't work, then to varchar, which also doesn't work.
https://i.imgur.com/7KbU5V0.png
I suspect it has to do with the[ GeoLib framework they're using ](http://geotonics.com/doc/geolib/). (same org, if i've posted about the apple farm here in the past... ugh... )
I haven't figured out where in that library it might be thinking that needs to be a datetime field. This thing is crazy: they have it set up w/ an MS Access DB on a PC in their office where they can scan pallet label barcodes into their .mdb prior to shipping. Then, once they update the local .mdb, it's setup to send a query to their MySQL... get this... wordpress database, remote. And they're using that GeoLib thing to do the database abstraction, though the docs explicitly state it has no abstraction layer. (don't ask, 'cause i have no idea. lol')
I just need to figure out why it's throwing that datatime error. I'm not a PDO expert, so your help is greatly appreciated.
