Public bug reported: Binary package hint: lxr-cvs
The genxref program from lxr-cvs produces errors when used with the --reindexall option. To reproduce set up an LXR inastallation and run genxref --url=http://localhost/lxr --allversions --reindexall Output: DBD::mysql::st execute failed: Unknown table 'lxr_indexes' in MULTI DELETE at /usr/share/perl5/LXR/Index/Mysql.pm line 334. DBD::mysql::st execute failed: Unknown table 'lxr_useage' in MULTI DELETE at /usr/share/perl5/LXR/Index/Mysql.pm line 335. DBD::mysql::st execute failed: Unknown table 'lxr_status' in MULTI DELETE at /usr/share/perl5/LXR/Index/Mysql.pm line 336. DBD::mysql::st execute failed: Unknown table 'lxr_files' in MULTI DELETE at /usr/share/perl5/LXR/Index/Mysql.pm line 338. The problem lies with the MySQL statements used for "delete_indexes", "delete_useage", "delete_status" and "delete_files" in /usr/share/perl5/LXR/Index/Mysql.pm. Between lines 114 and 131 the statements are defines as "delete from ${prefix}indexes using ${prefix}indexes i, ${prefix}releases r where ...". This is not working and according to the MySQL manual not correct syntax. Since aliases are used, the alias has to be used with DELETE, too. The correct synax would be: "delete from i using ${prefix}indexes i, ${prefix}releases r where ..." ** Affects: lxr-cvs (Ubuntu) Importance: Undecided Status: Unconfirmed -- lxr-cvs uses wrong syntax in MySQL delete statement https://launchpad.net/bugs/80894 -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
