[Fwd: Re: mysql wont start]

[James Kosin-3]

Jason Dawkins wrote:

> O.k. That worked Thanks you very everyone.
> I'm up and running, but now all the users are getting this error when trying to close bugs. It seems that can't close bugs when they enter 'Additional Comments'.
>
> Here is the error
>
>
> Software error:
>
> DBD::mysql::db do failed: Incorrect key file for table './bugs/bugs_fulltext.MYI'; try to repair it [for Statement "UPDATE bugs_fulltext SET comments = ?, comments_noprivate = ?
>                WHERE bug_id = ?"] at Bugzilla/Bug.pm line 750
> Bugzilla::Bug::_sync_fulltext('Bugzilla::Bug=HASH(0x9c8ed90)') called at Bugzilla/Bug.pm line 707
> Bugzilla::Bug::update('Bugzilla::Bug=HASH(0x9c8ed90)', '2008-10-09 12:28:31') called at /var/www/html/bugzilla/process_bug.cgi line 521
>
>
>
> For help, please send mail to the webmaster (root@localhost), giving this error message and the time and date of the error.

Try doing a 'Sanity Check' on the database.

James




_______________________________________________
support-bugzilla mailing list
support-bugzilla@...
https://lists.mozilla.org/listinfo/support-bugzilla
PLEASE put support-bugzilla@... in the To: field when you reply.

[Jason Dawkins]

Sanity Check output

 

Checking references to bug_severity.value...

... from bugs.bug_severity.

Checking references to op_sys.value...

... from bugs.op_sys.

Bad value '' found in bugs.op_sys (bug 395
<http://wireshark1/bugzilla/show_bug.cgi?id=395> )

Bad value '' found in bugs.op_sys (bug 406
<http://wireshark1/bugzilla/show_bug.cgi?id=406> )

Bad value '' found in bugs.op_sys (bug 415
<http://wireshark1/bugzilla/show_bug.cgi?id=415> )

Bad value '' found in bugs.op_sys (bug 419
<http://wireshark1/bugzilla/show_bug.cgi?id=419> )

Bad value '' found in bugs.op_sys (bug 421
<http://wireshark1/bugzilla/show_bug.cgi?id=421> )

Bad value '' found in bugs.op_sys (bug 453
<http://wireshark1/bugzilla/show_bug.cgi?id=453> )

Bad value '' found in bugs.op_sys (bug 463
<http://wireshark1/bugzilla/show_bug.cgi?id=463> )

Bad value '' found in bugs.op_sys (bug 478
<http://wireshark1/bugzilla/show_bug.cgi?id=478> )

Bad value '' found in bugs.op_sys (bug 656
<http://wireshark1/bugzilla/show_bug.cgi?id=656> )

Checking references to priority.value...

... from bugs.priority.

Checking references to rep_platform.value...

... from bugs.rep_platform.

Bad value '' found in bugs.rep_platform (bug 395
<http://wireshark1/bugzilla/show_bug.cgi?id=395> )

Bad value '' found in bugs.rep_platform (bug 406
<http://wireshark1/bugzilla/show_bug.cgi?id=406> )

Bad value '' found in bugs.rep_platform (bug 415
<http://wireshark1/bugzilla/show_bug.cgi?id=415> )

Bad value '' found in bugs.rep_platform (bug 419
<http://wireshark1/bugzilla/show_bug.cgi?id=419> )

Bad value '' found in bugs.rep_platform (bug 421
<http://wireshark1/bugzilla/show_bug.cgi?id=421> )

Bad value '' found in bugs.rep_platform (bug 453
<http://wireshark1/bugzilla/show_bug.cgi?id=453> )

Bad value '' found in bugs.rep_platform (bug 463
<http://wireshark1/bugzilla/show_bug.cgi?id=463> )

Bad value '' found in bugs.rep_platform (bug 478
<http://wireshark1/bugzilla/show_bug.cgi?id=478> )

Bad value '' found in bugs.rep_platform (bug 656
<http://wireshark1/bugzilla/show_bug.cgi?id=656> )

Checking references to series.series_id...

... from series_data.series_id.

Checking references to series_categories.id...

... from series.category.

... from category_group_map.category_id.

... from series.subcategory.

Checking references to whine_events.id...

... from whine_queries.eventid.

... from whine_schedules.eventid.

Checking references to attachments.attach_id...

... from attach_data.id.

... from bugs_activity.attach_id.

Checking references to bug_status.id...

... from status_workflow.old_status.

... from status_workflow.new_status.

Checking references to attachments.bug_id / attachments.attach_id...

... from flags.bug_id / flags.attach_id.

... from bugs_activity.bug_id / bugs_activity.attach_id.

Checking references to components.product_id / components.id...

... from bugs.product_id / bugs.component_id.

... from flagexclusions.product_id / flagexclusions.component_id.

... from flaginclusions.product_id / flaginclusions.component_id.

Checking references to versions.product_id / versions.value...

... from bugs.product_id / bugs.version.

Checking references to milestones.product_id / milestones.value...

... from bugs.product_id / bugs.target_milestone.

... from products.id / products.defaultmilestone.

Checking profile logins.

Bad profile email address, id=1,
<bugzilla-admin@...>.

Checking cached vote counts.

Checking keywords table.

Checking cached keywords.

Checking for flags being in the wrong product/component.

Checking for bugs with no creation date (which makes them invisible).

Checking for bugs with no entry for full text searching.

Checking resolution/duplicates

Checking statuses/resolutions

Checking statuses/everconfirmed

Checking votes/everconfirmed

Checking for bad values in group_control_map

Checking for bugs with groups violating their product's group controls

Checking for unsent mail

Checking for whines with non-existent users/groups.

Sanity check completed.

 

 

From: support-bugzilla-bounces+jdawkins=pulselink.net@...
[mailto:support-bugzilla-bounces+jdawkins=pulselink.net@...
g] On Behalf Of James Kosin
Sent: Thursday, October 09, 2008 1:54 PM
To: support-bugzilla@...
Subject: [Fwd: Re: mysql wont start]

 

 

_______________________________________________
support-bugzilla mailing list
support-bugzilla@...
https://lists.mozilla.org/listinfo/support-bugzilla
PLEASE put support-bugzilla@... in the To: field when you reply.