View Issue Details

IDProjectCategoryView StatusLast Update
0007031OXID eShop (all versions)6. ------ Setup -------public2024-07-03 15:45
Reporterkaistrecker Assigned To 
PrioritylowSeverityminorReproducibilityalways
Status confirmedResolutionopen 
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.
Attached Files
OXID Mexiko Staaten Fix.txt (2,985 bytes)   
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', '', '');
OXID Mexiko Staaten Fix.txt (2,985 bytes)   
ThemeNot defined
BrowserNot defined
PHP VersionNot defined
Database VersionNot defined

Activities

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', '', '');