View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0007031 | OXID eShop (all versions) | 6. ------ Setup ------- | public | 2019-09-11 15:38 | 2019-09-12 09:30 |
| Reporter | kaistrecker | Assigned To | |||
| Priority | low | Severity | minor | Reproducibility | always |
| Status | acknowledged | Resolution | open | ||
| Summary | 0007031: For Mexico there are no states stored in OXID, which can lead to problems with PayPal. | ||||
| Description | No 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 - | ||||
| Tags | No 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', '', '');
| ||||
| Theme | Not defined | ||||
| Browser | Not defined | ||||
| PHP Version | Not defined | ||||
| Database Version | Not defined | ||||
|
|
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', '', ''); |
