Skocz do zawartości
  • 👋 Witaj na MPCForum!

    Przeglądasz forum jako gość, co oznacza, że wiele świetnych funkcji jest jeszcze przed Tobą! 😎

    • Pełny dostęp do działów i ukrytych treści
    • Możliwość pisania i odpowiadania w tematach
    • System prywatnych wiadomości
    • Zbieranie reputacji i rozwijanie swojego profilu
    • Członkostwo w jednej z największych społeczności graczy

    👉 Dołączenie zajmie Ci mniej niż minutę – a zyskasz znacznie więcej!

    Zarejestruj się teraz

[PROBLEM]Serwer :(


Rekomendowane odpowiedzi

Opublikowano

Siema ! mam serwer na plikach by mcn cc.pl i tak:

 

wszystko ładnie działało, aż do czasu... :

 

-przekonwertowałem sobie item proto client na serwer, i query dzialaja, portmap ON ale:

 

wpisuje passy i pisze 1-3 sekundy zostaniesz polączony z serwerem i loga mnie do wyboru CH..

 

co jest? jak wgralem stare item_proto to tak samo było. wie ktoś o co chodzi?

 

pozdrawiam

 

 

.syserr z ch1:

 

 

SYSERR: Apr 26 16:39:08 :: SpawnMob: SpawnMob: no mob data for vnum 10102
SYSERR: Apr 26 16:39:10 :: SpawnMob: SpawnMob: no mob data for vnum 10096
SYSERR: Apr 26 16:39:12 :: SpawnMob: SpawnMob: no mob data for vnum 10101
SYSERR: Apr 26 16:39:32 :: SpawnMob: SpawnMob: no mob data for vnum 9013
SYSERR: Apr 26 16:39:35 :: SpawnMob: SpawnMob: no mob data for vnum 10102
SYSERR: Apr 26 16:39:37 :: SpawnMob: SpawnMob: no mob data for vnum 10096
SYSERR: Apr 26 16:39:39 :: SpawnMob: SpawnMob: no mob data for vnum 10101
SYSERR: Apr 26 16:40:02 :: SpawnMob: SpawnMob: no mob data for vnum 10102
SYSERR: Apr 26 16:40:04 :: SpawnMob: SpawnMob: no mob data for vnum 10096
SYSERR: Apr 26 16:40:07 :: SpawnMob: SpawnMob: no mob data for vnum 10101
SYSERR: Apr 26 16:40:26 :: SpawnMob: SpawnMob: no mob data for vnum 9013
SYSERR: Apr 26 16:40:29 :: SpawnMob: SpawnMob: no mob data for vnum 10102
SYSERR: Apr 26 16:40:31 :: SpawnMob: SpawnMob: no mob data for vnum 10096
SYSERR: Apr 26 16:40:34 :: SpawnMob: SpawnMob: no mob data for vnum 10101
SYSERR: Apr 26 16:40:36 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Apr 29 15:17:31 :: socket_connect: HOST 220.95.239.40:7120, could not connect.
SYSERR: Apr 29 15:17:37 :: ReadCommonDropItemFile: No such an item (name: ??+1)
SYSERR: Apr 29 15:17:37 :: Boot: cannot load CommonDropItem: locale/germany/common_drop_item.txt
SYSERR: Apr 29 15:24:49 :: socket_connect: HOST 220.95.239.40:7120, could not connect.
SYSERR: Apr 29 15:24:52 :: ReadCommonDropItemFile: No such an item (name: ??+1)
SYSERR: Apr 29 15:24:52 :: Boot: cannot load CommonDropItem: locale/germany/common_drop_item.txt

 

 

 

syserr z auth:

 

 

SYSERR: Jan  8 15:04:53 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Jan  8 15:16:46 :: SetBilling: cannot find login key 655360
SYSERR: Jan  8 15:17:08 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Jan  8 15:21:58 :: Analyze: Handshake phase does not handle packet 71 (fd 16)
SYSERR: Jan  8 15:21:58 :: Process: SEQUENCE 2890d400 mismatch 0xaf != 0x20 header 71
SYSERR: Jan  8 15:21:58 :: Process: SEQUENCE_LOG [uNKNOWN]-------------
[071 : 0xaf]
SYSERR: Jan  8 15:22:09 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jan  8 15:22:09 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Jan  8 15:22:09 :: socket_block: fcntl: nonblock: Bad file descriptor
SYSERR: Jan  8 15:28:57 :: Analyze: Handshake phase does not handle packet 71 (fd 16)
SYSERR: Jan  8 15:28:57 :: Process: SEQUENCE 2890d400 mismatch 0xaf != 0x20 header 71
SYSERR: Jan  8 15:28:57 :: Process: SEQUENCE_LOG [uNKNOWN]-------------
[071 : 0xaf]
SYSERR: Feb 13 14:34:37 :: socket_connect: HOST 220.95.239.40:7120, could not connect.
SYSERR: Feb 13 14:41:23 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Feb 13 14:41:23 :: socket_connect: HOST 220.95.239.40:7120, could not connect.
SYSERR: Feb 13 15:06:17 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Feb 13 15:06:17 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Feb 13 15:06:17 :: socket_block: fcntl: nonblock: Bad file descriptor
SYSERR: Feb 13 15:06:33 :: socket_connect: HOST 220.95.239.40:7120, could not connect.
SYSERR: Feb 13 15:08:20 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Feb 13 15:08:34 :: ChildLoop: AsyncSQL: query failed: Table 'account.string' doesn't exist (query: SELECT name, text FROM string errno: 1146)
SYSERR: Feb 13 15:08:34 :: socket_connect: HOST 220.95.239.40:7120, could not connect.
SYSERR: Feb 13 15:37:46 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Feb 13 15:40:34 :: socket_connect: HOST 220.95.239.40:7120, could not connect.

 

 

syserr z db:

 

 

SYSERR: Apr 26 15:18:39 :: ChildLoop: AsyncSQL::ChildLoop : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2):
query: REPLACE INTO item (id, owner_id, window, pos, count, vnum) VALUES(10000042, 57700, 1, 14, 200, 27003)
SYSERR: Apr 26 15:18:39 :: ChildLoop: AsyncSQL::ChildLoop : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2):
query: REPLACE INTO item (id, owner_id, window, pos, count, vnum) VALUES(10000042, 57700, 1, 14, 200, 27003)
SYSERR: Apr 26 15:18:39 :: ChildLoop: AsyncSQL::ChildLoop : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2):
query: REPLACE INTO item (id, owner_id, window, pos, count, vnum) VALUES(10000042, 57700, 1, 14, 200, 27003)
SYSERR: Apr 26 15:18:39 :: ChildLoop: AsyncSQL::ChildLoop : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2):
query: REPLACE INTO item (id, owner_id, window, pos, count, vnum) VALUES(10000042, 57700, 1, 14, 200, 27003)
SYSERR: Apr 26 15:18:39 :: ChildLoop: AsyncSQL::ChildLoop : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2):
query: REPLACE INTO item (id, owner_id, window, pos, count, vnum) VALUES(10000042, 57700, 1, 14, 200, 27003)
SYSERR: Apr 26 15:18:39 :: ChildLoop: AsyncSQL::ChildLoop : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2):
query: REPLACE INTO item (id, owner_id, window, pos, count, vnum) VALUES(10000042, 57700, 1, 14, 200, 27003)
SYSERR: Apr 26 15:18:39 :: ChildLoop: AsyncSQL::ChildLoop : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2):
query: REPLACE INTO item (id, owner_id, window, pos, count, vnum) VALUES(10000042, 57700, 1, 14, 200, 27003)
SYSERR: Apr 26 15:18:39 :: ChildLoop: AsyncSQL::ChildLoop : mysql_query error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2):
query: REPLACE INTO item (id, owner_id, window, pos, count, vnum) VALUES(10000042, 57700, 1, 14, 200, 27003)
SYSERR: Apr 26 15:20:07 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Apr 26 15:20:08 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id
SYSERR: Apr 26 15:20:08 :: LoadMonarchCandidacy:  DirectQuery failed(SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id)
SYSERR: Apr 26 15:20:09 :: Load:  DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)
SYSERR: Apr 26 15:29:40 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Apr 26 15:30:00 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Apr 26 15:30:01 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id
SYSERR: Apr 26 15:30:01 :: LoadMonarchCandidacy:  DirectQuery failed(SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id)
SYSERR: Apr 26 15:30:01 :: Load:  DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)
SYSERR: Apr 26 15:30:43 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Apr 26 15:32:31 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Apr 26 15:32:33 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id
SYSERR: Apr 26 15:32:33 :: LoadMonarchCandidacy:  DirectQuery failed(SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id)
SYSERR: Apr 26 15:32:33 :: Load:  DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)
SYSERR: Apr 26 15:36:07 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Apr 26 15:36:08 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id
SYSERR: Apr 26 15:36:08 :: LoadMonarchCandidacy:  DirectQuery failed(SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id)
SYSERR: Apr 26 15:36:08 :: Load:  DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)
SYSERR: Apr 26 15:39:45 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Apr 26 15:39:47 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id
SYSERR: Apr 26 15:39:47 :: LoadMonarchCandidacy:  DirectQuery failed(SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id)
SYSERR: Apr 26 15:39:47 :: Load:  DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)
SYSERR: Apr 26 15:47:28 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Apr 26 15:50:03 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Apr 26 15:50:04 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id
SYSERR: Apr 26 15:50:04 :: LoadMonarchCandidacy:  DirectQuery failed(SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id)
SYSERR: Apr 26 15:50:04 :: Load:  DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)
SYSERR: Apr 26 16:40:36 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Apr 29 15:17:21 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Apr 29 15:17:23 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id
SYSERR: Apr 29 15:17:23 :: LoadMonarchCandidacy:  DirectQuery failed(SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id)
SYSERR: Apr 29 15:17:23 :: Load:  DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)
SYSERR: Apr 29 15:17:31 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='5.115.208.100')
SYSERR: Apr 29 15:17:38 :: Process: FDWATCH: peer null in event: ident 21
SYSERR: Apr 29 15:24:42 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Apr 29 15:24:43 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id
SYSERR: Apr 29 15:24:43 :: LoadMonarchCandidacy:  DirectQuery failed(SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id)
SYSERR: Apr 29 15:24:43 :: socket_bind: bind: Address already in use
SYSERR: Apr 29 15:24:49 :: __GetAdminInfo: __GetAdminInfo() ==> DirectQuery failed(SELECT mID,mAccount,mName,mContactIP,mServerIP,mAuthority FROM gmlist WHERE mServerIP='ALL' or mServerIP='5.115.208.100')
SYSERR: Apr 29 15:24:53 :: Process: FDWATCH: peer null in event: ident 21

 

 

f5

Opublikowano

japierdo**.. jak widzę twoje posty to mnie normalnie przerażają ... zobacz najpierw syserr !!!!

 

czekam na odp. od bardziej dośw. osoby -.-

 

 

rayman, nie zebym mial cos do ciebie, ale pierw czytaj syserr,potem pisz ^^

Opublikowano

Jest problem z komunikacją baza - serwer gry. Na pewno zrobiłeś użytkownika mt2 hasło

*9E9FBD6E1A44E7A46E5738CCA10B00371CB5FA88

z prawami?

 

Po za tym prawdopodobnie auth ci się nie uruchamia, bo popatrz na ostatnią datę

SYSERR: Feb 13 15:40:34

sygnatura2.png


Opublikowano

@Up

 

znaczy się.. hasło do mysql zmieniałem.. ale było wszystko dobrze..

 

a auth? jak je uruchomic :P ? może coś mam z item_proto? lookajcie i pomagajcie ;p

Opublikowano

@up

 

xD .. akurat mam taka sciezke.. a.. napewno mi sie auth nie odpala? bo napisalem na innym forum i gosc napisal takie cos:''

 

ReadCommonDropItemFile: No such an item (name: ??+1)

SYSERR: Apr 29 15:24:52 :: Boot: cannot load CommonDropItem: locale/germany/common_drop_item.txt

 

lub nie moze znalezc tego itemu

(name: ??+1) i jest blad ,dokładnie nie wiem,sproboj wgrywajac czysty plik niemodyfikowany i napisz czy pomoglo

 

 

lecz common_drop_item nie ruszałem wgl..

 

 

help

Opublikowano

@Qentinios

 

xD .. akurat mam taka sciezke.. a.. napewno mi sie auth nie odpala? bo napisalem na innym forum i gosc napisal takie cos:''

 

ReadCommonDropItemFile: No such an item (name: ??+1)

SYSERR: Apr 29 15:24:52 :: Boot: cannot load CommonDropItem: locale/germany/common_drop_item.txt

 

lub nie moze znalezc tego itemu

(name: ??+1) i jest blad ,dokładnie nie wiem,sproboj wgrywajac czysty plik niemodyfikowany i napisz czy pomoglo

 

 

lecz common_drop_item nie ruszałem wgl..

 

 

help

Opublikowano

A to oczywiście że to. Nie zauważyłem tego loga.

 

masz w common dodany item ??+1, a w item_proto przy żadnym przedmiocie w kolumnie name tego nie ma.

sygnatura2.png


Zarchiwizowany

Ten temat przebywa obecnie w archiwum. Dodawanie nowych odpowiedzi zostało zablokowane.

×
×
  • Dodaj nową pozycję...