Error generated when attempting to create a new bug in Bugzilla 5.2

[David Miller]

That sounds like checksetup.pl didn't finish.  The table it's flagging 
is one that gets modified by the upgrade script between 5.0.6 and 5.2. 
Did checksetup.pl give you any errors when you upgraded?

On 12/18/24 8:42 AM, Hunt, Ron (PERATON) wrote:
>
> Hello,
>
> I have just completed my upgrade from Bugzilla 5.0.6 to Bugzilla 5.2 
> and loaded my MySql upgrade from 57 to 80 database which was converted 
> into a new format during the Bugzilla install. When I access my 
> Bugzilla website and attempt to create a new bug, I am getting the 
> following error:
>
> undef error - DBD::mysql::db selectcol_arrayref failed: Table 
> 'prds.flagexclusions' doesn't exist [for Statement "SELECT id FROM 
> flagtypes INNER JOIN flaginclusions AS i ON flagtypes.id = i.type_id 
> LEFT JOIN flagexclusions AS e ON (flagtypes.id = e.type_id AND 
> (e.component_id = 249 OR e.component_id IS NULL) AND ((e.product_id = 
> 12 ) OR e.product_id IS NULL)) WHERE 1=1 AND (i.product_id = 12 OR 
> i.product_id IS NULL) AND (i.component_id = 249 OR i.component_id IS 
> NULL) AND e.type_id IS NULL"] at Bugzilla/DB.pm line 64. 
> Bugzilla::DB::__ANON__(Bugzilla::DB::Mysql=HASH(0x56399d0f38c0), 
> "SELECT id FROM flagtypes INNER JOIN flaginclusions AS i ON fl"...) 
> called at Bugzilla/FlagType.pm line 623 
> Bugzilla::FlagType::match(HASH(0x56399dbfa828)) called at 
> Bugzilla/Component.pm line 381 
> Bugzilla::Component::flag_types(Bugzilla::Component=HASH(0x56399d856be8)) 
> called at template/en/default/bug/create/create.html.tmpl line 50 eval 
> {...} called at template/en/default/bug/create/create.html.tmpl line 
> 50 eval {...} called at 
> template/en/default/bug/create/create.html.tmpl line 65 eval {...} 
> called at template/en/default/bug/create/create.html.tmpl line 18 
> Template::Provider::__ANON__(Bugzilla::Template::Context=HASH(0x56399d73ecf0)) 
> called at /usr/local/lib64/perl5/Template/Document.pm line 166 eval 
> {...} called at /usr/local/lib64/perl5/Template/Document.pm line 164 
> Template::Document::process(Template::Document=HASH(0x56399dab9d28), 
> Bugzilla::Template::Context=HASH(0x56399d73ecf0)) called at 
> /usr/local/lib64/perl5/Template/Context.pm line 354 eval {...} called 
> at /usr/local/lib64/perl5/Template/Context.pm line 324 
> Template::Context::process(Bugzilla::Template::Context=HASH(0x56399d73ecf0), 
> Template::Document=HASH(0x56399dab9d28)) called at 
> Bugzilla/Template/Context.pm line 36 
> Bugzilla::Template::Context::process(Bugzilla::Template::Context=HASH(0x56399d73ecf0), 
> Template::Document=HASH(0x56399dab9d28)) called at 
> /usr/local/lib64/perl5/Template/Service.pm line 96 eval {...} called 
> at /usr/local/lib64/perl5/Template/Service.pm line 93 
> Template::Service::process(Template::Service=HASH(0x56399d73e228), 
> "bug/create/create.html.tmpl", HASH(0x56399d72bfc8)) called at 
> /usr/local/lib64/perl5/Template.pm line 66 
> Template::process(Bugzilla::Template=HASH(0x56399d72bea8), 
> "bug/create/create.html.tmpl", HASH(0x56399d72bfc8)) called at 
> Bugzilla/Template.pm line 725 
> Bugzilla::Template::process(Bugzilla::Template=HASH(0x56399d72bea8), 
> "bug/create/create.html.tmpl", HASH(0x56399d72bfc8)) called at 
> /var/www/html/bugzilla-5.2/enter_bug.cgi line 383
>
> Would this be some sort of permissions thing on one of the perl 
> modules installed?
>
> Thanks,
>
> Ron
>
>
> _______________________________________________
> support-list mailing list
> support-list at bugzilla.org
> https://lists.bugzilla.org/listinfo/support-list
-- 
[Bugzilla Logo] 	
*Dave Miller*
Project Leader
*Bugzilla Project*
https://bugzilla.org/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bugzilla.org/pipermail/support-list/attachments/20241220/f3ec7cbc/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 5IUcDX5QNX5w0y5R.png
Type: image/png
Size: 7345 bytes
Desc: not available
URL: <http://lists.bugzilla.org/pipermail/support-list/attachments/20241220/f3ec7cbc/attachment.png>