Sry for the trouble

if someone dun mind,pls explain to me and teach me how to fix this,i got it when i tried to add in 9999 seller

1062 - Duplicate entry '978854' for key 1
1062 - Duplicate entry '978857' for key 1
1062 - Duplicate entry '978868' for key 1
1062 - Duplicate entry '978875' for key 1
1062 - Duplicate entry '978870' for key 1
1062 - Duplicate entry '978859' for key 1
1062 - Duplicate entry '978877' for key 1
1062 - Duplicate entry '978881' for key 1
1062 - Duplicate entry '978883' for key 1
1062 - Duplicate entry '978885' for key 1
1062 - Duplicate entry '978890' for key 1
1062 - Duplicate entry '99997' for key 1

thx alot ppl^^

you have to run a query to delete those, or delete them manually, and then run the script again

the easiest i do when it comes to duplicates is like ibeatuall said delete those existing lines or change the INSERT TO to REPLACE and done ;)

Quote:

Originally Posted by ibeatuall you have to run a query to delete those, or delete them manually, and then run the script again

Quote:

Originally Posted by cyberghoser1 the easiest i do when it comes to duplicates is like ibeatuall said delete those existing lines or change the INSERT TO to REPLACE and done ;)

how u guys can know about if this ids is important or not ??

Quote:

Originally Posted by DestinyFate if someone dun mind,pls explain to me and teach me how to fix this,i got it when i tried to add in 9999 seller 1062 - Duplicate entry '978854' for key 1 1062 - Duplicate entry '978857' for key 1 1062 - Duplicate entry '978868' for key 1 1062 - Duplicate entry '978875' for key 1 1062 - Duplicate entry '978870' for key 1 1062 - Duplicate entry '978859' for key 1 1062 - Duplicate entry '978877' for key 1 1062 - Duplicate entry '978881' for key 1 1062 - Duplicate entry '978883' for key 1 1062 - Duplicate entry '978885' for key 1 1062 - Duplicate entry '978890' for key 1 1062 - Duplicate entry '99997' for key 1 thx alot ppl^^

just change this ids for new ones

incorrect zspider, if the ids are duplicate it means they already exist, this does not mean they are correct or incorrect but since its about the 9900 seller he can do that without anything to loose.

ya it's mean like this..?
delete from cq_action where id >=978854 and id <=978890;

Quote:

Originally Posted by PraDevil ya it's mean like this..? delete from cq_action where id =978854 and id=978890;

An id can never be both 978854 and 978890 at the same time so that query will not work. Looks like you need to use "or" or use "between" depending on what you are trying to do.

and this?
delete from cq_action where id >=978854 and id <=978890;

or this?

delete from cq_action where id =978854;
delete from cq_action where id =978890;
............

thx everyone,its fixed ^^ now another prob lol,i dunno which files ip i have to change to host,non hamachi,now i messed up and my account server is not link with my npc and msg server anymore

Quote:

Originally Posted by DestinyFate thx everyone,its fixed ^^ now another prob lol,i dunno which files ip i have to change to host,non hamachi,now i messed up and my account server is not link with my npc and msg server anymore

From the "How to setup a server!" Sticky:
Everything that says [Hamachi IP] just change use your external IP for non-hamachi.

Quote:

Originally Posted by Drenferalis You need to edit the following files: C:\Server\mannequin\Server\GameServer\config.ini  Spoiler Code: ; ÅäÖÃÎļþ [System] SERVERNAME = [Server Name] MONSTER_ACTIVE_LIMIT = 4000 [GameServer] GAMESERVER_IP = [HAMACHI IP Address] GAMESERVER_PORT = 5816 SND_SIZE = 64000 RCV_SIZE = 16000 [Database] DB_IP = 127.0.0.1 DB_USER = root DB_PW = test DB_NAME = my [InternetPort] MASTER_IP = [Hamachi IP Address] MASTER_PORT = 8653 PORT_SIZE = 53 LOGIN_KEY = dfkKO23k'[cvK934 CURRENT_PORTID = 2 [BusySleep] LEVEL1 = 20 ; > 1000 sleep 20% LEVEL2 = 30 ; > 2000 LEVEL3 = 40 ; > 3000 LEVEL4 = 50 ; > 4000 LEVEL5 = 60 ; > 5000 C:\Server\mannequin\Server\GameServer\shell.ini  Spoiler Code: ; Íâ¿ÇÅäÖÃÎļþ ; 2002.10.23 [System] MAPGROUP_SIZE = 1 ACCEPT_MS = 500 [StreamType] TYPE = 0 ;0=Õý³£´ÓSOCKET£¬1=SOCKET¼Ç¼µ½Îļþ, 2=´ÓÎļþ¶Á(³ÌÐòµ÷ÊÔÓÃ) [Database] DB_IP = 127.0.0.1 DB_USER = root DB_PW = test DB_DB = my [AccountServer] ACCOUNT_IP = [Hamachi IP Address] ACCOUNT_PORT = 9865 SERVERNAME = [Server Name] LOGINNAME = root PASSWORD = test ; µÇ¼±í³ß´ç, 10-5000 MAXLOGINTABLESIZE=1500 ; µÇ¼±í³¬Ê±ÃëÊý£¬0-86400 LOGINOVERTIMESECS=120 [InternetPort] MASTER_IP = [Hamachi IP Address] MASTER_PORT = 8653 PORT_SIZE = 53 LOGIN_KEY = dfkKO23k'[cvK934 CURRENT_PORTID = 1 C:\Server\mannequin\Server\ACCServer\config.ini  Spoiler Code: [System] LOGINLISTENPORT = 9958 POINTLISTENPORT = 9865 SERVER_FULL_DELAY_SECS = 5000 SERVER_BUSY_DELAY_SECS = 3000 SERVERNAME = [Server Name] LOGINNAME = root PASSWORD = test SERVERIP = [Hamachi IP Address] [Database] DBHOSTNAME=127.0.0.1 DATABASENAME=my DBUSER=root DBPASSWORD=test C:\Server\mannequin\Server\ACCServer\account.ini  Spoiler Code: [Account1] SERVERNAME=[SERVER NAME] LOGINNAME=root PASSWORD=test FREE_DEBUG=3 Then you need to use a HEX EDITOR to edit: C:\Server\mannequin\Server\GameServer\shell.dat  Spoiler [Only registered and activated users can see links. Click Here To Register...] ... Now you can edit your OEM.ini and OEM.dat, they are in the same format so if you delete oem.dat and modify oem.ini you can make a copy of that one and make the copy oem.dat C:\Server\ini\oem.ini  Spoiler Code: [Oem] Id=2010 ; maybe something else can be here? [AccountSetup] Type=1 [ServerInfo] URL=http://acme.servegame.com/ ;I leave this alone [ServerStatus] Link=http://acme.servegame.com/ ;I leave this alone too [Header] GroupAmount=1 Group1=[Your Company or Server Group Name] [Group1] ServerAmount=[# of servers] Server1=[Server Name] Ip1=[Hamachi IP] Pic1=Server1 ServerName1=[Server Name] ;if more than one server remove the ";" from the beginning of each line and enter your info ;Server2=[Server Name] ;Ip2=[Hamachi IP] ;Pic2=Server2 ;ServerName2=[Server Name]

Quote:

Originally Posted by King_Arthur From the "How to setup a server!" Sticky: Everything that says [Hamachi IP] just change use your external IP for non-hamachi.

thx alot^^,so i change all this on my files or the one i let ppl download?or both?sorry again :o

just for make sure..if u make your server wit hamachi..the people must connect to your hamachi;)

Both. Also, if you have a router you need to configure it to forward the ports to your host computer.