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@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@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@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@neodymium bugzilla]# perl --version
This is perl, v5.8.8 built for x86_64-linux-thread-multi
[root@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.