|
You last visited: Today at 05:27
Advertisement
SQL Errors
Discussion on SQL Errors within the Shaiya PServer Development forum part of the Shaiya Private Server category.
05/05/2020, 06:35
|
#1
|
elite*gold: 0
Join Date: May 2011
Posts: 8
Received Thanks: 0
|
SQL Errors
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:
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
|
|
|
05/05/2020, 12:07
|
#2
|
elite*gold: 0
Join Date: Mar 2019
Posts: 98
Received Thanks: 10
|
you have discord or skype?
|
|
|
05/09/2020, 14:29
|
#3
|
elite*gold: 0
Join Date: May 2020
Posts: 9
Received Thanks: 7
|
Add this. Edit your sql user pass example: 'Shaiya','Shaiya123'
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.
|
|
|
 |
Similar Threads
|
[Help]2 Errors when use SQl
05/19/2013 - Dekaron Private Server - 4 Replies
Hi guyz , i have a problem when i try to make my own server offline with A9 Serverfiles ..
Error 1 ImageShack® - Online Photo and Video Hosting
Error 2 : ImageShack® - Online Photo and Video Hosting
and some have some a9 ServerFile completely because I have are those that are damaged and not descomprim the loginserver.exe winrar
Sorry for my bad eng , but google translate no work perfectly :) .
Thanks for all =)
|
SQL 2012 errors
07/19/2012 - Rappelz Private Server - 6 Replies
I have run a private 6.2 server using sql 2008 just fine, but since the 7.3/4 need sql 2012, ive come up with a problem. It could be minor,
http://img716.imageshack.us/img716/2056/problemuz .png
|
Some Errors in SQL
02/13/2012 - Shaiya Private Server - 8 Replies
err=-1, Fehler beim Konvertieren des varchar-Datentyps in datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)
SaveBuyPointItem 45 *CENSORED* qerr=0, {?=call usp_Save_User_BuyPointItems_NCash(16,45,0,'Brillia nt','2012-02-13 11:42:34')}
Ist im PS_DBAGENT__system.log__* zu finden...
Der Fehler tritt aber nur auf bei kauf von AP Items.
Ein anderer Bug ist:
dc-rollback ( Nach dem DC der Spieler ist ein Rollback )
char erstellung ( Bei Char erstellung DC error 0 )
The error occurs...
|
Vsro Files SQL Time Errors
12/30/2011 - SRO Private Server - 0 Replies
Hey , I have on my server a "timebug" wich is changing automaticilly anyone knows how to fix this i mean to stop auto-changing ?
Also is change Fortress Wars , CTF , Battle Arena time ..
|
[Guide] 2 Fixes on Sro-Errors (no bot-errors)
03/04/2011 - SRO Guides & Templates - 5 Replies
Hey guys,
here are 2 fixes for silkroad-errors (not bot-errors!). I know they dont appear for many people but some guys have problems with it.
1st Fix: "Server is undergoing inspection..."
Why does this error appear?
Because Joymax has some problems with the Login-Servers.
Fix:
Step1): Click on "Start" then on "Run"
|
All times are GMT +1. The time now is 05:28.
|
|