Sry for the trouble

03/28/2010 03:10 DestinyFate#1
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^^
03/28/2010 03:18 ~WARNING~#2
you have to run a query to delete those, or delete them manually, and then run the script again
03/28/2010 11:35 cyberghoser1#3
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 ;)
03/28/2010 16:03 zspider#4
Quote:
Originally Posted by ibeatuall View Post
you have to run a query to delete those, or delete them manually, and then run the script again
Quote:
Originally Posted by cyberghoser1 View Post
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 View Post
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
03/28/2010 16:07 cyberghoser1#5
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.
03/28/2010 17:20 PraDevil[ELITE]#6
ya it's mean like this..?
delete from cq_action where id >=978854 and id <=978890;
03/28/2010 18:46 King_Arthur#7
Quote:
Originally Posted by PraDevil View Post
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.
03/28/2010 18:59 PraDevil[ELITE]#8
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;
............
03/28/2010 19:57 DestinyFate#9
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
03/28/2010 20:26 King_Arthur#10
Quote:
Originally Posted by DestinyFate View Post
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 View Post
You need to edit the following files:


C:\Server\mannequin\Server\GameServer\config.ini
C:\Server\mannequin\Server\GameServer\shell.ini
C:\Server\mannequin\Server\ACCServer\config.ini
C:\Server\mannequin\Server\ACCServer\account.ini
Then you need to use a HEX EDITOR to edit:
C:\Server\mannequin\Server\GameServer\shell.dat


...

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
03/29/2010 00:04 DestinyFate#11
Quote:
Originally Posted by King_Arthur View Post
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
03/29/2010 02:48 PraDevil[ELITE]#12
just for make sure..if u make your server wit hamachi..the people must connect to your hamachi;)
03/29/2010 05:10 King_Arthur#13
Both. Also, if you have a router you need to configure it to forward the ports to your host computer.