安装bugzilla无法创建管理员

persister · 发表于 2007-3-13 11:27:35

DBD::mysql::db do failed: Field 'disabledtext' doesn't have a default value at D
:\bugzilla\checksetup.pl line 4542, <STDIN> chunk 5.
Use of uninitialized value in concatenation (.) or string at D:\bugzilla\checkse
tup.pl line 4554, <STDIN> chunk 5.
Use of uninitialized value in concatenation (.) or string at D:\bugzilla\checkse
tup.pl line 4554, <STDIN> chunk 5.
DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to use near
' , 0, 0)' at line 3 at D:\bugzilla\checksetup.pl line 4554, <STDIN> chunk 5.
Use of uninitialized value in concatenation (.) or string at D:\bugzilla\checkse
tup.pl line 4557, <STDIN> chunk 5.
Use of uninitialized value in concatenation (.) or string at D:\bugzilla\checkse
tup.pl line 4557, <STDIN> chunk 5.
DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to use near
' , 1, 0)' at line 3 at D:\bugzilla\checksetup.pl line 4557, <STDIN> chunk 5.

'yangliang@mail.xls.com.cn' is now set up as an administrator account.
Updating field type short_desc in table bugs ...
old: mediumtext
new: mediumtext not null
No administrator! at D:\bugzilla\checksetup.pl line 4702, <STDIN> chunk 5.

新手真诚求教，希望大家不吝赐教，谢谢了！

[ 本帖最后由 persister 于 2007-3-13 11:47 编辑 ]

sunxy5291 · 发表于 2007-3-13 15:55:09

我也遇到过
因为这个工具很麻烦
期待学习

persister · 发表于 2007-3-13 16:14:00

请问你是怎么解决的？谢谢了

interstellar · 发表于 2007-3-13 17:16:25

Bugzilla的配置确实是比较复杂的过程，中间会碰到各种问题。
你这样的问题描述，别人更难帮你。

persister · 发表于 2007-3-13 17:39:22

哦，可能是我没说清楚，我在执行checksetup.pl时，如下：

D:\bugzilla>checksetup.pl

Checking perl modules ...
Checking for    AppConfig (v1.52) ok: found v1.55
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.36) ok: found v1.52
Checking for    DBD::mysql (v2.1010) ok: found v2.9004
Checking for    File::Spec (v0.82) ok: found v3.12
Checking for    File::Temp (any)    ok: found v0.16
Checking for       Template (v2.08) ok: found v2.13
Checking for    Text::Wrap (v2001.0131) ok: found v2005.082401

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::Parser (any)    ok: found v2.34
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 HTML::Parser (v3.40) ok: found v3.56
Checking for  HTML::Scrubber (any)    not found

All the required modules are available at:
http://landfill.bugzilla.org/ppm/
You can add the repository with the following command:
ppm rep add bugzilla http://landfill.bugzilla.org/ppm/

If you want additional HTML tags within product and group descriptions,
you should install:
HTML::Scrubber: ppm install HTML::Scrubber

Checking user setup ...
Removing existing compiled templates ...
Precompiling templates ...
Checking for MySQL Server (v3.23.41) ok: found v5.0.19-nt-max

Updating field type target_milestone in table bugs ...
old: varchar(20) default "---"
new: varchar(20) not null default "---"
Updating field type value in table milestones ...
old: varchar(20)
new: varchar(20) not null
new: varchar(64) not null
Updating field type disabledtext in table profiles ...
old: mediumtext
new: mediumtext not null
Adding group tweakparams ...
DBD::mysql::st execute failed: Field 'last_changed' doesn't have a default value
at D:\bugzilla\checksetup.pl line 2115.
Adding group editusers ...
DBD::mysql::st execute failed: Field 'last_changed' doesn't have a default value
at D:\bugzilla\checksetup.pl line 2115.
Adding group creategroups ...
DBD::mysql::st execute failed: Field 'last_changed' doesn't have a default value
at D:\bugzilla\checksetup.pl line 2115.
Adding group editcomponents ...
DBD::mysql::st execute failed: Field 'last_changed' doesn't have a default value
at D:\bugzilla\checksetup.pl line 2115.
Adding group editkeywords ...
DBD::mysql::st execute failed: Field 'last_changed' doesn't have a default value
at D:\bugzilla\checksetup.pl line 2115.
Adding group admin ...
DBD::mysql::st execute failed: Field 'last_changed' doesn't have a default value
at D:\bugzilla\checksetup.pl line 2115.
Adding group editbugs ...
DBD::mysql::st execute failed: Field 'last_changed' doesn't have a default value
at D:\bugzilla\checksetup.pl line 2115.
Adding group canconfirm ...
DBD::mysql::st execute failed: Field 'last_changed' doesn't have a default value
at D:\bugzilla\checksetup.pl line 2115.

Looks like we don't have an administrator set up yet.  Either this is your
first time using Bugzilla, or your administrator's privileges might have acciden
tly
been deleted.
Enter the e-mail address of the administrator: xxxx@mail.xxxxi.com
You entered 'xxxx@mail.xxxx.com'.  Is this correct? [Y/n] Y
Enter the real name of the administrator: xxxxx
Enter a password for the administrator account: 123456

Please retype the password to verify: 123456
DBD::mysql::db do failed: Field 'disabledtext' doesn't have a default value at D
:\bugzilla\checksetup.pl line 4542, <STDIN> chunk 5.
Use of uninitialized value in concatenation (.) or string at D:\bugzilla\checkse
tup.pl line 4554, <STDIN> chunk 5.
Use of uninitialized value in concatenation (.) or string at D:\bugzilla\checkse
tup.pl line 4554, <STDIN> chunk 5.
DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to use near
' , 0, 0)' at line 3 at D:\bugzilla\checksetup.pl line 4554, <STDIN> chunk 5.
Use of uninitialized value in concatenation (.) or string at D:\bugzilla\checkse
tup.pl line 4557, <STDIN> chunk 5.
Use of uninitialized value in concatenation (.) or string at D:\bugzilla\checkse
tup.pl line 4557, <STDIN> chunk 5.
DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to use near
' , 1, 0)' at line 3 at D:\bugzilla\checksetup.pl line 4557, <STDIN> chunk 5.

'xxxxx@mail.xxxx.com' is now set up as an administrator account.
Updating field type short_desc in table bugs ...
old: mediumtext
new: mediumtext not null
No administrator! at D:\bugzilla\checksetup.pl line 4702, <STDIN> chunk 5.

从上面的报错可以看出，是数据库执行的时候的问题，可是我就是不明白，这个怎么会出错呢
是checksetup.pl文件本身就错了吗？现在我也不敢乱改，请问各位高手有没有碰到类似的问题
帮帮我，谢谢了，很急！

[ 本帖最后由 persister 于 2007-3-13 17:49 编辑 ]

zhangtao · 发表于 2007-3-13 18:04:58

你可以上网上找找安装bugzilla的帮助的文档，以前用过！

dionysus · 发表于 2007-3-13 21:09:35

你的数据库没有安装好吧？或者没有安装好与数据库的连接组件

liuhaoyutz · 发表于 2007-4-2 21:45:23

请教:
我在Precompiling templates ...时出现率Segmentation fault错误,为什么啊,请高手指教!!谢了!!

[root@localhost bugzilla-2.18.6]# vi localconfig
[root@localhost bugzilla-2.18.6]# ./checksetup.pl

Checking perl modules ...
Checking for    AppConfig (v1.52) ok: found v1.64
Checking for          CGI (v2.93) ok: found v3.28
Checking for Data::Dumper (any)    ok: found v2.12
Checking for Date::Format (v2.21) ok: found v2.22
Checking for          DBI (v1.36) ok: found v1.54
Checking for    DBD::mysql (v2.1010) ok: found v2.9003
Checking for    File::Spec (v0.82) ok: found v3.24
Checking for    File::Temp (any)    ok: found v0.13
Checking for       Template (v2.08) ok: found v2.08
Checking for    Text::Wrap (v2001.0131) ok: found v2001.0929

The following Perl modules are optional:
Checking for             GD (v1.20) ok: found v1.20
Checking for    Chart::Base (v1.0) ok: found v2.1
Checking for    XML::Parser (any)    ok: found v2.31
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.4
Checking for HTML::Parser (v3.40) found v3.26
Checking for  HTML::Scrubber (any)    ok: found v0.08

If you want additional HTML tags within product and group descriptions,
you should install:
HTML::Parser: /usr/bin/perl -MCPAN -e 'install "HTML::Parser"'

Checking user setup ...
Removing existing compiled templates ...
Precompiling templates ...
Segmentation fault
[root@localhost bugzilla-2.18.6]#
[root@localhost bugzilla-2.18.6]#

chengmoys · 发表于 2010-6-22 13:29:35

这个，你是已经创建过bugzilla管理员之后，想换新的管理员吗？

chengmoys · 发表于 2010-6-23 15:29:40

[root@localhost bugzilla]# ./checksetup.pl
* This is Bugzilla 3.2.3 on perl 5.10.0
* Running on Linux 2.6.27.41-170.2.117_ND5_1.i686 #1 SMP Wed Dec 23 10:31:48 CST 2009

Checking perl modules...
Checking for             CGI.pm (v3.33) ok: found v3.43
Checking for          TimeDate (v2.21) ok: found v2.22
Checking for          PathTools (v0.84) ok: found v3.3
Checking for                DBI (v1.41) ok: found v1.607
Checking for Template-Toolkit (v2.15) ok: found v2.19
Checking for       Email-Send (v2.00) ok: found v2.192
Checking for       Email-MIME (v1.861)  ok: found v1.861
Checking for Email-MIME-Modifier (v1.442)  ok: found v1.442

Checking available perl DBD modules...
Checking for             DBD-Pg (v1.45) not found
Checking for          DBD-mysql (v4.00) ok: found v4.005
Checking for       DBD-Oracle (v1.19) not found

The following Perl modules are optional:
Checking for                GD (v1.20) ok: found v2.45
Checking for             Chart (v1.0) ok: found v2.4.1
Checking for       Template-GD (any)    ok: found v1.56
Checking for       GDTextUtil (any)    ok: found v0.86
Checking for          GDGraph (any)    ok: found v1.44
Checking for          XML-Twig (any)    ok: found v3.32
Checking for       MIME-tools (v5.406)  ok: found v5.427
Checking for       libwww-perl (any)    ok: found v5.823
Checking for       PatchReader (v0.9.4)  ok: found v0.9.5
Checking for       PerlMagick (any)    ok: found v6.5.4
Checking for          perl-ldap (any)    ok: found v0.34
Checking for       Authen-SASL (any)    ok: found v2.15
Checking for       RadiusPerl (any)    ok: found v0.17
Checking for          SOAP-Lite (any)    ok: found v0.710.07
Checking for       HTML-Parser (v3.40) ok: found v3.59
Checking for    HTML-Scrubber (any)    ok: found v0.08
Checking for Email-MIME-Attachment-Stripper (any)    ok: found v1.314
Checking for       Email-Reply (any)    ok: found v1.202
Checking for          mod_perl (v1.999022) ok: found v2.000004
Reading /etc/bugzilla/localconfig...
Checking for          DBD-mysql (v4.00) ok: found v4.005
Checking for          MySQL (v4.1.2)  ok: found v5.0.88

WARNING: You need to set the max_allowed_packet parameter in your MySQL
configuration to at least 3276750. Currently it is set to 1048576.
You can set this parameter in the [mysqld] section of your MySQL
configuration file.

Removing existing compiled templates...
Precompiling templates...done.
Fixing file permissions...

我上面执行的跟你的差不多。

		自动登录	找回密码
密码			(注-册)加入51Testing

[原创] 安装bugzilla无法创建管理员

相关帖子

回复 #3 sunxy5291 的帖子

你这样的问题描述，别人很难帮你。

回复 #5 interstellar 的帖子

管理员好象是在装数据库时设置的

站长推荐 /1