falsche country_id in xtcommerce.sql

[Modulfux]

Beim Auräumen der SQL-Installationsdatei ist mir folgende Fehler aufgefallen.

Code: SQL  [Auswählen]

#Pakistan
INSERT INTO zones VALUES ('',99,'KHI','Karachi');
INSERT INTO zones VALUES ('',99,'LH','Lahore');
INSERT INTO zones VALUES ('',99,'ISB','Islamabad');
INSERT INTO zones VALUES ('',99,'QUE','Quetta');
INSERT INTO zones VALUES ('',99,'PSH','Peshawar');
INSERT INTO zones VALUES ('',99,'GUJ','Gujrat');
INSERT INTO zones VALUES ('',99,'SAH','Sahiwal');
INSERT INTO zones VALUES ('',99,'FSB','Faisalabad');
INSERT INTO zones VALUES ('',99,'RIP','Rawal Pindi');
 

Muss aber so lauten:

Code: SQL  [Auswählen]

#Pakistan
INSERT INTO zones VALUES ('',162,'KHI','Karachi');
INSERT INTO zones VALUES ('',162,'LH','Lahore');
INSERT INTO zones VALUES ('',162,'ISB','Islamabad');
INSERT INTO zones VALUES ('',162,'QUE','Quetta');
INSERT INTO zones VALUES ('',162,'PSH','Peshawar');
INSERT INTO zones VALUES ('',162,'GUJ','Gujrat');
INSERT INTO zones VALUES ('',162,'SAH','Sahiwal');
INSERT INTO zones VALUES ('',162,'FSB','Faisalabad');
INSERT INTO zones VALUES ('',162,'RIP','Rawal Pindi');
 

Indien hat die countries_id '92' und Paktistan die '162'. Der Fehler stammt noch von xtCommerce selber und zieht sich durch einige Forks durch.

Gruß
Ronny



Linkback: https://www.modified-shop.org/forum/index.php?topic=12396.0

[Tomcraft]

Tatsache! Echt immer wieder der Hammer, wie so alte Dinger jahrelang unentdeckt bleiben!

Korrigiert in r1893.

Grüße

Torsten

[speedy]

[...]
Indien hat die countries_id '92' und Paktistan die '162'. [...]

In 1.05 und im Trunk hat Indien 99 und nicht 92.
92 ist Guyana.
Pakistan ist 162.

Also nur vorweg der Beschwerde, Torstens Fix ist damit korrekt.

für's Melden.

[Modulfux]

Speedy, das war ein Tippfehler von mir. Indien hat auch die '99', wie es auch in den INSERT-Anweisungen drin steht. Weiß gerade selber nicht, wie ich auf '92' komme.

By the way: Besteht Interesse an einer aktuellen Tabelle für die türkischen Provinzen. Einer meiner Kunden hat mich darauf aufmerksam gemacht.

Gruß
Ronny

[speedy]

An allem, was falsch oder veraltet ist, besteht immer Interesse.

[Modulfux]

Hier die aktuellen türkischen Provinzen.

Code: SQL  [Auswählen]

#Turkey
INSERT INTO zones VALUES ('',215,'Adana' ,'Adana');
INSERT INTO zones VALUES ('',215,'Adiyaman', 'Adiyaman');
INSERT INTO zones VALUES ('',215,'Afyonkarahisar', 'Afyonkarahisar');
INSERT INTO zones VALUES ('',215,'Agri', 'Agri');
INSERT INTO zones VALUES ('',215,'Aksaray', 'Aksaray');
INSERT INTO zones VALUES ('',215,'Amasya', 'Amasya');
INSERT INTO zones VALUES ('',215,'Ankara', 'Ankara');
INSERT INTO zones VALUES ('',215,'Antalya', 'Antalya');
INSERT INTO zones VALUES ('',215,'Ardahan', 'Ardahan');
INSERT INTO zones VALUES ('',215,'Artvin',      'Artvin');
INSERT INTO zones VALUES ('',215,'Aydin' ,'Aydin');
INSERT INTO zones VALUES ('',215,'Balikesir', 'Balikesir');
INSERT INTO zones VALUES ('',215,'Bartin', 'Bartin');
INSERT INTO zones VALUES ('',215,'Batman', 'Batman');
INSERT INTO zones VALUES ('',215,'Bayburt', 'Bayburt');
INSERT INTO zones VALUES ('',215,'Bilecik', 'Bilecik');
INSERT INTO zones VALUES ('',215,'Bingöl', 'Bingöl');
INSERT INTO zones VALUES ('',215,'Bitlis', 'Bitlis');
INSERT INTO zones VALUES ('',215,'Bolu', 'Bolu' );
INSERT INTO zones VALUES ('',215,'Burdur', 'Burdur');
INSERT INTO zones VALUES ('',215,'Bursa', 'Bursa');
INSERT INTO zones VALUES ('',215,'Çanakkale', 'Çanakkale');
INSERT INTO zones VALUES ('',215,'Çankiri', 'Çankiri');
INSERT INTO zones VALUES ('',215,'Çorum' ,'Çorum');
INSERT INTO zones VALUES ('',215,'Denizli' , 'Denizli');
INSERT INTO zones VALUES ('',215,'Diyarbakir', 'Diyarbakir');
INSERT INTO zones VALUES ('',215,'Düzce', 'Düzce');
INSERT INTO zones VALUES ('',215,'Edirne', 'Edirne');
INSERT INTO zones VALUES ('',215,'Elazig', 'Elazig');
INSERT INTO zones VALUES ('',215,'Erzincan', 'Erzincan');
INSERT INTO zones VALUES ('',215,'Erzurum', 'Erzurum');
INSERT INTO zones VALUES ('',215,'Eskisehir', 'Eskisehir');
INSERT INTO zones VALUES ('',215,'Gaziantep', 'Gaziantep');
INSERT INTO zones VALUES ('',215,'Giresun', 'Giresun');
INSERT INTO zones VALUES ('',215,'Gümüshane', 'Gümüshane');
INSERT INTO zones VALUES ('',215,'Hakkari', 'Hakkari');
INSERT INTO zones VALUES ('',215,'Hatay','Hatay');
INSERT INTO zones VALUES ('',215,'Igdir', 'Igdir');
INSERT INTO zones VALUES ('',215,'Isparta', 'Isparta');
INSERT INTO zones VALUES ('',215,'Istanbul','Istanbul');
INSERT INTO zones VALUES ('',215,'Izmir', 'Izmir');
INSERT INTO zones VALUES ('',215,'Kahramanmaras', 'Kahramanmaras');
INSERT INTO zones VALUES ('',215,'Karabük', 'Karabük');
INSERT INTO zones VALUES ('',215,'Karaman', 'Karaman');
INSERT INTO zones VALUES ('',215,'Kars', 'Kars');
INSERT INTO zones VALUES ('',215,'Kastamonu', 'Kastamonu');
INSERT INTO zones VALUES ('',215,'Kayseri', 'Kayseri');
INSERT INTO zones VALUES ('',215,'Kilis', 'Kilis');
INSERT INTO zones VALUES ('',215,'Kirikkale', 'Kirikkale');
INSERT INTO zones VALUES ('',215,'Kirklareli', 'Kirklareli');
INSERT INTO zones VALUES ('',215,'Kirsehir', 'Kirsehir');
INSERT INTO zones VALUES ('',215,'Kocaeli', 'Kocaeli');
INSERT INTO zones VALUES ('',215,'Konya', 'Konya');
INSERT INTO zones VALUES ('',215,'Kütahya' ,'Kütahya');
INSERT INTO zones VALUES ('',215,'Malatya', 'Malatya');
INSERT INTO zones VALUES ('',215,'Manisa', 'Manisa');
INSERT INTO zones VALUES ('',215,'Mardin', 'Mardin');
INSERT INTO zones VALUES ('',215,'Mersin', 'Mersin');
INSERT INTO zones VALUES ('',215,'Mugla', 'Mugla');
INSERT INTO zones VALUES ('',215,'Mus', 'Mus');
INSERT INTO zones VALUES ('',215,'Nevsehir', 'Nevsehir');
INSERT INTO zones VALUES ('',215,'Nigde', 'Nigde');
INSERT INTO zones VALUES ('',215,'Ordu', 'Ordu');
INSERT INTO zones VALUES ('',215,'Osmaniye', 'Osmaniye');
INSERT INTO zones VALUES ('',215,'Rize', 'Rize');
INSERT INTO zones VALUES ('',215,'Sakarya', 'Sakarya');
INSERT INTO zones VALUES ('',215,'Samsun', 'Samsun');
INSERT INTO zones VALUES ('',215,'Sanliurfa', 'Sanliurfa');
INSERT INTO zones VALUES ('',215,'Siirt', 'Siirt');
INSERT INTO zones VALUES ('',215,'Sinop', 'Sinop');
INSERT INTO zones VALUES ('',215,'Sirnak', 'Sirnak');
INSERT INTO zones VALUES ('',215,'Sivas', 'Sivas');
INSERT INTO zones VALUES ('',215,'Tekirdag', 'Tekirdag');
INSERT INTO zones VALUES ('',215,'Tokat', 'Tokat');
INSERT INTO zones VALUES ('',215,'Trabzon', 'Trabzon');
INSERT INTO zones VALUES ('',215,'Tunceli', 'Tunceli');
INSERT INTO zones VALUES ('',215,'Usak', 'Usak');
INSERT INTO zones VALUES ('',215,'Van', 'Van');
INSERT INTO zones VALUES ('',215,'Yalova', 'Yalova');
INSERT INTO zones VALUES ('',215,'Yozgat', 'Yozgat');
INSERT INTO zones VALUES ('',215,'Zonguldak', 'Zonguldak');
 

Quelle: Liste der Provinzen der Türkei

Gruß
Ronny

[Tomcraft]

Danke Ronny, auch das habe ich in r1894 übernommen!

Grüße

Torsten