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