Sorry for top post blame my iPhoneIt 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 updatesHTH
Rob Kampen407-341-3815
On Aug 11, 2009, at 5:23 AM, Chris Ross <cnts5645@xxxxxxxxxxxx> 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@xxxxxxxxxxxx>> 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.> _______________________________________________> CentOS mailing list> CentOS@xxxxxxxxxx> http://lists.centos.org/mailman/listinfo/centos_______________________________________________CentOS mailing listCentOS@xxxxxxxxxxxxxx://lists.centos.org/mailman/listinfo/centos
