| [00:52:26] | <idoshmida[m]> | <mstenta[m] "This is something that we could "> where can I fined information about this plugin? do I need to build it from scrach? I dont have a Drupal dev experiance but its a good day to start:) using the right Taxonomy structure is a big issue for me |
| [01:52:28] | * JustTB has quit (Quit: Leaving.) |
| [03:29:51] | * JustTB has joined #farmos |
| [04:34:25] | * JustTB has quit (Quit: Leaving.) |
| [04:41:46] | * JustTB has joined #farmos |
| [07:07:47] | <mstenta[m]> | @idoshmida:matrix.org: hmm this may actually already be possible without a new plugin |
| [07:07:54] | <mstenta[m]> | I just found this: https://www.drupal.org/project/views/issues/1317206 |
| [07:08:55] | <mstenta[m]> | That suggests there is already a plugin available that may do what we want. We would just need to replace what we currently have in all Views |
| [07:09:04] | <mstenta[m]> | However, it also mentions limitations |
| [07:09:27] | <mstenta[m]> | So I would want to understand thoroughly what the trade-offs are before including in farmOS code |
| [07:09:39] | <mstenta[m]> | But it's something you can experiment with in your own farmOS |
| [07:09:53] | <mstenta[m]> | It just means you will override the default Views |
| [07:10:53] | <mstenta[m]> | If you investigate it, please open a GitHub issue to document your findings so we can all learn from it |
| [07:36:15] | <skipper_is[m]> | Oh wow, so many errors updating to FarmOS 1.3 |
| [07:37:00] | <skipper_is[m]> | `Failed: PDOException: SQLSTATE[42703]: Undefined column: 7 ERROR: column "vidcount" does not exist LINE 5: HAVING (vidcount >= '2') ^: SELECT t.field_farm_movement_revision_id AS field_farm_movement_revision_id, COUNT(t.field_farm_movement_revision_id) AS vidcount FROM {field_revision_field_farm_movement} t GROUP BY t.field_farm_movement_revision_id HAVING (vidcount >= :db_condition_placeholder_0) LIMIT 10 OFFSET 0; |
| [07:37:00] | <skipper_is[m]> | Array ( [:db_condition_placeholder_0] => 2 ) in field_collection_update_7009() (line 430 of /var/www/html/farmOS/profiles/farm/modules/contrib/field_collection/field_collection.install).` |
| [07:37:03] | <skipper_is[m]> | Being the main one.. |
| [07:38:04] | <skipper_is[m]> | Also.. my map has disapeared form the dashboard.. |
| [07:42:44] | <mstenta[m]> | I'll be online in an hour or two |
| [07:42:49] | <mstenta[m]> | Will help debug |
| [08:07:08] | <mstenta[m]> | That main one is coming from an update in the Field Collection module (one of farmOS dependencies) |
| [08:07:31] | <mstenta[m]> | I wonder if the update query for that module is not postgres compatible |
| [08:10:33] | <mstenta[m]> | As for the map, I wonder if clearing your cache will fix it |
| [11:56:53] | * JustTB has quit (Quit: Leaving.) |
| [12:02:06] | * JustTB has joined #farmos |
| [14:50:54] | <skipper_is[m]> | The map has appeared, on the top of everything else |
| [14:51:17] | <skipper_is[m]> | ACTION uploaded an image: image.png (89KB) < https://matrix.org/_matrix/media/r0/download/matrix.org/nroZHPNXYkjGbmpW... > |
| [14:51:29] | <skipper_is[m]> | I don't know if that is intentional. It also doesn't seem to have a default map... |
| [14:52:01] | <mstenta[m]> | skipper_is: yes that is intentional... although it should have a default base layer enabled |
| [14:52:23] | <mstenta[m]> | look in the layer switcher on the right: what do you see under Base Layers |
| [14:52:51] | <skipper_is[m]> | They're all there, but none are ticked |
| [14:53:31] | <mstenta[m]> | Hmm - that's odd. But if you tick one it works? |
| [14:53:47] | <mstenta[m]> | It will remember which one you tick by default, so next time you refresh the page that one should be shown |
| [14:54:00] | <skipper_is[m]> | Yea |
| [14:54:21] | <mstenta[m]> | Oh wait... something is different about yours |
| [14:54:32] | <mstenta[m]> | it should be below the menu, not above it |
| [14:54:45] | <skipper_is[m]> | It doesn't save when I tick one, if I refresh, back to nothing |
| [14:54:59] | <mstenta[m]> | Do you have any errors in console? |
| [14:55:33] | <skipper_is[m]> | I do not |
| [14:55:35] | <mstenta[m]> | Try selecting openstreetmap and refreshing - does that get remembered? (Someone else has reported an issue with Google being remembered, which I'm looking in to) |
| [14:56:54] | <skipper_is[m]> | Ah yea, that seems to be remembered |
| [14:57:04] | <mstenta[m]> | ok weird - thanks that helps |
| [14:57:13] | <mstenta[m]> | what browser/OS are you using? |
| [14:57:28] | <mstenta[m]> | we have not been able to replicate this - but three people (including you) have now reported it... |
| [14:57:54] | <mstenta[m]> | so i may ask your help in debugging |
| [14:58:40] | <skipper_is[m]> | Chrome on W10 |
| [14:59:30] | <mstenta[m]> | thanks |
| [14:59:33] | <mstenta[m]> | here is the open issue: https://github.com/farmOS/farmOS-map/issues/65 |
| [15:00:53] | <mstenta[m]> | skipper_is: also... regarding the error you saw during upgrades... i found this: https://www.drupal.org/project/field_collection/issues/3098191 |
| [15:01:04] | <mstenta[m]> | indeed seems to be a postgres issue |
| [15:01:06] | <mstenta[m]> | :-( |
| [15:02:22] | <mstenta[m]> | fwiw we plan to drop the field_collection module in the future... but it's disconcerting to find other modules (not just Drupal core) with very tenuous support for pgsql |
| [15:02:25] | <mstenta[m]> | no one seems to test on postgres |
| [15:03:23] | <skipper_is[m]> | Indeed... Regretting using PostGres :P |
| [15:04:07] | <skipper_is[m]> | And migrating over seems to be more trouble than just ignoring the bugs... |
| [15:05:33] | <mstenta[m]> | :-( |
| [15:05:49] | <mstenta[m]> | It's not the end of the world yet |
| [15:05:58] | <skipper_is[m]> | INdeed |
| [15:05:58] | <mstenta[m]> | Just this issue and the older one... |
| [15:06:14] | <skipper_is[m]> | Probably some hiding somewhere else as well |
| [15:06:39] | <mstenta[m]> | Maybe, but maybe not.... The older one I'm not surprised because it's a wacky query |
| [15:06:49] | <mstenta[m]> | This newer one is only in the update code, so only runs once |
| [15:06:54] | <mstenta[m]> | Also seems to be a bit unique |
| [15:07:06] | <skipper_is[m]> | But I'm trying to get our organisation to use FarmOS over their other sites, and their server is using MySQL, so I don't know I can pursuade them to install PostgreSQL as well |
| [15:07:10] | <mstenta[m]> | I haven't lost hope yet :-) |
| [15:07:47] | <mstenta[m]> | Right... i still have to believe it's possible to migrate |
| [15:08:47] | <skipper_is[m]> | Yea, I did have some luck with migrating, it brought across most of the logs, but there was a lot of errors |
| [15:09:11] | <skipper_is[m]> | And I didn't try anything else... and now I cannot remember how I did it... |
| [15:15:32] | <mstenta[m]> | Hmm you may want to restore from Backup and look into that update code a bit |
| [15:15:47] | <mstenta[m]> | I'm not sure what it does exactly... but it would be pretty easy to find out I bet |
| [15:16:52] | <mstenta[m]> | Here it is: https://git.drupalcode.org/project/field_collection/blob/7.x-1.x/field_c... |
| [15:16:55] | <mstenta[m]> | oof that's pretty long actually |
| [16:12:46] | * JustTB has quit (Ping timeout: 256 seconds) |
| [16:34:19] | * JustTB has joined #farmos |
| [16:43:10] | * JustTB has quit (Ping timeout: 258 seconds) |
| [17:03:05] | * rbarreca[m] has joined #farmos |
| [17:03:27] | <rbarreca[m]> | Ahoy! |
| [17:04:12] | <mstenta[m]> | Hey rbarreca ! Welcome! |
| [17:05:05] | * JustTB has joined #farmos |
| [17:58:13] | * JustTB has quit (Quit: Leaving.) |
| [18:10:09] | * JustTB has joined #farmos |