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 z source game

dawiiiiiid879

Rekomendowane odpowiedzi

dawiiiiiid879 Uczeń

dawiiiiiid879

Opublikowano
Uczeń

dawiiiiiid879

Opublikowano

Witam serdecznie. 

 

Walczę z poważnym błędem, który rozwala mi logowanie do gry. Serwer stoi na VPSie od tygodnia. Logowanie (11002), Channel1 (13000) działa bez zarzutu, do pewnego momentu gry. Później logując się podczas wyboru postaci wyrzuca mnie z gry. 

 

Do tej pory pracowałem na gotowcu game od terenzo i problem również się powtarzał, kiedy serwer postał dłużej niż kilkanaście godzin.

W związku z tym błędem postanowiłem przejść na source game i db. Niestety problem nie ustąpił. 

 

Uważam, że problem powinien zostać rzetelnie omówiony, gdyż przeszukując kilkanaście innych tematów dotyczących podobnego problemu, nie znalazłem konkretnego rozwiązania, ani nawet pomysłu. Będzie dla potomnych.

 

db syserr.txt

 

 

SYSERR: Aug 26 01:08:41 :: pid_init:
Start of pid: 1381

SYSERR: Aug 26 01:08:41 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Aug 26 01:08:45 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT empire, pid, name, money, windate FROM monarch a, player b where a.pid=b.id
SYSERR: Aug 26 03:40:05 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:05 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:10 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:10 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:10 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:10 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:15 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:15 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:15 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:15 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:15 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:15 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:20 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:20 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:20 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:20 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:20 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:20 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:20 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:20 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:25 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:25 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:25 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:25 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:25 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:25 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:25 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:25 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:25 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:25 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:30 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:30 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:30 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:30 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:30 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:30 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:30 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:30 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:30 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:30 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:30 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:30 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:35 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:35 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:35 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:35 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:35 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:35 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:35 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:35 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:35 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:35 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:35 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:35 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:35 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:35 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:40 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:40 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:40 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:40 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:40 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:40 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:40 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:40 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:40 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:40 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:40 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:40 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:40 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:40 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:40 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:40 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:45 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:45 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:45 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:45 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:45 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:45 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:45 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:45 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:45 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:45 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:45 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:45 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:45 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:45 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:45 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:45 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:45 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:45 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:50 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:50 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:50 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:50 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:50 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:50 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:50 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:50 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:50 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:50 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:50 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:50 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:50 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:50 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:50 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:50 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:50 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:50 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:50 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:50 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:55 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:55 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:55 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:55 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:55 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:55 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:55 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:55 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:55 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:55 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:55 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:55 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:55 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:55 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:55 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:55 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:55 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:55 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:55 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:55 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:55 :: ChildLoop: AsyncSQL: query failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2002)
SYSERR: Aug 26 03:40:55 :: ChildLoop: AsyncSQL: retrying
SYSERR: Aug 26 03:40:55 :: Process: FDWATCH: peer null in event: ident 20
SYSERR: Aug 26 03:40:59 :: ChildLoop: MySQL connection was reconnected. querying locale set

 

 

auth syserr.txt

 

 

SYSERR: Aug 26 01:08:47 :: pid_init: 
Start of pid: 1389
 
SYSERR: Aug 26 01:08:47 :: ChildLoop: AsyncSQL: query failed: Table 'account.string' doesn't exist (query: SELECT name, text FROM string errno: 1146)
SYSERR: Aug 26 01:08:47 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'time' at row 1 (query: INSERT INTO bootlog (time, hostname, channel) VALUES(NOW(), 'auth', 1) errno: 1264)
SYSERR: Aug 26 11:41:44 :: ChildLoop: MySQL connection was reconnected. querying locale set
SYSERR: Aug 26 11:41:44 :: DirectQuery: MySQL connection was reconnected. querying locale set

 
komenda ps w ftp

[[email protected]<script data-cfhash='f9e31' type="text/javascript">/* */</script>(~)]>  ps
 PID TT  STAT    TIME COMMAND
1075 v0  Is+  0:00.00 /usr/libexec/getty Pc ttyv0
1076 v1  Is+  0:00.00 /usr/libexec/getty Pc ttyv1
1077 v2  Is+  0:00.00 /usr/libexec/getty Pc ttyv2
1078 v3  Is+  0:00.00 /usr/libexec/getty Pc ttyv3
1079 v4  Is+  0:00.00 /usr/libexec/getty Pc ttyv4
1080 v5  Is+  0:00.00 /usr/libexec/getty Pc ttyv5
1081 v6  Is+  0:00.00 /usr/libexec/getty Pc ttyv6
1082 v7  Is+  0:00.00 /usr/libexec/getty Pc ttyv7
1381  0- I    0:58.71 ./db
1383  0- I    7:50.51 ./ch11 (game)
1387  0- I    3:39.46 ./ch99 (game)
1389  0- I    3:29.79 ./auth (game)
3703  1  Ss   0:00.02 -bash (bash)
3705  1  R+   0:00.00 ps

 
 

 

dawiiiiiid879 Uczeń

dawiiiiiid879

Opublikowano
Uczeń

dawiiiiiid879

  • Autor
Opublikowano

Niestety, to nic nie daje. 'account.string' nie istnieje. 

Dodam, że z w tej kwestii nic tu nie kręciłem. Analiza  tabelki account.account =status OK (przykładowo) ale tabelka account.string nie istnieje w mojej bazie danych (nie usuwałem jej, nie było jej, pliki serwerowe wgrane razem z bazą)

 

EDIT: Wyszukałem temat, na którym wlasnie w plikach serwerowych Terenzo. Ludzie usuwają te tabelki. Tylko pytanie po co?

 

Link do tematu: http://www.mpcforum.pl/topic/1235604-pliki-serwerowe-terenzo/           (na samej górze w najlepszych odpowiedziach)

Pesi Pasjonat

Pesi

Opublikowano
Pasjonat

Pesi

Opublikowano

Otwórz Navicat'a zaloguj się do bazy danych 

i stwórz tabele account.string :D

PPM na nazwe w navi jak już się zalogujesz i Console...

wklej to :

CREATE TABLE `string` (
`name` varchar(64) NOT NULL DEFAULT '',
`text` text,
PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Pozdro

POSTY: [50] [75] [100] [150] [200] [250] [300] [350] [400] [450] [500] [550] [600] [650] [700] [750] [800] [850] [900] [950] [1000]


1817914831025941486533.png


 Ważne !   Pisząc/Odpisując wpisz w poście @Pesi

dawiiiiiid879 Uczeń

dawiiiiiid879

Opublikowano
Uczeń

dawiiiiiid879

  • Autor
Opublikowano

Właśnie zrobiłem to już wcześniej i pomogło, dziękuję. Syserror.txt czyste jak łza!

 

 

Kaczor ms. : Naprawa zbugowanej tabelki również pomogła wyeliminować błędy na serwerze. Chodzi o błąd

 

 

SYSERR: Aug 26 01:08:45 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT empire, pid, name, money, windate FROM monarch a, player b where a.pid=b.id

Zarchiwizowany

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

Tematy
×
×
  • Dodaj nową pozycję...