The stored procedure 'dbo.UVG_VideoListByAuthor' doesn't exist > Support > Biz Modules Solutions

Host Partnership

If you are looking for good DNN hosting, then PowerDNN is the best DNN host around!

Need a custom module?

Should you have any questions about custom DNN modules or web projects, please let us know.

Latest Discussions

Critical Error by Dustin Eatchel

Hi, we're getting a critcal error in our UVG 424 Pro module. The error is "A cr...

CarouselEvolution not showing properly . . . by Mike Ulloa

I have recently installed UMG 8.5 on a DNN 5.05 server. The carousel does not...

Empty Gallery. UMG 8.5 by Diego Juzgado

I have delete all medias and albums from a gallery module and now, I can't acces...

pause at the end of a slider display by Brazos Donaho

Was wondering if it would be possible to have an option that could control if th...

Require login to post comments by Marty Goldberg

Is there a way to require users to login before they can post a comment on a vid...

Support Forum

Unanswered Active Topics

Forums Search

Forums > Ultra Video Gallery > Support Questions

Subject: The stored procedure 'dbo.UVG_VideoListByAuthor' doesn't exist

You are not authorized to post a reply.

Author

Messages

Frozen DNN
Posts:144
Diamond Member

Diamond Member

09/01/2010 9:18 PM
I am using UVG 3 currently but I removed old UVG modules. I have reloaded the UVG 3 module again but I get this error. I have lots of videos on this website so cannot do a fresh install. Please help as soon as possible. This is happening on a live website. UserAgent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.8) Gecko/20100722 Firefox/3.6.8 GTB7.1 DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider ExceptionGUID: 9f6d9030-106a-41b6-beaa-bf49ff768241 InnerException: The stored procedure 'dbo.UVG_VideoListByAuthor' doesn't exist. FileName: FileLineNumber: 0 FileColumnNumber: 0 Method: System.Data.SqlClient.SqlCommand.DeriveParameters StackTrace: Message: DotNetNuke.Services.Exceptions.PageLoadException: The stored procedure 'dbo.UVG_VideoListByAuthor' doesn't exist. ---> System.InvalidOperationException: The stored procedure 'dbo.UVG_VideoListByAuthor' doesn't exist. at System.Data.SqlClient.SqlCommand.DeriveParameters() at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at BizModules.UltraVideoGallery.Data.SqlDataProvider.ListVideoByAuthor(Int32 portalId, Int32 userId, Int32 exluded, Boolean approvedOnly, String orderType) at BizModules.UltraVideoGallery.VideoController.ListVideoByAuthor(Int32 portalId, Int32 userId, Int32 excluded, Boolean approvedOnly, String orderType) at BizModules.UltraVideoGallery.FreeVideoList.BindData() at BizModules.UltraVideoGallery.FreeVideoList.Page_PreRender(Object sender, EventArgs e) at System.Web.UI.Control.OnPreRender(EventArgs e) at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace --- Source: Server Name: VPS035

Frozen DNN
Posts:144
Diamond Member

Diamond Member

09/02/2010 1:11 AM
Just want to explain this in detail. I was using UVG 2 and Smart-Thinker on this website. I then upgraded this website with UVG Pro 3 couple of months ago. Everything was working fine. Couple of weeks ago I removed Smart-Thinker from this website and upgraded it with Active Social. Yesterday, when I was uploading a video it gave me an error that said something about Smart-Thinker. I assume it didn't find the story feed thingy. So I decided to clean the UVG by removing the old UVG 2 satellite moduled that were still there. After removing those satellite modules, I reinstalled UVG 3. However, now I get this error. I cannot completely remsove UVG and do the fresh install because this website has lots of videos from lots of members. This is a live website so any prompt help is appreciated. Thanks.

Frozen DNN
Posts:144
Diamond Member

Diamond Member

09/02/2010 1:27 AM
Looks like it's happening on this website (not mine) as well. http://ipc8.dip.go.th/Default.aspx?tabid=36&error=The+stored+procedure+%27dbo.UVG_VideoListByAuthor%27+doesn%27t+exist.&content=0

Frozen DNN
Posts:144
Diamond Member

Diamond Member

09/03/2010 12:18 AM
UserID: 1 UserName: host ActiveTabID: 36 ActiveTabName: Home RawURL: /DesktopModules/UltraVideoGallery/vId.aspx?vId=-1&portalId=0&timeStamp=2221420&baseUrl=/DesktopModules/UltraVideoGallery/ AbsoluteURL: /DesktopModules/UltraVideoGallery/vId.aspx AbsoluteURLReferrer: UserAgent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.8) Gecko/20100722 Firefox/3.6.8 GTB7.1 DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider ExceptionGUID: 01ec6fd8-d4b1-42b8-9b4c-ba4988b2a3e4 InnerException: The stored procedure 'dbo.UVG_VideoListRelated' doesn't exist. FileName: FileLineNumber: 0 FileColumnNumber: 0 Method: System.Data.SqlClient.SqlCommand.DeriveParameters StackTrace: Message: DotNetNuke.Services.Exceptions.PageLoadException: The stored procedure 'dbo.UVG_VideoListRelated' doesn't exist. ---> System.InvalidOperationException: The stored procedure 'dbo.UVG_VideoListRelated' doesn't exist. at System.Data.SqlClient.SqlCommand.DeriveParameters() at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at BizModules.UltraVideoGallery.Data.SqlDataProvider.ListRelatedVideos(Int32 itemId, Int32 portalId) at BizModules.UltraVideoGallery.VideoController.ListRelatedVideos(Int32 itemId, Int32 portalId) at BizModules.UltraVideoGallery.vId.Page_Load(Object sender, EventArgs e) at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace --- Source: Server Name: VPS035

Frozen DNN
Posts:144
Diamond Member

Diamond Member

09/03/2010 1:15 AM
UserAgent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.8) Gecko/20100722 Firefox/3.6.8 GTB7.1 DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider ExceptionGUID: 81dfe260-99c8-44b5-ba62-d828d965d70b InnerException: The stored procedure 'dbo.UVG_VideoListByCategory' doesn't exist. FileName: FileLineNumber: 0 FileColumnNumber: 0 Method: System.Data.SqlClient.SqlCommand.DeriveParameters StackTrace: Message: DotNetNuke.Services.Exceptions.PageLoadException: The stored procedure 'dbo.UVG_VideoListByCategory' doesn't exist. ---> System.InvalidOperationException: The stored procedure 'dbo.UVG_VideoListByCategory' doesn't exist. at System.Data.SqlClient.SqlCommand.DeriveParameters() at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at BizModules.UltraVideoGallery.Data.SqlDataProvider.ListVideoByCategory(Int32 portalId, Int32 categoryId, Int32 timeline, String orderType) at BizModules.UltraVideoGallery.VideoController.ListByCategory(Int32 portalId, Int32 categoryId, Int32 timeline, String orderType) at BizModules.UltraVideoGallery.VideoList.BindData() at BizModules.UltraVideoGallery.VideoList.Page_PreRender(Object sender, EventArgs e) at System.Web.UI.Control.OnPreRender(EventArgs e) at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace --- Source: Server Name: VPS035

Frozen DNN
Posts:144
Diamond Member

Diamond Member

09/03/2010 3:09 PM
As i said earlier, I was using Smart-thinker modules but not anymore. But when I tried to upload a video I got following error:A critical error has occurred. Invalid object name 'dbo.SmartThinker_StoryFeed_Action_Type'. This was before I started receiving the other error messages. Please help as my active website is down just because of this. Thanks

Pengtsen R
Posts:11264

09/04/2010 12:27 PM
just disable storyfeed integration in UVG_Configurations.

Pengtsen R http://www.bizmodules.net

Frozen DNN
Posts:144
Diamond Member

Diamond Member

09/05/2010 12:55 AM
What about the other errors? I disabeled the story feed integration but the stored procedure errors do not go away!

Pengtsen R
Posts:11264

09/07/2010 11:41 PM
it appears the stored procedures of UVG no longer exists. you may need to install UVG once again. but I guess your videos no longer exists too, do you have a backup?

Pengtsen R http://www.bizmodules.net

You are not authorized to post a reply.

Forums > Ultra Video Gallery > Support Questions > The stored procedure 'dbo.UVG_VideoListByAuthor' doesn't exist

ActiveForums 3.7