National Flags

Install SQL ERROR mysqli Unknown column 'flag_name' - National Flags

Install SQL ERROR mysqli Unknown column 'flag_name'

by construaprende » Tue Feb 21, 2017 2:50 am

Hi
I had before, the mod of country flags in phpbb 3.010
I upgraded to phpbb 3.2 recently and when I try to install National Flags extension, I recieve this error:

SQL ERROR [ mysqli ]

Unknown column 'flag_name' in 'field list' [1054]

SQL

INSERT INTO phpbb_flags (flag_name, flag_image) VALUES ('Afghanistan', 'AF.png'), ('Albania', 'AL.png'), ('Algeria', 'DZ.png'), ('American Samoa', 'AS.png'), ('Andorra', 'AD.png'), ('Angola', 'AO.png'), ('Anguilla', 'AI.png'), ('Antigua & Barbuda', 'AG.png'), ('Argentina', 'AR.png'), ('Armenia', 'AM.png'), ('Aruba', 'AW.png'), ('Australia', 'AU.png'), ('Austria', 'AT.png'), ('Azerbaijan', 'AZ.png'), ('Bahamas', 'BS.png'), ('Bahrain', 'BH.png'), ('Bangladesh', 'BD.png'), ('Barbados', 'BB.png'), ('Belarus', 'BY.png'), ('Belgium', 'BE.png'), ('Belize', 'BZ.png'), ('Benin', 'BJ.png'), ('Bermuda', 'BM.png'), ('Bhutan', 'BT.png'), ('Bolivia', 'BO.png'), ('Bonaire', 'BL.png'), ('Bosnia & Herzegovina', 'BA.png'), ('Botswana', 'BW.png'), ('Brazil', 'BR.png'), ('Brunei', 'BN.png'), ('Bulgaria', 'BG.png'), ('Burkina Faso', 'BF.png'), ('Burundi', 'BI.png'), ('Cambodia', 'KH.png'), ('Cameroon', 'CM.png'), ('Canada', 'CA.png'), ('Cape Verde', 'CV.png'), ('Cayman Islands', 'KY.png'), ('Central African Republic', 'CF.png'), ('Chad', 'TD.png'), ('Chile', 'CL.png'), ('China', 'CN.png'), ('Columbia', 'CO.png'), ('Comoros', 'KM.png'), ('Congo', 'CG.png'), ('Congo Democratic Republic', 'CD.png'), ('Costa Rica', 'CR.png'), ('Cote D-Ivoire', 'CI.png'), ('Croatia', 'HR.png'), ('Cuba', 'CU.png'), ('Cyprus', 'CY.png'), ('Czech Republic', 'CZ.png'), ('Denmark', 'DK.png'), ('Djibouti', 'DJ.png'), ('Dominica', 'DM.png'), ('Dominican Republic', 'DO.png'), ('East Timor', 'TL.png'), ('Ecuador', 'EC.png'), ('Egypt', 'EG.png'), ('El Salvador', 'SV.png'), ('Equatorial Guinea', 'GQ.png'), ('Eritrea', 'ER.png'), ('Estonia', 'EE.png'), ('Ethiopia', 'ET.png'), ('Falkland Islands', 'FK.png'), ('Faroe Islands', 'FO.png'), ('Fiji', 'FJ.png'), ('Finland', 'FI.png'), ('France', 'FR.png'), ('Gabon', 'GA.png'), ('Gambia', 'GM.png'), ('Georgia', 'GE.png'), ('Germany', 'DE.png'), ('Ghana', 'GH.png'), ('Great Britain', 'GB.png'), ('Greece', 'GR.png'), ('Greenland', 'GL.png'), ('Grenada', 'GD.png'), ('Guam', 'GU.png'), ('Guatemala', 'GT.png'), ('Guinea', 'GN.png'), ('Guinea Bissau', 'GW.png'), ('Guyana', 'GY.png'), ('Haiti', 'HT.png'), ('Honduras', 'HN.png'), ('Hong Kong', 'HK.png'), ('Hungary', 'HU.png'), ('Iceland', 'IS.png'), ('India', 'IN.png'), ('Indonesia', 'ID.png'), ('Iran', 'IR.png'), ('Iraq', 'IQ.png'), ('Ireland', 'IE.png'), ('Isle of Man', 'IM.png'), ('Israel', 'IL.png'), ('Italy', 'IT.png'), ('Jamaica', 'JM.png'), ('Japan', 'JP.png'), ('Jordan', 'JO.png'), ('Kazakhstan', 'KZ.png'), ('Kenya', 'KE.png'), ('Kiribati', 'KI.png'), ('Korea North', 'NK.png'), ('Korea South', 'KS.png'), ('Kuwait', 'KW.png'), ('Kyrgyzstan', 'KG.png'), ('Laos', 'LA.png'), ('Latvia', 'LV.png'), ('Lebanon', 'LB.png'), ('Lesotho', 'LS.png'), ('Liberia', 'LR.png'), ('Libya', 'LY.png'), ('Liechtenstein', 'LI.png'), ('Lithuania', 'LT.png'), ('Luxembourg', 'LU.png'), ('Macau', 'MO.png'), ('Macedonia', 'MK.png'), ('Madagascar', 'MG.png'), ('Malawi', 'MW.png'), ('Malaysia', 'MY.png'), ('Maldives', 'MV.png'), ('Mali', 'ML.png'), ('Malta', 'MT.png'), ('Marshall Islands', 'MH.png'), ('Mauritania', 'MR.png'), ('Mauritius', 'MU.png'), ('Mexico', 'MX.png'), ('Micronesia', 'FM.png'), ('Moldova', 'MD.png'), ('Monaco', 'MC.png'), ('Mongolia', 'MN.png'), ('Montserrat', 'MS.png'), ('Morocco', 'MA.png'), ('Mozambique', 'MZ.png'), ('Myanmar', 'MM.png'), ('Nambia', 'NA.png'), ('Nauru', 'NR.png'), ('Nepal', 'NP.png'), ('Netherland Antilles', 'AN.png'), ('Netherlands', 'NL.png'), ('New Zealand', 'NZ.png'), ('Nicaragua', 'NI.png'), ('Niger', 'NE.png'), ('Nigeria', 'NG.png'), ('Norfolk Island', 'NF.png'), ('Norway', 'NO.png'), ('Oman', 'OM.png'), ('Pakistan', 'PK.png'), ('Palau Island', 'PW.png'), ('Palestine', 'PS.png'), ('Panama', 'PA.png'), ('Papua New Guinea', 'PG.png'), ('Paraguay', 'PY.png'), ('Peru', 'PE.png'), ('Philippines', 'PH.png'), ('Pitcairn Island', 'PN.png'), ('Poland', 'PL.png'), ('Portugal', 'PT.png'), ('Puerto Rico', 'PR.png'), ('Qatar', 'QA.png'), ('Romania', 'RO.png'), ('Russia', 'RU.png'), ('Rwanda', 'RW.png'), ('Samoa', 'WS.png'), ('San Marino', 'SM.png'), ('Sao Tome & Principe', 'ST.png'), ('Saudi Arabia', 'SA.png'), ('Senegal', 'SN.png'), ('Seychelles', 'SC.png'), ('Sierra Leone', 'SL.png'), ('Singapore', 'SG.png'), ('Slovakia', 'SK.png'), ('Slovenia', 'SI.png'), ('Solomon Islands', 'SB.png'), ('Somalia', 'SO.png'), ('South Africa', 'ZA.png'), ('Spain', 'ES.png'), ('Sri Lanka', 'LK.png'), ('St Helena', 'SH.png'), ('St Kitts-Nevis', 'KN.png'), ('St Lucia', 'LC.png'), ('St Vincent & Grenadines', 'VC.png'), ('Sudan', 'SD.png'), ('Suriname', 'SR.png'), ('Swaziland', 'SZ.png'), ('Sweden', 'SE.png'), ('Switzerland', 'CH.png'), ('Syria', 'SY.png'), ('Taiwan', 'TW.png'), ('Tajikistan', 'TJ.png'), ('Tanzania', 'TZ.png'), ('Thailand', 'TH.png'), ('Togo', 'TG.png'), ('Tonga', 'TO.png'), ('Trinidad & Tobago', 'TT.png'), ('Tunisia', 'TN.png'), ('Turkey', 'TR.png'), ('Turkmenistan', 'TM.png'), ('Turks & Caicos Is', 'TC.png'), ('Tuvalu', 'TV.png'), ('Uganda', 'UG.png'), ('Ukraine', 'UA.png'), ('United Arab Emirates', 'AE.png'), ('United States of America', 'US.png'), ('Uruguay', 'UY.png'), ('Uzbekistan', 'UZ.png'), ('Vanuatu', 'VU.png'), ('Venezuela', 'VE.png'), ('Vietnam', 'VN.png'), ('Virgin Islands (Brit)', 'VG.png'), ('Virgin Islands (USA)', 'VI.png'), ('Wales', 'WLS.png'), ('Western Sahara', 'EH.png'), ('Yemen', 'YE.png'), ('Zambia', 'ZM.png'), ('Zimbabwe', 'ZW.png')

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 996
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 659
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 377
CALL: phpbb\db\driver\driver->sql_multi_insert()

FILE: [ROOT]/ext/rmcgirr83/nationalflags/migrations/m2_initial_data.php
LINE: 914
CALL: phpbb\db\driver\factory->sql_multi_insert()

FILE: (not given by php)
LINE: (not given by php)
CALL: rmcgirr83\nationalflags\migrations\m2_initial_data->flag_install_images()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 711
CALL: call_user_func_array()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 658
CALL: phpbb\db\migrator->run_step()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 436
CALL: phpbb\db\migrator->process_data_step()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 351
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 351
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 351
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 351
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 288
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 241
CALL: phpbb\db\migrator->update_do()

FILE: [ROOT]/phpbb/extension/base.php
LINE: 78
CALL: phpbb\db\migrator->update()

FILE: [ROOT]/phpbb/extension/manager.php
LINE: 185
CALL: phpbb\extension\base->enable_step()

FILE: [ROOT]/includes/acp/acp_extensions.php
LINE: 197
CALL: phpbb\extension\manager->enable_step()

FILE: [ROOT]/includes/functions_module.php
LINE: 676
CALL: acp_extensions->main()

FILE: [ROOT]/adm/index.php
LINE: 82
CALL: p_master->load_active()
I have PHP Version 7.0.15
MYSQL 5.6.34

How can I solve it

Thanks a lot
construaprende
Registered User
Posts: 59
Joined: Tue May 18, 2004 7:40 pm
Location: Mexico

Re: Install SQL ERROR mysqli Unknown column 'flag_name'

by construaprende » Tue Feb 21, 2017 3:36 am

I unistall with the option to erase data
And reinstall

It is solved :-)
construaprende
Registered User
Posts: 59
Joined: Tue May 18, 2004 7:40 pm
Location: Mexico