IRC logs for #farmOS, 2020-01-29 (GMT)

2020-01-28
2020-01-30
TimeNickMessage
[19:34:13]* JustTB has quit (Ping timeout: 260 seconds)
[19:46:53]* JustTB has joined #farmos
[21:27:51]* JustTB has quit (Ping timeout: 268 seconds)
[22:11:12]* JustTB has joined #farmos
[00:54:20]* JustTB has quit (Ping timeout: 265 seconds)
[01:09:57]* JustTB has joined #farmos
[01:31:13]* JustTB has quit (Ping timeout: 260 seconds)
[01:45:46]* JustTB has joined #farmos
[02:18:55]* JustTB has quit (Ping timeout: 265 seconds)
[02:33:44]* JustTB has joined #farmos
[02:59:19]* JustTB has quit (Ping timeout: 265 seconds)
[03:47:02]* JustTB has joined #farmos
[04:15:53]* JustTB has quit (Ping timeout: 265 seconds)
[04:30:13]* JustTB has joined #farmos
[04:57:27]* JustTB has quit (Ping timeout: 265 seconds)
[05:11:33]* JustTB has joined #farmos
[05:35:11]* gunter[m] has joined #farmos
[07:05:14]* JustTB has quit (Ping timeout: 240 seconds)
[07:20:01]* JustTB has joined #farmos
[10:21:29]* JustTB has quit (Quit: Leaving.)
[10:21:32]* JustTB1 has joined #farmos
[10:53:13]* JustTB1 has quit (Ping timeout: 268 seconds)
[10:54:22]* JustTB has joined #farmos
[14:47:53]<skipper_is[m]>I'm trying to view the average weights of my kids in Farm OS, using the reports, but it is a blank chart...
[14:47:55]<skipper_is[m]>ACTION uploaded an image: image.png (20KB) < https://matrix.org/_matrix/media/r0/download/matrix.org/EWTiNOAUYfCpSyNE... >
[14:48:59]<skipper_is[m]>It throws the following error:
[14:48:59]<skipper_is[m]>> Notice: Undefined variable: table_data in farm_livestock_weight_group_report() (line 491 of /var/www/html/farmOS/profiles/farm/modules/farm/farm_livestock/farm_livestock_weight/farm_livestock_weight.module).
[14:50:01]* JustTB has quit (Ping timeout: 265 seconds)
[14:55:46]<mstenta[m]>skipper_is: are your weight logs observations? and do they have "Measure: Weight" set?
[14:56:24]<mstenta[m]>(they should if they are created through the "Weight" bulk operation button)
[14:56:47]<skipper_is[m]>I created them through each individual animal's page (so, edit the animal, set the weight in the box)
[14:56:54]<skipper_is[m]>There is an observation with the weight measur set
[14:56:58]<mstenta[m]>ok
[14:57:55]<skipper_is[m]>ACTION uploaded an image: image.png (48KB) < https://matrix.org/_matrix/media/r0/download/matrix.org/UvyyijbpxqZPAEVN... >
[14:58:04]<skipper_is[m]>One of the weight logs on one of the kids
[14:59:36]<mstenta[m]>Oh hmm. I wonder if this is related to the modification you put into place to fix the postgresql issue with groups/locations
[15:00:02]<mstenta[m]>It may be using that same query to get the list of group members in your Kids group
[15:00:24]<skipper_is[m]>Ahh ok
[15:00:39]<skipper_is[m]>I'm just updating FarmOS as I think i'm a bit out of date anyways, and I'll try again
[15:01:07]<mstenta[m]>That postgres bug hasn't been fixed yet :-)
[15:01:10]<mstenta[m]> * That postgres bug hasn't been fixed yet :-(
[15:01:37]<mstenta[m]>So if you update, you'll need to maintain those same modifications
[15:01:43]<mstenta[m]>Which means this still won't work :-(
[15:01:44]<skipper_is[m]>Ah yea
[15:02:45]<mstenta[m]>Once that gets fixed, though, this should start working for you
[15:03:06]<skipper_is[m]>The sites folder doesn't need copying across on update does it?
[15:04:34]<skipper_is[m]>Oh, that update broke some other things Warning: call_user_func_array() expects parameter 1 to be a valid callback, function 'farm_livestock_weight_group_report_form' not found or invalid function name in drupal_retrieve_form() (line 844 of /var/www/html/farmOS/includes/form.inc).
[15:04:40]* JustTB has joined #farmos
[15:05:48]<mstenta[m]>How are you updating? `git pull`?
[15:06:05]<skipper_is[m]>wget the drupal file
[15:06:25]<mstenta[m]>Oh yes you always need to preserve the sites directory!
[15:06:43]<mstenta[m]>If I'm understanding you correctly
[15:06:55]<skipper_is[m]>Weird, the weights are still displayed in the animal page, but there is no weight tab anymore
[15:07:15]<mstenta[m]>Ok try going to `/update.php` and clickign through the steps
[15:07:35]<skipper_is[m]>ACTION uploaded an image: image.png (15KB) < https://matrix.org/_matrix/media/r0/download/matrix.org/tftFyxXwAIQGZkge... >
[15:07:41]<mstenta[m]>You should always do that after updating code, in case there are any db updates
[15:07:57]<skipper_is[m]>Ah I assumed the cron job ran the updates
[15:08:01]<mstenta[m]>The reason the tab isn't showing (I think) is because the menu router table needs to be refreshed
[15:08:10]<mstenta[m]>NOPE! You always need to run updates yourself!
[15:08:25]<mstenta[m]>Very important to do that FIRST THING after changing code
[15:08:39]<mstenta[m]>Just in case any db updates are needed
[15:08:41]<skipper_is[m]>Says no pending updates....
[15:08:51]<mstenta[m]>Ok, still click "Next" or whatever until the end
[15:09:00]<mstenta[m]>I think that will refresh the menu router table
[15:09:03]<mstenta[m]>If not...
[15:09:03]<skipper_is[m]>There is no next page button or anything
[15:09:10]<mstenta[m]>Oh ok
[15:09:20]<mstenta[m]>Is the menu tab working now?
[15:09:22]<mstenta[m]>If not...
[15:09:24]<skipper_is[m]>Nope
[15:09:36]<mstenta[m]>Go to `/admin/modules` and click the "Save Configuration" button
[15:09:43]<mstenta[m]>(submitting the modules page definitely rebuilds the menu)
[15:10:23]<skipper_is[m]>That is a negative
[15:10:49]<mstenta[m]>Ok I'm gonna have to defer to paul121
[15:10:49]<skipper_is[m]>If I toggle livestock weight, it'll keep my records right?
[15:11:01]<skipper_is[m]>They're saved as observations, so should be ok
[15:11:20]<mstenta[m]>Yes it won't delete your records
[15:11:20]<mstenta[m]>But that's a good idea to try
[15:16:28]<skipper_is[m]>Nope
[15:17:29]<skipper_is[m]>And all of my reports have gone... Hmm
[15:18:08]<mstenta[m]>You re-enabled it, and now the individual report is gone too?
[15:18:37]<skipper_is[m]>Yup, the tab is empty
[15:18:48]<mstenta[m]>So... I'm not sure what commit you were on before the update... but I do remember moving those report paths around at one point... not sure if that's what you're experiencing though
[15:19:06]<mstenta[m]>The tab is empty? Or the tab doesn't exist?
[15:19:16]<mstenta[m]>(can you see the actual tab?)
[15:19:16]<skipper_is[m]>tab is there, but there is nothing in it
[15:19:21]<mstenta[m]>huh.
[15:19:29]<skipper_is[m]>ACTION uploaded an image: image.png (7KB) < https://matrix.org/_matrix/media/r0/download/matrix.org/TiVTmmjEoNxynVPC... >
[15:19:34]<mstenta[m]>and that's the individual animal one, right?
[15:19:35]<mstenta[m]>oh
[15:19:38]<skipper_is[m]>I create the weirdest bugs
[15:19:41]<skipper_is[m]>no that is all reports
[15:20:07]<mstenta[m]>so just to confirm: you can see the "Weight" tab on an animal record, but when you click on it the page is empty
[15:20:19]<mstenta[m]>and: under the /farm/reports tab on the dashboard, there are no options
[15:20:28]<mstenta[m]>?
[15:20:34]<skipper_is[m]>Negative on both
[15:20:44]<skipper_is[m]>Although the current weight is displayed on the asset page
[15:20:51]<mstenta[m]>hmm
[15:21:40]<mstenta[m]>are there any errors in `/admin/reports/dblog`?
[15:22:09]<skipper_is[m]>One page not found for farm/quantity
[15:22:26]<skipper_is[m]>Assorted logs for me enabling and disabling the relevant modules
[15:22:37]<skipper_is[m]>I'll try a clear CC..
[15:23:10]<mstenta[m]>I'm trying to figure out what version you had before updating...
[15:23:20]<mstenta[m]>Did you have the "Reports" tab on the dashboard?
[15:23:23]<skipper_is[m]>I'll have a quick look
[15:23:27]<skipper_is[m]>Yea, tab is there
[15:26:10]<skipper_is[m]>I think it must've been October time
[15:26:15]<mstenta[m]>It sounds like your `{menu_router}` table is not updated
[15:26:35]<mstenta[m]>Do you have drush?
[15:26:58]<skipper_is[m]>No, although I'm sure I used to..
[15:27:53]<mstenta[m]>ACTION needs more coffee
[15:33:53]<mstenta[m]>ACTION sent a long message: < https://matrix.org/_matrix/media/r0/download/matrix.org/fslzPilgZjCbQVVs... >
[15:34:00]<mstenta[m]>ACTION sent a long message: < https://matrix.org/_matrix/media/r0/download/matrix.org/LbgczyrSIQEbwjwg... >
[15:34:06]<mstenta[m]>does that return anything?
[15:34:14]<skipper_is[m]>in postgresql?
[15:34:20]<mstenta[m]>yea
[15:34:55]<skipper_is[m]>no return
[15:35:07]<mstenta[m]>ok that's the problem
[15:35:12]<mstenta[m]>one of them anyway
[15:36:13]<skipper_is[m]>Shouldn't the menu router update when a module is enabled?
[15:36:37]<mstenta[m]>I would think
[15:37:12]<mstenta[m]>It should definitely update when the admin modules form is submitted
[15:37:54]<skipper_is[m]>No way to force an update?
[15:38:10]<mstenta[m]>Submit that form will do it
[15:38:23]<mstenta[m]>But if that's not fixing it then something else is going on
[15:38:51]<mstenta[m]>You don't think anything funky happened when you updated files do you?
[15:39:16]<mstenta[m]>You deleted everything except sites, and then unzipped the packaged 7.x-1.x-dev code into the webroot?
[15:39:21]<mstenta[m]>(except for sites
[15:39:41]<skipper_is[m]>No, I did an overwrite... You think maybe there is something that wasn't over written?
[15:39:49]<skipper_is[m]>I'll do a full wipe bar sites
[15:40:10]<mstenta[m]>maybe - i'm just taking guesses at this point haha
[15:40:35]<mstenta[m]>i hope that didn't happen, i would be worried about other issues potentially
[15:40:57]<mstenta[m]>of course, you DID take a backup of your database before updating, right? ;-)
[15:41:11]<skipper_is[m]>I did indeed
[15:41:22]<mstenta[m]>ACTION sighs in relief
[15:41:22]<skipper_is[m]>Though I've never had to do a restore, so I don't really want to test it!
[15:41:23]<mstenta[m]>:-)
[15:41:37]<mstenta[m]>let's hope you don't have to
[15:41:54]<skipper_is[m]>Indeed!
[15:42:01]<skipper_is[m]>Empty folder bar sites looks so wrong...
[15:42:33]<mstenta[m]>Here is the line of code that defines the `farm/report/weight` path: https://github.com/farmOS/farmOS/blob/7.x-1.x/modules/farm/farm_livestoc...
[15:42:39]<mstenta[m]>That is what will be read during a menu update
[15:42:49]<mstenta[m]>So also look at that in your code and make sure it's exactly the same
[15:43:00]<skipper_is[m]>Ah it just duplicated everything... what the hell?!
[15:43:03]<mstenta[m]>It should be if the code was properly updated
[15:43:11]<mstenta[m]>duplicated?
[15:43:32]<skipper_is[m]>Yea, I ended up with 2x every folder (except hafl were with (1)...)
[15:44:10]<skipper_is[m]>next time, I will verify it is empty!
[15:44:22]<mstenta[m]>oh do you think the same thing happened before?
[15:44:35]<skipper_is[m]>No, I overwrote before
[15:45:37]<skipper_is[m]>..module in the wrong place XD
[15:45:51]<skipper_is[m]>I put the weather module in the farm/modules not in sites..
[15:45:55]<skipper_is[m]>Now I deleted it..
[15:46:11]<mstenta[m]>ooh... yea if you didn't delete everything first then you might have ended up with some old things till there
[15:46:21]<mstenta[m]> * ooh... yea if you didn't delete everything first then you might have ended up with some old things still there
[15:46:33]<skipper_is[m]>Yea, hopefully that was the issue.. Just got to refind the modules I put in the wrong place the first time around
[15:46:35]<mstenta[m]>not sure if that explains the issue though...
[15:46:55]<skipper_is[m]>No, but it's always good to have a tidy up
[15:47:12]<mstenta[m]>indeed
[15:48:54]<skipper_is[m]>I should probably just use Farmier, but I'd probably break that...
[15:50:30]<mstenta[m]>hahaha
[15:51:19]<skipper_is[m]>PICNIC error...
[15:51:19]<mstenta[m]>FYI skipper_is I just found this issue about PostgreSQL support in Drupal 8: https://www.drupal.org/project/drupal/issues/2564307
[15:51:51]<mstenta[m]>haha haven't heard that one before (googled it) :-)
[15:52:04]<mstenta[m]>is it working for you now?
[15:52:30]<skipper_is[m]>Partially...
[15:52:37]<skipper_is[m]>The tab is back in the animal page
[15:53:00]<skipper_is[m]>But I get our old friend SQL error 42601 when I try to do the report
[15:53:06]<skipper_is[m]>(The report tab has all it's friends back)
[15:53:20]<mstenta[m]>Oh ok yea, that's to be expected, because you overwrote your modification
[15:53:23]<skipper_is[m]>So the error in the report is due to the postgresql bug]
[15:53:36]<mstenta[m]>And Field Kit won't work for you also until you remodify
[15:53:46]<skipper_is[m]>Yea, I'm just about to do so now
[15:53:49]<mstenta[m]>Right - so that's probably all the same PostgreSQL issue
[15:53:54]<skipper_is[m]>Looks like
[15:54:17]<mstenta[m]>Well - at least it's just ONE issue! haha
[15:54:21]<mstenta[m]>With many children
[15:54:22]<skipper_is[m]>I'll add it to the list :P
[15:54:35]<mstenta[m]>thanks
[15:57:19]<skipper_is[m]>Oh 3 errors it throws!
[16:03:39]<skipper_is[m]>Which were the places to disable? Farm_group.farm_area.inc and there was one other?
[16:05:35]<mstenta[m]>https://github.com/farmOS/farmOS/issues/193#issuecomment-519195689
[16:06:48]<skipper_is[m]>Yea, couldn't find farm_movement_area_assets_property_get()... I assumed farm_movement.locatrion.inc
[16:10:09]<mstenta[m]>https://github.com/farmOS/farmOS/blob/729e9962612f54b0fa2e9f3f34ecede330...
[16:13:16]<skipper_is[m]>Nice one, I'm just going to comment that at the end of my issue log, so next time I break it, I ca find it again!
[16:13:30]<mstenta[m]>cool! sounds good!
[16:14:00]<skipper_is[m]>Right then! Well, everything appears to be, well, if not working, where it was when I started poking!
[16:14:04]<skipper_is[m]>Much appreciated!
[16:14:24]<skipper_is[m]>I'd better go check my incubator.. First time incubating eggs... And there is one poking it's beak out
[16:14:45]<skipper_is[m]>But he's been doing it for the last 24h, so not sure whether to cut him free... Or give him more time
[16:14:48]<mstenta[m]>cool!
[16:14:50]<mstenta[m]>post a pic if you think of it :-)
[16:15:25]<skipper_is[m]>ACTION uploaded an image: image.png (528KB) < https://matrix.org/_matrix/media/r0/download/matrix.org/RpreoqZNwxbIYeAv... >
[16:15:37]<skipper_is[m]>Well, that's all it is at the moment... Dunno how long it is meant to take
[17:57:45]* JustTB has quit (Quit: Leaving.)
[18:03:39]* berryfarmer[m] has joined #farmos
[18:07:43]<berryfarmer[m]>hi @all I was wondering if there is a way to use a , instead of . a decimal separator? I somehow like that the interface is english but input and output numbers are not correct since I am in Germany and we use 1,00 for saying its one point something while in the US 1,00 would mean one hundred right?
[18:09:15]<berryfarmer[m]>So what 1,234,567.89 would be in the US is 1.234.567,89 in Germany. Is this something that can be changed?
[18:17:12]<berryfarmer[m]>According to wikipedia we are not the only ones using this system: others are Argentina, Austria, Belgium (Dutch), Bosnia and Herzegovina, Brazil, Chile, Colombia, Costa Rica, Croatia, Denmark, Germany, Greece, Indonesia, Italy, Netherlands, Romania, Slovenia, Spain, Turkey, Vietnam.
[18:48:56]<mstenta[m]>Hi @berryfarmer[m] thanks for bringing this up
[18:49:24]<mstenta[m]>This is something we can do with Drupal's date formatting features I believe
[18:49:37]<mstenta[m]>Would you mind opening a feature request on GitHub?
[18:50:03]<mstenta[m]>https://github.com/farmOS/farmOS/issues
[18:50:50]* JustTB has joined #farmos