[CentOS] Bugzilla not working following RHEL to CentOS migration

Tue Aug 11 10:20:36 UTC 2009
Rob Kampen <rkampen at kampensonline.com>

Sorry for top post blame my iPhone
It looks like there is a mySql table missing between the old and new  
versions of bugzilla.
Look for a script in the newer version that performs the table updates
HTH

Rob Kampen
407-341-3815

On Aug 11, 2009, at 5:23 AM, Chris Ross <cnts5645 at tebibyte.org> wrote:

> Dear listmates,
>
> I've recently moved a server from RHEL5 to CentOS 5.3 after it was
> decided not to renew the subscripton. Everything works beautifully
> except for Bugzilla, which throws MySQL errors. For example, the
> sanitycheck.cgi page says:
>
>
> # # #
>
> Bugzilla – Sanity Check
>
>     * Home
>     * | New
>     * | Search
>     * |
>     * | Reports
>     *
>     * | My Votes
>     * | Preferences
>     * | Administration
>     * | Log out bugzilla at grandeye.com
>
> Bugzilla is checking the referential integrity of your database. This
> may take several minutes to complete.
>
> Errors, if any, will be emphasized like this. Depending on the errors
> found, some links will be displayed allowing you to easily fix them.
> Fixing these errors will automatically run this script again (so be
> aware that it may take an even longer time than the first run).
>
> OK, now running sanity checks.
>
> Checking references to classifications.id...
>
> ... from products.classification_id.
>
> Checking references to keyworddefs.id...
>
> ... from keywords.keywordid.
>
> Checking references to fielddefs.id...
>
> ... from bugs_activity.fieldid.
>
> ... from profiles_activity.fieldid.
>
> Checking references to flagtypes.id...
>
> ... from flags.type_id.
>
> ... from flagexclusions.type_id.
>
> ... from flaginclusions.type_id.
>
> Checking references to bugs.bug_id...
>
> ... from bugs_activity.bug_id.
>
> ... from bug_group_map.bug_id.
>
> ... from bugs_fulltext.bug_id.
> Software error:
>
> DBD::mysql::st execute failed: Table 'bugs.bugs_fulltext' doesn't  
> exist
> [for Statement "SELECT DISTINCT bugs_fulltext.bug_id FROM  
> bugs_fulltext
>                     LEFT JOIN bugs
>                            ON bugs_fulltext.bug_id = bugs.bug_id
>                         WHERE bugs.bug_id IS NULL
>                           AND bugs_fulltext.bug_id IS NOT NULL"] at
> /var/www/html/bugzilla/sanitycheck.cgi line 428
>    main::CrossCheck('bugs', 'bug_id', 'ARRAY(0x1760b5a0)',
> 'ARRAY(0x18298ba0)', 'ARRAY(0x18298830)', 'ARRAY(0x1814a150)',
> 'ARRAY(0x17f0bf50)', 'ARRAY(0x18298840)', 'ARRAY(0x18298850)', ...)
> called at /var/www/html/bugzilla/sanitycheck.cgi line 469
>
> For help, please send mail to the webmaster (root at localhost), giving
> this error message and the time and date of the error.
>
> # # #
>
>
>
>
> bugzilla, mysql and perl are fully up-to-date according to yum, I have
> checked that the database is OK but restored a suitable (mysqldump)
> backup anyway.
>
>
> [root at neodymium bugzilla]# rpm -qa bugzilla mysql perl
> mysql-5.0.45-7.el5
> bugzilla-3.2.4-1.el5
> mysql-5.0.45-7.el5
> perl-5.8.8-18.el5_3.1
> [root at neodymium bugzilla]# perl --version
>
> This is perl, v5.8.8 built for x86_64-linux-thread-multi
>
> [root at neodymium bugzilla]# mysql --version
> mysql  Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu (x86_64) using
> readline 5.0
>
>
> Googling hasn't helped beyond suggesting this has happened to others
> following RHEL upgrading Bugzilla 3.0.2 to 3.2.4 in July for security.
> Sadly, that didn't show the way out of it.
>
> Any help would be gratefully accepted.
>
> Many thanks,
> Chris R.
> _______________________________________________
> CentOS mailing list
> CentOS at centos.org
> http://lists.centos.org/mailman/listinfo/centos