Author Topic: New States/Provinces lists to add in installation  (Read 5059 times)

Pisu

  • Contributing Developer
  • Jr. Member
  • *
  • Posts: 451
  • ..still looking for..
    • Blog di Stefano Bagnatica
New States/Provinces lists to add in installation
« on: November 07, 2007, 12:48:37 pm »
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

  • Beginner
  • *
  • Posts: 1
Re: New States/Provinces lists to add in installation
« Reply #1 on: November 30, 2007, 09:57:14 am »
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.

aravot

  • Peter
  • Moderator
  • Sr. Member
  • *
  • Posts: 2874
    • VirtueMart Extensions
Re: New States/Provinces lists to add in installation
« Reply #2 on: November 30, 2007, 10:16:27 am »
If you are using VM 1.1 rev 1062, those states are installed.

Pisu

  • Contributing Developer
  • Jr. Member
  • *
  • Posts: 451
  • ..still looking for..
    • Blog di Stefano Bagnatica
Re: New States/Provinces lists to add in installation
« Reply #3 on: November 30, 2007, 10:32:48 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