I am installing on WinXp and everything was going fine till I ran the perl
checksetup.pl the second time to build the tables and then I get this
Checking user setup
Removing existing compiled templates
Precompiling templates
Checking for DBD::mysql (v2.9003) ok: found v3.0002
Checking for MySQL (v4.0.14) ok: found v5.0.26-community-nt
<h1>Software error:</h1>
<pre>DBD::mysql::st execute failed: Table 'bugs.bugs' doesn't exist [for
Stateme
nt "SHW INDEX FRM bugs"] at Bugzilla/DB/Mysql.pm line 634
('Bugzilla::DB::Mysql=HASH(0x3e34
150)', 'bugs', 'assigned_to') called at Bugzilla/DB/Mysql.pm line 297
('Bugzilla::DB::Mysql=HASH(0x3e341
50)') called at checksetup.pl line 1601
</pre>
<p>
For help, please send mail to this site's webmaster, giving this error
message
and the time and date of the error.
</p>
[Tue 17 14:41:58 2006] checksetup.pl: DBD::mysql::st execute failed:
Table '
bugs.bugs' doesn't exist [for Statement "SHW INDEX FRM bugs"] at
Bugzilla/DB/M
ysql.pm line 634
[Tue 17 14:41:58 2006] checksetup.pl:
fo_real('Bugzilla::DB::Mysql=HASH(0x3e34150)', 'bugs', 'assigned_to') called
at
Bugzilla/DB/Mysql.pm line 297
[Tue 17 14:41:58 2006] checksetup.pl:
tabase('Bugzilla::DB::Mysql=HASH(0x3e34150)') called at checksetup.pl line
1601
C:\bugzillia\bugzilla-2.22>
support-bugzilla mailing list
support-bugzilla (AT) lists (DOT) mozilla.org
PLEASE put support-bugzilla (AT) lists (DOT) mozilla.org in the To: field when you reply.

Hi,

I have found that the error is common in MySql when you set a create a field
with type NTNULL and you then set a default value.

However looking at the schema.pm file this clearly shows that it is not
trying to set a default value so this is very confusing.

status_whiteboard ={TYPE ='MEDIUMTEXT', NTNULL =1,
DEFAULT ="''"},

The only thing i can find is the suggestion that you shouldn't set a default
value to a BLB or TEXT field?

Still stuck.

<tomthi (AT) gmail (DOT) comwrote in message
news:1161195244.331992.15050 (AT) i3g2000cwc (DOT) googlegroups.com
I'm having the same exact problem, when you run the Checksetup.pl it
stops at

<h1>Software error:</h1>
<pre>DBD::mysql::st execute failed: Table 'bugs.bugs' doesn't exist
[for Statement "SHW INDEX FRM bugs"]
>
>
>
>
>
>
>
>
alcon wrote:
>Well I wiped the computer, (just to make sure), reinstalled everything
>and
>during the second run of checksetup.pl I got the following
>>
>C:\bugzilla\bugzilla-2.22>perl checksetup.pl
>>
>Checking perl modules
>Checking for AppConfig (v1.52) ok: found v1.63
>Checking for CGI (v2.93) ok: found v3.20
>Checking for Data::Dumper (any) ok: found v2.121_08
>Checking for Date::Format (v2.21) ok: found v2.22
>Checking for DBI (v1.38) ok: found v1.52
>Checking for File::Spec (v0.84) ok: found v3.12
>Checking for File::Temp (any) ok: found v0.16
>Checking for Template (v2.08) ok: found v2.15
>Checking for Text::Wrap (v2001.0131) ok: found v2005.082401
>Checking for Mail::Mailer (v1.67) ok: found v1.74
>Checking for MIME::Base64 (v3.01) ok: found v3.07
>Checking for MIME::Tools (v5.406) ok: found v5.411
>Checking for Storable (any) ok: found v2.15
>>
>The following Perl modules are optional:
>Checking for GD (v1.20) ok: found v2.16
>Checking for Chart::Base (v1.0) ok: found v2.3
>Checking for XML::Twig (any) not found
>Checking for GD::Graph (any) ok: found v1.43
>Checking for GD::Text::Align (any) ok: found v1.18
>Checking for PatchReader (v0.9.4) ok: found v0.9.5
>Checking for Image::Magick (any) not found
>>
>All the required modules are available at:
>
>You can add the repository with the following command:
>ppm rep add bugzilla
>>
>If you want to use the bug import/export feature to move bugs to
>or from other bugzilla installations, you will need to install
>the XML::Twig module by running (as Administrator):
>>
>ppm install XML::Twig
>>
>If you want to convert BMP image attachments to PNG to conserve
>disk space, you will need to install the ImageMagick application
>Available from http://www.imagemagick.org, and the Image::Magick
>Perl module by running (as Administrator):
>>
>ppm install Image::Magick
>>
>Checking user setup
>Creating data directory (./data)
>Creating local attachments directory
>Creating graphs directory
>Creating .htaccess
>Creating
>Creating Bugzilla/.htaccess
>Creating ./data/.htaccess
>Creating ./template/.htaccess
>Creating ./data/webdot/.htaccess
>>
>Bugzilla requires an SMTP server to function on Windows.
>Please enter your SMTP server's hostname: xxxxx.xxx
>Precompiling templates
>Checking for DBD::mysql (v2.9003) ok: found v3.0002
>Checking for MySQL (v4.0.14) ok: found v5.0.26-community-nt
>>
>Building Schema object from database
>Adding new table bz_schema
>Initializing the new Schema storage
>Adding new table attach_data
>Adding new table attachments
>Adding new table bug_group_map
>Adding new table bug_severity
>Adding new table bug_status
>Adding new table bugs
><h1>Software error:</h1>
><pre>DBD::mysql::db do failed: BLB/TEXT column 'status_whiteboard' can't
>have a
>default value at Bugzilla/DB.pm line 513
>
>('Bugzilla::DB::Mysql=HASH(0x3e30f34)',
>'
>bugs') called at Bugzilla/DB.pm line 488
>Bugzilla::DB::bz_add_table('Bugzilla::DB::Mysql=HA SH(0x3e30f34)',
>'bugs'
>) called at Bugzilla/DB.pm line 335
>
>('Bugzilla::DB::Mysql=HASH(0x3e30f34)')
>c
>alled at Bugzilla/DB/Mysql.pm line 453
>
>('Bugzilla::DB::Mysql=HASH(0x3e30f
>34)') called at checksetup.pl line 1601
></pre>
><p>
>For help, please send mail to this site's webmaster, giving this error
>message
>and the time and date of the error.
>>
></p>
>[Wed 18 11:41:51 2006] checksetup.pl: DBD::mysql::db do failed:
>BLB/TEXT co
>lumn 'status_whiteboard' can't have a default value at Bugzilla/DB.pm
>line
>513
>[Wed 18 11:41:51 2006] checksetup.pl:
>(
>'Bugzilla::DB::Mysql=HASH(0x3e30f34)', 'bugs') called at Bugzilla/DB.pm
>line
>488
>>
>[Wed 18 11:41:51 2006] checksetup.pl:
>Bugzilla::DB::bz_add_table('Bugz
>illa::DB::Mysql=HASH(0x3e30f34)', 'bugs') called at Bugzilla/DB.pm line
>335
>[Wed 18 11:41:51 2006] checksetup.pl:
>(
>'Bugzilla::DB::Mysql=HASH(0x3e30f34)') called at Bugzilla/DB/Mysql.pm
>line
>453
>[Wed 18 11:41:51 2006] checksetup.pl:
>
>tabase('Bugzilla::DB::Mysql=HASH(0x3e30f34)') called at checksetup.pl
>line
>1601
>>
>>
>I have been following install guide at
>and everything goes smooth
>till that point.
>>
>any further ideas?
>"Max Kanat-Alexander" <mkanat (AT) bugzilla (DOT) orgwrote in message
>@lists.mozilla.org
>Tue, 2006-10-17 at 14:48 -0500, alcon wrote:
>><pre>DBD::mysql::st execute failed: Table 'bugs.bugs' doesn't exist
>>[for
>>Statement "SHW INDEX FRM bugs"]
>>
>Is this a brand-new installation?
>>
>If so, start over from scratch and follow the Installation and
>Configuration sections of the Bugzilla Guide very carefully.
>>
>It's possible you forgot to give the MySQL user the correct
>permissions.
>>
>-Max
>--
>
>Competent, Friendly Bugzilla Services. And Everything Else, too.
>>

support-bugzilla mailing list
support-bugzilla (AT) lists (DOT) mozilla.org

PLEASE put support-bugzilla (AT) lists (DOT) mozilla.org in the To: field when you reply.

,

I have found that if you remove this information:
",
DEFAULT ="''"
"

>From these fields:
status_whiteboard
Keywords
userregexp

>From The Schema.pm file it gets past the first three cases of this issue by
not setting defaults on these types of fields.

However the process then tries to modify the column "userregexp" adding the
default back in and causing it to fail again. I'm now stuck at this point as
i have no Perl knowledge what so ever its a bit of a search in the dark for
me, however i think it is setting this information automatically and not
using a schema?

HELP

"John Ince" <bensoni (AT) rangersuite (DOT) comwrote in message
@mozilla.org
Hi,

I have found that the error is common in MySql when you set a create a
field with type NTNULL and you then set a default value.

However looking at the schema.pm file this clearly shows that it is not
trying to set a default value so this is very confusing.

status_whiteboard ={TYPE ='MEDIUMTEXT', NTNULL =1,
DEFAULT ="''"},

The only thing i can find is the suggestion that you shouldn't set a
default value to a BLB or TEXT field?

Still stuck.

<tomthi (AT) gmail (DOT) comwrote in message
news:1161195244.331992.15050 (AT) i3g2000cwc (DOT) googlegroups.com
>I'm having the same exact problem, when you run the Checksetup.pl it
>stops at
>>
><h1>Software error:</h1>
><pre>DBD::mysql::st execute failed: Table 'bugs.bugs' doesn't exist
>[for Statement "SHW INDEX FRM bugs"]
>>
>>
>>
>>
>>
>>
>>
>>
>alcon wrote:
Well I wiped the computer, (just to make sure), reinstalled everything
and
during the second run of checksetup.pl I got the following

C:\bugzilla\bugzilla-2.22>perl checksetup.pl

Checking perl modules
Checking for AppConfig (v1.52) ok: found v1.63
Checking for CGI (v2.93) ok: found v3.20
Checking for Data::Dumper (any) ok: found v2.121_08
Checking for Date::Format (v2.21) ok: found v2.22
Checking for DBI (v1.38) ok: found v1.52
Checking for File::Spec (v0.84) ok: found v3.12
Checking for File::Temp (any) ok: found v0.16
Checking for Template (v2.08) ok: found v2.15
Checking for Text::Wrap (v2001.0131) ok: found v2005.082401
Checking for Mail::Mailer (v1.67) ok: found v1.74
Checking for MIME::Base64 (v3.01) ok: found v3.07
Checking for MIME::Tools (v5.406) ok: found v5.411
Checking for Storable (any) ok: found v2.15

The following Perl modules are optional:
Checking for GD (v1.20) ok: found v2.16
Checking for Chart::Base (v1.0) ok: found v2.3
Checking for XML::Twig (any) not found
Checking for GD::Graph (any) ok: found v1.43
Checking for GD::Text::Align (any) ok: found v1.18
Checking for PatchReader (v0.9.4) ok: found v0.9.5
Checking for Image::Magick (any) not found

All the required modules are available at:

You can add the repository with the following command:
ppm rep add bugzilla

If you want to use the bug import/export feature to move bugs to
or from other bugzilla installations, you will need to install
the XML::Twig module by running (as Administrator):

ppm install XML::Twig

If you want to convert BMP image attachments to PNG to conserve
disk space, you will need to install the ImageMagick application
Available from http://www.imagemagick.org, and the Image::Magick
Perl module by running (as Administrator):

ppm install Image::Magick

Checking user setup
Creating data directory (./data)
Creating local attachments directory
Creating graphs directory
Creating .htaccess
Creating
Creating Bugzilla/.htaccess
Creating ./data/.htaccess
Creating ./template/.htaccess
Creating ./data/webdot/.htaccess

Bugzilla requires an SMTP server to function on Windows.
Please enter your SMTP server's hostname: xxxxx.xxx
Precompiling templates
Checking for DBD::mysql (v2.9003) ok: found v3.0002
Checking for MySQL (v4.0.14) ok: found v5.0.26-community-nt

Building Schema object from database
Adding new table bz_schema
Initializing the new Schema storage
Adding new table attach_data
Adding new table attachments
Adding new table bug_group_map
Adding new table bug_severity
Adding new table bug_status
Adding new table bugs
<h1>Software error:</h1>
<pre>DBD::mysql::db do failed: BLB/TEXT column 'status_whiteboard'
can't
have a
default value at Bugzilla/DB.pm line 513

('Bugzilla::DB::Mysql=HASH(0x3e30f34)',
'
bugs') called at Bugzilla/DB.pm line 488

Bugzilla::DB::bz_add_table('Bugzilla::DB::Mysql=HA SH(0x3e30f34)',
'bugs'
) called at Bugzilla/DB.pm line 335

('Bugzilla::DB::Mysql=HASH(0x3e30f34)')
c
alled at Bugzilla/DB/Mysql.pm line 453

('Bugzilla::DB::Mysql=HASH(0x3e30f
34)') called at checksetup.pl line 1601
</pre>
<p>
For help, please send mail to this site's webmaster, giving this error
message
and the time and date of the error.

</p>
[Wed 18 11:41:51 2006] checksetup.pl: DBD::mysql::db do failed:
BLB/TEXT co
lumn 'status_whiteboard' can't have a default value at Bugzilla/DB.pm
line
513
[Wed 18 11:41:51 2006] checksetup.pl:
(
'Bugzilla::DB::Mysql=HASH(0x3e30f34)', 'bugs') called at Bugzilla/DB.pm
line
488

[Wed 18 11:41:51 2006] checksetup.pl:
Bugzilla::DB::bz_add_table('Bugz
illa::DB::Mysql=HASH(0x3e30f34)', 'bugs') called at Bugzilla/DB.pm line
335
[Wed 18 11:41:51 2006] checksetup.pl:
(
'Bugzilla::DB::Mysql=HASH(0x3e30f34)') called at Bugzilla/DB/Mysql.pm
line
453
[Wed 18 11:41:51 2006] checksetup.pl:

tabase('Bugzilla::DB::Mysql=HASH(0x3e30f34)') called at checksetup.pl
line
1601

I have been following install guide at
and everything goes
smooth
till that point.

any further ideas?
"Max Kanat-Alexander" <mkanat (AT) bugzilla (DOT) orgwrote in message
@lists.mozilla.org
Tue, 2006-10-17 at 14:48 -0500, alcon wrote:
><pre>DBD::mysql::st execute failed: Table 'bugs.bugs' doesn't exist
>[for
>Statement "SHW INDEX FRM bugs"]
>
Is this a brand-new installation?
>
If so, start over from scratch and follow the Installation and
Configuration sections of the Bugzilla Guide very carefully.
>
It's possible you forgot to give the MySQL user the correct
permissions.
>
-Max
--
Competent, Friendly Bugzilla Services. And Everything Else, too.
>
>>
>

support-bugzilla mailing list
support-bugzilla (AT) lists (DOT) mozilla.org

PLEASE put support-bugzilla (AT) lists (DOT) mozilla.org in the To: field when you reply.

The problem was caused by the Mysql Version 5. this needs to be version 4.1.

The problem is that in the latest version of MySql. It has different
requirements for the default settings on new fields.

uninstall version 5 and install version 4 to resolve your problems.

I hope this helps.

"John Ince" <bensoni (AT) rangersuite (DOT) comwrote in message
@mozilla.org
,
--
I have found that if you remove this information:
",
DEFAULT ="''"
"

From these fields:
status_whiteboard
Keywords
userregexp

From The Schema.pm file it gets past the first three cases of this issue
by not setting defaults on these types of fields.

However the process then tries to modify the column "userregexp" adding
the default back in and causing it to fail again. I'm now stuck at this
point as i have no Perl knowledge what so ever its a bit of a search in
the dark for me, however i think it is setting this information
automatically and not using a schema?

HELP

"John Ince" <bensoni (AT) rangersuite (DOT) comwrote in message
@mozilla.org
>Hi,
>>
>I have found that the error is common in MySql when you set a create a
>field with type NTNULL and you then set a default value.
>>
>However looking at the schema.pm file this clearly shows that it is not
>trying to set a default value so this is very confusing.
>>
>status_whiteboard ={TYPE ='MEDIUMTEXT', NTNULL =1,
>DEFAULT ="''"},
>>
>The only thing i can find is the suggestion that you shouldn't set a
>default value to a BLB or TEXT field?
>>
>Still stuck.
>>
><tomthi (AT) gmail (DOT) comwrote in message
>news:1161195244.331992.15050 (AT) i3g2000cwc (DOT) googlegroups.com
I'm having the same exact problem, when you run the Checksetup.pl it
stops at

<h1>Software error:</h1>
<pre>DBD::mysql::st execute failed: Table 'bugs.bugs' doesn't exist
[for Statement "SHW INDEX FRM bugs"]

alcon wrote:
Well I wiped the computer, (just to make sure), reinstalled everything
and
during the second run of checksetup.pl I got the following

C:\bugzilla\bugzilla-2.22>perl checksetup.pl

Checking perl modules
Checking for AppConfig (v1.52) ok: found v1.63
Checking for CGI (v2.93) ok: found v3.20
Checking for Data::Dumper (any) ok: found v2.121_08
Checking for Date::Format (v2.21) ok: found v2.22
Checking for DBI (v1.38) ok: found v1.52
Checking for File::Spec (v0.84) ok: found v3.12
Checking for File::Temp (any) ok: found v0.16
Checking for Template (v2.08) ok: found v2.15
Checking for Text::Wrap (v2001.0131) ok: found v2005.082401
Checking for Mail::Mailer (v1.67) ok: found v1.74
Checking for MIME::Base64 (v3.01) ok: found v3.07
Checking for MIME::Tools (v5.406) ok: found v5.411
Checking for Storable (any) ok: found v2.15

The following Perl modules are optional:
Checking for GD (v1.20) ok: found v2.16
Checking for Chart::Base (v1.0) ok: found v2.3
Checking for XML::Twig (any) not found
Checking for GD::Graph (any) ok: found v1.43
Checking for GD::Text::Align (any) ok: found v1.18
Checking for PatchReader (v0.9.4) ok: found v0.9.5
Checking for Image::Magick (any) not found

All the required modules are available at:

You can add the repository with the following command:
ppm rep add bugzilla

If you want to use the bug import/export feature to move bugs to
or from other bugzilla installations, you will need to install
the XML::Twig module by running (as Administrator):

ppm install XML::Twig

If you want to convert BMP image attachments to PNG to conserve
disk space, you will need to install the ImageMagick application
Available from http://www.imagemagick.org, and the Image::Magick
Perl module by running (as Administrator):

ppm install Image::Magick

Checking user setup
Creating data directory (./data)
Creating local attachments directory
Creating graphs directory
Creating .htaccess
Creating
Creating Bugzilla/.htaccess
Creating ./data/.htaccess
Creating ./template/.htaccess
Creating ./data/webdot/.htaccess

Bugzilla requires an SMTP server to function on Windows.
Please enter your SMTP server's hostname: xxxxx.xxx
Precompiling templates
Checking for DBD::mysql (v2.9003) ok: found v3.0002
Checking for MySQL (v4.0.14) ok: found v5.0.26-community-nt

Building Schema object from database
Adding new table bz_schema
Initializing the new Schema storage
Adding new table attach_data
Adding new table attachments
Adding new table bug_group_map
Adding new table bug_severity
Adding new table bug_status
Adding new table bugs
<h1>Software error:</h1>
<pre>DBD::mysql::db do failed: BLB/TEXT column 'status_whiteboard'
can't
have a
default value at Bugzilla/DB.pm line 513

('Bugzilla::DB::Mysql=HASH(0x3e30f34)',
'
bugs') called at Bugzilla/DB.pm line 488

Bugzilla::DB::bz_add_table('Bugzilla::DB::Mysql=HA SH(0x3e30f34)',
'bugs'
) called at Bugzilla/DB.pm line 335

('Bugzilla::DB::Mysql=HASH(0x3e30f34)')
c
alled at Bugzilla/DB/Mysql.pm line 453

('Bugzilla::DB::Mysql=HASH(0x3e30f
34)') called at checksetup.pl line 1601
</pre>
<p>
For help, please send mail to this site's webmaster, giving this error
message
and the time and date of the error.

</p>
[Wed 18 11:41:51 2006] checksetup.pl: DBD::mysql::db do failed:
BLB/TEXT co
lumn 'status_whiteboard' can't have a default value at Bugzilla/DB.pm
line
513
[Wed 18 11:41:51 2006] checksetup.pl:
(
'Bugzilla::DB::Mysql=HASH(0x3e30f34)', 'bugs') called at Bugzilla/DB.pm
line
488

[Wed 18 11:41:51 2006] checksetup.pl:
Bugzilla::DB::bz_add_table('Bugz
illa::DB::Mysql=HASH(0x3e30f34)', 'bugs') called at Bugzilla/DB.pm line
335
[Wed 18 11:41:51 2006] checksetup.pl:
(
'Bugzilla::DB::Mysql=HASH(0x3e30f34)') called at Bugzilla/DB/Mysql.pm
line
453
[Wed 18 11:41:51 2006] checksetup.pl:

tabase('Bugzilla::DB::Mysql=HASH(0x3e30f34)') called at checksetup.pl
line
1601

I have been following install guide at
and everything goes
smooth
till that point.

any further ideas?
"Max Kanat-Alexander" <mkanat (AT) bugzilla (DOT) orgwrote in message
@lists.mozilla.org
Tue, 2006-10-17 at 14:48 -0500, alcon wrote:
><pre>DBD::mysql::st execute failed: Table 'bugs.bugs' doesn't exist
>[for
>Statement "SHW INDEX FRM bugs"]
>
Is this a brand-new installation?
>
If so, start over from scratch and follow the Installation and
Configuration sections of the Bugzilla Guide very carefully.
>
It's possible you forgot to give the MySQL user the correct
permissions.
>
-Max
--
Competent, Friendly Bugzilla Services. And Everything Else, too.
>

>>
>>
>

support-bugzilla mailing list
support-bugzilla (AT) lists (DOT) mozilla.org

PLEASE put support-bugzilla (AT) lists (DOT) mozilla.org in the To: field when you reply.

that worked version 4.1 did the trick. Thanks a lot.
"John Ince" <bensoni (AT) rangersuite (DOT) comwrote in message
@mozilla.org
The problem was caused by the Mysql Version 5. this needs to be version
4.1.

The problem is that in the latest version of MySql. It has different
requirements for the default settings on new fields.

uninstall version 5 and install version 4 to resolve your problems.

I hope this helps.

"John Ince" <bensoni (AT) rangersuite (DOT) comwrote in message
@mozilla.org
>,
>>
>>
>I have found that if you remove this information:
>",
>DEFAULT ="''"
>"
>>
>From these fields:
>status_whiteboard
>Keywords
>userregexp
>>
>From The Schema.pm file it gets past the first three cases of this issue
>by not setting defaults on these types of fields.
>>
>However the process then tries to modify the column "userregexp" adding
>the default back in and causing it to fail again. I'm now stuck at this
>point as i have no Perl knowledge what so ever its a bit of a search in
>the dark for me, however i think it is setting this information
>automatically and not using a schema?
>>
>HELP
>>
>"John Ince" <bensoni (AT) rangersuite (DOT) comwrote in message
>@mozilla.org
Hi,

I have found that the error is common in MySql when you set a create a
field with type NTNULL and you then set a default value.

However looking at the schema.pm file this clearly shows that it is not
trying to set a default value so this is very confusing.

status_whiteboard ={TYPE ='MEDIUMTEXT', NTNULL =1,
DEFAULT ="''"},

The only thing i can find is the suggestion that you shouldn't set a
default value to a BLB or TEXT field?

Still stuck.

<tomthi (AT) gmail (DOT) comwrote in message
news:1161195244.331992.15050 (AT) i3g2000cwc (DOT) googlegroups.com
I'm having the same exact problem, when you run the Checksetup.pl it
stops at

<h1>Software error:</h1>
<pre>DBD::mysql::st execute failed: Table 'bugs.bugs' doesn't exist
[for Statement "SHW INDEX FRM bugs"]

alcon wrote:
Well I wiped the computer, (just to make sure), reinstalled everything
and
during the second run of checksetup.pl I got the following

C:\bugzilla\bugzilla-2.22>perl checksetup.pl

Checking perl modules
Checking for AppConfig (v1.52) ok: found v1.63
Checking for CGI (v2.93) ok: found v3.20
Checking for Data::Dumper (any) ok: found v2.121_08
Checking for Date::Format (v2.21) ok: found v2.22
Checking for DBI (v1.38) ok: found v1.52
Checking for File::Spec (v0.84) ok: found v3.12
Checking for File::Temp (any) ok: found v0.16
Checking for Template (v2.08) ok: found v2.15
Checking for Text::Wrap (v2001.0131) ok: found v2005.082401
Checking for Mail::Mailer (v1.67) ok: found v1.74
Checking for MIME::Base64 (v3.01) ok: found v3.07
Checking for MIME::Tools (v5.406) ok: found v5.411
Checking for Storable (any) ok: found v2.15

The following Perl modules are optional:
Checking for GD (v1.20) ok: found v2.16
Checking for Chart::Base (v1.0) ok: found v2.3
Checking for XML::Twig (any) not found
Checking for GD::Graph (any) ok: found v1.43
Checking for GD::Text::Align (any) ok: found v1.18
Checking for PatchReader (v0.9.4) ok: found v0.9.5
Checking for Image::Magick (any) not found

All the required modules are available at:

You can add the repository with the following command:
ppm rep add bugzilla

If you want to use the bug import/export feature to move bugs to
or from other bugzilla installations, you will need to install
the XML::Twig module by running (as Administrator):

ppm install XML::Twig

If you want to convert BMP image attachments to PNG to conserve
disk space, you will need to install the ImageMagick application
Available from http://www.imagemagick.org, and the Image::Magick
Perl module by running (as Administrator):

ppm install Image::Magick

Checking user setup
Creating data directory (./data)
Creating local attachments directory
Creating graphs directory
Creating .htaccess
Creating
Creating Bugzilla/.htaccess
Creating ./data/.htaccess
Creating ./template/.htaccess
Creating ./data/webdot/.htaccess

Bugzilla requires an SMTP server to function on Windows.
Please enter your SMTP server's hostname: xxxxx.xxx
Precompiling templates
Checking for DBD::mysql (v2.9003) ok: found v3.0002
Checking for MySQL (v4.0.14) ok: found v5.0.26-community-nt

Building Schema object from database
Adding new table bz_schema
Initializing the new Schema storage
Adding new table attach_data
Adding new table attachments
Adding new table bug_group_map
Adding new table bug_severity
Adding new table bug_status
Adding new table bugs
<h1>Software error:</h1>
<pre>DBD::mysql::db do failed: BLB/TEXT column 'status_whiteboard'
can't
have a
default value at Bugzilla/DB.pm line 513

('Bugzilla::DB::Mysql=HASH(0x3e30f34)',
'
bugs') called at Bugzilla/DB.pm line 488

Bugzilla::DB::bz_add_table('Bugzilla::DB::Mysql=HA SH(0x3e30f34)',
'bugs'
) called at Bugzilla/DB.pm line 335

('Bugzilla::DB::Mysql=HASH(0x3e30f34)')
c
alled at Bugzilla/DB/Mysql.pm line 453

('Bugzilla::DB::Mysql=HASH(0x3e30f
34)') called at checksetup.pl line 1601
</pre>
<p>
For help, please send mail to this site's webmaster, giving this error
message
and the time and date of the error.

</p>
[Wed 18 11:41:51 2006] checksetup.pl: DBD::mysql::db do failed:
BLB/TEXT co
lumn 'status_whiteboard' can't have a default value at Bugzilla/DB.pm
line
513
[Wed 18 11:41:51 2006] checksetup.pl:
(
'Bugzilla::DB::Mysql=HASH(0x3e30f34)', 'bugs') called at
Bugzilla/DB.pm line
488

[Wed 18 11:41:51 2006] checksetup.pl:
Bugzilla::DB::bz_add_table('Bugz
illa::DB::Mysql=HASH(0x3e30f34)', 'bugs') called at Bugzilla/DB.pm
line 335
[Wed 18 11:41:51 2006] checksetup.pl:
(
'Bugzilla::DB::Mysql=HASH(0x3e30f34)') called at Bugzilla/DB/Mysql.pm
line
453
[Wed 18 11:41:51 2006] checksetup.pl:

tabase('Bugzilla::DB::Mysql=HASH(0x3e30f34)') called at checksetup.pl
line
1601

I have been following install guide at
and everything goes
smooth
till that point.

any further ideas?
"Max Kanat-Alexander" <mkanat (AT) bugzilla (DOT) orgwrote in message
@lists.mozilla.org
Tue, 2006-10-17 at 14:48 -0500, alcon wrote:
><pre>DBD::mysql::st execute failed: Table 'bugs.bugs' doesn't exist
>[for
>Statement "SHW INDEX FRM bugs"]
>
Is this a brand-new installation?
>
If so, start over from scratch and follow the Installation and
Configuration sections of the Bugzilla Guide very carefully.
>
It's possible you forgot to give the MySQL user the correct
permissions.
>
-Max
--
Competent, Friendly Bugzilla Services. And Everything Else, too.
>


>>
>>
>

support-bugzilla mailing list
support-bugzilla (AT) lists (DOT) mozilla.org

PLEASE put support-bugzilla (AT) lists (DOT) mozilla.org in the To: field when you reply.

I removed MySQL 5.0 and installed 4.1 and that fixed the problems.

19, 8:38 am, "John Ince" <bens (AT) rangersuite (DOT) comwrote:
The problem was caused by the Mysql Version 5. this needs to be version 4.1.

The problem is that in the latest version of MySql. It has different
requirements for the default settings on new fields.

uninstall version 5 and install version 4 to resolve your problems.

I hope this helps.

"John Ince" <bens (AT) rangersuite (DOT) comwrote in @mozilla.org

,

I have found that if you remove this information:
",
DEFAULT ="''"
"

From these fields:
status_whiteboard
Keywords
userregexp

From The Schema.pm file it gets past the first three cases of this issue
by not setting defaults on these types of fields.

However the process then tries to modify the column "userregexp" adding
the default back in and causing it to fail again. I'm now stuck at this
point as i have no Perl knowledge what so ever its a bit of a search in
the dark for me, however i think it is setting this information
automatically and not using a schema?

HELP

"John Ince" <bens (AT) rangersuite (DOT) comwrote in message
>@mozilla.org
>Hi,
>
>I have found that the error is common in MySql when you set a create a
>field with type NTNULL and you then set a default value.
>
>However looking at the schema.pm file this clearly shows that it is not
>trying to set a default value so this is very confusing.
>
>status_whiteboard ={TYPE ='MEDIUMTEXT', NTNULL =1,
>DEFAULT ="''"},
>
>The only thing i can find is the suggestion that you shouldn't set a
>default value to a BLB or TEXT field?
>
>Still stuck.
>
><tom (AT) gmail (DOT) comwrote in message
>>news:1161195244.331992.15050 (AT) i3g2000cwc (DOT) googlegroups.com
I'm having the same exact problem, when you run theChecksetup.plit
stops at

<h1>Software error:</h1>
<pre>DBD::mysql::st execute failed: Table 'bugs.bugs' doesn't exist
[for Statement "SHW INDEX FRM bugs"]

alcon wrote:
Well I wiped the computer, (just to make sure), reinstalled everything
and
during the second run ofchecksetup.pl I got the following

C:\bugzilla\bugzilla-2.22>perlchecksetup.pl

Checking perl modules
Checking for AppConfig (v1.52) ok: found v1.63
Checking for CGI (v2.93) ok: found v3.20
Checking for Data::Dumper (any) ok: found v2.121_08
Checking for Date::Format (v2.21) ok: found v2.22
Checking for DBI (v1.38) ok: found v1.52
Checking for File::Spec (v0.84) ok: found v3.12
Checking for File::Temp (any) ok: found v0.16
Checking for Template (v2.08) ok: found v2.15
Checking for Text::Wrap (v2001.0131) ok: found v2005.082401
Checking for Mail::Mailer (v1.67) ok: found v1.74
Checking for MIME::Base64 (v3.01) ok: found v3.07
Checking for MIME::Tools (v5.406) ok: found v5.411
Checking for Storable (any) ok: found v2.15

The following Perl modules are optional:
Checking for GD (v1.20) ok: found v2.16
Checking for Chart::Base (v1.0) ok: found v2.3
Checking for XML::Twig (any) not found
Checking for GD::Graph (any) ok: found v1.43
Checking for GD::Text::Align (any) ok: found v1.18
Checking for PatchReader (v0.9.4) ok: found v0.9.5
Checking for Image::Magick (any) not found

All the required modules are available at:

You can add the repository with the following command:
ppm rep add

If you want to use the bug import/export feature to move bugs to
or from other bugzilla installations, you will need to install
the XML::Twig module byrunning(as Administrator):

ppm install XML::Twig

If you want to convert BMP image attachments to PNG to conserve
disk space, you will need to install the ImageMagick application
Available fromhttp://www.imagemagick.org, and the Image::Magick
Perl module byrunning(as Administrator):

ppm install Image::Magick

Checking user setup
Creating data directory (./data)
Creating local attachments directory
Creating graphs directory
Creating .htaccess
Creating
Creating Bugzilla/.htaccess
Creating ./data/.htaccess
Creating ./template/.htaccess
Creating ./data/webdot/.htaccess

Bugzilla requires an SMTP server to function on Windows.
Please enter your SMTP server's hostname: xxxxx.xxx
Precompiling templates
Checking for DBD::mysql (v2.9003) ok: found v3.0002
Checking for MySQL (v4.0.14) ok: found v5.0.26-community-nt

Building Schema object from database
Adding new table bz_schema
Initializing the new Schema storage
Adding new table attach_data
Adding new table attachments
Adding new table bug_group_map
Adding new table bug_severity
Adding new table bug_status
Adding new table bugs
<h1>Software error:</h1>
<pre>DBD::mysql::db do failed: BLB/TEXT column 'status_whiteboard'
can't
have a
default value at Bugzilla/DB.pm line 513

('Bugzilla::DB::Mysql=HASH(0x3e30f34)',
'
bugs') called at Bugzilla/DB.pm line 488

Bugzilla::DB::bz_add_table('Bugzilla::DB::Mysql=HA SH(0x3e30f34)',
'bugs'
) called at Bugzilla/DB.pm line 335

('Bugzilla::DB::Mysql=HASH(0x3e30f34)')
c
alled at Bugzilla/DB/Mysql.pm line 453

('Bugzilla::DB::Mysql=HASH(0x3e30f
34)') called atchecksetup.plline 1601
</pre>
<p>
For help, please send mail to this site's webmaster, giving this error
message
and the time and date of the error.

</p>
[Wed 18 11:41:51 2006]checksetup.pl: DBD::mysql::db do failed:
BLB/TEXT co
lumn 'status_whiteboard' can't have a default value at Bugzilla/DB.pm
line
513
[Wed 18 11:41:51 2006]checksetup.pl:
(
'Bugzilla::DB::Mysql=HASH(0x3e30f34)', 'bugs') called at Bugzilla/DB.pm
line
488

[Wed 18 11:41:51 2006]checksetup.pl:
Bugzilla::DB::bz_add_table('Bugz
illa::DB::Mysql=HASH(0x3e30f34)', 'bugs') called at Bugzilla/DB.pm line
335
[Wed 18 11:41:51 2006]checksetup.pl:
(
'Bugzilla::DB::Mysql=HASH(0x3e30f34)') called at Bugzilla/DB/Mysql.pm
line
453
[Wed 18 11:41:51 2006]checksetup.pl:

tabase('Bugzilla::DB::Mysql=HASH(0x3e30f34)') called atchecksetup.pl
line
1601

I have been following install guide at
everything goes
smooth
till that point.

any further ideas?
"Max Kanat-Alexander" <mka (AT) bugzilla (DOT) orgwrote in message
@lists.mozilla.org
Tue, 2006-10-17 at 14:48 -0500, alcon wrote:
><pre>DBD::mysql::st execute failed: Table 'bugs.bugs' doesn't exist
>[for
>Statement "SHW INDEX FRM bugs"]
>
Is this a brand-new installation?

If so, start over from scratch and follow the Installation and
Configuration sections of the Bugzilla Guide very carefully.

It's possible you forgot to give the MySQL user the correct
permissions.

-Max
--

Competent, Friendly Bugzilla Services. And Everything Else, too.

support-bugzilla mailing list
support-bugzilla (AT) lists (DOT) mozilla.org

PLEASE put support-bugzilla (AT) lists (DOT) mozilla.org in the To: field when you reply.