SQL Problem on Field Server
Does anyone knows how to fix this problem on SQL query?
I can't figure it out.
My Session and Login is OK.
Thanks in advance guys...i hope you could help me...
Service Provider:CHINA
CreateIoCompletionPort OK
INFO:SQL_ATTR_CONNECTION_POOLING OK
INFO:SQLAllocHandle OK
User DB Open OK
Game DB Open OK
Log DB Open OK
Shop DB Open OK
Database Thread Create OK
Log Database Thread Create OK
User Database Thread Create OK
--------------- System Information -------------------
Microsoft Windows 7 or Windows Server 2008 R2
Multi Core Processor Detected 2345 Mhz
4 System Processor Detected
------------------------------------------------------
4 Worker Thread
1 st Worker Thread Create OK
2 st Worker Thread Create OK
3 st Worker Thread Create OK
4 st Worker Thread Create OK
nProtect GameGuard server DLL load failed
[Gaea Server] Start
PK MODE : 1
DB:SELECT MaxNum, NIDMain, NIDSub, MakeType FROM LogItemMax WITH (NOLOCK) WHERE SGNum=0 AND SvrNum=0 AND FldNum=0
DB:42S02, NativeError:208, [Microsoft][SQL Native Client][SQL Server]Invalid object name 'LogItemMax'.
[Add Map] w_school_04_in_b2.Lev / [15/0]
[Add Map] w_SchoolWar_01.lev / [47/0]
[Add Map] w_school_04_in_b1.Lev / [14/0]
[Add Map] w_ep3_saintB_1F.Lev / [46/0]
[Add Map] w_school_03_in_33.Lev / [142/0]
[Add Map] w_school_04_in_3f.Lev / [13/0]
[Add Map] w_ep3_another_3.Lev / [45/0]
[Add Map] w_school_03_in_31.Lev / [141/0]
[Add Map] w_school_04_in_2f.Lev / [12/0]
[Add Map] w_ep3_another_2.Lev / [44/0]
[Add Map] w_club_c_out.Lev / [204/0]
[Add Map] w_school_04_in_1f.Lev / [11/0]
[Add Map] w_ep3_another_1.Lev / [43/0]
[Add Map] w_school_01_in_31.Lev / [107/0]
[Add Map] w_club_b_out.Lev / [203/0]
[Add Map] w_school_04.Lev / [10/0]
[Add Map] w_ep3_saintB_1B.Lev / [42/0]
[Add Map] w_school_01_in_22.Lev / [106/0]
[Add Map] w_school_03_in_22_2.Lev / [138/0]
[Add Map] w_club_h_out.Lev / [202/0]
[Add Map] w_city_s_03.Lev / [9/0]
[Add Map] w_ep3_saintB_boss2.Lev / [41/0]
[Add Map] w_school_01_in_17.Lev / [105/0]
[Add Map] w_school_03_in_22.Lev / [137/0]
[Add Map] w_club_s_out.Lev / [201/0]
[Add Map] w_school_03.Lev / [8/0]
[Add Map] w_ep3_saintB_boss1.Lev / [40/0]
[Add Map] w_school_01_in_14_2.Lev / [104/0]
[Add Map] w_school_03_in_14.Lev / [136/0]
[Add Map] innerzone_31.lev / [7/0]
[Add Map] w_ep3_saintB_right.Lev / [39/0]
[Add Map] w_school_01_in_14.Lev / [103/0]
[Add Map] w_school_03_in_17.Lev / [135/0]
[Add Map] w_city_s_02.Lev / [6/0]
[Add Map] w_ep3_saintB_left.Lev / [38/0]
[Add Map] w_school_01_trash.Lev / [102/0]
[Add Map] w_school_03_trash.Lev / [134/0]
[Add Map] w_school_02.Lev / [5/0]
[Add Map] w_blue_in_3F.Lev / [21/0]
[Add Map] w_ep3_saintB_90F.Lev / [37/0]
[Add Map] w_school_01_in_08_2.Lev / [101/0]
[Add Map] w_club_b_in.Lev / [213/0]
[Add Map] innerzone_21.lev / [4/0]
[Add Map] w_blue_in_2F.Lev / [20/0]
[Add Map] w_ep3_saintB_50F.Lev / [36/0]
[Add Map] w_ep3_saintB_52F.Lev / [52/0]
[Add Map] w_school_01_in_08.Lev / [100/0]
[Add Map] prison_undercave_02.Lev / [132/0]
[Add Map] w_club_h_in.Lev / [212/0]
[Add Map] w_city_s_01.Lev / [3/0]
[Add Map] w_blue_in_1F.Lev / [19/0]
[Add Map] w_ep3_saintB_30F.Lev / [35/0]
[Add Map] w_ep3_saintB_51F.Lev / [51/0]
[Add Map] w_school_03_in_08_2.Lev / [131/0]
[Add Map] w_club_s_in.Lev / [211/0]
[Add Map] w_Prison_02.Lev / [227/0]
[Add Map] w_school_01.Lev / [2/0]
[Add Map] w_city_D_01.lev / [18/0]
[Add Map] w_sibuya_new.lev / [34/0]
[Add Map] w_school_03_in_08.Lev / [130/0]
[Add Map] ev_underpark2.Lev / [162/0]
[Add Map] w_city_s_tunnel.Lev / [17/0]
[Add Map] undercave_bossroom.Lev / [33/0]
[Add Map] ev_underpark.Lev / [161/0]
[Add Map] innerzone_01.lev / [0/0]
[Add Map] w_city_C_01.Lev / [16/0]
[Add Map] prison_undercave.Lev / [32/0]
[Add Map] w_Special_01.lev / [48/0]
[Add Map] w_cube_lapse_5.Lev / [96/0]
[Add Map] w_school_02_trash2.Lev / [128/0]
[Add Map] w_Wedding.lev / [31/0]
[Add Map] w_cube_lapse_4.Lev / [95/0]
[Add Map] w_school_04_in_b3.Lev / [30/0]
[Add Map] w_cube_lapse_3.Lev / [94/0]
[Add Map] w_school_02_trash.Lev / [126/0]
[Add Map] w_city_E2.lev / [29/0]
[Add Map] w_sibuya_new_v3.Lev / [61/0]
[Add Map] w_cube_lapse_2.Lev / [93/0]
[Add Map] w_school_02_in_33.Lev / [125/0]
[Add Map] w_city_E1.lev / [28/0]
[Add Map] w_cube_lapse_1.Lev / [92/0]
[Add Map] w_school_02_in_31.Lev / [124/0]
[Add Map] w_Prison_01.Lev / [27/0]
[Add Map] w_cube_lapse.Lev / [91/0]
[Add Map] w_school_02_in_17.Lev / [123/0]
[Add Map] w_blue_in_3F_ch3.Lev / [155/0]
[Add Map] W_Tunnel_3.Lev / [26/0]
[Add Map] w_school_02_in_22.Lev / [122/0]
[Add Map] w_blue_in_3F_ch2.Lev / [154/0]
[Add Map] W_Tunnel_4.Lev / [250/0]
[Add Map] w_sibuya_new_v2.Lev / [25/0]
[Add Map] w_school_02_in_08_2.Lev / [121/0]
[Add Map] w_blue_in_2F_ch3.Lev / [153/0]
[Add Map] w_New_suryun.lev / [24/0]
[Add Map] w_school_02_in_08.Lev / [120/0]
[Add Map] w_blue_in_2F_ch2.Lev / [152/0]
[Add Map] w_Total_suryun.lev / [23/0]
[Add Map] w_blue_in_1F_ch3.Lev / [151/0]
[Add Map] w_tradezone1.Lev / [22/0]
[Add Map] w_blue_in_1F_ch2.Lev / [150/0]
[Add Map] w_club_c_in.Lev / [214/0]
DB:SELECT GuNum, ChaNum, GuDeputy, ChaName, GuName, GuRank, GuMoney, GuIncomeMoney, GuMarkVer, GuBattleWin, GuBattleDraw, GuBattleLose, GuBattleLastTime, GuAllianceBattleWin, GuAllianceBattleDraw, GuAllianceBattleLose, GuMakeTime, GuExpireTime, GuAuthorityTime, GuAllianceSec, GuAllianceDis, GuNotice FROM viewGuildInfo
DB:42S02, NativeError:208, [Microsoft][SQL Native Client][SQL Server]Invalid object name 'viewGuildInfo'.
DB:SELECT RegionID, GuNum, RegionTax FROM GuildRegion WITH (NOLOCK) ORDER BY RegionID
DB:42S02, NativeError:208, [Microsoft][SQL Native Client][SQL Server]Invalid object name 'GuildRegion'.
[Gaea Server] Start Succeeded
[Gaea Server] ---------------
Server Update Thread Create OK
WSASocket OK
Bind OK
192.168.2.109:3000
Server Accept Thread Create OK
============================
Session Server Connection OK
============================
INFO:SessionSndSvrInfo 192.168.2.109
INFO:SessionSndSvrInfo 192.168.2.109
NET_MSG_BASE 984
=======================================================
Server Start OK
=======================================================
Re: SQL Problem on Field Server
there's a help section post it there
The error is in your database double check your SQL
3 Attachment(s)
Re: SQL Problem on Field Server
All databases were already ok in ODBC connection...
Example:
Attachment 131118
But the Server Field has a SQL error connecting to the database of RanLog stating this:
Invalid object name 'LogItemMax'.
But when I manually query the database, the table is existing...
Attachment 131119
errors on RanGame1 db:
Invalid object name 'viewGuildInfo'.
Invalid object name 'GuildRegion'
But when I check there is a 'GuildRegion' and no 'viewGuildInfo' table on RanGame1.
Attachment 131120
Anyone encountered this and fixed?
My ODBC connection is ok...
thank you for the support!
Re: SQL Problem on Field Server
Try deleting the tables with error in your SQL :) or Try remaking your ODBC's there's probably an error there :)
Re: SQL Problem on Field Server
missing column on your database or change your database