Restore Error

[Yoeri Van de Moortel]

After restoring a Bugzilla database backup, I get the following error when
submitting a new bug:

DBD::mysql::st execute failed: Field 'status_whiteboard' doesn't have a
default value [for Statement "INSERT INTO bugs
(version,rep_platform,bug_severity,priority,op_sys,assigned_to,bug_status,everconfirmed,bug_file_loc,short_desc,target_milestone,product_id,component_id,
reporter, delta_ts, estimated_time, remaining_time, deadline) VALUES
('Unspecified','PC','normal','P2','Windows','1','NEW','1','','test','---','2','4',1,
'2005-11-09 13:45:08', 0, 0, NULL)"] at Bugzilla/DB.pm line 84
Bugzilla::DB::SendSQL('INSERT INTO bugs
(version,rep_platform,bug_severity,priority,...') called at
C:\Bugzilla220\post_bug.cgi line 382Can anybody help me out here ? I am
obviously doing something wrong with the backupthanksYoeri Van de Moortel

[Olav Vitters]

On Wed, Nov 09, 2005 at 01:47:22PM +0100, Yoeri Van de Moortel wrote:
> After restoring a Bugzilla database backup, I get the following error when
> submitting a new bug:

Could be due to one of two things:

1. Made the mysqlbackup without --opt option. This adds MySQL specific
stuff to the dump, perhaps includes the default option.

2. Bugzilla 2.20 hasn't been fully tested with MySQL 5. In 5.0 you can
select various ANSI compatibility options. Perhaps that is messing
things up. Try choosing a 4.1 compatible one. There was more info at
http://dev.mysql.com/ (online documentation).

--
Regards,
Olav

[Yoeri Van de Moortel]

The only way I am able to make a full backup is to copy the "Bugs" folder
from MySQL\Data

"Olav Vitters" <ol...@bkor.dhs.org> wrote in message
news:mailman.1131544563.1...@mozilla.org...