Installation Issue on Windows 10

[sake...@gmail.com]

Hi,

I have tried to install the Bugzilla-5.0.4 version in my Windows 10 OS system.

Also, I have installed MySQL 8.0 version along to maintain the all Bug data assets. I have installed all plugin which were not install.

I have provided all database configuration in localconfig file.





But i am facing issue while running checksetup.pl command .
Few last lines taken from the CMD window while executing below command.

c:\Bugzilla>perl checksetup.pl
* This is Bugzilla 5.0.4 on perl 5.24.3
* Running on Win10 Build 17134
.
.
.
.
.
.
.
.

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

Adding new table groups...
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 'groups (
id mediumint auto_increment PRIMARY KEY NOT NULL,
name varchar(255) N' at line 1 [for Statement "CREATE TABLE groups (
id mediumint auto_increment PRIMARY KEY NOT NULL,
name varchar(255) NOT NULL,
description mediumtext NOT NULL,
isbuggroup tinyint NOT NULL,
userregexp tinytext DEFAULT '' NOT NULL,
isactive tinyint DEFAULT 1 NOT NULL,
icon_url tinytext
) ENGINE = InnoDB CHARACTER SET utf8"] at Bugzilla/DB.pm line 837.
Bugzilla::DB::_bz_add_table_raw(Bugzilla::DB::Mysql=HASH(0x913ec90), "groups", HASH(0x94cf7c8)) called at Bugzilla/DB.pm line 796
Bugzilla::DB::bz_add_table(Bugzilla::DB::Mysql=HASH(0x913ec90), "groups", HASH(0x94cf7c8)) called at Bugzilla/DB.pm line 509
Bugzilla::DB::bz_setup_database(Bugzilla::DB::Mysql=HASH(0x913ec90)) called at Bugzilla/DB/Mysql.pm line 558
Bugzilla::DB::Mysql::bz_setup_database(Bugzilla::DB::Mysql=HASH(0x913ec90)) called at checksetup.pl line 121





I really appreciate your help.
Thank you.

[Akshay S Dinesh]

It is a bug because of changes in MySQL. Already been reported upstream:
https://bugzilla.mozilla.org/show_bug.cgi?id=1424043

> _______________________________________________
> community-india mailing list
> communi...@lists.mozilla.org
> https://lists.mozilla.org/listinfo/community-india
>

[DILIP KUMAR]

Thanks I have now installed the MySQL 5.0.7 version which now works fine.

I could see 'checksetup.pl complete.' message in Command Prompt.

But again due to some reason it is still show below error.:


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


Though, the could able to see params.json file is present in same location(Bugzilla >> data>> params.json).

Please help.

[Akshay S Dinesh]

Please make sure you're following all the instructions at
https://bugzilla.readthedocs.io/en/latest/installing/windows.html

I do not think Windows is a preferred OS for bugzilla. Neither do I have a
Windows installation. So, if the error persists all the suggestions I can
give you would be to either dig in the code and figure out what is causing
the error or switch to a GNU/Linux OS and try again.

If you do find a bug in the code and want help to get it fixed in upstream
bugzilla code, do reach out (to me or to #bugzilla channel on
irc.mozilla.org)
https://www.bugzilla.org/developers/

Akshay

https://mozillians.org/u/asdofindia