fcom_geo_country error during install

Anshuman Bhartiya

I see the same error:

Migrating modules DB structure...

[1/17] Installing FCom_Geo: 0.1.1 ... *0.1.1;

SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'numcode' at row 117

QUERY: replace into fcom_geo_country (iso,iso3,numcode,name) values ('AF','AFG','4','Afghanistan'),('AX','ALA','248','Aland Islands'),('AL','ALB','8','Albania'),('DZ','DZA','12','Algeria'),('AS','ASM','16','American Samoa'),('AD','AND','20','Andorra'),('AO','AGO','24','Angola'),('AI','AIA','660','Anguilla'),('AQ','ATA','10','Antarctica'),('AG','ATG','28','Antigua and Barbuda'),('AR','ARG','32','Argentina'),('AM','ARM','51','Armenia'),('AW','ABW','533','Aruba'),('AU','AUS','36','Australia'),('AT','AUT','40','Austria'),('AZ','AZE','31','Azerbaijan'),('BS','BHS','44','Bahamas'),('BH','BHR','48','Bahrain'),('BD','BGD','50','Bangladesh'),('BB','BRB','52','Barbados'),('BY','BLR','112','Belarus'),('BE','BEL','56','Belgium'),('BZ','BLZ','84','Belize'),('BJ','BEN','204','Benin'),('BM','BMU','60','Bermuda'),('BT','BTN','64','Bhutan'),('BO','BOL','68','Bolivia'),('BQ','BES','535','Bonaire, Sint Eustatius and Saba'),('BA','BIH','70','Bosnia and Herzegovina'),('BW','BWA','72','Botswana'),('BV','BVT','74','Bouvet Island'),('BR','BRA','76','Brazil'),('IO','IOT','86','British Indian Ocean Territory'),('BN','BRN','96','Brunei'),('BG','BGR','100','Bulgaria'),('BF','BFA','854','Burkina Faso'),('BI','BDI','108','Burundi'),('KH','KHM','116','Cambodia'),('CM','CMR','120','Cameroon'),('CA','CAN','124','Canada'),('CV','CPV','132','Cape Verde'),('KY','CYM','136','Cayman Islands'),('CF','CAF','140','Central African Republic'),('TD','TCD','148','Chad'),('CL','CHL','152','Chile'),('CN','CHN','156','China'),('CX','CXR','162','Christmas Island'),('CC','CCK','166','Cocos (Keeling) Islands'),('CO','COL','170','Colombia'),('KM','COM','174','Comoros'),('CG','COG','178','Congo'),('CK','COK','184','Cook Islands'),('CR','CRI','188','Costa Rica'),('CI','CIV','384','Cote d\'ivoire (Ivory Coast)'),('HR','HRV','191','Croatia'),('CU','CUB','192','Cuba'),('CW','CUW','531','Curacao'),('CY','CYP','196','Cyprus'),('CZ','CZE','203','Czech Republic'),('CD','COD','180','Democratic Republic of the Congo'),('DK','DNK','208','Denmark'),('DJ','DJI','262','Djibouti'),('DM','DMA','212','Dominica'),('DO','DOM','214','Dominican Republic'),('EC','ECU','218','Ecuador'),('EG','EGY','818','Egypt'),('SV','SLV','222','El Salvador'),('GQ','GNQ','226','Equatorial Guinea'),('ER','ERI','232','Eritrea'),('EE','EST','233','Estonia'),('ET','ETH','231','Ethiopia'),('FK','FLK','238','Falkland Islands (Malvinas)'),('FO','FRO','234','Faroe Islands'),('FJ','FJI','242','Fiji'),('FI','FIN','246','Finland'),('FR','FRA','250','France'),('GF','GUF','254','French Guiana'),('PF','PYF','258','French Polynesia'),('TF','ATF','260','French Southern Territories'),('GA','GAB','266','Gabon'),('GM','GMB','270','Gambia'),('GE','GEO','268','Georgia'),('DE','DEU','276','Germany'),('GH','GHA','288','Ghana'),('GI','GIB','292','Gibraltar'),('GR','GRC','300','Greece'),('GL','GRL','304','Greenland'),('GD','GRD','308','Grenada'),('GP','GLP','312','Guadaloupe'),('GU','GUM','316','Guam'),('GT','GTM','320','Guatemala'),('GG','GGY','831','Guernsey'),('GN','GIN','324','Guinea'),('GW','GNB','624','Guinea-Bissau'),('GY','GUY','328','Guyana'),('HT','HTI','332','Haiti'),('HM','HMD','334','Heard Island and McDonald Islands'),('HN','HND','340','Honduras'),('HK','HKG','344','Hong Kong'),('HU','HUN','348','Hungary'),('IS','ISL','352','Iceland'),('IN','IND','356','India'),('ID','IDN','360','Indonesia'),('IR','IRN','364','Iran'),('IQ','IRQ','368','Iraq'),('IE','IRL','372','Ireland'),('IM','IMN','833','Isle of Man'),('IL','ISR','376','Israel'),('IT','ITA','380','Italy'),('JM','JAM','388','Jamaica'),('JP','JPN','392','Japan'),('JE','JEY','832','Jersey'),('JO','JOR','400','Jordan'),('KZ','KAZ','398','Kazakhstan'),('KE','KEN','404','Kenya'),('KI','KIR','296','Kiribati'),('XK','','','Kosovo'),('KW','KWT','414','Kuwait'),('KG','KGZ','417','Kyrgyzstan'),('LA','LAO','418','Laos'),('LV','LVA','428','Latvia'),('LB','LBN','422','Lebanon'),('LS','LSO','426','Lesotho'),('LR','LBR','430','Liberia'),('LY','LBY','434','Libya'),('LI','LIE','438','Liechtenstein'),('LT','LTU','440','Lithuania'),('LU','LUX','442','Luxembourg'),('MO','MAC','446','Macao'),('MK','MKD','807','Macedonia'),('MG','MDG','450','Madagascar'),('MW','MWI','454','Malawi'),('MY','MYS','458','Malaysia'),('MV','MDV','462','Maldives'),('ML','MLI','466','Mali'),('MT','MLT','470','Malta'),('MH','MHL','584','Marshall Islands'),('MQ','MTQ','474','Martinique'),('MR','MRT','478','Mauritania'),('MU','MUS','480','Mauritius'),('YT','MYT','175','Mayotte'),('MX','MEX','484','Mexico'),('FM','FSM','583','Micronesia'),('MD','MDA','498','Moldava'),('MC','MCO','492','Monaco'),('MN','MNG','496','Mongolia'),('ME','MNE','499','Montenegro'),('MS','MSR','500','Montserrat'),('MA','MAR','504','Morocco'),('MZ','MOZ','508','Mozambique'),('MM','MMR','104','Myanmar (Burma)'),('NA','NAM','516','Namibia'),('NR','NRU','520','Nauru'),('NP','NPL','524','Nepal'),('NL','NLD','528','Netherlands'),('NC','NCL','540','New Caledonia'),('NZ','NZL','554','New Zealand'),('NI','NIC','558','Nicaragua'),('NE','NER','562','Niger'),('NG','NGA','566','Nigeria'),('NU','NIU','570','Niue'),('NF','NFK','574','Norfolk Island'),('KP','PRK','408','North Korea'),('MP','MNP','580','Northern Mariana Islands'),('NO','NOR','578','Norway'),('OM','OMN','512','Oman'),('PK','PAK','586','Pakistan'),('PW','PLW','585','Palau'),('PS','PSE','275','Palestine'),('PA','PAN','591','Panama'),('PG','PNG','598','Papua New Guinea'),('PY','PRY','600','Paraguay'),('PE','PER','604','Peru'),('PH','PHL','608','Phillipines'),('PN','PCN','612','Pitcairn'),('PL','POL','616','Poland'),('PT','PRT','620','Portugal'),('PR','PRI','630','Puerto Rico'),('QA','QAT','634','Qatar'),('RE','REU','638','Reunion'),('RO','ROU','642','Romania'),('RU','RUS','643','Russia'),('RW','RWA','646','Rwanda'),('BL','BLM','652','Saint Barthelemy'),('SH','SHN','654','Saint Helena'),('KN','KNA','659','Saint Kitts and Nevis'),('LC','LCA','662','Saint Lucia'),('MF','MAF','663','Saint Martin'),('PM','SPM','666','Saint Pierre and Miquelon'),('VC','VCT','670','Saint Vincent and the Grenadines'),('WS','WSM','882','Samoa'),('SM','SMR','674','San Marino'),('ST','STP','678','Sao Tome and Principe'),('SA','SAU','682','Saudi Arabia'),('SN','SEN','686','Senegal'),('RS','SRB','688','Serbia'),('SC','SYC','690','Seychelles'),('SL','SLE','694','Sierra Leone'),('SG','SGP','702','Singapore'),('SX','SXM','534','Sint Maarten'),('SK','SVK','703','Slovakia'),('SI','SVN','705','Slovenia'),('SB','SLB','90','Solomon Islands'),('SO','SOM','706','Somalia'),('ZA','ZAF','710','South Africa'),('GS','SGS','239','South Georgia and the South Sandwich Isl'),('KR','KOR','410','South Korea'),('SS','SSD','728','South Sudan'),('ES','ESP','724','Spain'),('LK','LKA','144','Sri Lanka'),('SD','SDN','729','Sudan'),('SR','SUR','740','Suriname'),('SJ','SJM','744','Svalbard and Jan Mayen'),('SZ','SWZ','748','Swaziland'),('SE','SWE','752','Sweden'),('CH','CHE','756','Switzerland'),('SY','SYR','760','Syria'),('TW','TWN','158','Taiwan'),('TJ','TJK','762','Tajikistan'),('TZ','TZA','834','Tanzania'),('TH','THA','764','Thailand'),('TL','TLS','626','Timor-Leste (East Timor)'),('TG','TGO','768','Togo'),('TK','TKL','772','Tokelau'),('TO','TON','776','Tonga'),('TT','TTO','780','Trinidad and Tobago'),('TN','TUN','788','Tunisia'),('TR','TUR','792','Turkey'),('TM','TKM','795','Turkmenistan'),('TC','TCA','796','Turks and Caicos Islands'),('TV','TUV','798','Tuvalu'),('UG','UGA','800','Uganda'),('UA','UKR','804','Ukraine'),('AE','ARE','784','United Arab Emirates'),('GB','GBR','826','United Kingdom'),('US','USA','840','United States'),('UM','UMI','581','United States Minor Outlying Islands'),('UY','URY','858','Uruguay'),('UZ','UZB','860','Uzbekistan'),('VU','VUT','548','Vanuatu'),('VA','VAT','336','Vatican City'),('VE','VEN','862','Venezuela'),('VN','VNM','704','Vietnam'),('VG','VGB','92','Virgin Islands, British'),('VI','VIR','850','Virgin Islands, US'),('WF','WLF','876','Wallis and Futuna'),('EH','ESH','732','Western Sahara'),('YE','YEM','887','Yemen'),('ZM','ZMB','894','Zambia'),('ZW','ZWE','716','Zimbabwe')

LOCATION: /Library/WebServer/Documents/sellvana/FCom/Geo/Migrate.php:20 There was an error, please check the output or log file and try again.

Click here to continue

2014-05-26T00:58:55+00:00

Comments (8)

Boris Gurvich
Thank you for the report, what was the exact error?
- 2014-05-14T20:37:21+00:00
Boris Gurvich
- changed status to resolved
Please check with the latest commit
- 2014-05-14T22:57:33+00:00
Dragan Vuletic
bug still present in latest code. The problem is in FCom_Geo module, Migrate.php~~#48~~ The record for Kosovo does not contain numcode value "('XK','','','Kosovo')"
- 2014-05-18T15:17:40+00:00
Anshuman Bhartiya
I see the same error:

Migrating modules DB structure...

[1/17] Installing FCom_Geo: 0.1.1 ... *0.1.1;

SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'numcode' at row 117

QUERY: replace into fcom_geo_country (iso,iso3,numcode,name) values ('AF','AFG','4','Afghanistan'),('AX','ALA','248','Aland Islands'),('AL','ALB','8','Albania'),('DZ','DZA','12','Algeria'),('AS','ASM','16','American Samoa'),('AD','AND','20','Andorra'),('AO','AGO','24','Angola'),('AI','AIA','660','Anguilla'),('AQ','ATA','10','Antarctica'),('AG','ATG','28','Antigua and Barbuda'),('AR','ARG','32','Argentina'),('AM','ARM','51','Armenia'),('AW','ABW','533','Aruba'),('AU','AUS','36','Australia'),('AT','AUT','40','Austria'),('AZ','AZE','31','Azerbaijan'),('BS','BHS','44','Bahamas'),('BH','BHR','48','Bahrain'),('BD','BGD','50','Bangladesh'),('BB','BRB','52','Barbados'),('BY','BLR','112','Belarus'),('BE','BEL','56','Belgium'),('BZ','BLZ','84','Belize'),('BJ','BEN','204','Benin'),('BM','BMU','60','Bermuda'),('BT','BTN','64','Bhutan'),('BO','BOL','68','Bolivia'),('BQ','BES','535','Bonaire, Sint Eustatius and Saba'),('BA','BIH','70','Bosnia and Herzegovina'),('BW','BWA','72','Botswana'),('BV','BVT','74','Bouvet Island'),('BR','BRA','76','Brazil'),('IO','IOT','86','British Indian Ocean Territory'),('BN','BRN','96','Brunei'),('BG','BGR','100','Bulgaria'),('BF','BFA','854','Burkina Faso'),('BI','BDI','108','Burundi'),('KH','KHM','116','Cambodia'),('CM','CMR','120','Cameroon'),('CA','CAN','124','Canada'),('CV','CPV','132','Cape Verde'),('KY','CYM','136','Cayman Islands'),('CF','CAF','140','Central African Republic'),('TD','TCD','148','Chad'),('CL','CHL','152','Chile'),('CN','CHN','156','China'),('CX','CXR','162','Christmas Island'),('CC','CCK','166','Cocos (Keeling) Islands'),('CO','COL','170','Colombia'),('KM','COM','174','Comoros'),('CG','COG','178','Congo'),('CK','COK','184','Cook Islands'),('CR','CRI','188','Costa Rica'),('CI','CIV','384','Cote d\'ivoire (Ivory Coast)'),('HR','HRV','191','Croatia'),('CU','CUB','192','Cuba'),('CW','CUW','531','Curacao'),('CY','CYP','196','Cyprus'),('CZ','CZE','203','Czech Republic'),('CD','COD','180','Democratic Republic of the Congo'),('DK','DNK','208','Denmark'),('DJ','DJI','262','Djibouti'),('DM','DMA','212','Dominica'),('DO','DOM','214','Dominican Republic'),('EC','ECU','218','Ecuador'),('EG','EGY','818','Egypt'),('SV','SLV','222','El Salvador'),('GQ','GNQ','226','Equatorial Guinea'),('ER','ERI','232','Eritrea'),('EE','EST','233','Estonia'),('ET','ETH','231','Ethiopia'),('FK','FLK','238','Falkland Islands (Malvinas)'),('FO','FRO','234','Faroe Islands'),('FJ','FJI','242','Fiji'),('FI','FIN','246','Finland'),('FR','FRA','250','France'),('GF','GUF','254','French Guiana'),('PF','PYF','258','French Polynesia'),('TF','ATF','260','French Southern Territories'),('GA','GAB','266','Gabon'),('GM','GMB','270','Gambia'),('GE','GEO','268','Georgia'),('DE','DEU','276','Germany'),('GH','GHA','288','Ghana'),('GI','GIB','292','Gibraltar'),('GR','GRC','300','Greece'),('GL','GRL','304','Greenland'),('GD','GRD','308','Grenada'),('GP','GLP','312','Guadaloupe'),('GU','GUM','316','Guam'),('GT','GTM','320','Guatemala'),('GG','GGY','831','Guernsey'),('GN','GIN','324','Guinea'),('GW','GNB','624','Guinea-Bissau'),('GY','GUY','328','Guyana'),('HT','HTI','332','Haiti'),('HM','HMD','334','Heard Island and McDonald Islands'),('HN','HND','340','Honduras'),('HK','HKG','344','Hong Kong'),('HU','HUN','348','Hungary'),('IS','ISL','352','Iceland'),('IN','IND','356','India'),('ID','IDN','360','Indonesia'),('IR','IRN','364','Iran'),('IQ','IRQ','368','Iraq'),('IE','IRL','372','Ireland'),('IM','IMN','833','Isle of Man'),('IL','ISR','376','Israel'),('IT','ITA','380','Italy'),('JM','JAM','388','Jamaica'),('JP','JPN','392','Japan'),('JE','JEY','832','Jersey'),('JO','JOR','400','Jordan'),('KZ','KAZ','398','Kazakhstan'),('KE','KEN','404','Kenya'),('KI','KIR','296','Kiribati'),('XK','','','Kosovo'),('KW','KWT','414','Kuwait'),('KG','KGZ','417','Kyrgyzstan'),('LA','LAO','418','Laos'),('LV','LVA','428','Latvia'),('LB','LBN','422','Lebanon'),('LS','LSO','426','Lesotho'),('LR','LBR','430','Liberia'),('LY','LBY','434','Libya'),('LI','LIE','438','Liechtenstein'),('LT','LTU','440','Lithuania'),('LU','LUX','442','Luxembourg'),('MO','MAC','446','Macao'),('MK','MKD','807','Macedonia'),('MG','MDG','450','Madagascar'),('MW','MWI','454','Malawi'),('MY','MYS','458','Malaysia'),('MV','MDV','462','Maldives'),('ML','MLI','466','Mali'),('MT','MLT','470','Malta'),('MH','MHL','584','Marshall Islands'),('MQ','MTQ','474','Martinique'),('MR','MRT','478','Mauritania'),('MU','MUS','480','Mauritius'),('YT','MYT','175','Mayotte'),('MX','MEX','484','Mexico'),('FM','FSM','583','Micronesia'),('MD','MDA','498','Moldava'),('MC','MCO','492','Monaco'),('MN','MNG','496','Mongolia'),('ME','MNE','499','Montenegro'),('MS','MSR','500','Montserrat'),('MA','MAR','504','Morocco'),('MZ','MOZ','508','Mozambique'),('MM','MMR','104','Myanmar (Burma)'),('NA','NAM','516','Namibia'),('NR','NRU','520','Nauru'),('NP','NPL','524','Nepal'),('NL','NLD','528','Netherlands'),('NC','NCL','540','New Caledonia'),('NZ','NZL','554','New Zealand'),('NI','NIC','558','Nicaragua'),('NE','NER','562','Niger'),('NG','NGA','566','Nigeria'),('NU','NIU','570','Niue'),('NF','NFK','574','Norfolk Island'),('KP','PRK','408','North Korea'),('MP','MNP','580','Northern Mariana Islands'),('NO','NOR','578','Norway'),('OM','OMN','512','Oman'),('PK','PAK','586','Pakistan'),('PW','PLW','585','Palau'),('PS','PSE','275','Palestine'),('PA','PAN','591','Panama'),('PG','PNG','598','Papua New Guinea'),('PY','PRY','600','Paraguay'),('PE','PER','604','Peru'),('PH','PHL','608','Phillipines'),('PN','PCN','612','Pitcairn'),('PL','POL','616','Poland'),('PT','PRT','620','Portugal'),('PR','PRI','630','Puerto Rico'),('QA','QAT','634','Qatar'),('RE','REU','638','Reunion'),('RO','ROU','642','Romania'),('RU','RUS','643','Russia'),('RW','RWA','646','Rwanda'),('BL','BLM','652','Saint Barthelemy'),('SH','SHN','654','Saint Helena'),('KN','KNA','659','Saint Kitts and Nevis'),('LC','LCA','662','Saint Lucia'),('MF','MAF','663','Saint Martin'),('PM','SPM','666','Saint Pierre and Miquelon'),('VC','VCT','670','Saint Vincent and the Grenadines'),('WS','WSM','882','Samoa'),('SM','SMR','674','San Marino'),('ST','STP','678','Sao Tome and Principe'),('SA','SAU','682','Saudi Arabia'),('SN','SEN','686','Senegal'),('RS','SRB','688','Serbia'),('SC','SYC','690','Seychelles'),('SL','SLE','694','Sierra Leone'),('SG','SGP','702','Singapore'),('SX','SXM','534','Sint Maarten'),('SK','SVK','703','Slovakia'),('SI','SVN','705','Slovenia'),('SB','SLB','90','Solomon Islands'),('SO','SOM','706','Somalia'),('ZA','ZAF','710','South Africa'),('GS','SGS','239','South Georgia and the South Sandwich Isl'),('KR','KOR','410','South Korea'),('SS','SSD','728','South Sudan'),('ES','ESP','724','Spain'),('LK','LKA','144','Sri Lanka'),('SD','SDN','729','Sudan'),('SR','SUR','740','Suriname'),('SJ','SJM','744','Svalbard and Jan Mayen'),('SZ','SWZ','748','Swaziland'),('SE','SWE','752','Sweden'),('CH','CHE','756','Switzerland'),('SY','SYR','760','Syria'),('TW','TWN','158','Taiwan'),('TJ','TJK','762','Tajikistan'),('TZ','TZA','834','Tanzania'),('TH','THA','764','Thailand'),('TL','TLS','626','Timor-Leste (East Timor)'),('TG','TGO','768','Togo'),('TK','TKL','772','Tokelau'),('TO','TON','776','Tonga'),('TT','TTO','780','Trinidad and Tobago'),('TN','TUN','788','Tunisia'),('TR','TUR','792','Turkey'),('TM','TKM','795','Turkmenistan'),('TC','TCA','796','Turks and Caicos Islands'),('TV','TUV','798','Tuvalu'),('UG','UGA','800','Uganda'),('UA','UKR','804','Ukraine'),('AE','ARE','784','United Arab Emirates'),('GB','GBR','826','United Kingdom'),('US','USA','840','United States'),('UM','UMI','581','United States Minor Outlying Islands'),('UY','URY','858','Uruguay'),('UZ','UZB','860','Uzbekistan'),('VU','VUT','548','Vanuatu'),('VA','VAT','336','Vatican City'),('VE','VEN','862','Venezuela'),('VN','VNM','704','Vietnam'),('VG','VGB','92','Virgin Islands, British'),('VI','VIR','850','Virgin Islands, US'),('WF','WLF','876','Wallis and Futuna'),('EH','ESH','732','Western Sahara'),('YE','YEM','887','Yemen'),('ZM','ZMB','894','Zambia'),('ZW','ZWE','716','Zimbabwe')

LOCATION: /Library/WebServer/Documents/sellvana/FCom/Geo/Migrate.php:20 There was an error, please check the output or log file and try again.

Click here to continue
- 2014-05-26T00:58:55+00:00
Boris Gurvich
Fixed Issue ~~#76~~

→ <<cset 9f70d9a3e8ea>>
- 2014-05-26T01:04:56+00:00
Boris Gurvich
Please try again with the latest commit
- 2014-05-26T01:05:05+00:00
Anshuman Bhartiya
I cloned the repo. Restarted Apache, MySQL and tried to access http://127.0.0.1/sellvana/index.php/ but I am still getting the same error. Am I missing something?

How do I start again?
- 2014-05-26T01:18:13+00:00
Boris Gurvich
Usually regular git pull and page refresh works
- 2014-05-26T01:19:08+00:00
Log in to comment