Your message dated Tue, 20 Nov 2007 22:32:04 +0000
with message-id <[EMAIL PROTECTED]>
and subject line Bug#430523: fixed in lxr-cvs 0.9.4.0.20071020-1
has caused the attached Bug report to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what I am
talking about this indicates a serious mail system misconfiguration
somewhere. Please contact me immediately.)
Debian bug tracking system administrator
(administrator, Debian Bugs database)
--- Begin Message ---
Package: lxr-cvs
Version: 0.9.4.0.20061001-2
Severity: normal
Tags: patch
Hello,
MySQL schema uses reserved word 'release' as field name (table
lxr_releases). To be handled correctly, it should be quoted in schema
initialization script (initdb-mysql) and MySQL access module (Mysql.pm).
MySQL error message:
/usr/share/doc/lxr-cvs/examples# cat initdb-mysql | mysql
ERROR 1064 (42000) at line 35: You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the
right syntax to use near 'release)
)' at line 4
Patch which fix this in attachment.
-- System Information:
Debian Release: 4.0
APT prefers stable
APT policy: (500, 'stable')
Architecture: i386 (i686)
Shell: /bin/sh linked to /bin/bash
Kernel: Linux 2.6.18-4-686
Locale: LANG=ru_RU.UTF-8, LC_CTYPE=ru_RU.UTF-8 (charmap=UTF-8)
Versions of packages lxr-cvs depends on:
ii apache [httpd-cgi] 1.3.34-4.1 versatile, high-performance HTTP s
ii exuberant-ctags 1:5.6-1 build tag file indexes of source c
ii libfile-mmagic-perl 1.27-1 Perl module to guess file type
ii perl [perl5] 5.8.8-7 Larry Wall's Practical Extraction
Versions of packages lxr-cvs recommends:
ii libdbd-mysql-perl 3.0008-1 A Perl5 database interface to the
ii mysql-server 5.0.32-7etch1 mysql database server (meta packag
ii mysql-server-5.0 [mysql-se 5.0.32-7etch1 mysql database server binaries
-- no debconf information
diff -Nru lxr/initdb-mysql new/lxr/initdb-mysql
--- lxr/initdb-mysql 2006-10-03 10:18:37.000000000 +0400
+++ new/lxr/initdb-mysql 2007-06-25 13:57:27.000000000 +0400
@@ -35,7 +35,7 @@
create table lxr_releases
(fileid int not null references lxr_files,
`release` char(255) binary not null,
- primary key (fileid,release)
+ primary key (fileid,`release`)
);
create table lxr_useage
diff -Nru lxr/lib/LXR/Index/Mysql.pm new/lxr/lib/LXR/Index/Mysql.pm
--- lxr/lib/LXR/Index/Mysql.pm 2006-10-03 10:18:37.000000000 +0400
+++ new/lxr/lib/LXR/Index/Mysql.pm 2007-06-25 14:00:07.000000000 +0400
@@ -71,16 +71,16 @@
. "where s.symid = i.symid and i.fileid = f.fileid "
. "and f.fileid = r.fileid "
. "and i.langid = d.langid and i.type = d.declid "
- . "and s.symname = ? and r.release = ?");
+ . "and s.symname = ? and r.`release` = ?");
$self->{indexes_insert} =
$self->{dbh}->prepare(
"insert into ${prefix}indexes (symid, fileid, line, langid,
type, relsym) values (?, ?, ?, ?, ?, ?)"
);
$self->{releases_select} =
- $self->{dbh}->prepare("select * from ${prefix}releases where fileid =
? and release = ?");
+ $self->{dbh}->prepare("select * from ${prefix}releases where fileid =
? and `release` = ?");
$self->{releases_insert} =
- $self->{dbh}->prepare("insert into ${prefix}releases (fileid,
release) values (?, ?)");
+ $self->{dbh}->prepare("insert into ${prefix}releases (fileid,
`release`) values (?, ?)");
$self->{status_get} =
$self->{dbh}->prepare("select status from ${prefix}status where
fileid = ?");
@@ -102,7 +102,7 @@
. "where s.symid = u.symid "
. "and f.fileid = u.fileid "
. "and u.fileid = r.fileid "
- . "and s.symname = ? and r.release = ? "
+ . "and s.symname = ? and r.`release` = ? "
. "order by f.filename");
$self->{decl_select} =
$self->{dbh}->prepare(
@@ -115,24 +115,24 @@
$self->{dbh}->prepare("delete from ${prefix}indexes "
. "using ${prefix}indexes i, ${prefix}releases r "
. "where i.fileid = r.fileid "
- . "and r.release = ?");
+ . "and r.`release` = ?");
$self->{delete_useage} =
$self->{dbh}->prepare("delete from ${prefix}useage "
. "using ${prefix}useage u, ${prefix}releases r "
. "where u.fileid = r.fileid "
- . "and r.release = ?");
+ . "and r.`release` = ?");
$self->{delete_status} =
$self->{dbh}->prepare("delete from ${prefix}status "
. "using ${prefix}status s, ${prefix}releases r "
. "where s.fileid = r.fileid "
- . "and r.release = ?");
+ . "and r.`release` = ?");
$self->{delete_releases} =
- $self->{dbh}->prepare("delete from ${prefix}releases " . "where
release = ?");
+ $self->{dbh}->prepare("delete from ${prefix}releases " . "where
`release` = ?");
$self->{delete_files} =
$self->{dbh}->prepare("delete from ${prefix}files "
. "using ${prefix}files f, ${prefix}releases r "
. "where f.fileid = r.fileid "
- . "and r.release = ?");
+ . "and r.`release` = ?");
return $self;
}
--- End Message ---
--- Begin Message ---
Source: lxr-cvs
Source-Version: 0.9.4.0.20071020-1
We believe that the bug you reported is fixed in the latest version of
lxr-cvs, which is due to be installed in the Debian FTP archive:
lxr-cvs_0.9.4.0.20071020-1.diff.gz
to pool/main/l/lxr-cvs/lxr-cvs_0.9.4.0.20071020-1.diff.gz
lxr-cvs_0.9.4.0.20071020-1.dsc
to pool/main/l/lxr-cvs/lxr-cvs_0.9.4.0.20071020-1.dsc
lxr-cvs_0.9.4.0.20071020-1_all.deb
to pool/main/l/lxr-cvs/lxr-cvs_0.9.4.0.20071020-1_all.deb
lxr-cvs_0.9.4.0.20071020.orig.tar.gz
to pool/main/l/lxr-cvs/lxr-cvs_0.9.4.0.20071020.orig.tar.gz
A summary of the changes between this version and the previous one is
attached.
Thank you for reporting the bug, which will now be closed. If you
have further comments please address them to [EMAIL PROTECTED],
and the maintainer will reopen the bug report if appropriate.
Debian distribution maintenance software
pp.
Giacomo Catenazzi <[EMAIL PROTECTED]> (supplier of updated lxr-cvs package)
(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing [EMAIL PROTECTED])
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Format: 1.7
Date: Tue, 20 Nov 2007 23:09:28 +0100
Source: lxr-cvs
Binary: lxr-cvs
Architecture: source all
Version: 0.9.4.0.20071020-1
Distribution: unstable
Urgency: low
Maintainer: [EMAIL PROTECTED]
Changed-By: Giacomo Catenazzi <[EMAIL PROTECTED]>
Description:
lxr-cvs - A general hypertext cross-referencing tool
Closes: 411060 420055 430523 449091
Changes:
lxr-cvs (0.9.4.0.20071020-1) unstable; urgency=low
.
* New upstream CVS release: support git repositories (closes: #449091)
* From Max Lapan: quote other new reserver word "release".
Thanks Max (closes: #430523, #411060)
* correct the symlink (closes: #420055)
Files:
60aad6e53f13b1a8f42270e2b70f5c0a 598 misc extra lxr-cvs_0.9.4.0.20071020-1.dsc
95f9f694c5e233e88d8f37326715d769 112741 misc extra
lxr-cvs_0.9.4.0.20071020.orig.tar.gz
e572e3062e60048e33d20790432add6f 8067 misc extra
lxr-cvs_0.9.4.0.20071020-1.diff.gz
fe7a0a3cb3e7512c21ca542c349b6307 71984 misc extra
lxr-cvs_0.9.4.0.20071020-1_all.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
iD8DBQFHQ194+ZNUJLHfmlcRApV2AJ9S1EkA3Mt7mdn/aWGb/vVgynvhvQCgi1cu
0FHknoLevbWjUw8O5bZdw+g=
=Ibpo
-----END PGP SIGNATURE-----
--- End Message ---
