Life is Feudal Official Forum

[Pavel3]

I have a problem with dedicated server setup.
There is an error with patch.sql
When I start servers it shuts down after patching the database with error

Code: Select all

 <initServer> [0] CmServerInfoManager::_applyDbPatch() - validation of patch file execution failed


When I try to patch database myself using patch.sql I get an error

Code: Select all

ERROR 1064 (42000) at line 6: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 15


I hink there is problem with delimeters like in new.sql

[Pavel3]

Okay. I've managed to fix patch errors.
Servers starts and after message "Steam initialized" it started a cycle of some weird SQL requests

Code: Select all

WARN 2019-06-17 22:55:27.668 {} <<Thread>> [] DB::noRS(1 ms) START TRANSACTION; [T:DBIGuildsProcess:14460]
WARN 2019-06-17 22:55:27.668 {} <<Thread>> [] DB::noRS(0 ms) UPDATE guild_actions_queue set OwnerConnectionID = CONNECTION_ID(), OwnedTimestamp = CURRENT_TIMESTAMP() where OwnerConnectionID = 0 limit 10; [T:DBIGuildsProcess:14460]
WARN 2019-06-17 22:55:27.668 {} <<Thread>> [] DB::RS(0 ms) SELECT   `ID`, `TicketID`, `ActionType`, `ProducerCharID`, `GuildID`, `CharID`, `GuildName`, `GuildTag`, `GuildCharter`, `GuildTypeID`, `CharIsKicked`, `CharGuildRoleID`,   `OtherGuildID`, `StandingTypeID`, `UnmovableObjectID`, `ClaimID`, `HeraldryID`, `CanEnter`, `CanBuild`, `CanClaim`, `CanUse`, `CanDestroy` FROM `guild_actions_queue` where OwnerConnectionID = CONNECTION_ID()  ORDER BY `ID` [T:DBIGuildsProcess:14460]
WARN 2019-06-17 22:55:27.668 {} <<Thread>> [] DB::noRS(0 ms) COMMIT; [T:DBIGuildsProcess:14460]


When I try to connect to server directly client shows me "Waiting for server" message and nothing else