<HTML ><HEAD ><TITLE >Cleaning up after mucking with Bugzilla</TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.64 "><LINK REL="HOME" TITLE="The Bugzilla Guide" HREF="index.html"><LINK REL="UP" TITLE="The Bugzilla Database" HREF="database.html"><LINK REL="PREVIOUS" TITLE="MySQL Permissions & Grant Tables" HREF="granttables.html"><LINK REL="NEXT" TITLE="Bugzilla Variants" HREF="variants.html"></HEAD ><BODY CLASS="SECTION" BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#0000FF" VLINK="#840084" ALINK="#0000FF" ><DIV CLASS="NAVHEADER" ><TABLE WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TH COLSPAN="3" ALIGN="center" >The Bugzilla Guide</TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="bottom" ><A HREF="granttables.html" >Prev</A ></TD ><TD WIDTH="80%" ALIGN="center" VALIGN="bottom" >Appendix C. The Bugzilla Database</TD ><TD WIDTH="10%" ALIGN="right" VALIGN="bottom" ><A HREF="variants.html" >Next</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><DIV CLASS="SECTION" ><H1 CLASS="SECTION" ><A NAME="CLEANUPWORK" >C.4. Cleaning up after mucking with Bugzilla</A ></H1 ><P CLASS="LITERALLAYOUT" >Contributed by Eric Hanson:<br> There are several things, and one trick. There is a small tiny piece of<br> documentation I saw once that said something very important.<br> 1) After pretty much any manual working of the Mysql db, you must<br> delete a file in the bugzilla directory: data/versioncache<br> Versioncache basically is a way to speed up bugzilla (from what I<br> understand). It stores a lot of commonly used information. However,<br> this file is refreshed every so often (I can't remember the time<br> interval though). So eventually all changes do propogate out, so you<br> may see stuff suddenly working.<br> 2) Assuming that failed, you will also have to check something with the<br> checksetup.pl file. It actually is run twice. The first time it<br> creates the file: localconfig. You can modify localconfig, (or not if<br> you are doing bug_status stuff) or you should delete localconfig and<br> rerun your modified checksetup.pl. Since I don't actually see anything<br> in localconfig pertaining to bug_status, this point is mainly a FYI.<br> </P ></DIV ><DIV CLASS="NAVFOOTER" ><HR ALIGN="LEFT" WIDTH="100%"><TABLE WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" ><A HREF="granttables.html" >Prev</A ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="index.html" >Home</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" ><A HREF="variants.html" >Next</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >MySQL Permissions & Grant Tables</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="database.html" >Up</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >Bugzilla Variants</TD ></TR ></TABLE ></DIV ></BODY ></HTML >