|
You last visited: Today at 07:15
Advertisement
need help
Discussion on need help within the Shaiya forum part of the MMORPGs category.
02/08/2011, 17:54
|
#1
|
elite*gold: 0
Join Date: Aug 2009
Posts: 47
Received Thanks: 18
|
need help
what is this error someone can help me
err=-1, [Microsoft][ODBC SQL Server Driver]Timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2011-02-08 17:43:54 ::LoadBillingItem 14263 qerr=-1, EXEC usp_Read_Char_Product_Item_E 14273
|
|
|
02/08/2011, 18:08
|
#2
|
elite*gold: 0
Join Date: Jul 2010
Posts: 498
Received Thanks: 449
|
I had this error while setting up my new server it was because of the details in linked server objects, i suggest you delete them all,
then use the following query ( After setting your new details):
Code:
/* Add server link, and Shaiya username */
IF NOT EXISTS (SELECT [name] FROM master.dbo.syslogins WHERE name = 'Shaiya')
BEGIN
EXEC sp_addlogin 'Shaiya', 'Shaiya123', 'PS_GameDefs';
END
EXEC sp_addsrvrolemember 'Shaiya', 'sysadmin';
/* Add linked servers */
IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='game')
BEGIN
EXEC sp_addlinkedserver 'game','','SQLOLEDB','127.0.0.1';
EXEC sp_addlinkedsrvlogin 'game','false',null,'Shaiya','Shaiya123';
END
exec sp_serveroption @server='game', @optname='rpc', @optvalue='true';
exec sp_serveroption @server='game', @optname='rpc out', @optvalue='true';
IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_DEFINEDB')
BEGIN
EXEC sp_addlinkedserver 'PS_DEFINEDB','','SQLOLEDB','127.0.0.1';
EXEC sp_addlinkedsrvlogin 'PS_DEFINEDB','false',null,'Shaiya','Shaiya123';
END
exec sp_serveroption @server='PS_DEFINEDB', @optname='rpc', @optvalue='true';
exec sp_serveroption @server='PS_DEFINEDB', @optname='rpc out', @optvalue='true';
IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_NCASH')
BEGIN
EXEC sp_addlinkedserver 'PS_NCASH','','SQLOLEDB','127.0.0.1';
EXEC sp_addlinkedsrvlogin 'PS_NCASH','false',null,'Shaiya','Shaiya123';
END
exec sp_serveroption @server='PS_NCASH', @optname='rpc', @optvalue='true';
exec sp_serveroption @server='PS_NCASH', @optname='rpc out', @optvalue='true';
IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_USERDB')
BEGIN
EXEC sp_addlinkedserver 'PS_USERDB','','SQLOLEDB','127.0.0.1';
EXEC sp_addlinkedsrvlogin 'PS_USERDB','false',null,'Shaiya','Shaiya123';
END
exec sp_serveroption @server='PS_USERDB', @optname='rpc', @optvalue='true';
exec sp_serveroption @server='PS_USERDB', @optname='rpc out', @optvalue='true';
IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_GAMEDB01')
BEGIN
EXEC sp_addlinkedserver 'PS_GAMEDB01','','SQLOLEDB','127.0.0.1';
EXEC sp_addlinkedsrvlogin 'PS_GAMEDB01','false',null,'Shaiya','Shaiya123';
END
exec sp_serveroption @server='PS_GAMEDB01', @optname='rpc', @optvalue='true';
exec sp_serveroption @server='PS_GAMEDB01', @optname='rpc out', @optvalue='true';
IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_USERDB01')
BEGIN
EXEC sp_addlinkedserver 'PS_USERDB01','','SQLOLEDB','127.0.0.1';
EXEC sp_addlinkedsrvlogin 'PS_USERDB01','false',null,'Shaiya','Shaiya123';
END
exec sp_serveroption @server='PS_USERDB01', @optname='rpc', @optvalue='true';
exec sp_serveroption @server='PS_USERDB01', @optname='rpc out', @optvalue='true';
--exec PS_UserData.dbo.usp_Create_ShaiyaAccount 1, 'admin', admin123
/* Add to Game User: admin, Password: admin123 and user information*/
IF NOT EXISTS (SELECT UserUID FROM PS_UserData.dbo.Users_Master WHERE UserUID=1)
BEGIN
INSERT INTO PS_UserData.dbo.Users_Master
(UserUID, UserID, Pw, JoinDate, Admin, AdminLevel, UseQueue, Status, Leave, LeaveDate, UserType, UserIp, ModiIp, ModiDate, Point, Enpassword, Birth)
VALUES (1,'admin', 'admin123', GETDATE(), 1, 255,'',16,'', DATEADD(year, +10, GETDATE()),'A',NULL,NULL,NULL,0,NULL,NULL);
END
IF NOT EXISTS (SELECT UserUID FROM OMG_GameWEB.dbo.GameAccountTBL WHERE UserUID=1)
BEGIN
INSERT INTO OMG_GameWEB.dbo.GameAccountTBL
(UserUID,GameAccount,OneTimePassword,OTPExpireDate,DelCharPWD,CreateDate)
VALUES (1,'admin','admin123',DATEADD(year, +20, GETDATE()),'ff',GETDATE())
END
IF NOT EXISTS (SELECT UserUID FROM PS_UserData.dbo.Users_Detail WHERE UserUID=1)
BEGIN
INSERT INTO PS_UserData.dbo.Users_Detail
(UserID,UserUID,UserName,SocialNo1,SocialNo2,PwQuestion,PwAnswer,Email,PostNo,Addr1,Addr2,Phone1,
Phone2,Phone3,Mobile1,Mobile2,Mobile3,NewsLetter,Sms,AdultAuth,AdultAuthDate,EmailAuth,EmailAuthKey,
Job,JobNo,LocalNo,PwQuNo)
VALUES ('admin',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
END
Edit your Inis in client folder with the correct details and restart after applying changes.
I hope this helps.
Tip: Open the query with notepad and do control + H then replace Shaiya123 by your new pass for example. You'll save some time
|
|
|
02/25/2011, 19:38
|
#3
|
elite*gold: 0
Join Date: Jan 2011
Posts: 526
Received Thanks: 175
|
i know its old but when i excute that i get this error:
Msg 15247, Level 16, State 1, Procedure sp_addsrvrolemember, Line 29
User does not have permission to perform this action.
Msg 515, Level 16, State 2, Line 85
Cannot insert the value NULL into column 'PwQuestion', table 'PS_UserData.dbo.Users_Detail'; column does not allow nulls. INSERT fails.
The statement has been terminated.
EDIT i have win Seven Ultimate
|
|
|
All times are GMT +1. The time now is 07:15.
|
|