[Problem]Need Help With teleportation-Teleportation not Working !

06/26/2016 06:38 amrel3sal#1

well i checked every thing in the database and activated the alex teleportation but still when clicking it in the game it doesn't send me there ! :rtfm:
my pc ram is 8G and core I5 ! why now
if it's any thing else tell me and give me a query <better:)
Thx :handsdown::handsdown:
By the way i don't know how to restart shard manger !
and it get's me an Query Error!!! Query Result : -1, Query : {?=CALL _ExistsServiceOffRentItem}
& SQL Error State:42000, Native Error Code: AFC, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure '_ExistsServiceOffRentItem'.
& {?=CALL _ExistsServiceOffRentItem} & CALL _ExistsServiceOffRentItem Failed!!
then SR_ShardManager is initialized successfully and continue normally game server luncher server is on all okay!
and jangan cave too !

06/26/2016 14:17 AceSpace#2

The error explains itself,
Make sure your ODBC Configuration are right, re-do them.

Also execute this:

Code:

USE [SRO_VT_SHARD]
GO
/****** Object:  StoredProcedure [dbo].[_ExistsServiceOffRentItem]    Script Date: 6/26/2016 2:16:56 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO



CREATE procedure [dbo].[_ExistsServiceOffRentItem]
as

if( exists (select * from _Items with (nolock) where RefItemID in (select RefItemID from _RefRentItem where Service = 0 ) ) )
begin
return -1
end

06/26/2016 14:42 amrel3sal#3

Quote:

Originally Posted by Skipper*

The error explains itself,
Make sure your ODBC Configuration are right, re-do them.

Also execute this:

Code:

USE [SRO_VT_SHARD]
GO
/****** Object:  StoredProcedure [dbo].[_ExistsServiceOffRentItem]    Script Date: 6/26/2016 2:16:56 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO



CREATE procedure [dbo].[_ExistsServiceOffRentItem]
as

if( exists (select * from _Items with (nolock) where RefItemID in (select RefItemID from _RefRentItem where Service = 0 ) ) )
begin
return -1
end

thx for the error fixing it was as u just said in ODBC Configuration
++++ thanks :handsdown::handsdown::handsdown::handsdown::hands down: