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.