Discussion:
Reg : issue with after restoration of old MySQL to mariadb
Kashyap
2018-10-13 11:02:55 UTC
Permalink
Hi

I have installed bugzilla its working fine without old database,
but when i was trying to bringup with old database i got following error

#./checksetup.pl no errors without database

but

#./checksetup.pl got errors while restoring old databse (mysql Ver 14.12
Distrib 5.0.45 to mysql Ver 15.1 Distrib 10.3.10-MariaDB )

DBD::mysql::db do failed: Can't create table `bugs`.`#sql-6684_13` (errno:
150 "Foreign key constraint is incorrectly formed") [for Statement "ALTER
TABLE test_case_components ADD
CONSTRAINT fk_test_case_components_component_id_components_id FOREIGN
KEY (component_id)
REFERENCES components(id)
ON UPDATE CASCADE ON DELETE CASCADE"] at Bugzilla/DB.pm line 667.
Bugzilla::DB::bz_add_fks('Bugzilla::DB::Mysql=HASH(0x6c14b08)',
'test_case_components', 'HASH(0x63960d8)', 'HASH(0xa0286b8)') called at
Bugzilla/DB.pm line 571

Bugzilla::DB::bz_setup_foreign_keys('Bugzilla::DB::Mysql=HASH(0x6c14b08)')
called at Bugzilla/Install/DB.pm line 748
Bugzilla::Install::DB::update_table_definitions('HASH(0x18c6100)')
called at ./checksetup.pl line 172

--
Thorsten Schöning
2018-10-13 11:41:41 UTC
Permalink
Guten Tag Kashyap,
Post by Kashyap
#./checksetup.pl no errors without database
Because it is creating a new one with default data.
Post by Kashyap
150 "Foreign key constraint is incorrectly formed") [for Statement "ALTER
TABLE test_case_components ADD
CONSTRAINT fk_test_case_components_component_id_components_id FOREIGN
KEY (component_id)
REFERENCES components(id)
ON UPDATE CASCADE ON DELETE CASCADE"] at Bugzilla/DB.pm line 667.
Bugzilla::DB::bz_add_fks('Bugzilla::DB::Mysql=HASH(0x6c14b08)',
'test_case_components', 'HASH(0x63960d8)', 'HASH(0xa0286b8)') called at
Bugzilla/DB.pm line 571
"test_case_components" belongs to Testopia most likely and if you used
that in the past, you need to provide it in the future as well. Have a
look at the following thread dealing with that problem as well:

https://groups.google.com/forum/#!topic/mozilla.support.bugzilla/fl7asEwZOxY
https://developer.mozilla.org/en-US/docs/Mozilla/Bugzilla/Testopia#Testopia_3.0_(not_yet_released)

Mit freundlichen Grüßen,

Thorsten Schöning
--
Thorsten Schöning E-Mail: ***@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
Thorsten Schöning
2018-10-13 11:44:09 UTC
Permalink
Guten Tag Thorsten Schöning,
Post by Kashyap
DBD::mysql::db do failed: Can't create table
`bugs`.`#sql-6684_13`[...]
Besides what I said regarding Testopia, keep in mind that if you
restore a backed up database, you need to properly restore it into an
empty database!

https://bugzilla.readthedocs.io/en/5.0/installing/moving.html

Mit freundlichen Grüßen,

Thorsten Schöning
--
Thorsten Schöning E-Mail: ***@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
Kashyap
2018-10-15 05:09:24 UTC
Permalink
Post by Thorsten Schöning
Guten Tag Kashyap,
Post by Kashyap
#./checksetup.pl no errors without database
Because it is creating a new one with default data.
Post by Kashyap
DBD::mysql::db do failed: Can't create table `bugs`.`#sql-6684_13`
150 "Foreign key constraint is incorrectly formed") [for Statement "ALTER
TABLE test_case_components ADD
CONSTRAINT fk_test_case_components_component_id_components_id
FOREIGN
Post by Kashyap
KEY (component_id)
REFERENCES components(id)
ON UPDATE CASCADE ON DELETE CASCADE"] at Bugzilla/DB.pm line 667.
Bugzilla::DB::bz_add_fks('Bugzilla::DB::Mysql=HASH(0x6c14b08)',
'test_case_components', 'HASH(0x63960d8)', 'HASH(0xa0286b8)') called at
Bugzilla/DB.pm line 571
"test_case_components" belongs to Testopia most likely and if you used
that in the past, you need to provide it in the future as well. Have a
https://groups.google.com/forum/#!topic/mozilla.support.
bugzilla/fl7asEwZOxY
https://developer.mozilla.org/en-US/docs/Mozilla/Bugzilla/
Testopia#Testopia_3.0_(not_yet_released)
How can i take backup without testopia ? is it possible from turnoff and
take backup via Administration | parameters | testopia ( since we are not
using testopia now , we don't want to install it )
Post by Thorsten Schöning
Mit freundlichen Grüßen,
Thorsten Schöning
--
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
_______________________________________________
support-bugzilla mailing list
https://lists.mozilla.org/listinfo/support-bugzilla
reply.
Kashyap
2018-10-15 06:27:46 UTC
Permalink
Guten Tag ,
Post by Kashyap
#./checksetup.pl no errors without database
Because it is creating a new one with default data.
Post by Kashyap
DBD::mysql::db do failed: Can't create table `bugs`.`#sql-6684_13`
150 "Foreign key constraint is incorrectly formed") [for Statement "ALTER
TABLE test_case_components ADD
CONSTRAINT fk_test_case_components_component_id_components_id
FOREIGN
Post by Kashyap
KEY (component_id)
REFERENCES components(id)
ON UPDATE CASCADE ON DELETE CASCADE"] at Bugzilla/DB.pm line 667.
Bugzilla::DB::bz_add_fks('Bugzilla::DB::Mysql=HASH(0x6c14b08)',
'test_case_components', 'HASH(0x63960d8)', 'HASH(0xa0286b8)') called at
Bugzilla/DB.pm line 571
"test_case_components" belongs to Testopia most likely and if you used
that in the past, you need to provide it in the future as well. Have a
https://groups.google.com/forum/#!topic/mozilla.support.bugz
illa/fl7asEwZOxY
https://developer.mozilla.org/en-US/docs/Mozilla/Bugzilla/Te
stopia#Testopia_3.0_(not_yet_released)
How can i take backup without testopia ? is it possible from turnoff and
take backup via Administration | parameters | testopia ( since we are not
using testopia now , we don't want to install it )
Post by Kashyap
Guten Tag Kashyap,
Post by Kashyap
#./checksetup.pl no errors without database
Because it is creating a new one with default data.
Post by Kashyap
DBD::mysql::db do failed: Can't create table `bugs`.`#sql-6684_13`
150 "Foreign key constraint is incorrectly formed") [for Statement
"ALTER
Post by Kashyap
TABLE test_case_components ADD
CONSTRAINT fk_test_case_components_component_id_components_id
FOREIGN
Post by Kashyap
KEY (component_id)
REFERENCES components(id)
ON UPDATE CASCADE ON DELETE CASCADE"] at Bugzilla/DB.pm line 667.
Bugzilla::DB::bz_add_fks('Bugzilla::DB::Mysql=HASH(0x6c14b08)',
'test_case_components', 'HASH(0x63960d8)', 'HASH(0xa0286b8)') called at
Bugzilla/DB.pm line 571
"test_case_components" belongs to Testopia most likely and if you used
that in the past, you need to provide it in the future as well. Have a
https://groups.google.com/forum/#!topic/mozilla.support.bugz
illa/fl7asEwZOxY
https://developer.mozilla.org/en-US/docs/Mozilla/Bugzilla/Te
stopia#Testopia_3.0_(not_yet_released)
How can i take backup without testopia ? is it possible from turnoff and
take backup via Administration | parameters | testopia ( since we are not
using testopia now , we don't want to install it )
Post by Kashyap
Mit freundlichen Grüßen,
Thorsten Schöning
--
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
_______________________________________________
support-bugzilla mailing list
https://lists.mozilla.org/listinfo/support-bugzilla
reply.
--
*Regards,*
Thorsten Schöning
2018-10-15 06:29:23 UTC
Permalink
Guten Tag Kashyap,
Post by Kashyap
How can i take backup without testopia ?
You can't (easily), I explained that in the linked thread already, so
please read it.
Post by Kashyap
is it possible from
turnoff and take backup via Administration | parameters | testopia (
No.
Post by Kashyap
since we are not using testopia now , we don't want to install it )
You need to, details in the linked thread. Testopia is registered in
Bugzilla's schema and every extension which is needs to be available.

Mit freundlichen Grüßen,

Thorsten Schöning
--
Thorsten Schöning E-Mail: ***@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
Loading...