IRC logs for #farmOS, 2023-02-26 (GMT)

2023-02-25
2023-02-27
TimeNickMessage
[11:04:51]<lordeddi[m]>i am trying to go through the update process https://farmos.org/hosting/update/
[11:04:51]<lordeddi[m]>it says automated-updates.
[11:04:51]<lordeddi[m]>does this cover v2.0-beta4 -> v2.0.1 ?
[11:05:28]<lordeddi[m]>also, the steps on the update.php state: install your new files in the appropriate location, as described in the handbook
[11:05:54]<lordeddi[m]>does that mean downloading farmOS tarbal 2.0.1 and unpacking it, then replacing all files EXCEPT the /sites ?
[11:06:08]<lordeddi[m]>making sure, i do have backups of which one has been restored just now, just to make sure :D
[11:29:26]<mstenta[m]>> does this cover v2.0-beta4 -> v2.0.1 ?
[11:29:26]<mstenta[m]>yes it should!
[11:29:47]<mstenta[m]>are you running farmOS in Docker? or in a normal Apache webroot?
[11:30:04]<lordeddi[m]>this is a "normal apache webroot"
[11:30:08]<mstenta[m]>(did you use the "docker" or "tarball" method described here: https://farmos.org/hosting/install/)
[11:30:10]<mstenta[m]>ok
[11:30:27]<mstenta[m]>https://farmos.org/hosting/update/#updating-via-packaged-releases
[11:30:39]<lordeddi[m]>yeah that's what i'm doing
[11:30:41]<mstenta[m]>> does that mean downloading farmOS tarbal 2.0.1 and unpacking it, then replacing all files EXCEPT the /sites ?
[11:30:42]<mstenta[m]>yes
[11:30:49]<mstenta[m]>BUT
[11:31:05]<mstenta[m]>have you done any customization outside of the web/sites directory?
[11:31:08]<lordeddi[m]>mstenta[m]: i think i replaced all files but have an SQL PDO error or something, wo- oooowwww ๐Ÿ˜…
[11:31:12]<mstenta[m]>eg: added new modules somewhere?
[11:31:33]<lordeddi[m]>not on this install
[11:31:34]<mstenta[m]>ok
[11:31:58]<mstenta[m]>best way to be sure you've replaced everything is to move the sites directory up to a parent directory, then delete everything, unpack the new tarball, then move sites back
[11:32:29]<lordeddi[m]>yeah, that's what i will do now, i called rsync with the `--delete' flag which should've worked
[11:32:41]<lordeddi[m]>had to upgrade to php 8.0.1
[11:32:41]<mstenta[m]>(note that sites is actually in web/sites in the webroot... but you probably figured that out already)
[11:33:48]<mstenta[m]>i would rm, but that's just my preference. as long as you are confident rsync will result in the same permissions etc
[11:33:56]<mstenta[m]>you have to make sure you have all the right rsync args
[11:34:13]<lordeddi[m]>i thought i did, then again, your option is much much cleaner
[11:34:16]<lordeddi[m]>:)
[11:34:33]<mstenta[m]>less room for error
[11:36:02]<lordeddi[m]>hm... something else must've gone wrong then.
[11:36:02]<lordeddi[m]>after unpacking and replacing, do i still continue on that `update.php/selection` url ?
[11:36:27]<mstenta[m]>go to [url]/update.php no other arguments in the URL
[11:36:32]<lordeddi[m]>Backend log: Error: Undefined constant PDO::MYSQL_ATTR_USE_BUFFERED_QUERY in /web/core/modules/mysql/src/Driver/Database/mysql/Connection.php on line 172
[11:36:57]<lordeddi[m]>so happy i have a restored instance running next to this failing upgrade ๐Ÿ˜… hahaha
[11:37:16]<mstenta[m]>never saw that before... but this seems to suggest a solution: https://stackoverflow.com/questions/52163353/error-undefined-class-const...
[11:37:46]<mstenta[m]>you said you also upgraded PHP? maybe you lost php-mysql in the process?
[11:37:52]<mstenta[m]>there are a bunch of other PHP libs that are required by drupal FYI
[11:37:55]<lordeddi[m]>thinking the same
[11:38:19]<mstenta[m]>https://www.drupal.org/docs/system-requirements/php-requirements
[11:38:23]<lordeddi[m]>don't worry ay mstenta, if you have more fun things todo, i will figure it out
[11:38:30]<mstenta[m]>(this is one of the benefits of the Docker container) :-)
[11:38:48]<lordeddi[m]>mstenta[m]: i was gonna say that
[11:38:49]<lordeddi[m]>haha
[11:38:55]<lordeddi[m]>in the future i'll move it to a k8s cluster
[11:45:12]<lordeddi[m]>`... (full message at <https://libera.ems.host/_matrix/media/v3/download/libera.chat/ad6538f200...)
[11:45:33]<lordeddi[m]>ACTION uploaded an image: (80KiB) < https://libera.ems.host/_matrix/media/v3/download/oblak.be/kdQYZOjrFbEeo... >
[11:45:49]<lordeddi[m]>not sure if i need to act on this, or not, it says both "error message" and "warning"
[11:45:50]<lordeddi[m]> :)
[11:46:40]<lordeddi[m]>ACTION uploaded an image: (25KiB) < https://libera.ems.host/_matrix/media/v3/download/oblak.be/rjJvILEaxJAfv... >
[11:46:50]<lordeddi[m]>well, that seems to be fixed-ish :D
[11:47:18]<lordeddi[m]>quickly sweep it under the rug ๐Ÿงน
[11:47:18]<mstenta[m]>Haha did it work?
[11:47:25]<lordeddi[m]>seems it did work yes..
[11:47:30]<mstenta[m]>Go to /admin/reports/status
[11:47:34]<lordeddi[m]>i'm still logged in and all
[11:47:51]<mstenta[m]>It will say what farmOS version you have, and if there are any warnings/issues
[11:47:58]<lordeddi[m]>ACTION uploaded an image: (11KiB) < https://libera.ems.host/_matrix/media/v3/download/oblak.be/rYUAnHgUFHHCJ... >
[11:48:26]<lordeddi[m]>it's all fine
[11:48:34]<lordeddi[m]>nice! the future is here!
[11:48:55]<mstenta[m]>Hooray!
[11:48:59]<mstenta[m]>Are those warnings OK?
[11:49:13]<lordeddi[m]>semi
[11:49:13]<lordeddi[m]>` Database Isolation Level
[11:49:13]<lordeddi[m]>REPEATABLE-READ
[11:49:13]<lordeddi[m]>For the best performance and to minimize locking issues, the READ-COMMITTED `
[11:49:33]<lordeddi[m]>GEOS PHP extension The GEOS PHP extension is not installed.
[11:49:34]<lordeddi[m]>PHP OPcode caching Not enabled
[11:49:34]<lordeddi[m]>` Update notifications
[11:49:34]<lordeddi[m]>Not enabled
[11:49:35]<lordeddi[m]> * ` Update notifications
[11:49:35]<lordeddi[m]>Not enabled `
[11:49:35]<lordeddi[m]>s///, s//`/
[11:49:50]<lordeddi[m]>that GEOS i don't know how important that is
[11:49:52]<lordeddi[m]>the database i am looking into
[11:56:08]<mstenta[m]>ok those are minor yea
[11:56:28]<lordeddi[m]>cool
[11:56:32]<mstenta[m]>GEOS improves accuracy of polygon area calculations
[11:56:46]<mstenta[m]>opcode cache will improve performance
[11:57:08]<lordeddi[m]>so square meters being more accurate? or also more accurate GPS to points on map accuracy?
[11:57:33]<mstenta[m]>> square meters being more accurate
[11:57:56]<lordeddi[m]>now i will do the same upgrade on my dockerized restored instance from beta4 -> 2.0.1
[11:58:16]<lordeddi[m]>:)
[12:03:11]<lordeddi[m]>one funny remark, i have upgraded another instance where that first one runs, and it did not complain about anything (of course i fixed that PDO bug already, but that warning screenshot thingy never happened)
[12:03:20]<lordeddi[m]>๐Ÿคท won some time i guess
[12:04:19]<mstenta[m]>do you mean the "undefined array key" warnings? i haven't seen those before either
[12:04:59]<lordeddi[m]>yup those ones, they did not happen on that other one
[12:04:59]<mstenta[m]>those were all in the EntityViewsData class it seems... which runs when cache is rebuilt - so it shouldn't cause any issues... but if you continue to see that then something might be wrong
[12:05:52]<lordeddi[m]>it might have been because of that mysql error earlier on? who knows, quickly now, ๐Ÿงน under the rug with it all
[12:05:52]<mstenta[m]>go to /admin/reports/dblog and check to see if you're getting any recurring errors
[12:05:55]<mstenta[m]>then maybe try clearing the cache and checking again
[12:06:12]<mstenta[m]>(to see if the errors occur when cache is being rebuilt)
[12:06:12]<lordeddi[m]>on my way
[12:06:13]<mstenta[m]>those are the things i would try
[12:07:12]<lordeddi[m]>nope, not recurring, only on those couple of pageloads of update.php it seems
[12:07:35]<mstenta[m]>ok then, it's probably fine
[12:07:42]<lordeddi[m]>again, in that docker container, it all "just works" it seems
[12:08:30]<mstenta[m]>sometimes Drupal shows warnings/errors AFTER they've occurred to... eg: maybe it cached the message and then showed it to you the next time you loaded the page
[12:09:11]<lordeddi[m]>those caches man, they seem to mess things up sometimes :D
[12:09:19]<mstenta[m]>but either way... that `EntityViewsData` stuff is "stateless" in the sense that it's just used to build information about the database tables for Views to use... so re-running it (via cache rebuild) will reset it
[12:09:22]<lordeddi[m]>that's okay, it all works though, this aint no big problems
[12:09:36]<mstenta[m]>caches... can't live with them, can't live without them
[12:09:42]<lordeddi[m]>๐ŸŽป
[12:26:27]<lordeddi[m]>one more small question, if i want to know the most recent version of farmOS where do i find that ? i did not see it on farmos.org... so i went to the github page
[12:26:47]<lordeddi[m]>not sure if that's the way though
[12:28:36]<mstenta[m]>yea either https://github.com/farmOS/farmOS/releases or https://www.drupal.org/project/farm/
[12:29:04]<lordeddi[m]>ah, forgot the drupal one! gotcha thanks
[12:29:05]<mstenta[m]>our github actions packaging logic automatically creates the github release, so that's sort of the canonical
[12:29:14]<mstenta[m]>then i manually create the drupal.org release and link to the github one
[12:29:26]<lordeddi[m]>is this information on farmos.org? asking more as non-technical end-user
[12:29:33]<mstenta[m]>maybe not
[12:29:33]<lordeddi[m]>like on the update or hosting page
[12:29:39]<lordeddi[m]>just have a link pointing to where to go
[12:29:44]<mstenta[m]>yea good idea
[12:29:50]<lordeddi[m]>like that one person who tried running docker container v2.x
[12:30:02]<mstenta[m]>yup :-)
[12:30:40]<mstenta[m]>it would be cool if we could just automatically populate the docs with the current version
[12:31:19]<mstenta[m]>but simple enough to add something like "To find the current version, go to github.com/farmOS/farmOS/releases"
[12:32:49]<lordeddi[m]>๐Ÿค” not sure how to pull that information into the .md page though
[13:54:21]* jsoons[m] has joined #farmos