PSMServer_Mgr.exe issue

04/14/2016 12:52 [ADM]Minxii#1
ok i have an odd issue. i am using the server files below and all seemed fine till i started the server manager.
[Only registered and activated users can see links. Click Here To Register...]
as you can see from the picture i have all services installed
[Only registered and activated users can see links. Click Here To Register...]
however the one i am using is missing trees
[Only registered and activated users can see links. Click Here To Register...]
game loads up (using an edited ep6.3 client)with /vckoff and i get this
[Only registered and activated users can see links. Click Here To Register...]
also having an issue with no connection on test with the linked servers(i use mssql 2014). i have exhausted all my own knowledge on this reinstalling servers etc to no avail.
My logs
04/14/2016 13:36 AgustinWoW#2
i had that error but i fixed it installing sql 2005 and if is a ep 6.3 Omega files worked to me
04/14/2016 13:39 [ADM]Minxii#3
ok fixed the psm servermanager issue there were some extra files that needed configuring. now i just DC after server choice ... any ideas?

04/15/2016 07:10 killer2p#4
Your missing your rank Column in guilds
04/17/2016 18:27 wallerus#5
Quote:
Originally Posted by taurian83 View Post
Fixed...ready for this?

"CREATE Proc usp_Read_Guild2_R

AS

SET NOCOUNT ON

SELECT G.GuildID, G.GuildName, G.MasterName, G.Country, G.GuildPoint,
ISNULL(H.Rank,31) Rank, ISNULL(H.Etin,0) Etin, ISNULL(H.UseHouse,0) UseHouse, ISNULL(H.Remark, '') Remark, ISNULL( H.BuyHouse,0) BuyHouse, ISNULL(H.EtinReturnCnt, 0 ) EtinReturnCnt, ISNULL(H.KeepEtin, 0) KeepEtin
FROM Guilds G
LEFT OUTER JOIN GuildDetails H ON G.GuildID = H.GuildID
WHERE G.Del=0
ORDER BY G.Rank DESC

SET NOCOUNT OFF"

Line 14..."G.Rank"...I changed the "G" to an "H" as it is put in line 8

I have since restarted the server on 5 attempts and it has worked each time.

-Syn
Pulled from [Only registered and activated users can see links. Click Here To Register...]. Let us know if it fixes your issue.
04/18/2016 20:52 [ADM]Minxii#6
All fixed thank you all who offered suggestions
i basically reinstalled everything and it workd. also the original issue with the psm server manager i found a psm server config file which was mostly blank with a uacc server name and edited that with details of the server and it all installed and works fine.