- Aur-dev - lists.archlinux.org

[aur-dev][PATCH 1/3] fix broken SQL query that always failed
by Eli Schwartz 20 Feb '21

20 Feb '21

Due to missing whitespace at the end of strings during joining, we ended up with the query fragment "DelTS IS NULLAND NOT PinnedTS" which should be "DelTS IS NULL AND NOT PinnedTS" So the check for pinned comments > 5 likely always failed. In php 7, a completely broken query that raises exceptions in the database engine was silently ignored... in php 8, it raises Uncaught PDOException: SQLSTATE[HY000]: General error: 1 near "PinnedTS": syntax error in <file> and aborts the page building. End result: users with permission to pin comments cannot see any comments, or indeed page content below the first comment header Signed-off-by: Eli Schwartz <eschwartz(a)archlinux.org> --- web/lib/pkgbasefuncs.inc.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/web/lib/pkgbasefuncs.inc.php b/web/lib/pkgbasefuncs.inc.php index a4925891..4c8abba7 100644 --- a/web/lib/pkgbasefuncs.inc.php +++ b/web/lib/pkgbasefuncs.inc.php @@ -21,7 +21,7 @@ function pkgbase_comments_count($base_id, $include_deleted, $only_pinned=false) $q = "SELECT COUNT(*) FROM PackageComments "; $q.= "WHERE PackageBaseID = " . $base_id . " "; if (!$include_deleted) { - $q.= "AND DelTS IS NULL"; + $q.= "AND DelTS IS NULL "; } if ($only_pinned) { $q.= "AND NOT PinnedTS = 0"; -- 2.30.1

3 4

[PATCH] pacman-key: Close msg string in generate_master_key
by foxboron＠archlinux.org 10 Jan '21

10 Jan '21

From: Morten Linderud <morten(a)linderud.pw> In 19980a61e9ed9b9a57520aaa919c40a4b5311f87 there was a msg added which didn't get the string closed. Signed-off-by: Morten Linderud <morten(a)linderud.pw> --- scripts/pacman-key.sh.in | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/scripts/pacman-key.sh.in b/scripts/pacman-key.sh.in index 59162840..c65669f5 100644 --- a/scripts/pacman-key.sh.in +++ b/scripts/pacman-key.sh.in @@ -145,7 +145,7 @@ key_lookup_from_name() { generate_master_key() { # Generate the master key, which will be in both pubring and secring - msg "$(gettext "Generating pacman master key. This may take some time.") + msg "$(gettext "Generating pacman master key. This may take some time.")" "${GPG_PACMAN[@]}" --gen-key --batch <<EOF %echo Generating pacman keyring master key... -- 2.30.0

1 0

[PATCH] Fetch Transifex image from https://www.transifex.com
by Lukas Fleischer 28 Dec '20

28 Dec '20

Fixes GitLab issue #3. Signed-off-by: Lukas Fleischer <lfleischer(a)archlinux.org> --- README.md | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/README.md b/README.md index f7285a5..77f3b13 100644 --- a/README.md +++ b/README.md @@ -45,4 +45,4 @@ Translations Translations are welcome via our Transifex project at https://www.transifex.com/lfleischer/aurweb; see `doc/i18n.txt` for details. -![Transifex](http://www.transifex.net/projects/p/aurweb/chart/image_png) +![Transifex](https://www.transifex.com/projects/p/aurweb/chart/image_png) -- 2.29.2

1 0

[PATCH] .gitignore: add test/trash directory*
by Lukas Fleischer 28 Dec '20

28 Dec '20

Signed-off-by: Lukas Fleischer <lfleischer(a)archlinux.org> --- .gitignore | 1 + 1 file changed, 1 insertion(+) diff --git a/.gitignore b/.gitignore index 7c9fa60..4d961d1 100644 --- a/.gitignore +++ b/.gitignore @@ -7,4 +7,5 @@ aur.git/ __pycache__/ *.py[cod] test/test-results/ +test/trash directory* schema/aur-schema-sqlite.sql -- 2.29.2

1 0

Re: [Contact] aur-dev Digest, Vol 144, Issue 1
by Gerard Barlow 18 Dec '20

18 Dec '20

Thank you, I really appreciate you Sent from my T-Mobile 4G LTE Device Get Outlook for Android<https://aka.ms/ghei36> ________________________________ From: aur-dev <aur-dev-bounces(a)archlinux.org> on behalf of aur-dev-request(a)archlinux.org <aur-dev-request(a)archlinux.org> Sent: Friday, December 18, 2020 1:36:42 AM To: aur-dev(a)archlinux.org <aur-dev(a)archlinux.org> Subject: [Contact] aur-dev Digest, Vol 144, Issue 1 Send aur-dev mailing list submissions to aur-dev(a)archlinux.org To subscribe or unsubscribe via the World Wide Web, visit https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.archlinux.org_li… or, via email, send a message with subject or body 'help' to aur-dev-request(a)archlinux.org You can reach the person managing the list at aur-dev-owner(a)archlinux.org When replying, please edit your Subject line so it is more specific than "Re: Contents of aur-dev digest..." Today's Topics: 1. openoffice (Bartosz Bartczak) 2. Re: openoffice (Eli Schwartz) 3. Re: openoffice (Bartosz Bartczak) ---------------------------------------------------------------------- Message: 1 Date: Fri, 18 Dec 2020 01:51:40 +0100 From: Bartosz Bartczak <bartosz(a)algrim.pl> To: aur-dev(a)archlinux.org Subject: openoffice Message-ID: <8da363b1-6626-38b1-a47d-503d7ca33586(a)algrim.pl> Content-Type: text/plain; charset=utf-8 $ yaourt -S openoffice ==> Downloading openoffice PKGBUILD from AUR... x .SRCINFO x PKGBUILD kikislater commented on <a href="#comment-751939" class="date">2020-06-19 05:25</a> LordofNoob commented on <a href="#comment-752120" class="date">2020-06-20 09:18</a> kikislater commented on <a href="#comment-752377" class="date">2020-06-22 05:11</a> micwoj92 commented on <a href="#comment-774049" class="date">2020-11-05 08:32</a> gameboy commented on <a href="#comment-779686" class="date">2020-12-08 13:06</a> openoffice 4.1.7-1? (2019-10-17 11:05) ( Unsupported package: Potentially dangerous ! ) ==> Edit PKGBUILD ? [Y/n] ("A" to abort) ==> ------------------------------------ ==> n ==> openoffice dependencies: ?- freetype2 (already installed) ?- glibc>=2.5 (already installed) ?- gtk2>=2.10.4 (already installed) ?- hicolor-icon-theme (already installed) ?- desktop-file-utils (already installed) ?- shared-mime-info (already installed) ==> Continue building openoffice ? [Y/n] ==> ------------------------------------ ==> ==> Building and installing package ==> Making package: openoffice 4.1.7-1 (Thu Dec 17 22:08:40 2020) ==> Checking runtime dependencies... ==> Checking buildtime dependencies... ==> Retrieving sources... ? -> Downloading v4.1.7-x86_64... ? % Total??? % Received % Xferd? Average Speed?? Time??? Time???? Time? Current ???????????????????????????????? Dload? Upload?? Total?? Spent??? Left? Speed 100?? 306? 100?? 306??? 0???? 0?? 2528????? 0 --:--:-- --:--:-- --:--:--? 2508 ? 0???? 0??? 0???? 0??? 0???? 0????? 0????? 0 --:--:-- --:--:-- --:--:--???? 0 curl: (22) The requested URL returned error: 404 Not Found ==> ERROR: Failure while downloading https://urldefense.proofpoint.com/v2/url?u=http-3A__apache.org_dist_openoff… ??? Aborting... ==> ERROR: Makepkg was unable to build openoffice. ==> Restart building openoffice ? [y/N] ==> ----------------------------------- ==> n AUR see old version openoffice 4.1.7-1 not 4.1.8 and can't download package from source to build. I think so that can fix it. When fixit buildfile get other error: yaour -S openoffice [...] ==> Continue building openoffice ? [Y/n] ==> ------------------------------------ ==> ==> Building and installing package ==> Making package: openoffice 4.1.8-1 (Thu Dec 17 23:42:02 2020) ==> Checking runtime dependencies... ==> Checking buildtime dependencies... ==> Retrieving sources... ? -> Downloading v4.1.8-x86_64... ? % Total??? % Received % Xferd? Average Speed?? Time??? Time???? Time? Current ???????????????????????????????? Dload? Upload?? Total?? Spent??? Left? Speed 100? 161M? 100? 161M??? 0???? 0? 1279k????? 0? 0:02:08? 0:02:08 --:--:-- 1547k ==> Validating source_x86_64 files with md5sums... ??? v4.1.8-x86_64 ... Passed ==> Extracting sources... ? -> Extracting v4.1.8-x86_64 with bsdtar ==> Entering fakeroot environment... ==> Starting package()... ==> Skipping openoffice4.1.8-mandriva-menus-4.1.8-9803.noarch.rpm ==> Skipping openoffice4.1.8-redhat-menus-4.1.8-9803.noarch.rpm ==> Skipping openoffice4.1.8-suse-menus-4.1.8-9803.noarch.rpm ==> Extracting openoffice-brand-base-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-en-US-impress-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-en-US-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-core02-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-math-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-draw-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-brand-calc-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-impress-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-core06-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-en-US-help-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-core01-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-en-US-res-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-ogltrans-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-base-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-brand-impress-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-javafilter-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-gnome-integration-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-ure-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-en-US-writer-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-ooolinguistic-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-core07-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-en-US-calc-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-brand-writer-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-brand-math-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-en-US-draw-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-core04-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-pyuno-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-en-US-base-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-brand-draw-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-images-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-core03-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-graphicfilter-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-brand-en-US-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-calc-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-en-US-math-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-ooofonts-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-xsltfilter-4.1.8-9803.x86_64.rpm ==> Extracting openoffice4.1.8-freedesktop-menus-4.1.8-9803.noarch.rpm ==> Extracting openoffice-writer-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-core05-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-onlineupdate-4.1.8-9803.x86_64.rpm ? -> Completing package find: 'opt/openoffice4/program/python-core-2.7.6/lib': No such file or directory sed: no input files ==> ERROR: A failure occurred in package(). ??? Aborting... ==> ERROR: Makepkg was unable to build openoffice. ==> Restart building openoffice ? [y/N] ==> ----------------------------------- ==> But in /opt/openoffice4/program/python-core-2.7.6/lib" i see files. ok next correct patch (add "/") and get next error: [...] ==> Extracting openoffice-xsltfilter-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-writer-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-core05-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-onlineupdate-4.1.8-9803.x86_64.rpm ==> Extracting openoffice4.1.8-freedesktop-menus-4.1.8-9803.noarch.rpm ? -> Completing package sed: couldn't open temporary file /opt/openoffice4/program/python-core-2.7.6/lib/sedlrxOz8: Permission denied ==> ERROR: A failure occurred in package(). ??? Aborting... ==> ERROR: Makepkg was unable to build openoffice. ==> Restart building openoffice ? [y/N] ==> ----------------------------------- ==> interesting... I see maintainers nothing doing for last 1,5 year. ?Best Regards Bartosz Bartczak ------------------------------ Message: 2 Date: Thu, 17 Dec 2020 20:02:50 -0500 From: Eli Schwartz <eschwartz(a)archlinux.org> To: aur-dev(a)archlinux.org Subject: Re: openoffice Message-ID: <528db7d3-1608-a771-a627-0ea7e7a8e268(a)archlinux.org> Content-Type: text/plain; charset="utf-8"; Format="flowed" On 12/17/20 7:51 PM, Bartosz Bartczak wrote: > $ yaourt -S openoffice > > ==> Downloading openoffice PKGBUILD from AUR... > x .SRCINFO > x PKGBUILD > kikislater commented on <a href="#comment-751939" > class="date">2020-06-19 05:25</a> > > LordofNoob commented on <a href="#comment-752120" > class="date">2020-06-20 09:18</a> > > kikislater commented on <a href="#comment-752377" > class="date">2020-06-22 05:11</a> > > micwoj92 commented on <a href="#comment-774049" class="date">2020-11-05 > 08:32</a> > > gameboy commented on <a href="#comment-779686" class="date">2020-12-08 > 13:06</a> > > openoffice 4.1.7-1? (2019-10-17 11:05) > ( Unsupported package: Potentially dangerous ! ) > ==> Edit PKGBUILD ? [Y/n] ("A" to abort) > ==> ------------------------------------ > ==> n > > ==> openoffice dependencies: > ?- freetype2 (already installed) > ?- glibc>=2.5 (already installed) > ?- gtk2>=2.10.4 (already installed) > ?- hicolor-icon-theme (already installed) > ?- desktop-file-utils (already installed) > ?- shared-mime-info (already installed) > > > ==> Continue building openoffice ? [Y/n] > ==> ------------------------------------ > ==> > ==> Building and installing package > ==> Making package: openoffice 4.1.7-1 (Thu Dec 17 22:08:40 2020) > ==> Checking runtime dependencies... > ==> Checking buildtime dependencies... > ==> Retrieving sources... > ? -> Downloading v4.1.7-x86_64... > ? % Total??? % Received % Xferd? Average Speed?? Time??? Time???? Time > Current > ???????????????????????????????? Dload? Upload?? Total?? Spent??? Left > Speed > 100?? 306? 100?? 306??? 0???? 0?? 2528????? 0 --:--:-- --:--:-- > --:--:--? 2508 > ? 0???? 0??? 0???? 0??? 0???? 0????? 0????? 0 --:--:-- --:--:-- > --:--:--???? 0 > curl: (22) The requested URL returned error: 404 Not Found > ==> ERROR: Failure while downloading > https://urldefense.proofpoint.com/v2/url?u=http-3A__apache.org_dist_openoff… > ??? Aborting... > ==> ERROR: Makepkg was unable to build openoffice. > ==> Restart building openoffice ? [y/N] > ==> ----------------------------------- > ==> n > > > AUR see old version openoffice 4.1.7-1 not 4.1.8 and can't download package from source to build. Correct, because that is the last version its maintainer uploaded. It matches the details page: https://urldefense.proofpoint.com/v2/url?u=https-3A__aur.archlinux.org_pack… > I think so that can fix it. > When fixit buildfile get other error: Clearly it needs more work. This is the job of a maintainer. The aurweb software is not responsible maintaining or fixing PKGBUILDs. > yaour -S openoffice > > [...] > > ==> Continue building openoffice ? [Y/n] > ==> ------------------------------------ > ==> > ==> Building and installing package > ==> Making package: openoffice 4.1.8-1 (Thu Dec 17 23:42:02 2020) > ==> Checking runtime dependencies... > ==> Checking buildtime dependencies... > ==> Retrieving sources... > ? -> Downloading v4.1.8-x86_64... > ? % Total??? % Received % Xferd? Average Speed?? Time??? Time???? Time > Current > ???????????????????????????????? Dload? Upload?? Total?? Spent??? Left > Speed > 100? 161M? 100? 161M??? 0???? 0? 1279k????? 0? 0:02:08? 0:02:08 --:--:-- > 1547k > ==> Validating source_x86_64 files with md5sums... > ??? v4.1.8-x86_64 ... Passed > ==> Extracting sources... > ? -> Extracting v4.1.8-x86_64 with bsdtar > ==> Entering fakeroot environment... > ==> Starting package()... > ==> Skipping openoffice4.1.8-mandriva-menus-4.1.8-9803.noarch.rpm > ==> Skipping openoffice4.1.8-redhat-menus-4.1.8-9803.noarch.rpm > ==> Skipping openoffice4.1.8-suse-menus-4.1.8-9803.noarch.rpm > ==> Extracting openoffice-brand-base-4.1.8-9803.x86_64.rpm > ==> Extracting openoffice-en-US-impress-4.1.8-9803.x86_64.rpm > ==> Extracting openoffice-en-US-4.1.8-9803.x86_64.rpm > ==> Extracting openoffice-core02-4.1.8-9803.x86_64.rpm > ==> Extracting openoffice-math-4.1.8-9803.x86_64.rpm > ==> Extracting openoffice-draw-4.1.8-9803.x86_64.rpm > ==> Extracting openoffice-brand-calc-4.1.8-9803.x86_64.rpm > ==> Extracting openoffice-impress-4.1.8-9803.x86_64.rpm > ==> Extracting openoffice-core06-4.1.8-9803.x86_64.rpm > ==> Extracting openoffice-en-US-help-4.1.8-9803.x86_64.rpm > ==> Extracting openoffice-core01-4.1.8-9803.x86_64.rpm > ==> Extracting openoffice-en-US-res-4.1.8-9803.x86_64.rpm > ==> Extracting openoffice-ogltrans-4.1.8-9803.x86_64.rpm > ==> Extracting openoffice-base-4.1.8-9803.x86_64.rpm > ==> Extracting openoffice-4.1.8-9803.x86_64.rpm > ==> Extracting openoffice-brand-impress-4.1.8-9803.x86_64.rpm > ==> Extracting openoffice-javafilter-4.1.8-9803.x86_64.rpm > ==> Extracting openoffice-gnome-integration-4.1.8-9803.x86_64.rpm > ==> Extracting openoffice-ure-4.1.8-9803.x86_64.rpm > ==> Extracting openoffice-en-US-writer-4.1.8-9803.x86_64.rpm > ==> Extracting openoffice-ooolinguistic-4.1.8-9803.x86_64.rpm > ==> Extracting openoffice-core07-4.1.8-9803.x86_64.rpm > ==> Extracting openoffice-en-US-calc-4.1.8-9803.x86_64.rpm > ==> Extracting openoffice-brand-writer-4.1.8-9803.x86_64.rpm > ==> Extracting openoffice-brand-math-4.1.8-9803.x86_64.rpm > ==> Extracting openoffice-en-US-draw-4.1.8-9803.x86_64.rpm > ==> Extracting openoffice-core04-4.1.8-9803.x86_64.rpm > ==> Extracting openoffice-pyuno-4.1.8-9803.x86_64.rpm > ==> Extracting openoffice-en-US-base-4.1.8-9803.x86_64.rpm > ==> Extracting openoffice-brand-draw-4.1.8-9803.x86_64.rpm > ==> Extracting openoffice-images-4.1.8-9803.x86_64.rpm > ==> Extracting openoffice-core03-4.1.8-9803.x86_64.rpm > ==> Extracting openoffice-graphicfilter-4.1.8-9803.x86_64.rpm > ==> Extracting openoffice-brand-en-US-4.1.8-9803.x86_64.rpm > ==> Extracting openoffice-calc-4.1.8-9803.x86_64.rpm > ==> Extracting openoffice-en-US-math-4.1.8-9803.x86_64.rpm > ==> Extracting openoffice-ooofonts-4.1.8-9803.x86_64.rpm > ==> Extracting openoffice-xsltfilter-4.1.8-9803.x86_64.rpm > ==> Extracting openoffice4.1.8-freedesktop-menus-4.1.8-9803.noarch.rpm > ==> Extracting openoffice-writer-4.1.8-9803.x86_64.rpm > ==> Extracting openoffice-core05-4.1.8-9803.x86_64.rpm > ==> Extracting openoffice-onlineupdate-4.1.8-9803.x86_64.rpm > ? -> Completing package > find: 'opt/openoffice4/program/python-core-2.7.6/lib': No such file or > directory > sed: no input files > ==> ERROR: A failure occurred in package(). > ??? Aborting... > ==> ERROR: Makepkg was unable to build openoffice. > ==> Restart building openoffice ? [y/N] > ==> ----------------------------------- > ==> > > But in /opt/openoffice4/program/python-core-2.7.6/lib" i see files. > ok next correct patch (add "/") and get next error: > > [...] > ==> Extracting openoffice-xsltfilter-4.1.8-9803.x86_64.rpm > ==> Extracting openoffice-writer-4.1.8-9803.x86_64.rpm > ==> Extracting openoffice-core05-4.1.8-9803.x86_64.rpm > ==> Extracting openoffice-onlineupdate-4.1.8-9803.x86_64.rpm > ==> Extracting openoffice4.1.8-freedesktop-menus-4.1.8-9803.noarch.rpm > ? -> Completing package > sed: couldn't open temporary file > /opt/openoffice4/program/python-core-2.7.6/lib/sedlrxOz8: Permission denied > ==> ERROR: A failure occurred in package(). > ??? Aborting... > ==> ERROR: Makepkg was unable to build openoffice. > ==> Restart building openoffice ? [y/N] > ==> ----------------------------------- > ==> > > interesting... > > I see maintainers nothing doing for last 1,5 year. The aurweb software contains a (presumably working) feature to submit an orphan request if you feel a package is not being maintained. I don't see anything else for us (the mailing list for discussion about development of the website software) to do here. ... Perhaps you meant to post to the aur-general mailing list for help? -- Eli Schwartz Bug Wrangler and Trusted User

1 0

openoffice
by Bartosz Bartczak 18 Dec '20

18 Dec '20

$ yaourt -S openoffice ==> Downloading openoffice PKGBUILD from AUR... x .SRCINFO x PKGBUILD kikislater commented on <a href="#comment-751939" class="date">2020-06-19 05:25</a> LordofNoob commented on <a href="#comment-752120" class="date">2020-06-20 09:18</a> kikislater commented on <a href="#comment-752377" class="date">2020-06-22 05:11</a> micwoj92 commented on <a href="#comment-774049" class="date">2020-11-05 08:32</a> gameboy commented on <a href="#comment-779686" class="date">2020-12-08 13:06</a> openoffice 4.1.7-1 (2019-10-17 11:05) ( Unsupported package: Potentially dangerous ! ) ==> Edit PKGBUILD ? [Y/n] ("A" to abort) ==> ------------------------------------ ==> n ==> openoffice dependencies: - freetype2 (already installed) - glibc>=2.5 (already installed) - gtk2>=2.10.4 (already installed) - hicolor-icon-theme (already installed) - desktop-file-utils (already installed) - shared-mime-info (already installed) ==> Continue building openoffice ? [Y/n] ==> ------------------------------------ ==> ==> Building and installing package ==> Making package: openoffice 4.1.7-1 (Thu Dec 17 22:08:40 2020) ==> Checking runtime dependencies... ==> Checking buildtime dependencies... ==> Retrieving sources... -> Downloading v4.1.7-x86_64... % Total % Received % Xferd Average Speed Time Time Time Current Dload Upload Total Spent Left Speed 100 306 100 306 0 0 2528 0 --:--:-- --:--:-- --:--:-- 2508 0 0 0 0 0 0 0 0 --:--:-- --:--:-- --:--:-- 0 curl: (22) The requested URL returned error: 404 Not Found ==> ERROR: Failure while downloading http://apache.org/dist/openoffice/4.1.7/binaries/en-US/Apache_OpenOffice_4.… Aborting... ==> ERROR: Makepkg was unable to build openoffice. ==> Restart building openoffice ? [y/N] ==> ----------------------------------- ==> n AUR see old version openoffice 4.1.7-1 not 4.1.8 and can't download package from source to build. I think so that can fix it. When fixit buildfile get other error: yaour -S openoffice [...] ==> Continue building openoffice ? [Y/n] ==> ------------------------------------ ==> ==> Building and installing package ==> Making package: openoffice 4.1.8-1 (Thu Dec 17 23:42:02 2020) ==> Checking runtime dependencies... ==> Checking buildtime dependencies... ==> Retrieving sources... -> Downloading v4.1.8-x86_64... % Total % Received % Xferd Average Speed Time Time Time Current Dload Upload Total Spent Left Speed 100 161M 100 161M 0 0 1279k 0 0:02:08 0:02:08 --:--:-- 1547k ==> Validating source_x86_64 files with md5sums... v4.1.8-x86_64 ... Passed ==> Extracting sources... -> Extracting v4.1.8-x86_64 with bsdtar ==> Entering fakeroot environment... ==> Starting package()... ==> Skipping openoffice4.1.8-mandriva-menus-4.1.8-9803.noarch.rpm ==> Skipping openoffice4.1.8-redhat-menus-4.1.8-9803.noarch.rpm ==> Skipping openoffice4.1.8-suse-menus-4.1.8-9803.noarch.rpm ==> Extracting openoffice-brand-base-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-en-US-impress-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-en-US-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-core02-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-math-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-draw-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-brand-calc-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-impress-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-core06-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-en-US-help-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-core01-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-en-US-res-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-ogltrans-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-base-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-brand-impress-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-javafilter-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-gnome-integration-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-ure-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-en-US-writer-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-ooolinguistic-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-core07-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-en-US-calc-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-brand-writer-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-brand-math-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-en-US-draw-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-core04-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-pyuno-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-en-US-base-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-brand-draw-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-images-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-core03-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-graphicfilter-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-brand-en-US-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-calc-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-en-US-math-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-ooofonts-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-xsltfilter-4.1.8-9803.x86_64.rpm ==> Extracting openoffice4.1.8-freedesktop-menus-4.1.8-9803.noarch.rpm ==> Extracting openoffice-writer-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-core05-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-onlineupdate-4.1.8-9803.x86_64.rpm -> Completing package find: 'opt/openoffice4/program/python-core-2.7.6/lib': No such file or directory sed: no input files ==> ERROR: A failure occurred in package(). Aborting... ==> ERROR: Makepkg was unable to build openoffice. ==> Restart building openoffice ? [y/N] ==> ----------------------------------- ==> But in /opt/openoffice4/program/python-core-2.7.6/lib" i see files. ok next correct patch (add "/") and get next error: [...] ==> Extracting openoffice-xsltfilter-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-writer-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-core05-4.1.8-9803.x86_64.rpm ==> Extracting openoffice-onlineupdate-4.1.8-9803.x86_64.rpm ==> Extracting openoffice4.1.8-freedesktop-menus-4.1.8-9803.noarch.rpm -> Completing package sed: couldn't open temporary file /opt/openoffice4/program/python-core-2.7.6/lib/sedlrxOz8: Permission denied ==> ERROR: A failure occurred in package(). Aborting... ==> ERROR: Makepkg was unable to build openoffice. ==> Restart building openoffice ? [y/N] ==> ----------------------------------- ==> interesting... I see maintainers nothing doing for last 1,5 year. Best Regards Bartosz Bartczak

2 2

[PATCH] Adding color highlighting to orphaned packages on result list
by marcus＠tojoma.se 22 Sep '20

22 Sep '20

The following patch solves the issue addressed by me in a previous email, regarding the color of the word "orphan" when browsing packages. Signed-off-by: Marcus Andersson <marcus(a)tojoma.se> --- web/template/pkg_search_results.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) mode change 100644 => 100755 web/template/pkg_search_results.php diff --git a/web/template/pkg_search_results.php b/web/template/pkg_search_results.php old mode 100644 new mode 100755 index 7c5ad03b..61335560 --- a/web/template/pkg_search_results.php +++ b/web/template/pkg_search_results.php @@ -96,7 +96,7 @@ if (!$result): ?> <a href="<?= get_uri('/packages/'); ?>?K=<?= htmlspecialchars($row['Maintainer'], ENT_QUOTES) ?>& SeB=m"><?= htmlspecialchars($row['Maintainer']) ?></a> <?php endif; ?> <?php else: ?> - <span><?= __("orphan") ?></span> + <span class="error"><?= __("orphan") ?></span> <?php endif; ?> </td> </tr> -- 2.28.0 Regards, Marcus Andersson(mackilanu)

1 0

Re: Highlight orphaned packages in table (Marcus Andersson)
by marcus＠tojoma.se 22 Sep '20

22 Sep '20

Hi Lukas, No worries. Yes, exactly, changing the font color to red of the word "orphan". I think that the background color can stay the same, it will be easy enough to differentiate an orphaned package from a maintained one if the text color is different. Best Regards, Marcus Andersson (mackilanu) On Tue, Sep 22, 2020 at 12:00, aur-dev-request(a)archlinux.org wrote: > Send aur-dev mailing list submissions to > aur-dev(a)archlinux.org <mailto:aur-dev@archlinux.org> > > To subscribe or unsubscribe via the World Wide Web, visit > <https://lists.archlinux.org/listinfo/aur-dev> > or, via email, send a message with subject or body 'help' to > aur-dev-request(a)archlinux.org <mailto:aur-dev-request@archlinux.org> > > You can reach the person managing the list at > aur-dev-owner(a)archlinux.org <mailto:aur-dev-owner@archlinux.org> > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of aur-dev digest..." > > > Today's Topics: > > 1. Re: Highlight orphaned packages in table (Lukas Fleischer) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Mon, 21 Sep 2020 20:45:35 -0400 > From: Lukas Fleischer <lfleischer(a)archlinux.org > <mailto:lfleischer@archlinux.org>> > To: aur-dev(a)archlinux.org <mailto:aur-dev@archlinux.org> > Subject: Re: Highlight orphaned packages in table > Message-ID: <160073553521.155630.14274525589529055982@typhoon> > Content-Type: text/plain; charset="utf-8" > > Hi Marcus, > > Sorry, this somehow fell through the cracks. > > I like the idea in general. Do you have something more specific in > mind? > What would the highlighted entry look like? Red text color for the > word > "orphan"? > > Best, > Lukas > > > ------------------------------ > > Subject: Digest Footer > > _______________________________________________ > aur-dev mailing list > aur-dev(a)archlinux.org <mailto:aur-dev@archlinux.org> > <https://lists.archlinux.org/listinfo/aur-dev> > > > ------------------------------ > > End of aur-dev Digest, Vol 143, Issue 3 > ***************************************

2 1

Highlight orphaned packages in table
by Marcus Andersson 22 Sep '20

22 Sep '20

Hi! One minor feature that i personally would find helpful, is when you're scrolling thru the package list and "accidentally" find an orphaned package that you end up adopting; Unless you're specifically looking for packages to adopt, it's pretty hard to tell an orphaned package from a maintained one. Therefore I suggest a highlighting feature, making orphaned packages easier to spot as you scroll. Fore example, out of date package's version numbers is red when they are flagged like so, that behavior would be helpful for orphaned packages too. I am happy to implement this if it seems like a reasonable addition. Thanks! mackilanu

2 1

[PATCH] pkg_search_page: Limit number of results on package search
by foxboron＠archlinux.org 05 Sep '20

05 Sep '20

From: Morten Linderud <morten(a)linderud.pw> The current package search query is quite poorly optimized and becomes a resource hog when the offsets gets large enough. This DoSes the service. A quick fix is to just ensure we have some limit to the number of hits we return. The current hardcoding of 2500 is based on the following: * 250 hits pr page max * 10 pages We can maybe consider having it lower, but it seems easier to just have this a multiple of 250 in the first iteration. Signed-off-by: Morten Linderud <morten(a)linderud.pw> --- web/lib/pkgfuncs.inc.php | 7 +++++++ 1 file changed, 7 insertions(+) diff --git a/web/lib/pkgfuncs.inc.php b/web/lib/pkgfuncs.inc.php index 8c915711..948e716c 100644 --- a/web/lib/pkgfuncs.inc.php +++ b/web/lib/pkgfuncs.inc.php @@ -624,6 +624,10 @@ function pkg_search_page($params, $show_headers=true, $SID="") { $params['O'] = 0; } + if($params['O'] >= 2500){ + $params['O'] = 2500; + } + if (isset($params["PP"])) { $params["PP"] = bound(intval($params["PP"]), 50, 250); } else { @@ -772,6 +776,9 @@ function pkg_search_page($params, $show_headers=true, $SID="") { if ($result_t) { $row = $result_t->fetch(PDO::FETCH_NUM); $total = $row[0]; + if ($total >= 2500) { + $total = 2500; + } } else { $total = 0; -- 2.28.0

2 1