ItemMall ep5 DC

02/25/2017 19:11 balongskie123#1

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

this is my log

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

02/26/2017 07:12 Pave99#2

Quote:

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.

02/27/2017 15:16 balongskie123#3

Quote:

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

03/22/2017 17:14 balongskie123#4

Quote:

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

03/22/2017 20:12 Pave99#5

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

03/22/2017 23:02 [-Silomatx]#6

Execute this query:

Spoiler

Which can be found [Only registered and activated users can see links. Click Here To Register...].

03/25/2017 03:51 balongskie123#7

Quote:

Originally Posted by [-Silomatx]

Execute this query:

Spoiler

exec sp_serveroption @[Only registered and activated users can see links. Click Here To Register...]='game', @[Only registered and activated users can see links. Click Here To Register...]name='rpc', @[Only registered and activated users can see links. Click Here To Register...]value='true';
exec sp_serveroption @[Only registered and activated users can see links. Click Here To Register...]='game', @[Only registered and activated users can see links. Click Here To Register...]name='rpc out', @[Only registered and activated users can see links. Click Here To Register...]value='true';

Which can be found [Only registered and activated users can see links. Click Here To Register...].

thanks. but may i ask what is this for?

03/25/2017 12:01 [-Silomatx]#8

This was your error.

Quote:

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

Quote:

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

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

Quote:

@optvalue='true'

09/24/2019 23:00 [ADM]Festa#9

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