×
Spørsmål angående Zen Cart som ikke passer inn i andre kategorier.
postens service pakke
postens service pakke opprettet av tøffe
jeg får opp denne feilen når jeg prøver å laste opp sql filen.
jeg har lagt inn postnr
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 'DEFAULT CHARSET=utf8 AUTO_INCREMENT=49' at line 1
in:
[CREATE TABLE posten_postnr ( id int(11) NOT NULL auto_increment, sted_id int(11) NOT NULL default '0', fra_nr int(4) NOT NULL default '0', til_nr int(4) NOT NULL default '0', PRIMARY KEY (id), KEY sted_id (sted_id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=49 ;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
noen som vet hva som er galt?
jeg har lagt inn postnr
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 'DEFAULT CHARSET=utf8 AUTO_INCREMENT=49' at line 1
in:
[CREATE TABLE posten_postnr ( id int(11) NOT NULL auto_increment, sted_id int(11) NOT NULL default '0', fra_nr int(4) NOT NULL default '0', til_nr int(4) NOT NULL default '0', PRIMARY KEY (id), KEY sted_id (sted_id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=49 ;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
noen som vet hva som er galt?
11/05/2007 11:18
#1139
Vennligst Logg inn eller Registrer konto for å bli med i samtalen.
- tøffe
- Emneforfatter
- Besøkende
-
Besvart av Stian Nilsen i emne Sv:postens service pakke
Forsøk å stryk \"DEFAULT CHARSET=utf8\" fra SQL filen og prøv på nytt.
11/05/2007 23:13
#1142
Vennligst Logg inn eller Registrer konto for å bli med i samtalen.
- Stian Nilsen
- Besøkende
-
Besvart av tøffe i emne Sv:postens service pakke
nå får jeg opp en annen feilmelding
1062 Duplicate entry '1' for key 1
in:
[INSERT INTO posten_postnr (id, sted_id, fra_nr, til_nr) VALUES (1, 1, 0, 1499), (2, 1, 1900, 2099), (3, 2, 2100, 2299), (4, 3, 2300, 2451), (5, 3, 2600, 2629), (6, 3, 2800, 2899), (7, 4, 2452, 2599), (8, 5, 2630, 2699), (9, 6, 2900, 2999), (10, 7, 1500, 1899), (11, 8, 3000, 3079), (12, 8, 3300, 3499), (13, 9, 2700, 2799), (14, 9, 3500, 3599), (15, 10, 3600, 3699), (16, 11, 3080, 3299), (17, 12, 3700, 3999), (18, 13, 4800, 4999), (19, 14, 4600, 4799), (20, 15, 4400, 4599), (21, 16, 4000, 4199), (22, 16, 4300, 4399), (23, 17, 4200, 4299), (24, 17, 5400, 5599), (25, 18, 5600, 5699), (26, 19, 5000, 5399), (27, 19, 5800, 5999), (28, 20, 5700, 5799), (29, 21, 6800, 6849), (30, 21, 6900, 6999), (31, 22, 6100, 6199), (32, 22, 6700, 6799), (33, 23, 6850, 6899), (34, 24, 6000, 6099), (35, 24, 6200, 6299), (36, 25, 6300, 6499), (37, 26, 6500, 6699), (38, 27, 7600, 7999), (39, 28, 7000, 7599), (40, 29, 8000, 8299), (41, 30, 8600, 8999), (42, 31, 9000, 9299), (43, 32, 9300, 9399), (44, 33, 8300, 8599), (45, 33, 9400, 9499), (46, 34, 9500, 9669), (47, 35, 9670, 9799), (48, 36, 9800, 9999);]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
1062 Duplicate entry '1' for key 1
in:
[INSERT INTO posten_postnr (id, sted_id, fra_nr, til_nr) VALUES (1, 1, 0, 1499), (2, 1, 1900, 2099), (3, 2, 2100, 2299), (4, 3, 2300, 2451), (5, 3, 2600, 2629), (6, 3, 2800, 2899), (7, 4, 2452, 2599), (8, 5, 2630, 2699), (9, 6, 2900, 2999), (10, 7, 1500, 1899), (11, 8, 3000, 3079), (12, 8, 3300, 3499), (13, 9, 2700, 2799), (14, 9, 3500, 3599), (15, 10, 3600, 3699), (16, 11, 3080, 3299), (17, 12, 3700, 3999), (18, 13, 4800, 4999), (19, 14, 4600, 4799), (20, 15, 4400, 4599), (21, 16, 4000, 4199), (22, 16, 4300, 4399), (23, 17, 4200, 4299), (24, 17, 5400, 5599), (25, 18, 5600, 5699), (26, 19, 5000, 5399), (27, 19, 5800, 5999), (28, 20, 5700, 5799), (29, 21, 6800, 6849), (30, 21, 6900, 6999), (31, 22, 6100, 6199), (32, 22, 6700, 6799), (33, 23, 6850, 6899), (34, 24, 6000, 6099), (35, 24, 6200, 6299), (36, 25, 6300, 6499), (37, 26, 6500, 6699), (38, 27, 7600, 7999), (39, 28, 7000, 7599), (40, 29, 8000, 8299), (41, 30, 8600, 8999), (42, 31, 9000, 9299), (43, 32, 9300, 9399), (44, 33, 8300, 8599), (45, 33, 9400, 9499), (46, 34, 9500, 9669), (47, 35, 9670, 9799), (48, 36, 9800, 9999);]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
14/05/2007 14:40
#1152
Vennligst Logg inn eller Registrer konto for å bli med i samtalen.
- tøffe
- Emneforfatter
- Besøkende
-
Besvart av Stian Nilsen i emne Sv:postens service pakke
Fordi tabellen allerede har blitt lagt til. Slett den og prøv på nytt.
14/05/2007 19:30
#1154
Vennligst Logg inn eller Registrer konto for å bli med i samtalen.
- Stian Nilsen
- Besøkende
-