Bug 444368

Summary:	www-apps/lxr-2.0.2: removal (was: version bump)
Product:	Gentoo Linux	Reporter:	Torsten Kaiser <Storklerk>
Component:	Current packages	Assignee:	Gentoo Web Application Packages Maintainers <web-apps>
Status:	RESOLVED FIXED
Severity:	normal	CC:	hwoarang, mgorny, treecleaner, vdupras
Priority:	Normal	Keywords:	PATCH, PMASKED
Version:	unspecified
Hardware:	All
OS:	Linux
Whiteboard:	Pending removal: 2018-12-01
Package list:		Runtime testing required:	---
Attachments:	quote release column name to prevent error in newer mysql versions

Description Torsten Kaiser 2012-11-22 20:58:11 UTC

Created attachment 330270 [details, diff]
quote release column name to prevent error in newer mysql versions

Trying to install lxr its index building script failed at every(?) SQL command, because in newer mysql version 'release' is a reserverd word, but lxr uses it as a column name.

Just quoting the column name with ` worked for me, the index is now building, but upstream fixed it differently by renaming the offending column: <http://lxr.cvs.sourceforge.net/viewvc/lxr/lxr/lib/LXR/Index/Mysql.pm?r1=1.20&r2=1.21>

So a bump of lxr to 1.0.0 (released 2012-09-30 according to the lxr sourceforge page) would fix it, alternativly the attached patch works for me.

Comment 1 Jeroen Roovers (RETIRED) gentoo-dev

2014-10-05 09:18:18 UTC

*** Bug 499140 has been marked as a duplicate of this bug. ***

Comment 2 Virgil Dupras (RETIRED) gentoo-dev

2018-09-10 00:21:10 UTC

This seems unmaintained. Should we treeclean?

Comment 3 Pacho Ramos gentoo-dev

2018-11-01 10:07:34 UTC

Also seems that updating to the latest versions is needed to fix lots of security bugs
https://sourceforge.net/projects/lxr/files/stable/README-stable.txt/download

Comment 4 Larry the Git Cow gentoo-dev

2018-12-01 18:24:08 UTC

The bug has been closed via the following commit(s):

https://gitweb.gentoo.org/repo/gentoo.git/commit/?id=c4a294c1dfc7d80fd7ad07c962d74449db47a069

commit c4a294c1dfc7d80fd7ad07c962d74449db47a069
Author:     Michał Górny <mgorny@gentoo.org>
AuthorDate: 2018-12-01 18:21:25 +0000
Commit:     Michał Górny <mgorny@gentoo.org>
CommitDate: 2018-12-01 18:21:25 +0000

    www-apps/lxr: Remove last-rited pkg
    
    Closes: https://bugs.gentoo.org/444368
    Signed-off-by: Michał Górny <mgorny@gentoo.org>

 profiles/package.mask                           |  5 --
 www-apps/lxr/Manifest                           |  1 -
 www-apps/lxr/files/lxr-0.9.8-initdb-mysql.patch | 13 ----
 www-apps/lxr/files/postinstall-en.txt           | 44 -------------
 www-apps/lxr/files/reconfig                     | 21 ------
 www-apps/lxr/lxr-0.9.8-r1.ebuild                | 85 -------------------------
 www-apps/lxr/metadata.xml                       | 11 ----
 7 files changed, 180 deletions(-)