Task #1533: http://virtuemart.net/index.php?option=com_flyspray&Itemid=91&do=details&task_id=1533
States / Provinces of Spain and Italy are already available in Download Section:
http://virtuemart.net/index.php?option=com_docman&task=doc_download&gid=367&Itemid=66
http://virtuemart.net/index.php?option=com_docman&task=doc_download&gid=176&Itemid=66
So, I'll add them to installation SQL. If there are other states lists available, please let me now. At the moments, there are these states filled in the official VM 1.1.x package:
Australia (8)
Brazil (27)
Canada (13)
China (30)
Israel (3)
Mexico (32)
Netherlands Antilles (3)
Romania (41)
United Kingdom (4)
United States (51)
If anyone can check, if there are some states missing for these countries, and give other states list.
When i try to import to database show this error:
Error
consulta SQL:
INSERT INTO `Spain` ( `196` , `ESP` , `ES` ) VALUES ( 195, 'A Coruna', '15' ) , ( 195, 'Alava', '01' ) , ( 195, 'Albacete', '02' ) , ( 195, 'Alicante', '03' ) , ( 195, 'Almeria', '04' ) , ( 195, 'Asturias', '33' ) , ( 195, 'Avila', '05' ) , ( 195, 'Badajoz', '06' ) , ( 195, 'Baleares', '07' ) , ( 195, 'Barcelona', '08' ) , ( 195, 'Burgos', '09' ) , ( 195, 'Caceres', '10' ) , ( 195, 'Cadiz', '11' ) , ( 195, 'Cantabria', '39' ) , ( 195, 'Castellon', '12' ) , ( 195, 'Ceuta', '51' ) , ( 195, 'Ciudad Real', '13' ) , ( 195, 'Cordoba', '14' ) , ( 195, 'Cuenca', '16' ) , ( 195, 'Girona', '17' ) , ( 195, 'Granada', '18' ) , ( 195, 'Guadalajara', '19' ) , ( 195, 'Guipuzcoa', '20' ) , ( 195, 'Huelva', '21' ) , ( 195, 'Huesca', '22' ) , ( 195, 'Jaen', '23' ) , ( 195, 'La Rioja', '26' ) , ( 195, 'Las Palmas', '35' ) , ( 195, 'Leon', '24' ) , ( 195, 'Lleida', '25' ) , ( 195, 'Lugo', '27' ) , ( 195, 'Madrid', '28' ) , ( 195, 'Malaga', '29' ) , ( 195, 'Melilla', '52' ) , ( 195, 'Murcia', '30' ) , ( 195, 'Navarra', '31' ) , ( 195, 'Ourense', '32' ) , ( 195, 'Palencia', '34' ) , ( 195, 'Pontevedra', '36' ) , ( 195, 'Salamanca', '37' ) , ( 195, 'Santa Cruz de Tenerife', '38' ) , ( 195, 'Segovia', '40' ) , ( 195, 'Sevilla', '41' ) , ( 195, 'Soria', '42' ) , ( 195, 'Tarragona', '43' ) , ( 195, 'Teruel', '44' ) , ( 195, 'Toledo', '45' ) , ( 195, 'Valencia', '46' ) , ( 195, 'Valladolid', '47' ) , ( 195, 'Vizcaya', '48' ) , ( 195, 'Zamora', '49' ) , ( 195, 'Zaragoza', '50' ) ;
MySQL ha dicho:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO `Spain` ( `196`, `ESP`, `ES`) VALUES
(195, 'A Coruna', '15'),
(1' at line 1
thanks.
If you are using VM 1.1 rev 1062, those states are installed.
Quote from: dirab51 on November 30, 2007, 09:57:14 AM
INSERT INTO `Spain` ( `196` , `ESP` , `ES` ) VALUES ...
Insert into Spain???? There is not a "Spain" table!!!! If you are using VM 1.0, please use correctly the existing Spain package.