[EXT] Re: Bugzilla

[John Claessen]

Emmanuel,

I made a backup of  the database, copied it over to the new server, and
imported it. Changed the necessary variables in the localconfig file. If I
run checksetup.pl I get the below error. I'am using version 5.0.6 of
Bugzilla. Any idea on how to fix this. 

Bugzilla now uses the InnoDB storage engine in MySQL for most tables.
Converting tables to InnoDB:
Converting 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 ENGINE = InnoDB' at line 1
[for Statement "ALTER TABLE groups ENGINE = InnoDB"] at Bugzilla/DB/Mysql.pm
line 391, <DATA> line 747.
 
Bugzilla::DB::Mysql::bz_setup_database('Bugzilla::DB::Mysql=HASH(0x1f65070)'
) called at ./checksetup.pl line 123

Regards,

John Claessen

NXP Semiconductors 
High Tech Campus 60
5656 AG Eindhoven
The Netherlands
Mobile: +31 6 1212 8822
Email: John.Claessen at nxp.com	



-----Original Message-----
From: support-list <support-list-bounces at bugzilla.org> On Behalf Of Emmanuel
Seyman
Sent: Wednesday, May 12, 2021 3:48 PM
To: support-list at bugzilla.org
Subject: Re: [EXT] Re: Bugzilla

Caution: EXT Email

* John Claessen [12/05/2021 11:50] :
>
> In the Bugzilla/Config.pm File I find $Bugzilla::Config::VERSION = 
> "2.21.1++mspd", this seems to be a development snapshot version, does 
> this mean I first need to upgrade to version Bugzilla 2.22.7 and from 
> there on follow the instruction in the link below?

'2.21.1+' sounds like a snapshot of 2.21.1 with a number of changes added to
it. I have no idea what '+mspd' means.

FTR, your database schema should look like this:
https://eur01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fschema.seym
an.fr%2Fbugzilla%2Fschema%3Faction%3Dsingle%26version%3D2.21.1%26view%3DView
%2Bschema&data=04%7C01%7Cjohn.claessen%40nxp.com%7C4d8b846ad140490c24910
8d9154c9e35%7C686ea1d3bc2b4c6fa92cd99c5c301635%7C0%7C1%7C637564241078952445%
7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwi
LCJXVCI6Mn0%3D%7C2000&sdata=SArsZHgk%2BQlCLnV9Q%2BOx%2BaJIPG2G4IJbZ7tUPS
vxWdE%3D&reserved=0

There shouldn't be any need to update to an intermediary version.
Whatever version you install will update the database schema to match.

While I'm at it, this might interest you:
https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fblog.fedor
a-fr.org%2Feseyman%2Fpost%2FInstalling-Bugzilla-on-RHEL%2FCentos-7.x&dat
a=04%7C01%7Cjohn.claessen%40nxp.com%7C4d8b846ad140490c249108d9154c9e35%7C686
ea1d3bc2b4c6fa92cd99c5c301635%7C0%7C1%7C637564241078952445%7CUnknown%7CTWFpb
GZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C
2000&sdata=YxBGknNJMiipvRcji2qx%2FlPz45vXLTuRerzWlPWjEfQ%3D&reserved
=0

Emmanuel
_______________________________________________
support-list mailing list
support-list at bugzilla.org
https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.bugz
illa.org%2Flistinfo%2Fsupport-list&data=04%7C01%7Cjohn.claessen%40nxp.co
m%7C4d8b846ad140490c249108d9154c9e35%7C686ea1d3bc2b4c6fa92cd99c5c301635%7C0%
7C1%7C637564241078952445%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjo
iV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000&sdata=9MtA5iL5BQ%2BNZWvhO
Q8rTDIVDqspal5uHrEcL2dJJJM%3D&reserved=0
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 9583 bytes
Desc: not available
URL: <http://lists.bugzilla.org/pipermail/support-list/attachments/20210528/1ffd1dbc/attachment.p7s>