Eroare Mysql

[Kingsley]

Cand uploadez baza de date pe localhost imi da eroarea 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
(1, 1, 'The State', 'LS Bank', 1462.49, -1012.63, 26.8438, 2306, -16, 27, 10, 10000000, 1000, 5331172, 0, 0, 8408, 10000, 100, 0),
(2, 1, 'The State', 'B4L Gun Shop Los Santos', 1791.52, -1164.86, 23.8281, 316, -142, 1000, 9, 7000000, 5000, 1746695, 0, 7, 9502, 10000, 100, 0),
(3, 1, 'The State', ' Vicious Club ', 1836.09, -1682.5, 13.3624, 493.46, -24.0736, 1000.68, 4, 4000000, 5000, 173257, 0, 17, 9968, 10000, 100, 0),
(4, 1, 'The State', 'KRYSTAL', 2129.86, -1761.46, 13.5625, -228.27, 1401.07, 27.7656, 3, 100000, 15000, 119777, 0, 18, 9996, 10000, 100, 0),
(5, 1, 'The State', ' Vicious Strip Club ', 2421.41, -1220.3, 25.4937, 1204.83, -13.4011, 1000.92, 3, 3000000, 5000[...]

MySQL zice: Documentație
#1062 - Duplicate entry '1' for key 'PRIMARY'

Cum o rezolv?

[r3played]

Ruleaza query asta inainte de a rula datele din tabelul bizz

 

DELETE FROM bizz;

Daca mai ai probleme posteaza fisierul SQL aici si il reparam noi. Inseamna ca are ceva erori in el

Edited July 8, 2015 by r3played
Cuz i don't want to make "duble" post

[Kingsley]

Nu inteleg unde sa pun.LINK Baza de date:  http://www.solidfiles.com/d/60b49dff04/UNNIC_db.sql

[r3played]

Am reparat fisierul SQL insa l-am facut de asa fel incat atunci cand il rulezi o sa iti faca clean install.

Adica nu il folosi decat doar daca vrei sa faci server nou sau vrei sa dai wipe la tot db, adica sa resetez tot la stadiul de inceput (clean install)

Import has been successfully finished, 52 queries executed. (UNNIC_db.sql)

UNNIC_db_Clean_install.sql

[Kingsley]

Acu ma uit pe el ca da niste erori si dupa iti dau raspunsul

 

 

Tot nu mere.

 

 

 

 

 

[r3played]

Nu are cum sa nu mearga

Da-mi un paste la eroare

[Kingsley]

PAWN ERROR

C:\Users\VICTOR\Desktop\SERVER.UNNIC\gamemodes\yq10571.pwn(14506) : warning 217: loose indentation
C:\Users\VICTOR\Desktop\SERVER.UNNIC\gamemodes\yq10571.pwn(14510) : warning 217: loose indentation
C:\Users\VICTOR\Desktop\SERVER.UNNIC\gamemodes\yq10571.pwn(15200) : warning 217: loose indentation
C:\Users\VICTOR\Desktop\SERVER.UNNIC\gamemodes\yq10571.pwn(15236) : warning 217: loose indentation
C:\Users\VICTOR\Desktop\SERVER.UNNIC\gamemodes\yq10571.pwn(39820) : warning 217: loose indentation
C:\Users\VICTOR\Desktop\SERVER.UNNIC\gamemodes\yq10571.pwn(39821) : warning 217: loose indentation
C:\Users\VICTOR\Desktop\SERVER.UNNIC\gamemodes\yq10571.pwn(45983) : warning 217: loose indentation
C:\Users\VICTOR\Desktop\SERVER.UNNIC\gamemodes\yq10571.pwn(45984) : warning 217: loose indentation
C:\Users\VICTOR\Desktop\SERVER.UNNIC\gamemodes\yq10571.pwn(46001) : warning 217: loose indentation
C:\Users\VICTOR\Desktop\SERVER.UNNIC\gamemodes\yq10571.pwn(46002) : warning 217: loose indentation
C:\Users\VICTOR\Desktop\SERVER.UNNIC\gamemodes\yq10571.pwn(46018) : warning 217: loose indentation
C:\Users\VICTOR\Desktop\SERVER.UNNIC\gamemodes\yq10571.pwn(46019) : warning 217: loose indentation
C:\Users\VICTOR\Desktop\SERVER.UNNIC\gamemodes\yq10571.pwn(46035) : warning 217: loose indentation
C:\Users\VICTOR\Desktop\SERVER.UNNIC\gamemodes\yq10571.pwn(46036) : warning 217: loose indentation
Pawn compiler 3.2.3664              Copyright (c) 1997-2006, ITB CompuPhase

17 Warnings.

Se compileaza dar de aici cred ca porneste eroarea de la RUN:

RUN ERROR

 

----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3z, (C)2005-2014 SA-MP Team

[12:30:32] password = ""  (string)
[12:30:32] 
[12:30:32] Server Plugins
[12:30:32] --------------
[12:30:32]  Loading plugin: sscanf.so
[12:30:33]   Failed.
[12:30:33]  Loading plugin: streamer.so
[12:30:34]   Failed.
[12:30:34]  Loading plugin: mysql.so
[12:30:34]   Failed.
[12:30:34]  Loading plugin: crashdetect.so
[12:30:34]   Failed.
[12:30:34]  Loaded 0 plugins.

[12:30:34] 
[12:30:34] Ban list
[12:30:34] --------
[12:30:34]  Loaded: samp.ban
[12:30:34] 
[12:30:34] 
[12:30:34] Filterscripts
[12:30:34] ---------------
[12:30:34]   Loading filterscript 'PlayerOn.amx'...
[12:30:34]   Unable to load filterscript 'PlayerOn.amx'.
[12:30:34]   Loaded 0 filterscripts.

[12:30:34] Script[gamemodes/yq10571.amx]: Run time error 19: "File or function is not found"
[12:30:34] Number of vehicle models: 0

[mrtea]

,,Cand uploadez baza de date pe localhost imi da eroarea asta:" din cate vad eu ai zis ca pe localhost dar in log ai pluginurile .so?

[Stefan F.]

Poti te rog sa spui pe ce platforma ai serverul,dar si plugin-urile pe care le ai ?

[Kingsley]

PLUGINS

sscanf.so streamer.so mysql.so crashdetect.so

PLATFORMA

mysql