IRC logs for #farmOS, 2019-01-16 (GMT)

2019-01-15
2019-01-17
TimeNickMessage
[21:31:51]* ligius[m] is now known as lablab[m]
[22:27:33]* Fosten has quit (Quit: Leaving.)
[00:26:33]* Fosten has joined #farmos
[00:52:31]* Fosten has left #farmos ()
[14:25:28]* Fosten has joined #farmos
[14:28:39]<Fosten>mstenta[m]: Still researching the pi bug, haven't yet identified the cause.
[14:32:03]<Fosten>mstenta[m]: Do you think it has something to do with pi being 32-bit? ie: ARMv7 not ARM64
[14:33:39]<mstenta[m]>Fosten: Maybe - that was the original reason Docker didn't work on the Pi. But now it does.
[14:34:03]<mstenta[m]>I wonder if it would be worth trying to install farmOS on a pi OUTSIDE of Docker (standard Drupal installation), and see if it has the same issue.
[14:38:33]<Fosten>i thought about that. source install. eliminating the docker variable.
[14:38:38]<Fosten>it seems to have something to do with geoPHP. i'm wondering when it converts to WKB if the geometry is just too long for the table column.
[14:39:47]<Fosten>i'm not having any problem with assets, logs, etc
[14:40:30]<mstenta[m]>Can you take a look at the database table itself to see if any content is being saved to it?
[14:40:39]<mstenta[m]>It would be {field_data_field_farm_geofield}
[14:40:59]<Fosten>"where are area records stored in the database?" you answered my question before i asked haha!
[14:44:54]<Fosten>it is storing as a BLOB and trunicating to 6 decimals
[14:56:55]<Fosten>Could SpatiaLite be relevant? It is to SQLite what PostGIS is to PostgreSQL.
[14:57:29]<mstenta[m]>Hmm I don't know - never heard o it
[14:57:51]<mstenta[m]>When you say "truncating to 6 decimals" do you mean that's a bug?
[14:59:28]<Fosten>not sure, maybe its my db viewer, but sample point we used was 14, 15 decimals