SQL Errors

[Bagon424]

Hello Everyone
I got my new Shaiya PS up and running, but the client dc`s after Server select.
Here is my PS_DBAGENT__system.log:

 Spoiler

2020-05-05 05:47:18 PS_DBAGENT__system log start (DBAgent01)

2020-05-05 05:47:20 connect game, Name=



2020-05-05 05:47:20 connect game, Name=



2020-05-05 05:47:20 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Ungültiger Spaltenname 'Rank'., SQL STATE: 42S22, NATIVE ERROR: 207 (0xCF)

2020-05-05 05:47:20 LoadGuildList failed qerr=-1, EXEC usp_Read_Guild2_R

2020-05-05 05:47:20 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Ungültiger Spaltenname 'Rank'., SQL STATE: 42S22, NATIVE ERROR: 207 (0xCF)

2020-05-05 05:47:20 LoadGuildList failed qerr=-1, EXEC usp_Read_Guild2_R

2020-05-05 05:47:20 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Ungültiger Spaltenname 'Rank'., SQL STATE: 42S22, NATIVE ERROR: 207 (0xCF)

2020-05-05 05:47:20 LoadGuildList failed qerr=-1, EXEC usp_Read_Guild2_R

2020-05-05 06:05:58 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Server 'PS_USERDB01' konnte in 'sys.servers' nicht gefunden werden. Stellen Sie sicher, dass der richtige Servername angegeben wurde. Führen Sie ggf. die gespeicherte Prozedur 'sp_addlinkedserver' aus, um den Server in 'sys.servers' hinzuzufügen., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)

2020-05-05 06:05:58 ::LoadBillingItem 24 qerr=-1, EXEC usp_Read_Char_Product_Item_E 24

THANKS for any help

[admkraken81]

you have discord or skype?

[Kripteks]

Add this. Edit your sql user pass example: 'Shaiya','Shaiya123'

 Spoiler

if exists(select *
from master..sysservers
where isremote=1 and srvname='PS_USERDB01')
begin
exec sp_dropserver 'PS_USERDB01','droplogins'
end
exec sp_addlinkedserver 'PS_USERDB01','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_USERDB01','false',null,'USER_SQL_SERVER','PASS WORD_SQL_SERVER'

and add new column "Rank" to dbo.Guilds.