« August 2005 | Main | November 2005 »
October 26, 2005
Bugzilla and mySQL 5.0
I have been using Bugzilla for several months as a way to track bugs and features in various projects.
Here is the official description from bugzilla.org:
"Bugzilla is server software designed to help you manage software development."
It is not designed to work with mySQL 5.0 (yet), but I wanted to get it to work so I could start playing around with some of mySQL 5's new features like triggers, stored procedures and views. Here is how I did it.
The key problem is the way mySQL 5 handles JOIN's compared to mySQL 4.1. From the Release Notes:
Incompatible change: Beginning with MySQL 5.0.12, natural joins and joins with USING, including outer join variants, are processed according to the SQL:2003 standard. The changes include elimination of redundant output columns for NATURAL joins and joins specified with a USING clause and proper ordering of output columns. These changes make MySQL more compliant with standard SQL. However, they can result in different output columns for some joins. Also, some queries that appeared to work correctly prior to 5.0.12 must be rewritten to comply with the standard. For details about the scope of the changes and examples that show what query rewrites are necessary, see Section 13.2.7.1, 'JOIN Syntax'.
Let me say that I do not use nearly all of the features available in Bugzilla. I do however open, look at and re-assign bugs, make comments, etc. Even though these changes worked for me, install them at your own risk.
The following code allowed Bugzilla Version 2.18.3 to work with mySQL 5.0.15-NT on my PC. Basically, I just had to put parentheses around the table names after the FROM but before the JOIN.
C:\Bugzilla\Bugzilla\Search.pm, line 1110
change " FROM $suppstring"
to " FROM ($suppstring)"
C:\Bugzilla\Bugzilla\FlagType.pm, line 104
change "FROM flagtypes, flag${type}clusions " .
to "FROM (flagtypes, flag${type}clusions) " .
C:\Bugzilla\Bugzilla\FlagType.pm, line 59
change my @base_tables = ("flagtypes");
to my @base_tables = ("(flagtypes");
C:\Bugzilla\Bugzilla\FlagType.pm, line 363
change push(@$tables, ", flaginclusions");
to push(@$tables, ", flaginclusions)");
I also had to run this SQL:
alter table bugs change keywords keywords mediumtext null;
alter table bugs change status_whiteboard status_whiteboard mediumtext
null;
Good luck!
Posted by Chuck at 07:31 PM | Comments (17) | TrackBack
October 04, 2005
Just Added - Del.icio.us Bookmarks on Sidebar
Using an idea from Jeffrey Veen as well as the Feedsplitter PHP package, I added my 10 most recent del.icio.us bookmarks to my blog sidebar via a del.icio.us RSS Feed. Now, people can see which sites I consider worth bookmarking from right here. If you don't already use del.icio.us, I recommend it as a great place to keep track of your bookmarks as well as a place to find user-contributed pages on any subject. I also recommend this Greasemonkey script.
Note - I edited a Feedsplitter XML file in order to customize the way the feed looks on my site. You can download the updated file here. For whatever reason, the original XML file was not well-formed, but it still seems to work.
Posted by Chuck at 10:19 AM | Comments (1) | TrackBack