View Issue Details

IDProjectCategoryView StatusLast Update
0007031OXID eShop (all versions)6. ------ Setup -------public2019-09-12 09:30
Reporterkaistrecker 
PrioritylowSeverityminorReproducibilityalways
Status acknowledgedResolutionopen 
Product Version 
Target VersionFixed in Version 
Summary0007031: For Mexico there are no states stored in OXID, which can lead to problems with PayPal.
DescriptionNo states are deposited in OXID for Mexico. This means that you cannot pay via PayPal, because PayPal returns an error message if no state is specified.
I have attached a file with SQL queries, which adapt the database accordingly.
I took the states and country codes directly from the PayPal website: https://developer.paypal.com/docs/api/reference/state-codes/#mexico .
Additional Information- es -
TagsNo tags attached.
ThemeNot defined
BrowserNot defined
PHP VersionNot defined
MySQL VersionNot defined

Activities

kaistrecker

2019-09-11 15:38

reporter  

QA

2019-09-12 09:30

administrator   ~0012996

ALTER TABLE `oxstates` CHANGE COLUMN `OXISOALPHA2` `OXISOALPHA2` CHAR(5) NOT NULL DEFAULT '' COMMENT 'SEO short name' AFTER `OXTITLE`;

INSERT INTO `oxstates` (`OXID`, `OXCOUNTRYID`, `OXTITLE`, `OXISOALPHA2`, `OXTITLE_1`, `OXTITLE_2`, `OXTITLE_3`) VALUES
('AGS', '8f241f11095ebf3a6.86388577', 'Aguascalientes', 'AGS', 'Aguascalientes', '', ''),
('BC', '8f241f11095ebf3a6.86388577', 'Baja California', 'BC', 'Baja California', '', ''),
('BCS', '8f241f11095ebf3a6.86388577', 'Baja California Sur', 'BCS', 'Baja California Sur', '', ''),
('CAMP', '8f241f11095ebf3a6.86388577', 'Campeche', 'CAMP', 'Campeche', '', ''),
('CHIS', '8f241f11095ebf3a6.86388577', 'Chiapas', 'CHIS', 'Chiapas', '', ''),
('CHIH', '8f241f11095ebf3a6.86388577', 'Chihuahua', 'CHIH', 'Chihuahua', '', ''),
('CDMX', '8f241f11095ebf3a6.86388577', 'Ciudad de México', 'CDMX', 'Ciudad de México', '', ''),
('COAH', '8f241f11095ebf3a6.86388577', 'Coahuila', 'COAH', 'Coahuila', '', ''),
('COL', '8f241f11095ebf3a6.86388577', 'Colima', 'COL', 'Colima', '', ''),
('DF', '8f241f11095ebf3a6.86388577', 'Distrito Federal', 'DF', 'Distrito Federal', '', ''),
('DGO', '8f241f11095ebf3a6.86388577', 'Durango', 'DGO', 'Durango', '', ''),
('MEX', '8f241f11095ebf3a6.86388577', 'Estado de México', 'MEX', 'Estado de México', '', ''),
('GTO', '8f241f11095ebf3a6.86388577', 'Guanajuato', 'GTO', 'Guanajuato', '', ''),
('GRO', '8f241f11095ebf3a6.86388577', 'Guerrero', 'GRO', 'Guerrero', '', ''),
('HGO', '8f241f11095ebf3a6.86388577', 'Hidalgo', 'HGO', 'Hidalgo', '', ''),
('JAL', '8f241f11095ebf3a6.86388577', 'Jalisco', 'JAL', 'Jalisco', '', ''),
('MICH', '8f241f11095ebf3a6.86388577', 'Michoacán', 'MICH', 'Michoacán', '', ''),
('MOR', '8f241f11095ebf3a6.86388577', 'Morelos', 'MOR', 'Morelos', '', ''),
('NAY', '8f241f11095ebf3a6.86388577', 'Nayarit', 'NAY', 'Nayarit', '', ''),
('NL', '8f241f11095ebf3a6.86388577', 'Nuevo León', 'NL', 'Nuevo León', '', ''),
('OAX', '8f241f11095ebf3a6.86388577', 'Oaxaca', 'OAX', 'Oaxaca', '', ''),
('PUE', '8f241f11095ebf3a6.86388577', 'Puebla', 'PUE', 'Puebla', '', ''),
('QRO', '8f241f11095ebf3a6.86388577', 'Querétaro', 'QRO', 'Querétaro', '', ''),
('ROO', '8f241f11095ebf3a6.86388577', 'Quintana Roo Q', 'ROO', 'Quintana Roo Q', '', ''),
('SLP', '8f241f11095ebf3a6.86388577', 'San Luis Potosí', 'SLP', 'San Luis Potosí', '', ''),
('SIN', '8f241f11095ebf3a6.86388577', 'Sinaloa', 'SIN', 'Sinaloa', '', ''),
('SON', '8f241f11095ebf3a6.86388577', 'Sonora', 'SON', 'Sonora', '', ''),
('TAB', '8f241f11095ebf3a6.86388577', 'Tabasco', 'TAB', 'Tabasco', '', ''),
('TAMPS', '8f241f11095ebf3a6.86388577', 'Tamaulipas', 'TAMPS', 'Tamaulipas', '', ''),
('TLAX', '8f241f11095ebf3a6.86388577', 'Tlaxcala', 'TLAX', 'Tlaxcala', '', ''),
('VER', '8f241f11095ebf3a6.86388577', 'Veracruz', 'VER', 'Veracruz', '', ''),
('YUC', '8f241f11095ebf3a6.86388577', 'Yucatán', 'YUC', 'Yucatán', '', ''),
('ZAC', '8f241f11095ebf3a6.86388577', 'Zacatecas', 'ZAC', 'Zacatecas', '', '');