hallo
ich wollte heute neue autos in alle neuen autohäuser machen ausser in bayside (botshsop), soweit so gut dann war ich fertig damit und wollte es hochladen da zeigt es mir immer einen fehler beim hochladen an und ich komme da nicht weiter.
hier das script:
DROP TABLE IF EXISTS `carhouses_vehicles`;
CREATE TABLE `carhouses_vehicles` (
`AutohausID` int(50) NOT NULL,
`X` double NOT NULL,
`Y` double NOT NULL,
`Z` double NOT NULL,
`RX` double NOT NULL,
`RY` double NOT NULL,
`RZ` double NOT NULL,
`Preis` int(11) NOT NULL,
`Typ` int(50) NOT NULL,
`Info` varchar(50) NOT NULL,
`Comment` varchar(999) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of carhouses_vehicles
-- ----------------------------
INSERT INTO `carhouses_vehicles` (`AutohausID`, `X`, `Y`, `Z`, `RX`, `RY`, `RZ`, `Preis`, `Typ`, `Info`, `Comment`) VALUES
(1,-1400.5999755859,-220.10000610352,14.199999809265,0,0,318,60000,469,'kleiner\nHelikopter','Sparrow'),
(1,-1393.1999511719,-227.10000610352,14.39999961853,0,0,318,90000,487,'grossser\nHelikopter','Maverick'),
(1,-1372.8000488281,-245.69999694824,15.10000038147,0,0,318,300000,519,'Privatjet','Shamal'),
(1,-1358.0999755859,-260.70001220703,14.699999809265,0,0,318,150000,'kleines\nFlugzeug','Dodo'),
(2,-1947.6999511719,257.89999389648,35.400001525879,0,0,34,30000,551,'Billig\nauto','Merit'),
(2,-1954.3000488281,256.79998779297,35.299999237061,0,0,0,28000,426,'4Sitzer','Premier'),
(2,-1961.5999755859,257.39999389648,35.200000762939,0,0,0,15000,529,'4Sitzer','Willard'),
(2,-1945.6999511719,264.10000610352,35.099998474121,0,0,90,17000,547,'4Sitzer','Primo'),
(2,-1947.3000488281,273.89999389648,35.200000762939,0,0,134,20000,585,'4Sitzer','Emperor'),
(2,-1962.3000488281,301.10000610352,35.200000762939,0,0,270,40000,550,'4Sitzer','Sunrise'),
(2,-1952.9000244141,258.89999389648,41,0,0,0,22000,479,'4Sitzer','Regina'),
(2,-1949.5,273,41,0,0,144,25000,458,'4Sitzer','Solair'),
(3,-1670.3000488281,1206.0999755859,21.10000038147,0,0,274,200000,402,'Sportwagen','Buffalo'),
(3,-1660.0999755859,1205.0999755859,21,0,0,0,850000,411,'Sportwagen','Infernus'),
(3,-1649.4000244141,1206.5999755859,20.89999961853,0,0,60,350000,415,'Sportwagen','Cheetah'),
(3,-1663.3000488281,1220.0999755859,20.89999961853,0,0,208,750000,451,'Sportwagen','Turismo'),
(3,-1649.3000488281,1207.8000488281,13.5,0,0,50,150000,477,'Sportwagen','ZR-350'),
(3,-1664.6999511719,1222,13.5,0,0,226,100000,480,'Sportwagen','Comet'),
(3,-1671.4000244141,1205.8000488281,13.5,0,0,288,120000,'Sportwagen','Windsor'),
(4, -2213.1484375, 2411.6689453125, 0, 0, 0, 42, 179900, 484, 'Segelyacht\n( Mit Koje )', 'Marquis'),
(4, -2223.1516113281, 2400.8994140625, 0, 0, 0, 46, 129900, 454, 'Motoryacht\n( Mit Koje )', 'Tropic'),
(4, -2231.357421875, 2390.7587890625, 0, 0, 0, 44, 27900, 446, 'Speedboot', 'Squalo'),
(4, -2258.015691406, 2419.2734375, 0, 0, 0, 224, 19900, 452, 'Speedboot', 'Speeder'),
(4, -2249.8605957031, 2423.9106445313, 0, 0, 0, 224, 7900, 473, 'Schlauchboot', 'Dinghy'),
(4, -2239.6242675781, 2440.6728515625, 0, 0, 0, 226, 42500, 493, 'Speedboot', 'Jetmax');
Alles anzeigen
hier der error der immer angezeigt wird:
-- ------------------------------ Records of carhouses_vehicles-- ----------------------------INSERT INTO `carhouses_vehicles` (`AutohausID`, `X`, `Y`, `Z`, `RX`, `RY`, `RZ`, `Preis`, `Typ`, `Info`, `Comment`) VALUES(1,-1400.5999755859,-220.10000610352,14.199999809265,0,0,318,60000,469,'kleiner\nHelikopter','Sparrow'), (1,-1393.1999511719,-227.10000610352,14.39999961853,0,0,318,90000,487,'grossser\nHelikopter','Maverick'),(1,-1372.8000488281,-245.69999694824,15.10000038147,0,0,318,300000,519,'Privatjet','Shamal'),(1,-1358.0999755859,-260.70001220703,14.699999809265,0,0,318,150000,'kleines\nFlugzeug','Dodo'),(2,-1947.6999511719,257.89999389648,35.400001525879,0,0,34,30000,551,'Billig\nauto','Merit'),(2,-1954.3000488281,256.79998779297,35.299999237061,0,0,0,28000,426,'4Sitzer','Premier'),(2,-1961.5999755859,257.39999389648,35.200000762939,0,0,0,15000,529,'4Sitzer','Willard'),(2,-1945.6999511719,264.10000610352,35.099998474121,0,0,90,17000,547,'4Sitzer','Primo'),[...]
MySQL meldet: