Register for your free account! | Forgot your password?

Go Back   elitepvpers > Popular Games > Silkroad Online > SRO Private Server
You last visited: Today at 19:13

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



[BR Files] Missing stored procedure: _ResetQuestByCharName

Discussion on [BR Files] Missing stored procedure: _ResetQuestByCharName within the SRO Private Server forum part of the Silkroad Online category.

Reply
 
Old   #1
 
elite*gold: 505
Join Date: Nov 2008
Posts: 600
Received Thanks: 522
[BR Files] Missing stored procedure: _ResetQuestByCharName

Anyone have this stored procedure for Black Rogue DB? o.O
I keep getting this error in GS and it's really annoying (doesn't affect performance, just annoying -_-):

Query Error!!! Query Result : -1, Query : {CALL _ResetQuestByCharName ( 'RainyDays' )}
SQL Error State:42000, Native Error Code: AFC, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure '_ResetQuestByCharName'.
{CALL _ResetQuestByCharName ( 'RainyDays' )}
Query Error!!! Query Result : -1, Query : {CALL _ResetQuestByCharName ( 'RainyDays' )}
{CALL _ResetQuestByCharName ( 'RainyDays' )}
AQ_BrutalQuery:: DB Query Error(-1): {CALL _ResetQuestByCharName ( 'RainyDays' )}
AQ_CharDataSaver:: DB Query Error(100): UPDATE _TIMEDJOB SET TimeToKeep=2704 WHERE ID=2 AND CharID=7299
pH33n1x<3 is offline  
Old 04/27/2012, 21:19   #2



 
Disco Teka's Avatar
 
elite*gold: 325
Join Date: Dec 2008
Posts: 14,546
Received Thanks: 8,721
Arrow Private SRO Main Discussions / Questions -> Private SRO Ask the Experts

#moved
Disco Teka is offline  
Thanks
1 User
Old 04/27/2012, 21:22   #3
 
elite*gold: 0
Join Date: Jan 2012
Posts: 235
Received Thanks: 129
what you are doing is correct. there is a bug with the sql server stored procedure. apparently

the schemas hasn't changed since 3.5? were you able to go through the same process in ts3.5 without running into this error?

it looks like you have found the way to solve this problem. there are a few other step types that have similar error. specifically the IVI steps.before the bug is fixed, you can use validate to determines whether the statement and column information for the selected schema matches the tables and columns in the database.alternatively, you may look at the file below to find out the correct spelling of the stored procedures.
<TestStand 4.0>\Components\NI\Models\TestStandModels\Database \SQL Server Create Stored Proc Result Tables.sql
Look carefully at writing issues
jockeyrullz is offline  
Reply


Similar Threads Similar Threads
New Vsro Files Pet DC (Stored Prozedure)
12/04/2014 - SRO Private Server - 4 Replies
Hey Guys, maybe some of you know, which line in the _AddNewCOS Prozedure need to be deleted to get Pets working: USE GO /****** Object: StoredProcedure . Script Date: 04/22/2012 11:59:05 ******/ SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER ON
Questions about the tmp files stored in mabinogi's cache
01/08/2011 - Mabinogi - 1 Replies
Was your character ever turned into a black robe in the character screen? It's because its respective tmp file was deleted. They are typically stored in Documents/Mabinogi/Cache. However, I want to ask somebody who may know about them. If the deletion of one makes your character unplayable ingame, are there any other effects modification of these tmp files could have? Perhaps editing a character's tmp file can generate things ingame? Most likely not but I'm curious, could someone enlighten me?
[HELP]Res toon stored Procedure
07/23/2010 - Shaiya Private Server - 0 Replies
Hi all, hopefully someone can tell me what i am doing wrong. I am trying to use the dbo.usp_GM_Recovery_Char and it completes without errors but it doesn't res the toon. can anyone tell me how to fix this. I am tired of ressing them manually. thanks alot!!
Missing CO Files
02/19/2006 - Conquer Online 2 - 0 Replies
hey, I deleted CO before cuz i thought i didnt wanna play it anymore but now im gettin really bored and wanna get it again, and i found CO on a cd from august, but the problem is it's only version 2217. Does anyone have the manual patches from 2217 to atleast 2284? CO site doesn't have any patches past 2284. Also to redownload CO it'll take me about 30-40 hrs. >:o stupid dialup. So if anyone's got the patches please post here. +karma for anyone who posts them. I'll check back soon... thx.



All times are GMT +1. The time now is 19:14.


Powered by vBulletin®
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2026 elitepvpers All Rights Reserved.