| [22:04:25] | * JustTB has quit (Quit: Leaving.) |
| [02:27:48] | * JustTB has joined #farmos |
| [03:11:44] | * JustTB has quit (Quit: Leaving.) |
| [03:33:10] | * JustTB has joined #farmos |
| [06:44:35] | <skipper_is[m]> | Just ordered a new dedicated server, and am busy getting FarmOS installed on it. I'll try and put 2 versions on, a Postgresql and a Mysql version as well, so I can do some field testing of Postgresql functionality |
| [06:47:05] | <skipper_is[m]> | @mstenta, Is the mobile version on the play store the farmOS-Client as well? |
| [06:52:04] | <mstenta[m]> | @skipper_is awesome! |
| [06:52:25] | <mstenta[m]> | Yes farmOS-client == field kit |
| [06:56:06] | <skipper_is[m]> | Awesome, I'll drop a issue log on there. I've not managed to debug it at all, just had the crash when I opened it... Will do some poking at one point |
| [08:41:53] | <skipper_is[m]> | ACTION sent a long message: < https://matrix.org/_matrix/media/v1/download/matrix.org/vPSOSNasNQlpFZGx... > |
| [08:42:48] | <skipper_is[m]> | Oh, that wasn't the actual error page...: |
| [08:42:55] | <skipper_is[m]> | ACTION sent a long message: < https://matrix.org/_matrix/media/v1/download/matrix.org/kvQDakMsRhOorAHJ... > |
| [08:43:55] | <mstenta[m]> | skipper_is: Is this a fresh installation you are attempting? |
| [08:44:10] | <mstenta[m]> | That error would indicate that you are trying to install into a database that was already created. |
| [08:44:15] | <mstenta[m]> | Hence the tables already exist |
| [08:56:04] | <skipper_is[m]> | It was a blank database, just created it for the test. Completely empty apart from the public schema |
| [08:57:10] | <mstenta[m]> | Hmm, well try blowing away the database completely and trying again. See if it happens a second time. |
| [08:57:24] | <skipper_is[m]> | That was the 2nd time... |
| [08:58:07] | <skipper_is[m]> | I'll try wiping the server files as well, and doing a complete fresh install |
| [08:58:49] | <mstenta[m]> | You could check sites/default/settings.php |
| [08:58:58] | <mstenta[m]> | that's where the database credentials get stored for farmOS to connect |
| [08:59:02] | <mstenta[m]> | Maybe they are pointing to a different db? |
| [08:59:09] | <mstenta[m]> | Just guessing at this point... |
| [08:59:14] | <mstenta[m]> | Starting fresh is always a good approach :-) |
| [09:55:18] | <skipper_is[m]> | That's what I thought too.. No idea. done a complete wipe anyway, database wipe and file wipe |
| [09:55:25] | <skipper_is[m]> | 3rd time lucky! |
| [09:57:54] | <mstenta[m]> | Ah great! |
| [09:58:03] | <mstenta[m]> | Probably just some artifact leftover from a previous install. |
| [09:58:49] | <skipper_is[m]> | Yea, or some dependency I've missed on the new server install... |
| [09:59:41] | <mstenta[m]> | skipper_is: I forget if I've mentioned this to you already or not... but there is a Docker image available for farmOS |
| [09:59:46] | <mstenta[m]> | which packages all the dependencies |
| [09:59:56] | <mstenta[m]> | (except the database) |
| [10:00:50] | <skipper_is[m]> | I've not used Docker before, so I'm trying to avoid learning something new.. |
| [10:01:18] | <mstenta[m]> | Fair enough - it is definitely another layer |
| [10:01:39] | <mstenta[m]> | And it's good to have you testing all of this outside of Docker - because that needs to work too |
| [10:02:35] | <skipper_is[m]> | I'm just trying to figure out how to patch...... |
| [10:02:41] | <skipper_is[m]> | Without reading the instructions.... |
| [10:03:46] | <mstenta[m]> | `patch -p1 < [filename.patch]` |
| [10:03:59] | <mstenta[m]> | (back up your codebase before you run it, so you can easily roll back) |
| [10:04:18] | <mstenta[m]> | the patch command has an ability to roll back too... but since you don't feel like reading instructions ;-) |
| [10:05:11] | <skipper_is[m]> | Ooooh, that is too easy. I was going to manually edit all the files the .patch file touches.. |
| [10:05:48] | <mstenta[m]> | well you could do that if you really way :-) |
| [10:05:48] | <mstenta[m]> | want* |
| [10:05:54] | <skipper_is[m]> | I'm assuming you do that in the install directory.. |
| [10:09:35] | <mstenta[m]> | what patch are you applying? the one to drupal core for postgresql? |
| [10:09:54] | <mstenta[m]> | if so, then you run that in the webroot directory |
| [10:09:55] | <skipper_is[m]> | Yea |
| [10:09:56] | <skipper_is[m]> | https://www.drupal.org/files/issues/2019-04-30/2057693-D7-42.patch |
| [10:09:57] | <skipper_is[m]> | That one |
| [10:22:04] | <skipper_is[m]> | Seems to be working! |
| [10:27:12] | <mstenta[m]> | Great!! |
| [10:27:47] | <mstenta[m]> | Can you add a comment to that issue and close it if you think it's all set? |
| [12:38:39] | <skipper_is[m]> | Hmm, the issue cropped up again |
| [12:48:43] | <mstenta[m]> | Oh? |
| [12:48:43] | <mstenta[m]> | Same error? |
| [12:48:55] | <mstenta[m]> | Or something similar but different perhaps? |
| [13:06:47] | <skipper_is[m]> | Same error I think: |
| [13:06:54] | <skipper_is[m]> | PDOException: SQLSTATE[42803]: Grouping error: 7 ERROR: column "ss_log.timestamp" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT ss_log.timestamp AS ss_logtimestamp, ss_log.id AS ss_... ^: SELECT ss_log.timestamp AS ss_logtimestamp, ss_log.id AS ss_logid, SUM(ss_fdffiv.field_farm_inventory_value_numerator / ss_fdffiv.field_farm_inventory_value_denominator) AS inventory FROM {log} |
| [13:06:55] | <skipper_is[m]> | ss_log INNER JOIN {field_data_field_farm_inventory} ss_fdffi ON ss_fdffi.entity_type = 'log' AND ss_fdffi.entity_id = ss_log.id AND ss_fdffi.deleted = 0 INNER JOIN {field_data_field_farm_inventory_asset} ss_fdffia ON ss_fdffia.entity_id = ss_fdffi.field_farm_inventory_value AND ss_fdffia.deleted = 0 INNER JOIN {field_data_field_farm_inventory_value} ss_fdffiv ON ss_fdffiv.entity_id = ss_fdffi.field_farm_inventory_value |
| [13:06:55] | <skipper_is[m]> | AND ss_fdffiv.deleted = 0 WHERE (ss_log.timestamp <= 1559233593) AND (ss_log.done = 1) AND (ss_fdffia.field_farm_inventory_asset_target_id = 1) ORDER BY ss_log.timestamp DESC, ss_log.id DESC LIMIT 1 OFFSET 0; Array ( ) in farm_inventory() (line 417 of /var/www/html/farmOSpost/profiles/farm/modules/farm/farm_inventory/farm_inventory.module). |
| [13:08:03] | <skipper_is[m]> | Am just going through verifying that I've got everything updated now |
| [14:53:35] | <skipper_is[m]> | Yea, seems to be ok, but I'll try a fresh install again, just to be sure |
| [15:28:23] | <mstenta[m]> | > seems to be ok |
| [15:28:24] | <mstenta[m]> | Do you mean it's fixed? |
| [15:55:36] | <skipper_is[m]> | So, complete fresh install. Fully updated, same error |
| [15:56:11] | <skipper_is[m]> | And weirdly 2 new ones I've not seen before |
| [15:56:31] | <mstenta[m]> | Did you re-patch? |
| [15:56:37] | <skipper_is[m]> | Warning: Invalid argument supplied for foreach() in views_handler_filter->prepare_filter_select_options() (line 1208 of /var/www/html/farmOSpost/profiles/farm/modules/contrib/views/handlers/views_handler_filter.inc). |
| [15:56:38] | <skipper_is[m]> | and |
| [15:56:39] | <skipper_is[m]> | Notice: Undefined variable: options in views_handler_filter_term_node_tid->value_form() (line 238 of /var/www/html/farmOSpost/profiles/farm/modules/contrib/views/modules/taxonomy/views_handler_filter_term_node_tid.inc). |
| [15:56:47] | <skipper_is[m]> | Yup |
| [15:57:07] | <mstenta[m]> | Oh are you using 7.x-1.x-dev? Or 7.x-1.1? |
| [15:57:27] | <skipper_is[m]> | dev |
| [15:57:32] | <skipper_is[m]> | I just cloned the git |
| [15:57:47] | <skipper_is[m]> | and drush make the build-farm.make |
| [15:57:55] | <mstenta[m]> | Ah ok |
| [15:58:13] | <mstenta[m]> | So the new ones... those may be caused by a recent update to the Views module |
| [15:59:00] | <mstenta[m]> | I updated it in farmOS when the new version was released, and then started seeing some notices like those too |
| [15:59:01] | <mstenta[m]> | I haven't investigated yet |
| [15:59:13] | <mstenta[m]> | I think they are harmless, because they are just notices - but it needs to be fixed upstream in the Views module, I believe... |
| [15:59:31] | <skipper_is[m]> | Yea, they're just at the top of the screen |
| [15:59:58] | <mstenta[m]> | Regarding the patch... if you ran drush make on the dev branch, then it would already be patched |
| [16:00:00] | <skipper_is[m]> | Everything still works, well, it doesnt, hence the main error |
| [16:00:08] | <mstenta[m]> | Did you also run a `patch` command? |
| [16:00:12] | <mstenta[m]> | (Drush downloads and applies the patch automatically) |
| [16:00:34] | <mstenta[m]> | I wonder if maybe you accidentally undid the patch? |
| [16:00:39] | <mstenta[m]> | Just guessing... :-) |
| [16:01:21] | <skipper_is[m]> | I did not, just did build-farm.make |
| [16:01:32] | <skipper_is[m]> | I can try and repatch |
| [16:01:57] | <mstenta[m]> | ok hmm. can you check to see if the patch was applied? |
| [16:02:32] | <mstenta[m]> | i think it would be listed in PATCHES.txt in the webroot |
| [16:03:23] | <mstenta[m]> | farmOS applies two core patches, if i remember correctly, so that file should show two |
| [16:03:37] | <skipper_is[m]> | ACTION sent a long message: < https://matrix.org/_matrix/media/v1/download/matrix.org/doGdwQuExVMWCUgf... > |
| [16:03:53] | <mstenta[m]> | Ok yea that's both of them |
| [16:04:28] | <mstenta[m]> | well i guess we could check to make sure the file is patched by looking at it |
| [16:04:36] | <mstenta[m]> | includes/database/pgsql/select.inc |
| [16:04:57] | <mstenta[m]> | do you see `public function orderBy` in that function? |
| [16:04:58] | <mstenta[m]> | you shouldn't |
| [16:05:35] | <skipper_is[m]> | No, just see one function, orderRandom |
| [16:05:55] | <mstenta[m]> | ok good |
| [16:06:05] | <mstenta[m]> | well, now i'm stumped |
| [16:08:54] | <skipper_is[m]> | Do you have a dependency list? Are there any others aside from what is in the install menu? |
| [16:22:01] | <mstenta[m]> | https://farmos.org/hosting/installing/ |
| [16:23:26] | <mstenta[m]> | Question: you did see the error go away the first time you applied the patch, correct? |
| [17:09:30] | * JustTB1 has joined #farmos |
| [17:09:31] | * JustTB has quit (Read error: Connection reset by peer) |
| [19:28:02] | * JustTB1 has quit (Quit: Leaving.) |
| [19:30:29] | * JustTB has joined #farmos |