Running checksetup.pl ends with error: DBD::mysql::st execute failed: Table 'bugs.flags' doesn't exist [for Statement "SHOW INDEX FROM flags"] at Bugzilla/DB/Mysql.pm line 984.

[laxmi...@gmail.com]

I'm installing bugzilla for the first time and it's NOT about migrating old bugzilla version to new version. It's a brand new bugzilla 5.0.6 version that i'm trying to setup.

I installed bugzilla, apache web server and MY SQL DB on windows machine. When i access http://localhost/bugzilla/ i get below error on webpage:

----------------------------
Software error:
The ./data/params.json file does not exist. You probably need to run checksetup.pl. at Bugzilla/Config.pm line 341.
Compilation failed in require at C:/bugzilla/index.cgi line 15.
BEGIN failed--compilation aborted at C:/bugzilla/index.cgi line 15.
------------------------------

When i run checksetup.pl fron C:\bugzilla folder , i end up with below error:

--------------------------------
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(0x9587ff0), "flags", "flags_bidattid_idx") called at Bugzilla/DB/Mysql.pm line 411
Bugzilla::DB::Mysql::bz_setup_database(Bugzilla::DB::Mysql=HASH(0x9587ff0)) called at C:\bugzilla\checksetup.pl line 123

---------------------------------

When i check 'bugs' DB in mysql DB, following tables got created. i DON'T SEE any 'flags' table there.

Tables created:
-----------------
attach_data
attachments
AUDIT_LOG
bug_group_map
bug)see_also
bug_severity
bug_status
bug_tag
bug_user_last_visit
bugs
bugs_activity
bugs_aliases
bugs_fulltext
bz_schema

------------------

I'm stuck in this step for almost two days. Not progressing anywhere. No much info on the above error and solution to it in previous posts.

Can someone help me how to fix this error and setup bugzilla successfully.

Thanks very much for the help.

[Emmanuel]

* laxmi...@gmail.com [24/12/2019 00:36] :

>
> 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(0x9587ff0), "flags", "flags_bidattid_idx") called at Bugzilla/DB/Mysql.pm line 411
> Bugzilla::DB::Mysql::bz_setup_database(Bugzilla::DB::Mysql=HASH(0x9587ff0)) called at C:\bugzilla\checksetup.pl line 123

I suspect this is due to the fact that the version of MySQL you're using is
newer than what Bugzilla 5.0.6 supports.

> When i check 'bugs' DB in mysql DB, following tables got created. i DON'T SEE any 'flags' table there.

FTR, the list of tables that Bugzilla 5.0.6 creates is here:
http://schema.seyman.fr/bugzilla/schema?action=single&version=5.0.6&view=View+schema

Emmanuel

[Thorsten Schöning]

Guten Tag laxmi...@gmail.com,
am Dienstag, 24. Dezember 2019 um 09:36 schrieben Sie:

> DBD::mysql::st execute failed: Table 'bugs.flags' doesn't exist
> [for Statement "SHOW INDEX FROM flags"] at Bugzilla/DB/Mysql.pm line 984.

In contrast to what Emmanuel said, your version of MySQL/MariaDB might
be too old as well. You need at least 5.6, which supports FULLTEXT
INDEX for tables using InnoDB, which is the default these days by
Bugzilla.

https://dev.mysql.com/doc/refman/5.6/en/innodb-fulltext-index.html

If you search the list for the following error, you will find a lot of
hints to too old or too new versions of MySQL or MariaDB.

> DBD::mysql::st execute failed: Table 'bugs.flags' doesn't exist

> https://www.google.de/search?client=opera&q=bugzilla+"DBD%3A%3Amysql%3A%3Ast+execute+failed%3A+Table+%27bugs.flags%27+doesn%27t+exist"&sourceid=opera&ie=UTF-8&oe=UTF-8

Mit freundlichen Grüßen,

Thorsten Schöning

--
Thorsten Schöning E-Mail: Thorsten....@AM-SoFT.de
AM-SoFT IT-Systeme http://www.AM-SoFT.de/

Telefon...........05151- 9468- 55
Fax...............05151- 9468- 88
Mobil..............0178-8 9468- 04

AM-SoFT GmbH IT-Systeme, Brandenburger Str. 7c, 31789 Hameln
AG Hannover HRB 207 694 - Geschäftsführer: Andreas Muchow

[laxmi...@gmail.com]

Thanks for the replies. After upgrading MySQL DB from 5.5 to 5.7.8 version fixed the issue. I'm able to setup bugzilla successfully.