ItemMall ep5 DC

[balongskie123]

I got dc after i buy i use stinka123 server files and shen1 itemmall fix.

this is my log

 Spoiler

2017-02-26 02:01:12 PS_DBAGENT__system log start (DBAgent01)

Module list:

C:\ShaiyaServer\PSM_Client\bin\ps_dbAgent.exe, loaded at 0x00400000 - 11/09/14 16:20:57

2017-02-26 02:01:15 ### Connect[7864] : Game[?][0x00E1EB30], Addr=127.0.0.1, DBJobEnd=1

2017-02-26 02:01:15 ### DB_SYSTEM_CONNECT[6152] :Game[1][0x00E1EB30], Name=Game01, Addr=127.0.0.1

2017-02-26 02:02:13 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'usp_Save_User_BuyPointItems2'., SQL STATE: 42000, NATIVE ERROR: 2812 (0xAFC)

2017-02-26 02:02:13 SaveBuyPointItem 7 adb qerr=-1, {?=call usp_Save_User_BuyPointItems2(1,7,2499,'PK_0002','2 017-02-26 02:02:13')}

2017-02-26 02:03:30 1 1 SAgent:isconnect: (4, 64)

this is what i think my problem is. I got an issue for "name already in use" so i use this code to fix it.

DBCC DBReIndex ('PS_GameData.dbo.Chars')

do you think that this might be the problem if not then what is it? i give thanks to the person with a greatful heart

#RESPECT

[Pave99]

Originally Posted by balongskie123

2017-02-26 02:02:13 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'usp_Save_User_BuyPointItems2'., SQL STATE: 42000, NATIVE ERROR: 2812 (0xAFC)

This is your problem. Have you executed all the right .sql files? I can give mine just in case you can't get it working.

[balongskie123]

Originally Posted by Pave99

This is your problem. Have you executed all the right .sql files? I can give mine just in case you can't get it working.

THANKS! It works

#closed

[balongskie123]

Originally Posted by Pave99

This is your problem. Have you executed all the right .sql files? I can give mine just in case you can't get it working.

Pave im back with the same problem. i fix ma last problem using your query. i made a new server with many free. Again i got this error? any idea?

my logs

 Spoiler

2017-03-23 00:09:55 PS_DBAGENT__system log start (DBAgent01)

Module list:

C:\ShaiyaServer\PSM_Client\bin\ps_dbAgent.exe, loaded at 0x00400000 - 11/09/14 16:20:57

2017-03-23 00:10:10 ### Connect[3500] : Game[?][0x00CF8BF0], Addr=127.0.0.1, DBJobEnd=1

2017-03-23 00:10:11 ### DB_SYSTEM_CONNECT[3552] :Game[1][0x00CF8BF0], Name=Game01, Addr=127.0.0.1

2017-03-23 00:11:59 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Server 'game' is not configured for RPC., SQL STATE: 42000, NATIVE ERROR: 7411 (0x1CF3)

2017-03-23 00:11:59 SaveBuyPointItem 9 [GM]Creed qerr=-1, {?=call usp_Save_User_BuyPointItems2(3,9,0,'EM_007','2017-03-23 00:11:59')}

[Pave99]

Have you executed the linked servers query file? Got it here in the attachments.

[[-Silomatx]]

Execute this query:

 Spoiler

exec sp_serveroption @='game', @name='rpc', @value='true';
exec sp_serveroption @='game', @name='rpc out', @value='true';

Which can be found .

[balongskie123]

Originally Posted by [-Silomatx]

Execute this query:

 Spoiler

exec sp_serveroption @='game', @name='rpc', @value='true';
exec sp_serveroption @='game', @name='rpc out', @value='true';

Which can be found .

thanks. but may i ask what is this for?

[[-Silomatx]]

This was your error.

Originally Posted by balongskie123

2017-03-23 00:11:59 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Server 'game' is not configured for RPC., SQL STATE: 42000, NATIVE ERROR: 7411 (0x1CF3)
[/SPOILER]

It says 'game' is not configured for RPC.
So by executing this query, the server option for RPC

@optname= 'rpc', @optname= 'rpc out'

from 'game' will be activated, by setting it's value to true.

@optvalue='true'

[[ADM]Festa]

alguem pode mim ajuda estou com problema ao comprar algo no item mall. Sempre da dc o que pode ser? ep 6.4