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?

Forsøk å stryk \"DEFAULT CHARSET=utf8\" fra SQL filen og prøv på nytt.

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.

Fordi tabellen allerede har blitt lagt til. Slett den og prøv på nytt.