News:

Looking for documentation? Take a look on our wiki

Main Menu

New States/Provinces lists to add in installation

Started by Pisu, November 07, 2007, 12:48:37 PM

Previous topic - Next topic

Pisu

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.
Pisu - Team VMItalia (Supporto Italiano VirtueMart)
www.stefanobagnatica.it | www.vmitalia.net

dirab51

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.


Pisu

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.
Pisu - Team VMItalia (Supporto Italiano VirtueMart)
www.stefanobagnatica.it | www.vmitalia.net