Как исправить проблемы с SQL в MU online: перенос сервера и ODBC записи

Автор VATA, 2016 Дек. 19, 20:00

« назад - далее »

0 Пользователи и 1 гость просматривают эту тему.

Ключевые слова [SEO] mu onlinesql serverodbcисправление ошибок

VATA

Люди. Такая проблема: перенес сервер на другую машину и сервер перестал нормально запускаться вот логи. Подскажите в чем проблема и как исправить


Лог ГС.
Спойлер
LoginServer connect IP( 127.0.0.1 )
EventChip Connect IP [ 127.0.0.1 ]
DataServer connect IP( 127.0.0.1 ) PORT ( 55960 )
DataServer connect IP( 127.0.0.1 ) PORT ( 55962 )
GameServer create PORT ( 55901 )
[CastleSiege] CCastleSiege::DataRequest() - REQUEST DATA FIRST
[GensSystem] Request Update Info !
[20:48:30] [CastleSiege] CCastleSiege::LoadData() - Siege Schedule Start Date (2016-12-19)
[20:48:30] [CastleSiege] CCastleSiege::LoadData() - Siege Schedule Date (7-0-0)
[20:48:30] [CastleSiege] CCastleSiege::LoadData() - Siege Schedule End Date (2016-12-26(0:0:0)
[20:48:30] [CastleSiege] CCastleSiege::Init() - START
[ CRYWOLF ] SYNC Occupation: 0, State: 0
[20:48:30] [ Crywolf ][ ApplyDBInfo] OccupationState : 1
[GensSystem] Information recieved!
[GensSystem] Sync Update Time. [191] min remain
RUN ProcState_REGSIEGE()    LEFT-MSEC:97830000
LEFT : SEC(515490), SIEGE-DAY(2016-12-25 19:59:30)
[ KANTURU ][ Map Attr Change ] Map(0) State(0) DetailState(0)
[ KANTURU ] State(0) -> STANDBY
[ KANTURU ][ BattleStanby ] State(0) -> START
[20:48:30] [ KANTURU ][ TimeAttackEvent ] Date:20161219, Counter:1
[ RAKLION ] State(10) -> IDLE
[GensSystem] Request Update Info !
[GensSystem] Information recieved!
[GensSystem] Sync Update Time. [191] min remain
[GensSystem] Request Update Info !
[GensSystem] Information recieved!
[GensSystem] Sync Update Time. [191] min remain
[GensSystem] Request Update Info !
[свернуть]


И лог Мультисервера:
Спойлер
[19:42:16] [ MuOnline ] connection successful !
[19:42:16] [ MuOnline ] connection successful !
[19:42:16] [ JoinServer ] created on port [ 55970 ]
[19:42:16] [ MuOnline ] connection successful !
[19:42:16] [ MuOnline ] Party Matching connection successful !
[19:42:16] [ MuOnline ] Guild Matching connection successful !
[19:42:16] [ DataServer ] created on port [ 55960 ]
[19:42:16] [CashShop] Loaded 139 packages!
[19:42:16] [CashShop] Loaded 149 products!
[19:42:16] [ MuOnline ] connection successful !
[19:42:16] [ CashShopServer ] created on port [ 55821 ]
[19:42:39] [ GameServer1 ][ 127.0.0.1:55901 ] GameServer Connect
[19:42:39] SELECT ItemCount FROM GameServerInfo WHERE Number = 0
[19:42:40] [ GameServer1 ][ 127.0.0.1:55901 ] GameServer Connect
[19:42:41] EXEC WZ_CS_GetCastleTotalInfo 0, 7
[19:42:41] EXEC WZ_CS_GetCastleNpcInfo 0
[19:42:41] EXEC WZ_CW_InfoLoad 0
[19:42:41] exec GensServerInfo 0,30,7
[19:42:41] SQLSTATE:42000, SQLSTRING:[Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure 'GensServerInfo'.
[19:42:41] DELETE FROM MuCastle_NPC WHERE MAP_SVR_GROUP = 0
[19:42:41] EXEC WZ_CS_ReqNpcBuy 0, 283, 2, 0, 0, 400000, 400000, 94, 182, 1
[19:42:41] EXEC WZ_CS_ReqNpcBuy 0, 283, 3, 0, 0, 400000, 400000, 82, 130, 1
[19:42:41] EXEC WZ_CS_ReqNpcBuy 0, 283, 4, 0, 0, 400000, 400000, 107, 130, 1
[19:42:41] EXEC WZ_CS_ReqNpcBuy 0, 277, 1, 0, 0, 500000, 500000, 93, 204, 1
[19:42:41] EXEC WZ_CS_ReqNpcBuy 0, 277, 2, 0, 0, 500000, 500000, 81, 161, 1
[19:42:41] EXEC WZ_CS_ReqNpcBuy 0, 277, 3, 0, 0, 500000, 500000, 107, 161, 1
[19:42:41] EXEC WZ_CS_ReqNpcBuy 0, 277, 4, 0, 0, 500000, 500000, 67, 114, 1
[19:42:41] EXEC WZ_CS_ReqNpcBuy 0, 277, 5, 0, 0, 500000, 500000, 93, 114, 1
[19:42:41] EXEC WZ_CS_ReqNpcBuy 0, 277, 6, 0, 0, 500000, 500000, 119, 114, 1
[19:42:41] EXEC WZ_CS_ResetCastleSiege 0
[19:42:42] exec GensServerInfo 0,30,7
[19:42:42] SQLSTATE:42000, SQLSTRING:[Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure 'GensServerInfo'.
[19:42:43] exec GensServerInfo 0,30,7
[19:42:43] SQLSTATE:42000, SQLSTRING:[Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure 'GensServerInfo'.
[19:42:44] exec GensServerInfo 0,30,7
[19:42:44] SQLSTATE:42000, SQLSTRING:[Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure 'GensServerInfo'.
[19:42:45] exec GensServerInfo 0,30,7
[19:42:45] SQLSTATE:42000, SQLSTRING:[Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure 'GensServerInfo'.
[19:42:46] exec GensServerInfo 0,30,7
[свернуть]

demagoc

Твоя проблема в ODBC записи
[19:42:45] SQLSTATE:42000, SQLSTRING:[Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure

Перерегистрируй ODBC.reg или поправь руками в самом ODBC драйвере

VATA

Цитата: demagoc от 2016 Дек. 19, 21:42  Твоя проблема в ODBC записи
[19:42:45] SQLSTATE:42000, SQLSTRING:[Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure

Перерегистрируй ODBC.reg или поправь руками в самом ODBC драйвере

А где именно править в какой именно записи? GensServerInfo такой процедуры нету

demagoc


Похожие темы (5)

Сообщений: 17
Просмотров: 15424

Сообщений: 189
Просмотров: 70924

Сообщений: 16
Просмотров: 10502