|
You last visited: Today at 20:55
Advertisement
Sry for the trouble
Discussion on Sry for the trouble within the EO PServer Hosting forum part of the Eudemons Online category.
03/28/2010, 03:10
|
#1
|
elite*gold: 0 
Join Date: Mar 2010
Posts: 13
Received Thanks: 0
|
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^^
|
|
|
|
03/28/2010, 03:18
|
#2
|
elite*gold: 5
Join Date: Feb 2010
Posts: 1,040
Received Thanks: 442
|
you have to run a query to delete those, or delete them manually, and then run the script again
|
|
|
|
|
03/28/2010, 11:35
|
#3
|
elite*gold: 0
Join Date: Jan 2006
Posts: 504
Received Thanks: 1,069
|
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
|
#4
|
elite*gold: 0
Join Date: Sep 2009
Posts: 416
Received Thanks: 131
|
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
|
|
|
|
|
03/28/2010, 16:07
|
#5
|
elite*gold: 0
Join Date: Jan 2006
Posts: 504
Received Thanks: 1,069
|
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
|
#6
|
elite*gold: 0
Join Date: Nov 2009
Posts: 1,486
Received Thanks: 919
|
ya it's mean like this..?
delete from cq_action where id >=978854 and id <=978890;
|
|
|
|
|
03/28/2010, 18:46
|
#7
|
elite*gold: 246
Join Date: Jan 2008
Posts: 1,712
Received Thanks: 896
|
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.
|
|
|
|
|
03/28/2010, 18:59
|
#8
|
elite*gold: 0
Join Date: Nov 2009
Posts: 1,486
Received Thanks: 919
|
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
|
#9
|
elite*gold: 0
Join Date: Mar 2010
Posts: 13
Received Thanks: 0
|
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
|
#10
|
elite*gold: 246
Join Date: Jan 2008
Posts: 1,712
Received Thanks: 896
|
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
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
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
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
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
...
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
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]
|
|
|
|
|
|
03/29/2010, 00:04
|
#11
|
elite*gold: 0
Join Date: Mar 2010
Posts: 13
Received Thanks: 0
|
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 
|
|
|
|
|
03/29/2010, 02:48
|
#12
|
elite*gold: 0
Join Date: Nov 2009
Posts: 1,486
Received Thanks: 919
|
just for make sure..if u make your server wit hamachi..the people must connect to your hamachi
|
|
|
|
|
03/29/2010, 05:10
|
#13
|
elite*gold: 246
Join Date: Jan 2008
Posts: 1,712
Received Thanks: 896
|
Both. Also, if you have a router you need to configure it to forward the ports to your host computer.
|
|
|
|
 |
Similar Threads
|
Trouble ...
08/09/2010 - Metin2 - 2 Replies
i have one little trouble . I play on M2 PL ... and i cant use hack's from elite ... always is error on even dont open ... I have win vista n allways run as administrator ? maybe some1 have this same problem .
Greetz
|
having trouble
12/28/2009 - Dekaron - 19 Replies
i`m having trouble lvling..I am just 105.. and I`m making the DOOMED MAZE CQ but its so hard to lvl..anyone knows how to do it faster?..it tkates 5 CQ to 15%..its so anoying.. so if u guys can help me?
|
KTS Trouble
07/28/2009 - Rappelz - 3 Replies
Hello m8s,
Straight to the point -
When I try to register on Rappelz KTS I got this msg:
http://img40.imageshack.us/img40/2787/trob.th.jpg
Pls, any korean speak m8 to translate in english, coz this msg realy make me mad :-)
Friendly:
gubina
|
trouble
06/20/2008 - Eudemons Online - 2 Replies
when i start my client for the private server its all black like the world biggest lag ever, but when i start the orginal eudemons there is no problem at all, can any1 help me out?????
|
SV TROUBLE :(
11/01/2007 - Conquer Online 2 - 13 Replies
guys, i have a running SV 1.17, it works on all of my other accounts except my trojan. whenever i start SV, the trojan just stands there and does not move at all. any help plz? :(
|
All times are GMT +1. The time now is 20:57.
|
|
![PraDevil[ELITE]'s Avatar](https://www.elitepvpers.com/forum/customavatars/avatar1857785_25.gif){kind=avatar}
