|
Latest Discussions
|
 |
|
|
|
|
 |
|
|
Support Forum
|
|
|
| Author |
Messages |
|
Marc Huijbregts
Posts:139
 |
| 02/22/2010 4:32 PM |
|
Hi Pengtsen,
I got the following message:
TypeError: Error #1104
Please check your Event Viewer to find out detailed error message and contact service@bizmodules.net
The message from the event viewer is:
AssemblyVersion: 5.2.2
PortalID: 3
PortalName: Unknown
UserID: 147
UserName: Unknown
ActiveTabID: 193
ActiveTabName: Home
RawURL: /DesktopModules/UltraVideoGallery/vId.aspx?vId=32&portalId=3&timeStamp=22231930&baseUrl=/DesktopModules/UltraVideoGallery/
AbsoluteURL: /DesktopModules/UltraVideoGallery/vId.aspx
AbsoluteURLReferrer: http://www.unknown.com/DesktopModules/UltraVideoGallery/uvg.swf
UserAgent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US) AppleWebKit/532.5 (KHTML, like Gecko) Chrome/4.0.249.89 Safari/532.5
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 7b3b8184-ebf3-4c6f-91c5-b1fcdf4f5a72
InnerException: Parameter count does not match Parameter Value count.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: Microsoft.ApplicationBlocks.Data.SqlHelper.AssignParameterValues
StackTrace:
Message: DotNetNuke.Services.Exceptions.PageLoadException: Parameter count does not match Parameter Value count. ---> System.ArgumentException: Parameter count does not match Parameter Value count. at Microsoft.ApplicationBlocks.Data.SqlHelper.AssignParameterValues(SqlParameter[] commandParameters, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at BizModules.UltraVideoGallery.Data.SqlDataProvider.PickCommercial(Int32 portalId, Int32 categoryId, Int32 max) at BizModules.UltraVideoGallery.CommercialController.Pick(Int32 portalId, Int32 categoryId, Int32 max) at BizModules.UltraVideoGallery.UVGProfessionalEdition.LoadCommercial(Int32 portalId, Int32 category, Int32 count, String prefix, XmlDocument owner, XmlElement parent) 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 Naam:
Please advise.
Thanks in advance. |
|
Regards,
Marc
www.biservices.eu for free nl-NL resourcepacks (incl. UMG 6.5.3 & UVG 3.2.1). |
|
|
Pengtsen R
Posts:9386
|
| 02/23/2010 9:28 PM |
|
| please try to run 03.01.01.SqlDataProvider in UVG folder once again. |
|
Pengtsen R
http://www.bizmodules.net |
|
|
Marc Huijbregts
Posts:139
|
| 02/24/2010 1:18 AM |
|
I have performed a repair install with the latest UVG 312 Pro. This install gave me no errors so I assume that the SqlDataProvider has been run once again (right?). Unfortunatelly the error is still shown to me when trying to watch the video.
Is there something else you want me to try? |
|
Regards,
Marc
www.biservices.eu for free nl-NL resourcepacks (incl. UMG 6.5.3 & UVG 3.2.1). |
|
|
Pengtsen R
Posts:9386
|
| 02/24/2010 7:21 AM |
|
please just run 03.01.01.SqlDataProvider in Host - Sql.
when you repair install DNN won't execute sql scripts. |
|
Pengtsen R
http://www.bizmodules.net |
|
|
Marc Huijbregts
Posts:139
|
| 02/24/2010 8:30 AM |
|
I only have the folling SqlDataProviders present 03.01.05 till 03.01.12.
Judging on the filesize I assume that the 03.01.05 it the cumulative DataProvider. Should I run this one or one of the others?
Thanks in advance. |
|
Regards,
Marc
www.biservices.eu for free nl-NL resourcepacks (incl. UMG 6.5.3 & UVG 3.2.1). |
|
|
Marc Huijbregts
Posts:139
|
| 02/24/2010 1:19 PM |
|
I have restored the website to my localhost to test the running of the SqlDataProviders. After running them all (in ascending order) I tried to play the video once again but unfortunally it doesn't play.
Do you have another suggestion?
Thanks in advance. |
|
Regards,
Marc
www.biservices.eu for free nl-NL resourcepacks (incl. UMG 6.5.3 & UVG 3.2.1). |
|
|
Marc Huijbregts
Posts:139
|
| 02/25/2010 1:19 AM |
|
I noticed there was a new build of the 3.1.12 on Snowcovered yesterday and have installed it on my DNN installation but this didn't make a difference. Furthermore I noticed this is only for uploaded videos whereas Youtube like videos are shown without any problem.
Could you please enlight me on which of the SqlDataProviders I need to run?
Thanks in advance. |
|
Regards,
Marc
www.biservices.eu for free nl-NL resourcepacks (incl. UMG 6.5.3 & UVG 3.2.1). |
|
|
Pengtsen R
Posts:9386
|
| 02/25/2010 11:06 PM |
|
ok, so you now have UVG 3.1.12 installed.
please open UVG 3.1.12 PA, you should see 03.01.01.SqlDataProvider, please manually execute it. |
|
Pengtsen R
http://www.bizmodules.net |
|
|
Marc Huijbregts
Posts:139
|
| 02/26/2010 12:05 AM |
|
Ok, I ran the SqlDataProvider and got below mentioned error while running the script. Please advise how I shoudl proceed.
System.Data.SqlClient.SqlException: Procedure or function dbo.UVG_CommercialIsActive has too many arguments specified. Procedure or function dbo.UVG_CommercialIsActive has too many arguments specified. Procedure or function dbo.UVG_CommercialIsActive has too many arguments specified. Procedure or function dbo.UVG_CommercialIsActive has too many arguments specified. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) --The commercial should be limited to current portal only Procedures alter procedure dbo.UVG_CommercialPick @PortalId int, @CategoryId int, @Max int AS --The probability to pick a commercial, 0 ~ 100 DECLARE @PickProbability int set @PickProbability = 100 --Varibles below should not be changed --The @Rnd varible betweens 0 to 99 DECLARE @Rnd int Select @Rnd = Cast(RAND() * 100 As Int) if @Rnd < (100 - @PickProbability) return create table #UVG_TEMP (ItemId int not null) --Postroll, Preroll, Background, BottomThird insert into #UVG_TEMP SELECT TOP 1 ItemId FROM dbo.UVG_Commercial where ISNULL(CategoryId, @CategoryId) = @CategoryId AND PortalId=@PortalId AND dbo.UVG_CommercialIsActive(StartDate,EndDate,getdate(),MaxImpressions,Impressions,Criteria) = 1 And Type = 3 order by ISNULL(CategoryId, @CategoryId + 1) ASC,NEWID() insert into #UVG_TEMP SELECT TOP 1 ItemId FROM dbo.UVG_Commercial where ISNULL(CategoryId, @CategoryId) = @CategoryId AND PortalId=@PortalId AND dbo.UVG_CommercialIsActive(StartDate,EndDate,getdate(),MaxImpressions,Impressions,Criteria) = 1 And Type = 4 order by ISNULL(CategoryId, @CategoryId + 1) ASC,NEWID() set rowcount @Max insert into #UVG_TEMP SELECT ItemId FROM dbo.UVG_Commercial where ISNULL(CategoryId, @CategoryId) = @CategoryId AND PortalId=@PortalId AND dbo.UVG_CommercialIsActive(StartDate,EndDate,getdate(),MaxImpressions,Impressions,Criteria) = 1 And Type = 1 order by ISNULL(CategoryId, @CategoryId + 1) ASC,NEWID() insert into #UVG_TEMP SELECT ItemId FROM dbo.UVG_Commercial where ISNULL(CategoryId, @CategoryId) = @CategoryId AND PortalId=@PortalId AND dbo.UVG_CommercialIsActive(StartDate,EndDate,getdate(),MaxImpressions,Impressions,Criteria) = 1 And Type = 2 order by ISNULL(CategoryId, @CategoryId + 1) ASC,NEWID() set rowcount 0 SELECT * FROM dbo.UVG_Commercial WHERE ItemId IN(SELECT ItemId FROM #UVG_TEMP) drop table #UVG_TEMP |
|
Regards,
Marc
www.biservices.eu for free nl-NL resourcepacks (incl. UMG 6.5.3 & UVG 3.2.1). |
|
|
Marc Huijbregts
Posts:139
|
| 02/27/2010 7:19 AM |
|
Hi Pengtsen,
What else do you want me to try?
Thanks in advance. |
|
Regards,
Marc
www.biservices.eu for free nl-NL resourcepacks (incl. UMG 6.5.3 & UVG 3.2.1). |
|
|
Marc Huijbregts
Posts:139
|
| 03/01/2010 12:02 AM |
|
Could this somehow be related to the switch I have made from UVG to UVG professional?
Thanks in advance. |
|
Regards,
Marc
www.biservices.eu for free nl-NL resourcepacks (incl. UMG 6.5.3 & UVG 3.2.1). |
|
|
Pengtsen R
Posts:9386
|
| 03/02/2010 10:21 AM |
|
no, it's not related.
can you give me your database access ? I'll manually fix it.
it seems the UVG stored procedures in your db is corrupted. |
|
Pengtsen R
http://www.bizmodules.net |
|
|
Marc Huijbregts
Posts:139
|
| 03/02/2010 2:47 PM |
|
| Thanks, I'll send you the details by email. |
|
Regards,
Marc
www.biservices.eu for free nl-NL resourcepacks (incl. UMG 6.5.3 & UVG 3.2.1). |
|
|
Pengtsen R
Posts:9386
|
| 03/04/2010 8:44 AM |
|
| it's fixed. |
|
Pengtsen R
http://www.bizmodules.net |
|
|
Marc Huijbregts
Posts:139
|
| 03/04/2010 10:09 AM |
|
Hi Pengtsen,
I would like to thank you for your continued support in this matter. It works like a charm right now.
Thanks! |
|
Regards,
Marc
www.biservices.eu for free nl-NL resourcepacks (incl. UMG 6.5.3 & UVG 3.2.1). |
|
|
Pengtsen R
Posts:9386
|
| 03/10/2010 10:23 AM |
|
| always glad to help! |
|
Pengtsen R
http://www.bizmodules.net |
|
|
|
| You are not authorized to post a reply. |
|
|
|
|
|
|
|
 |
 |
|
 |
|