Closed Bug 1571397 Opened 6 years ago Closed 2 years ago

Could not setup BugZilla

Categories

(Bugzilla :: Installation & Upgrading, defect)

Product:
Bugzilla
Component:
Installation & Upgrading
Version:
5.0.6
Type:
defect
Priority:
Not set
Severity:
normal

Tracking

()

Status:
RESOLVED DUPLICATE of bug 1576270

People

(Reporter: ragukkl01, Unassigned)

Details

User Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.131 Safari/537.36

Steps to reproduce:

To set up bugzilla, i installed MySQL-5.5.62 for Db , ActivePerl-5.16.3, Apache Web Server-2.4.39.
Setup for all the other software's was done successfully. Got an issue at final stage when running the perl checksetup.pl

Actual results:

After running perl checksetup.pl after installing all the PERL modules.
The below mentioned error popped up.

DBD::mysql::st execute failed: Table 'bugs.flags' doesn't exist [for Statement "
SHOW INDEX FROM flags"] at Bugzilla/DB/Mysql.pm line 984.
Bugzilla::DB::Mysql::bz_index_info_real(Bugzilla::DB::Mysql=HASH(0x80a93
28), "flags", "flags_bidattid_idx") called at Bugzilla/DB/Mysql.pm line 411
Bugzilla::DB::Mysql::bz_setup_database(Bugzilla::DB::Mysql=HASH(0x80a932
8)) called at checksetup.pl line 123

Expected results:

It should have run successfully without popping the error.
And i'd be able to launch BugZilla.

Along with a Warning.

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.

Is this about a new, empty installation without any previously existing database?

Or have you had an old Bugzilla database already before you installed?

Flags: needinfo?(ragukkl01)

Yes, it is a new installation without any previously existing database.
For the same, a new database was created using MySQL.

Flags: needinfo?(ragukkl01)

Please provide the steps that you performed to create a new database using MySQL.
Please provide the complete output of checksetup.pl.

Flags: needinfo?(ragukkl01)

Please find below the complete output of checksetup.pl.

C:\Bugzilla>perl checksetup.pl

  • This is Bugzilla 5.0.6 on perl 5.16.3
  • Running on Win7 Build 7601 (Service Pack 1)

Checking perl modules...
Checking for CGI.pm (v3.51) ok: found v4.30
Checking for Digest-SHA (any) ok: found v5.95
Checking for TimeDate (v2.23) ok: found v2.24
Checking for DateTime (v0.75) ok: found v1.28
Checking for DateTime-TimeZone (v1.64) ok: found v2.00
Checking for DBI (v1.614) ok: found v1.636
Checking for Template-Toolkit (v2.24) ok: found v2.26
Checking for Email-Sender (v1.300011) ok: found v1.300028
Checking for Email-MIME (v1.904) ok: found v1.937
Checking for URI (v1.55) ok: found v1.60
Checking for List-MoreUtils (v0.32) ok: found v0.415
Checking for Math-Random-ISAAC (v1.0.1) ok: found v1.004
Checking for JSON-XS (v2.01) ok: found v2.34
Checking for Win32 (v0.35) ok: found v0.48
Checking for Win32-API (v0.55) ok: found v0.75
Checking for DateTime-TimeZone-Local-Win32 (v1.64) ok: found v1.88

Checking available perl DBD modules...
Checking for DBD-Pg (v2.7.0) ok: found v2.19.3
Checking for DBD-mysql (v4.001) ok: found v4.033
Checking for DBD-SQLite (v1.29) ok: found v1.48
Checking for DBD-Oracle (v1.19) ok: found v1.74

The following Perl modules are optional:
Checking for GD (v1.20) ok: found v2.50
Checking for Chart (v2.4.1) ok: found v2.4.10
Checking for Template-GD (any) not found
Checking for GDTextUtil (any) ok: found v0.86
Checking for GDGraph (any) ok: found v1.52
Checking for MIME-tools (v5.406) not found
Checking for libwww-perl (any) ok: found v6.15
Checking for XML-Twig (any) not found
Checking for PatchReader (v0.9.6) ok: found v0.9.6
Checking for perl-ldap (any) ok: found v0.65
Checking for Authen-SASL (any) ok: found v2.16
Checking for Net-SMTP-SSL (v1.01) not found
Checking for RadiusPerl (any) not found
Checking for SOAP-Lite (v0.712) not found
Checking for XMLRPC-Lite (v0.712) not found
Checking for JSON-RPC (any) not found
Checking for Test-Taint (v1.06) not found
Checking for HTML-Parser (v3.67) ok: found v3.72
Checking for HTML-Scrubber (any) not found
Checking for Encode (v2.21) ok: found v2.84
Checking for Encode-Detect (any) not found
Checking for Email-Reply (any) not found
Checking for HTML-FormatText-WithLinks (v0.13) not found
Checking for TheSchwartz (v1.07) not found
Checking for Daemon-Generic (any) not found
Checking for mod_perl (v1.999022) not found
Checking for Apache-SizeLimit (v0.96) not found
Checking for File-MimeInfo (any) not found
Checking for IO-stringy (any) not found
Checking for Cache-Memcached (any) not found
Checking for File-Copy-Recursive (any) ok: found v0.38
Checking for File-Which (any) ok: found v1.21

  • OPTIONAL MODULES *
  • Certain Perl modules are not required by Bugzilla, but by *
  • installing the latest version you gain access to additional *
  • features. *
  •                                                                 *
  • The optional modules you do not have installed are listed below, *
  • with the name of the feature they enable. Below that table are the *
  • commands to install each module. *
  •           MODULE NAME * ENABLES FEATURE(S)                      *

  •           Template-GD * Graphical Reports                       *

  •            MIME-tools * Move Bugs Between Installations         *

  •              XML-Twig * Move Bugs Between Installations, Automatic Update

Notifications *

  •          Net-SMTP-SSL * SSL Support for SMTP                    *

  •            RadiusPerl * RADIUS Authentication                   *

  •             SOAP-Lite * XML-RPC Interface                       *

  •           XMLRPC-Lite * XML-RPC Interface                       *

  •              JSON-RPC * JSON-RPC Interface, REST Interface      *

  •            Test-Taint * JSON-RPC Interface, XML-RPC Interface, REST Interf

ace *

  •         HTML-Scrubber * More HTML in Product/Group Descriptions *

  •         Encode-Detect * Automatic charset detection for text attachments *

  •           Email-Reply * Inbound Email                           *

  • HTML-FormatText-WithLinks * Inbound Email *

  •           TheSchwartz * Mail Queueing                           *

  •        Daemon-Generic * Mail Queueing                           *

  •              mod_perl * mod_perl                                *

  •      Apache-SizeLimit * mod_perl                                *

  •         File-MimeInfo * Sniff MIME type of attachments          *

  •            IO-stringy * Sniff MIME type of attachments          *

  •       Cache-Memcached * Memcached Support                       *

COMMANDS TO INSTALL OPTIONAL MODULES:

Template-GD: ppm install Template-GD
 MIME-tools: ppm install MIME-tools
   XML-Twig: ppm install XML-Twig

Net-SMTP-SSL: ppm install Net-SMTP-SSL
RadiusPerl: ppm install RadiusPerl
SOAP-Lite: ppm install SOAP-Lite
XMLRPC-Lite: ppm install XMLRPC-Lite
JSON-RPC: ppm install JSON-RPC
Test-Taint: ppm install Test-Taint
HTML-Scrubber: ppm install HTML-Scrubber
Encode-Detect: ppm install Encode-Detect
Email-Reply: ppm install Email-Reply
HTML-FormatText-WithLinks: ppm install HTML-FormatText-WithLinks
TheSchwartz: ppm install TheSchwartz
Daemon-Generic: ppm install Daemon-Generic
mod_perl: ppm install mod_perl
Apache-SizeLimit: ppm install Apache-SizeLimit
File-MimeInfo: ppm install File-MimeInfo
IO-stringy: ppm install IO-stringy
Cache-Memcached: ppm install Cache-Memcached

Reading ./localconfig...

OPTIONAL NOTE: If you want to be able to use the 'difference between two
patches' feature of Bugzilla (which requires the PatchReader Perl module
as well), you should install patchutils from:

http://cyberelk.net/tim/software/patchutils/

Checking for DBD-mysql (v4.001) ok: found v4.033
Checking for MySQL (v5.0.15) ok: found v5.5.62

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.

DBD::mysql::st execute failed: Table 'bugs.flags' doesn't exist [for Statement "
SHOW INDEX FROM flags"] at Bugzilla/DB/Mysql.pm line 984.
Bugzilla::DB::Mysql::bz_index_info_real(Bugzilla::DB::Mysql=HASH(0x80a93
28), "flags", "flags_bidattid_idx") called at Bugzilla/DB/Mysql.pm line 411
Bugzilla::DB::Mysql::bz_setup_database(Bugzilla::DB::Mysql=HASH(0x80a932
8)) called at checksetup.pl line 123

Flags: needinfo?(ragukkl01)

Also, for the setting up of MySQL -

  1. Installed MySQL-5.5.62, created a database 'bugs', with user 'bugs'.
  2. Installed all the required PERL modules for MySQL.
  3. Set up of Apache Web Server with the localhost.
  4. Installed all the remaining PERL modules at "C:\Bugzilla>" by running checksetup.pl.
    After that, the error pops up.

Any updates on the above mentioned ??

The problem is that you are running MySQL 5.5, which doesn't support fulltext for innodb tables. MySQL 5.6 or 5.7 is required. This is due to a DB schema change which has been committed to 5.0.6 despite this was not supposed to happen. You should install Bugzilla 5.0.4 instead.

Marking your bug as a duplicate of bug 1576270, despite your bug is older.

Assignee: general → installation
Status: UNCONFIRMED → RESOLVED
Closed: 2 years ago
Component: Bugzilla-General → Installation & Upgrading
Duplicate of bug: 1576270
Resolution: --- → DUPLICATE
Version: 5.0.4 → 5.0.6
You need to log in before you can comment on or make changes to this bug.