Proglema la tabela *bizz* la inportare.

[S1meD.]

Salut SA-MP Romania vreu sa ma ajutati cu o problema care am intimpinato.

 

 

Cind importa baza de date imi zice asta

 

 

-- Salvarea datelor din tabel `bizz`
--
INSERT INTO `bizz` (`ID`, `Owned`, `Owner`, `Message`, `EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `EntranceCost`, `Till`, `Locked`, `Interior`, `Products`, `MaxProducts`, `PriceProd`, `Virtual`) VALUES
(0, 0, 'T45', 'ReyRey Bank', 1462.49, -1012.63, 26.8438, 2306, -16, 27, 10, 10000000, 5000, 9970000, 0, 0, 7930, 10000, 100, 0),
(0, 0, 'Dreamcool', 'Gun Shop Los Santos', 1791.52, -1164.86, 23.8281, 316, -142, 1000, 9, 7000000, 5000, 0, 0, 7, 6734, 10000, 100, 0),
(0, 0, '[ZEW]TaNZer.', 'Triad Head.', 1836.09, -1682.5, 13.3624, 493.46, -24.0736, 1000.68, 4, 100000, 5000, 886213, 0, 17, 9542, 10000, 100, 0),
(0, 0, 'The State', 'La Carciuma [/drink]', 2129.86, -1761.46, 13.5625, -228.27, 1401.07, 27.7656, 3, 100000, 5000, 40235, 0, 18, 9642, 10000, 100, 0),
(0, 0, 'The State', '*** Vicious Strip Club ***', 2421.41, -1220.3, 25.4937, 1204.83, -13.4011, 1000.92, 3, 3000000, 5000, 75332, 0, 2, 976[...]

 

MySQL zice: 

#1062 - Duplicate entry '0' for key 'PRIMARY' 

 

 

Va rog daca puteti sa ma ajutati.

[ARTIST]

Buna seara stimate.

Pentru a nu va oferi multe explicatii si lectii privind lucrul cu platforma MySQL   in acest caz (un text de minim 30-40 randuri), am sa va sugerez urmatoarea metoda de solutionare a problemei dumneavoastra:

 

 

→ Modificati INSERT INTO in REPLACE INTO

Edited February 18, 2015 by ARTIST

[S1meD.]

Am facut ceai zis inport baza de date dar cind deschid serverul numi citesste gm-ul

[WopsS]

Inlocuieste fiecare 0 care este dupa ( si intre ",". Cu un numar de la 1 la infinit. 

 

DOAR primul zero.

[ARTIST]

Am facut ceai zis inport baza de date dar cind deschid serverul numi citesste gm-ul

 

Incercati stimate atunci in felul urmator:

 

INSERT INTO `bizz` (`ID`, `Owned`, `Owner`, `Message`, `EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `EntranceCost`, `Till`, `Locked`, `Interior`, `Products`, `MaxProducts`, `PriceProd`, `Virtual`) VALUES

(1, 0, 'T45', 'ReyRey Bank', 1462.49, -1012.63, 26.8438, 2306, -16, 27, 10, 10000000, 5000, 9970000, 0, 0, 7930, 10000, 100, 0),

(2, 0, 'Dreamcool', 'Gun Shop Los Santos', 1791.52, -1164.86, 23.8281, 316, -142, 1000, 9, 7000000, 5000, 0, 0, 7, 6734, 10000, 100, 0),

(3, 0, '[ZEW]TaNZer.', 'Triad Head.', 1836.09, -1682.5, 13.3624, 493.46, -24.0736, 1000.68, 4, 100000, 5000, 886213, 0, 17, 9542, 10000, 100, 0),

(4, 0, 'The State', 'La Carciuma [/drink]', 2129.86, -1761.46, 13.5625, -228.27, 1401.07, 27.7656, 3, 100000, 5000, 40235, 0, 18, 9642, 10000, 100, 0),

(5, 0, 'The State', '*** Vicious Strip Club ***', 2421.41, -1220.3, 25.4937, 1204.83, -13.4011, 1000.92, 3, 3000000, 5000, 75332, 0, 2, 976[...]

 

 

Adica in ordine crescatoare, de la 1 la X (pana la ultimul biz) modificati toate ID-urile.

 

P.S "Pentru campul "ID" (ale tebelului cu toate bizurile) in Baza dumneavoastra de Date folositi auto_increment"

Edited February 19, 2015 by ARTIST