MyBB Community Forums

i have installed countries plugin but when i want to edit profile from user cp i have an internal sql error : see screenshot below :

Uninstall & reinstall : the table seems to not have been created. Looks like you already had a "country" column in user table (another plugin did it ?)

Check your error log.

i have do it several times . when i install this plugin its working fine but no countries option is shown in the configuration page . help me please i have the problem with many mybb plugins

Check your DB, the trouble is with it, the table mybb_countries is not created.

And check if you have a "Country" setting in ACP, in the "Login and Registration Options"

Yes This table is Not Created in db and the option of Countries is present in Login & Registration Page .

Try to create the table yourself, by the hand:

CREATE TABLE mybb_countries (
				cid int unsigned NOT NULL auto_increment,
				name varchar(150) NOT NULL default '',
				flag varchar(255) NOT NULL default '',
				PRIMARY KEY (cid)
			) ENGINE=MyISAM DEFAULT CHARSET='utf8';

(adapt the charset)

And fill it:

INSERT INTO mybb_countries (cid, name, flag) VALUES
(1, '<lang:country_afghanistan>', 'images/flags/afghanistan.png'),
(2, '<lang:country_aland_islands>', 'images/flags/aland_islands.png'),
(3, '<lang:country_albania>', 'images/flags/albania.png'),
(4, '<lang:country_algeria>', 'images/flags/algeria.png'),
(5, '<lang:country_american_samoa>', 'images/flags/american_samoa.png'),
(6, '<lang:country_andorra>', 'images/flags/andorra.png'),
(7, '<lang:country_angola>', 'images/flags/angola.png'),
(8, '<lang:country_anguilla>', 'images/flags/anguilla.png'),
(9, '<lang:country_antarctica>', 'images/flags/antarctica.png'),
(10, '<lang:country_antigua_and_barbuda>', 'images/flags/antigua_and_barbuda.png'),
(11, '<lang:country_argentina>', 'images/flags/argentina.png'),
(12, '<lang:country_armenia>', 'images/flags/armenia.png'),
(13, '<lang:country_aruba>', 'images/flags/aruba.png'),
(14, '<lang:country_australia>', 'images/flags/australia.png'),
(15, '<lang:country_austria>', 'images/flags/austria.png'),
(16, '<lang:country_azerbaijan>', 'images/flags/azerbaijan.png'),
(17, '<lang:country_azores>', 'images/flags/azores.png'),
(18, '<lang:country_bahamas>', 'images/flags/bahamas.png'),
(19, '<lang:country_bahrain>', 'images/flags/bahrain.png'),
(20, '<lang:country_bangladesh>', 'images/flags/bangladesh.png'),
(21, '<lang:country_barbados>', 'images/flags/barbados.png'),
(22, '<lang:country_belarus>', 'images/flags/belarus.png'),
(23, '<lang:country_belgium>', 'images/flags/belgium.png'),
(24, '<lang:country_belize>', 'images/flags/belize.png'),
(25, '<lang:country_benin>', 'images/flags/benin.png'),
(26, '<lang:country_bermuda>', 'images/flags/bermuda.png'),
(27, '<lang:country_bhutan>', 'images/flags/bhutan.png'),
(28, '<lang:country_bolivia>', 'images/flags/bolivia.png'),
(29, '<lang:country_bosnia_and_herzegovina>', 'images/flags/bosnia_and_herzegovina.png'),
(30, '<lang:country_botswana>', 'images/flags/botswana.png'),
(31, '<lang:country_brazil>', 'images/flags/brazil.png'),
(32, '<lang:country_british_antarctic_territory>', 'images/flags/british_antarctic_territory.png'),
(33, '<lang:country_british_indian_ocean_territory>', 'images/flags/british_indian_ocean_territory.png'),
(34, '<lang:country_british_virgin_islands>', 'images/flags/british_virgin_islands.png'),
(35, '<lang:country_brunei>', 'images/flags/brunei.png'),
(36, '<lang:country_bulgaria>', 'images/flags/bulgaria.png'),
(37, '<lang:country_burkina_faso>', 'images/flags/burkina_faso.png'),
(38, '<lang:country_burundi>', 'images/flags/burundi.png'),
(39, '<lang:country_cambodia>', 'images/flags/cambodia.png'),
(40, '<lang:country_cameroon>', 'images/flags/cameroon.png'),
(41, '<lang:country_canada>', 'images/flags/canada.png'),
(42, '<lang:country_canary_islands>', 'images/flags/canary_islands.png'),
(43, '<lang:country_cape_verde>', 'images/flags/cape_verde.png'),
(44, '<lang:country_cayman_islands>', 'images/flags/cayman_islands.png'),
(45, '<lang:country_central_african_republic>', 'images/flags/central_african_republic.png'),
(46, '<lang:country_chad>', 'images/flags/chad.png'),
(47, '<lang:country_chile>', 'images/flags/chile.png'),
(48, '<lang:country_china>', 'images/flags/china.png'),
(49, '<lang:country_christmas_island>', 'images/flags/christmas_island.png'),
(50, '<lang:country_cocos_islands>', 'images/flags/cocos_islands.png'),
(51, '<lang:country_colombia>', 'images/flags/colombia.png'),
(52, '<lang:country_comoros>', 'images/flags/comoros.png'),
(53, '<lang:country_congo_democratic_republic>', 'images/flags/congo_democratic_republic.png'),
(54, '<lang:country_congo_republic>', 'images/flags/congo_republic.png'),
(55, '<lang:country_cook_islands>', 'images/flags/cook_islands.png'),
(56, '<lang:country_costa_rica>', 'images/flags/costa_rica.png'),
(57, '<lang:country_cote_divoire>', 'images/flags/cote_divoire.png'),
(58, '<lang:country_croatia>', 'images/flags/croatia.png'),
(59, '<lang:country_cuba>', 'images/flags/cuba.png'),
(60, '<lang:country_curacao>', 'images/flags/curacao.png'),
(61, '<lang:country_cyprus>', 'images/flags/cyprus.png'),
(62, '<lang:country_czech_republic>', 'images/flags/czech_republic.png'),
(63, '<lang:country_denmark>', 'images/flags/denmark.png'),
(64, '<lang:country_djibouti>', 'images/flags/djibouti.png'),
(65, '<lang:country_dominica>', 'images/flags/dominica.png'),
(66, '<lang:country_dominican_republic>', 'images/flags/dominican_republic.png'),
(67, '<lang:country_east_timor>', 'images/flags/east_timor.png'),
(68, '<lang:country_ecuador>', 'images/flags/ecuador.png'),
(69, '<lang:country_egypt>', 'images/flags/egypt.png'),
(70, '<lang:country_el_salvador>', 'images/flags/el_salvador.png'),
(71, '<lang:country_equatorial_guinea>', 'images/flags/equatorial_guinea.png'),
(72, '<lang:country_eritrea>', 'images/flags/eritrea.png'),
(73, '<lang:country_estonia>', 'images/flags/estonia.png'),
(74, '<lang:country_ethiopia>', 'images/flags/ethiopia.png'),
(75, '<lang:country_falkland_islands>', 'images/flags/falkland_islands.png'),
(76, '<lang:country_faroe_islands>', 'images/flags/faroe_islands.png'),
(77, '<lang:country_fiji>', 'images/flags/fiji.png'),
(78, '<lang:country_finland>', 'images/flags/finland.png'),
(79, '<lang:country_france>', 'images/flags/france.png'),
(80, '<lang:country_french_guiana>', 'images/flags/french_guiana.png'),
(81, '<lang:country_french_polynesia>', 'images/flags/french_polynesia.png'),
(82, '<lang:country_french_southern_and_antarctic_lands>', 'images/flags/french_southern_and_antarctic_lands.png'),
(83, '<lang:country_gabon>', 'images/flags/gabon.png'),
(84, '<lang:country_gambia>', 'images/flags/gambia.png'),
(85, '<lang:country_georgia>', 'images/flags/georgia.png'),
(86, '<lang:country_germany>', 'images/flags/germany.png'),
(87, '<lang:country_ghana>', 'images/flags/ghana.png'),
(88, '<lang:country_gibraltar>', 'images/flags/gibraltar.png'),
(89, '<lang:country_greece>', 'images/flags/greece.png'),
(90, '<lang:country_greenland>', 'images/flags/greenland.png'),
(91, '<lang:country_grenada>', 'images/flags/grenada.png'),
(92, '<lang:country_guadeloupe>', 'images/flags/guadeloupe.png'),
(93, '<lang:country_guam>', 'images/flags/guam.png'),
(94, '<lang:country_guatemala>', 'images/flags/guatemala.png'),
(95, '<lang:country_guernsey>', 'images/flags/guernsey.png'),
(96, '<lang:country_guinea>', 'images/flags/guinea.png'),
(97, '<lang:country_guinea_bissau>', 'images/flags/guinea_bissau.png'),
(98, '<lang:country_guyana>', 'images/flags/guyana.png'),
(99, '<lang:country_haiti>', 'images/flags/haiti.png'),
(100, '<lang:country_honduras>', 'images/flags/honduras.png'),
(101, '<lang:country_hong_kong>', 'images/flags/hong_kong.png'),
(102, '<lang:country_hungary>', 'images/flags/hungary.png'),
(103, '<lang:country_iceland>', 'images/flags/iceland.png'),
(104, '<lang:country_india>', 'images/flags/india.png'),
(105, '<lang:country_indonesia>', 'images/flags/indonesia.png'),
(106, '<lang:country_iran>', 'images/flags/iran.png'),
(107, '<lang:country_iraq>', 'images/flags/iraq.png'),
(108, '<lang:country_ireland>', 'images/flags/ireland.png'),
(109, '<lang:country_isle_of_man>', 'images/flags/isle_of_man.png'),
(110, '<lang:country_israel>', 'images/flags/israel.png'),
(111, '<lang:country_italy>', 'images/flags/italy.png'),
(112, '<lang:country_jamaica>', 'images/flags/jamaica.png'),
(113, '<lang:country_japan>', 'images/flags/japan.png'),
(114, '<lang:country_jersey>', 'images/flags/jersey.png'),
(115, '<lang:country_jordan>', 'images/flags/jordan.png'),
(116, '<lang:country_kazakhstan>', 'images/flags/kazakhstan.png'),
(117, '<lang:country_kenya>', 'images/flags/kenya.png'),
(118, '<lang:country_kiribati>', 'images/flags/kiribati.png'),
(119, '<lang:country_kosovo>', 'images/flags/kosovo.png'),
(120, '<lang:country_kuwait>', 'images/flags/kuwait.png'),
(121, '<lang:country_kyrgyzstan>', 'images/flags/kyrgyzstan.png'),
(122, '<lang:country_laos>', 'images/flags/laos.png'),
(123, '<lang:country_latvia>', 'images/flags/latvia.png'),
(124, '<lang:country_lebanon>', 'images/flags/lebanon.png'),
(125, '<lang:country_lesotho>', 'images/flags/lesotho.png'),
(126, '<lang:country_liberia>', 'images/flags/liberia.png'),
(127, '<lang:country_libya>', 'images/flags/libya.png'),
(128, '<lang:country_liechtenstein>', 'images/flags/liechtenstein.png'),
(129, '<lang:country_lithuania>', 'images/flags/lithuania.png'),
(130, '<lang:country_luxembourg>', 'images/flags/luxembourg.png'),
(131, '<lang:country_macau>', 'images/flags/macau.png'),
(132, '<lang:country_macedonia>', 'images/flags/macedonia.png'),
(133, '<lang:country_madagascar>', 'images/flags/madagascar.png'),
(134, '<lang:country_madeira>', 'images/flags/madeira.png'),
(135, '<lang:country_malawi>', 'images/flags/malawi.png'),
(136, '<lang:country_malaysia>', 'images/flags/malaysia.png'),
(137, '<lang:country_maldives>', 'images/flags/maldives.png'),
(138, '<lang:country_mali>', 'images/flags/mali.png'),
(139, '<lang:country_malta>', 'images/flags/malta.png'),
(140, '<lang:country_marshall_islands>', 'images/flags/marshall_islands.png'),
(141, '<lang:country_martinique>', 'images/flags/martinique.png'),
(142, '<lang:country_mauritania>', 'images/flags/mauritania.png'),
(143, '<lang:country_mauritius>', 'images/flags/mauritius.png'),
(144, '<lang:country_mayotte>', 'images/flags/mayotte.png'),
(145, '<lang:country_mexico>', 'images/flags/mexico.png'),
(146, '<lang:country_micronesia>', 'images/flags/micronesia.png'),
(147, '<lang:country_moldova>', 'images/flags/moldova.png'),
(148, '<lang:country_monaco>', 'images/flags/monaco.png'),
(149, '<lang:country_mongolia>', 'images/flags/mongolia.png'),
(150, '<lang:country_montenegro>', 'images/flags/montenegro.png'),
(151, '<lang:country_montserrat>', 'images/flags/montserrat.png'),
(152, '<lang:country_morocco>', 'images/flags/morocco.png'),
(153, '<lang:country_mozambique>', 'images/flags/mozambique.png'),
(154, '<lang:country_myanmar>', 'images/flags/myanmar.png'),
(155, '<lang:country_namibia>', 'images/flags/namibia.png'),
(156, '<lang:country_nauru>', 'images/flags/nauru.png'),
(157, '<lang:country_nepal>', 'images/flags/nepal.png'),
(158, '<lang:country_netherlands>', 'images/flags/netherlands.png'),
(159, '<lang:country_new_caledonia>', 'images/flags/new_caledonia.png'),
(160, '<lang:country_new_zealand>', 'images/flags/new_zealand.png'),
(161, '<lang:country_nicaragua>', 'images/flags/nicaragua.png'),
(162, '<lang:country_niger>', 'images/flags/niger.png'),
(163, '<lang:country_nigeria>', 'images/flags/nigeria.png'),
(164, '<lang:country_niue>', 'images/flags/niue.png'),
(165, '<lang:country_norfolk_island>', 'images/flags/norfolk_island.png'),
(166, '<lang:country_north_korea>', 'images/flags/north_korea.png'),
(167, '<lang:country_northern_mariana_islands>', 'images/flags/northern_mariana_islands.png'),
(168, '<lang:country_norway>', 'images/flags/norway.png'),
(169, '<lang:country_oman>', 'images/flags/oman.png'),
(170, '<lang:country_pakistan>', 'images/flags/pakistan.png'),
(171, '<lang:country_palau>', 'images/flags/palau.png'),
(172, '<lang:country_palestine>', 'images/flags/palestine.png'),
(173, '<lang:country_panama>', 'images/flags/panama.png'),
(174, '<lang:country_papua_new_guinea>', 'images/flags/papua_new_guinea.png'),
(175, '<lang:country_paraguay>', 'images/flags/paraguay.png'),
(176, '<lang:country_peru>', 'images/flags/peru.png'),
(177, '<lang:country_philippines>', 'images/flags/philippines.png'),
(178, '<lang:country_pitcairn_islands>', 'images/flags/pitcairn_islands.png'),
(179, '<lang:country_poland>', 'images/flags/poland.png'),
(180, '<lang:country_portugal>', 'images/flags/portugal.png'),
(181, '<lang:country_puerto_rico>', 'images/flags/puerto_rico.png'),
(182, '<lang:country_qatar>', 'images/flags/qatar.png'),
(183, '<lang:country_reunion>', 'images/flags/reunion.png'),
(184, '<lang:country_romania>', 'images/flags/romania.png'),
(185, '<lang:country_russia>', 'images/flags/russia.png'),
(186, '<lang:country_rwanda>', 'images/flags/rwanda.png'),
(187, '<lang:country_saint_barthelemy>', 'images/flags/saint_barthelemy.png'),
(188, '<lang:country_saint_helena_ascension_and_tristan_da_cunha>', 'images/flags/saint_helena_ascension_and_tristan_da_cunha.png'),
(189, '<lang:country_saint_kitts_and_nevis>', 'images/flags/saint_kitts_and_nevis.png'),
(190, '<lang:country_saint_lucia>', 'images/flags/saint_lucia.png'),
(191, '<lang:country_saint_martin>', 'images/flags/saint_martin.png'),
(192, '<lang:country_saint_pierre_and_miquelon>', 'images/flags/saint_pierre_and_miquelon.png'),
(193, '<lang:country_saint_vincent_and_the_grenadines>', 'images/flags/saint_vincent_and_the_grenadines.png'),
(194, '<lang:country_samoa>', 'images/flags/samoa.png'),
(195, '<lang:country_san_marino>', 'images/flags/san_marino.png'),
(196, '<lang:country_sao_tome_and_principe>', 'images/flags/sao_tome_and_principe.png'),
(197, '<lang:country_saudi_arabia>', 'images/flags/saudi_arabia.png'),
(198, '<lang:country_senegal>', 'images/flags/senegal.png'),
(199, '<lang:country_serbia>', 'images/flags/serbia.png'),
(200, '<lang:country_seychelles>', 'images/flags/seychelles.png'),
(201, '<lang:country_sierra_leone>', 'images/flags/sierra_leone.png'),
(202, '<lang:country_singapore>', 'images/flags/singapore.png'),
(203, '<lang:country_sint_maarten>', 'images/flags/sint_maarten.png'),
(204, '<lang:country_slovakia>', 'images/flags/slovakia.png'),
(205, '<lang:country_slovenia>', 'images/flags/slovenia.png'),
(206, '<lang:country_solomon_islands>', 'images/flags/solomon_islands.png'),
(207, '<lang:country_somalia>', 'images/flags/somalia.png'),
(208, '<lang:country_south_africa>', 'images/flags/south_africa.png'),
(209, '<lang:country_south_georgia_and_the_south_sandwich_islands>', 'images/flags/south_georgia_and_the_south_sandwich_islands.png'),
(210, '<lang:country_south_korea>', 'images/flags/south_korea.png'),
(211, '<lang:country_south_sudan>', 'images/flags/south_sudan.png'),
(212, '<lang:country_spain>', 'images/flags/spain.png'),
(213, '<lang:country_sri_lanka>', 'images/flags/sri_lanka.png'),
(214, '<lang:country_sudan>', 'images/flags/sudan.png'),
(215, '<lang:country_suriname>', 'images/flags/suriname.png'),
(216, '<lang:country_swaziland>', 'images/flags/swaziland.png'),
(217, '<lang:country_sweden>', 'images/flags/sweden.png'),
(218, '<lang:country_switzerland>', 'images/flags/switzerland.png'),
(219, '<lang:country_syria>', 'images/flags/syria.png'),
(220, '<lang:country_taiwan>', 'images/flags/taiwan.png'),
(221, '<lang:country_tajikistan>', 'images/flags/tajikistan.png'),
(222, '<lang:country_tanzania>', 'images/flags/tanzania.png'),
(223, '<lang:country_thailand>', 'images/flags/thailand.png'),
(224, '<lang:country_togo>', 'images/flags/togo.png'),
(225, '<lang:country_tokelau>', 'images/flags/tokelau.png'),
(226, '<lang:country_tonga>', 'images/flags/tonga.png'),
(227, '<lang:country_trinidad_and_tobago>', 'images/flags/trinidad_and_tobago.png'),
(228, '<lang:country_tunisia>', 'images/flags/tunisia.png'),
(229, '<lang:country_turkey>', 'images/flags/turkey.png'),
(230, '<lang:country_turkmenistan>', 'images/flags/turkmenistan.png'),
(231, '<lang:country_turks_and_caicos_islands>', 'images/flags/turks_and_caicos_islands.png'),
(232, '<lang:country_tuvalu>', 'images/flags/tuvalu.png'),
(233, '<lang:country_uganda>', 'images/flags/uganda.png'),
(234, '<lang:country_ukraine>', 'images/flags/ukraine.png'),
(235, '<lang:country_united_arab_emirates>', 'images/flags/united_arab_emirates.png'),
(236, '<lang:country_united_kingdom>', 'images/flags/united_kingdom.png'),
(237, '<lang:country_united_states>', 'images/flags/united_states.png'),
(238, '<lang:country_united_states_minor_outlying_islands>', 'images/flags/united_states_minor_outlying_islands.png'),
(239, '<lang:country_united_states_virgin_islands>', 'images/flags/united_states_virgin_islands.png'),
(240, '<lang:country_uruguay>', 'images/flags/uruguay.png'),
(241, '<lang:country_uzbekistan>', 'images/flags/uzbekistan.png'),
(242, '<lang:country_vanuatu>', 'images/flags/vanuatu.png'),
(243, '<lang:country_vatican_city>', 'images/flags/vatican_city.png'),
(244, '<lang:country_venezuela>', 'images/flags/venezuela.png'),
(245, '<lang:country_vietnam>', 'images/flags/vietnam.png'),
(246, '<lang:country_wallis_and_futuna_islands>', 'images/flags/wallis_and_futuna_islands.png'),
(247, '<lang:country_western_sahara>', 'images/flags/western_sahara.png'),
(248, '<lang:country_yemen>', 'images/flags/yemen.png'),
(249, '<lang:country_zambia>', 'images/flags/zambia.png'),
(250, '<lang:country_zimbabwe>', 'images/flags/zimbabwe.png')

o.k. I have issues with some plugins . I have installed My Advertisement Plugin But there is no Option of My Advertisement In Tool & Maintenance Page .

Please, only one trouble a thread.