Closed Bug 362195 Opened 19 years ago Closed 19 years ago

DBD::mysql::db do failed: BLOB/TEXT column 'userregexp' can't have a default value at Bugzilla/DB.pm line 514

Categories

(Bugzilla :: Installation & Upgrading, defect)

Product:
Bugzilla
Component:
Installation & Upgrading
Platform:
x86
Linux
Type:
defect
Priority:
Not set
Severity:
normal

Tracking

()

Status:
RESOLVED DUPLICATE of bug 321645

People

(Reporter: mmokrejs, Unassigned)

Details

Attachments

(1 file)

mysqldump
27.21 KB, text/plain
Details
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.13) Gecko/20060426 Build Identifier: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.13) Gecko/20060426 Hi, I am a bit big mess. I used to have 2.19.3 which worked fine unless I have happened to include a text bug including some char which was UTF8. Then subbmitting the bug broke. OK, I went to test 2.20.3 and I don't have the error message handy anymore, but the checksetup.pl failed. I tried 2.22.1 and I still got a problem. No I have even 2.23.3 and decided to report: # ./checksetup.pl --verbose * This is Bugzilla 2.23.3 on perl 5.8.8 * Running on Linux 2.6.18.1 #1 PREEMPT Mon Oct 16 22:51:11 CEST 2006 Checking perl modules... Checking for CGI (v2.93) ok: found v3.25 Checking for Date::Format (v2.21) ok: found v2.22 Checking for DBI (v1.41) ok: found v1.53 Checking for File::Spec (v0.84) ok: found v3.23 Checking for Template (v2.12) ok: found v2.15 Checking for Mail::Mailer (v1.67) ok: found v1.74 Checking for MIME::Base64 (v3.01) ok: found v3.07 Checking for MIME::Parser (v5.406) ok: found v5.420 You need one of the following DBD modules installed, depending on which database you are using with Bugzilla: Checking for DBD::Pg (v1.45) not found Checking for DBD::mysql (v2.9003) ok: found v3.0008 The following Perl modules are optional: Checking for GD (v1.20) ok: found v2.35 Checking for Template::Plugin::GD::Image (any) ok: found v1.56 Checking for Chart::Base (v1.0) ok: found v2.3 Checking for GD::Graph (any) ok: found v1.4308 Checking for GD::Text::Align (any) ok: found v1.18 Checking for XML::Twig (any) ok: found v3.26 Checking for LWP::UserAgent (any) ok: found v2.033 Checking for PatchReader (v0.9.4) ok: found v0.9.5 Checking for Image::Magick (any) not found Checking for Net::LDAP (any) ok: found v0.33 Checking for SOAP::Lite (any) ok: found v0.67 Checking for HTML::Parser (v3.40) ok: found v3.55 Checking for HTML::Scrubber (any) ok: found v0.08 The following modules are required for mod_perl support: Checking for mod_perl2 (v1.999022) ok: found v2.000002 Checking for CGI (v3.11) ok: found v3.25 Checking for Apache::DBI (v0.96) ok: found v1.05 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 root): /usr/bin/perl5.8.8 -MCPAN -e 'install "Image::Magick"' Reading ./localconfig... Checking for DBD::mysql (v2.9003) ok: found v3.0008 Checking for MySQL (v4.0.14) ok: found v5.0.26-log Adding new table component_cc ... Adding new table namedqueries_link_in_footer ... Adding new table namedquery_group_map ... Updating old chart storage format... Creating ./extensions directory... Creating graphs directory... Creating skins/contrib directory... Creating skins/custom directory... Creating skins/custom/admin.css... Creating skins/custom/buglist.css... Creating skins/custom/create_attachment.css... Creating skins/custom/dependency-tree.css... Creating skins/custom/duplicates.css... Creating skins/custom/editusers.css... Creating skins/custom/global.css... Creating skins/custom/index.css... Creating skins/custom/panel.css... Creating skins/custom/params.css... Creating skins/custom/show_bug.css... Creating skins/custom/show_multiple.css... Creating skins/custom/summarize-time.css... Creating skins/custom/voting.css... Removing versioncache... Creating ./Bugzilla/.htaccess... Creating ./template/.htaccess... Creating .htaccess... New parameter: allow_attachment_deletion New parameter: allow_attach_url New parameter: convert_uncompressed_images New parameter: docs_urlbase New parameter: utf8 New parameter: announcehtml New parameter: upgrade_notification New parameter: querysharegroup New parameter: strict_isolation New parameter: LDAPstarttls New parameter: quicksearch_comment_cutoff The following parameters are no longer used in Bugzilla, and so have been moved from your parameters file into old-params.txt: browserbugmessage, voteremovedmail, whinemail, passwordmail, newchangedmail Removing existing compiled templates ... Precompiling templates... Fixing file permissions... Adding new column 'type' to the 'fielddefs' table... Adding new column 'custom' to the 'fielddefs' table... Adding new column 'enter_bug' to the 'fielddefs' table... Renaming column 'fielddefs.fieldid' to 'fielddefs.id'... Updating column creator in table series ... Old: mediumint NOT NULL New: mediumint Updating column userregexp in table groups ... Old: tinytext NOT NULL New: tinytext DEFAULT '' NOT NULL DBD::mysql::db do failed: BLOB/TEXT column 'userregexp' can't have a default value at Bugzilla/DB.pm line 514 Bugzilla::DB::bz_alter_column_raw('Bugzilla::DB::Mysql=HASH(0x9666a8c)', 'groups', 'userregexp', 'HASH(0x9d0f540)', 'HASH(0x9816ef0)', 'undef') called at Bugzilla/DB.pm line 473 Bugzilla::DB::bz_alter_column('Bugzilla::DB::Mysql=HASH(0x9666a8c)', 'groups', 'userregexp', 'HASH(0x9d0f540)') called at Bugzilla/Install/DB.pm line 436 Bugzilla::Install::DB::update_table_definitions() called at ./checksetup.pl line 211 # Reproducible: Always
Attached file mysqldump —
Mysql database contents after partially processed checksetup.pl. Why does bugzilla not use transcactions to ROLLBACK when the checksetup.pl breaks? 3690 Query UPDATE series SET creator = NULL WHERE creator = 0 3690 Query SELECT 1 FROM series LIMIT 1 3690 Query SELECT id FROM groups where name = '' 3690 Query SELECT COUNT(*) FROM email_setting WHERE event = 9 3690 Query DESCRIBE `quips` 3690 Query SELECT series_id, query FROM series WHERE query LIKE 'field0-0-0=resolution&type0-0-0=notequals&value0-0-0=---%' 3690 Query DELETE FROM user_group_map WHERE grant_type = 1 3690 Query ALTER TABLE groups CHANGE COLUMN userregexp userregexp tinytext DEFAULT '' NOT NULL 3690 Quit
OK, I fix that problem for my with ALTER TABLE groups CHANGE COLUMN userregexp userregexp char(10) DEFAULT "" NOT NULL;
*** This bug has been marked as a duplicate of 321645 ***
Status: UNCONFIRMED → RESOLVED
Closed: 19 years ago
Resolution: --- → DUPLICATE
You need to log in before you can comment on or make changes to this bug.

Attachment

General

Creator:
Created:
Updated:
Size: