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.
|
Support Forum
| Author |
Messages |
|
andreas martin
Posts:57
 |
| 09/01/2009 2:50 PM |
|
Hi.
When I specify a category in the uvg_search module no videos are found what so ever. If I don't specify a categoy all relevant videos from all categories show up. All my videos are in series, and all the series are in a category. I believe this used to work earlier (the site is still in development).. Any suggestions on how to fix this? I really need the ability to specify the category when searching!
Regards
Andreas |
|
|
|
|
Pengtsen R
Posts:11533
|
| 09/02/2009 1:28 PM |
|
| it's a bug, I'll fix it. |
|
Pengtsen R
http://www.bizmodules.net |
|
|
andreas martin
Posts:57
|
| 09/02/2009 2:32 PM |
|
great! do you have an estimate for when an update for this will be released?
I have made a lot of qustomization of the different modules in the module settings (not the actual "module files"). Will that be ereased / reverted to default when I update to a newer version? |
|
|
|
|
Pengtsen R
Posts:11533
|
| 09/04/2009 10:50 AM |
|
it should be released some days later, send me an email if you need a fix soon.
the fix is on sql server scripts only, so you can run the new script(03.01.06.SqlDataProvider) in Host - Sql so it won't erease anything.
thanks. |
|
Pengtsen R
http://www.bizmodules.net |
|
|
andreas martin
Posts:57
|
| 10/15/2009 10:20 AM |
|
Ok, I have installed the update, and in comparison to before a search specified by category now finds results, but the problem now is that the results are incorrect. It now lists -ALL- videoes in the category as a match when searching, regardless of what the search-input is.
Example:
-> If I search in -all- categories for "fish" I can e.g. find 10 correct results.
-> If I seach for "fish" in a specified category (e.g. "atlantic ocean") I will get as many results as there are videos in the category "atlantic ocean", e.g. 100 results. This is clearly an error.
-> If I search for someting completely meaningless, like "afvkjn" I will still get as many results as there are videos in the category. =error.
This is clearly a bug. Hope this can be fixed swiftly! |
|
|
|
|
Pengtsen R
Posts:11533
|
| 10/16/2009 1:31 AM |
|
try to run this query in Host - Sql to see if it fix your problem:
--Add "AlphabeticalOrder"
alter procedure {databaseOwner}{objectQualifier}UVG_VideoListByKeyword
@PortalId int,
@CategoryId int,
@Keyword nvarchar(100),
@OrderType varchar(20)
AS
DECLARE @TagId int
SELECT @TagId = ItemId from {databaseOwner}{objectQualifier}UVG_Tag WHERE Tag = @Keyword
If ISNULL(@TagId, 0) =0
SET @TagId = 0
DECLARE @SQLString NVARCHAR(2000)
SET @SQLString = ''
SET @SQLString = 'SELECT * FROM {databaseOwner}{objectQualifier}UVG_Video where PortalId = ' + cast(@PortalId as varchar(10)) + ' and (ItemId in (SELECT VideoId from {databaseOwner}{objectQualifier}UVG_VideoTag where TagId = ' + cast(@TagId as varchar(10)) + ') Or isnull(Title, OriginalName) + isnull(Description,'''') like(''%' + @Keyword + '%'')) and approved = 1'
if @CategoryId > 0
SET @SQLString = @SQLString + ' and (CategoryId = ' + cast(@CategoryId as varchar(10)) + ' or (select CategoryId from {databaseOwner}{objectQualifier}UVG_Series where ItemId = UVG_Video.SeriesId) = ' + cast(@CategoryId as varchar(10)) + ')'
if @OrderType = 'Featured'
SET @SQLString = @SQLString + ' and IsFeatured = 1 Order By FeaturedDate Desc'
else if @OrderType = 'MostDiscussed'
SET @SQLString = @SQLString + ' Order By TotalComments Desc, CreatedDate Desc'
else if @OrderType = 'MostPopular'
SET @SQLString = @SQLString + ' Order By AverageRating * TotalRatings + Views + TotalComments'
else if @OrderType = 'MostViewed'
SET @SQLString = @SQLString + ' Order By Views Desc, CreatedDate Desc'
else if @OrderType = 'RecentVideos'
SET @SQLString = @SQLString + ' Order By CreatedDate Desc'
else if @OrderType = 'TopRated'
SET @SQLString = @SQLString + ' Order By AverageRating Desc, CreatedDate Desc'
else if @OrderType = 'AlphabeticalOrder'
SET @SQLString = @SQLString + ' Order By Title Asc'
EXECUTE sp_executesql @SQLString
GO
|
|
Pengtsen R
http://www.bizmodules.net |
|
|
andreas martin
Posts:57
|
| 10/17/2009 5:09 AM |
|
Great! That sorted out the search-malfunction!
I have noticed one thing that no longer seems to work though.
(I am not 100% this worked before though).
In the taglist-module I have turned on video-count.
Now, if I remove a tag, the tag-count does not go down. It goes up if I add a tag though. I even removed a tag completely. That removed the tag-text, but the tag-count (the number) still remains.
I have noticed that the tag-count updates if I add the tag to a new video.
Example:
I have ten videos with the tag "football". That gives med a taglist looking like this: "Football (10)".
Now, if I remove the football-tag from nine of the videos, the taglist still reads "Football (10)".
Now, if add the tag football to a new video, the taglist updates and says "Football (2)".
If I remove all the football-tags the taglist removes the tag-text ("football"), but the tag-count "(2)" remains.
Can this be fixed?
thanks |
|
|
|
|
Pengtsen R
Posts:11533
|
| 10/17/2009 9:30 PM |
|
try this query:
ALTER PROCEDURE {databaseOwner}{objectQualifier}UVG_VideoEnsureTag
@VideoId int,
@UserId int,
@BelongedTags nvarchar(500)
AS
DECLARE @Offset int
DECLARE @NextPosition int
DECLARE @Tags nvarchar(500)
DECLARE @Tag nvarchar(200)
DECLARE @TagId int
DECLARE @PortalId int
select @PortalId = PortalId from {databaseOwner}{objectQualifier}UVG_Video where ItemId = @VideoId
Set @Tags = ' ' + @BelongedTags + ' '
if CharIndex('\ ',@Tags) > 0
select @Tags = replace(@Tags, '\ ', 'SPACE')
begin transaction
Set NoCount ON
delete from {databaseOwner}{objectQualifier}UVG_VideoTag where VideoId=@VideoId
select @Offset = CharIndex(' ',@Tags)
select @NextPosition = CharIndex(' ',@Tags,@Offset + 1)
while @NextPosition > 0
begin
set @Tag= SUBSTRING(@Tags,@Offset + 1,@NextPosition - @Offset - 1)
if CharIndex('SPACE',@Tag) > 0
select @Tag = replace(@Tag, 'SPACE' , ' ')
set @TagId = 0
select @TagId = ItemId from {databaseOwner}{objectQualifier}UVG_Tag where Tag = @Tag
if isnull(@TagId, 0) =0
begin
insert {databaseOwner}{objectQualifier}UVG_Tag (PortalId, Tag, IsPrivate, CreatedByUser, CreatedDate) values (@PortalId, @Tag, 0, @UserId, getdate())
select @TagId = SCOPE_IDENTITY()
end
Insert into {databaseOwner}{objectQualifier}UVG_VideoTag (VideoId,TagId) Values(@VideoId,@TagId)
select @Offset = @NextPosition
select @NextPosition = CharIndex(' ',@Tags,@Offset + 1)
end
delete {databaseOwner}{objectQualifier}UVG_Tag where not exists(select * from {databaseOwner}{objectQualifier}UVG_VideoTag where {databaseOwner}{objectQualifier}UVG_VideoTag.TagId = {databaseOwner}{objectQualifier}UVG_Tag.ItemId)
update {databaseOwner}{objectQualifier}UVG_Tag set VideoCount = (Select count(*) from {databaseOwner}{objectQualifier}UVG_VideoTag where TagId = {databaseOwner}{objectQualifier}UVG_Tag.ItemId) where PortalId = @PortalId
Set NoCount OFF
if @@error=0
begin
commit transaction
end
else
begin
rollback transaction
end
GO
|
|
Pengtsen R
http://www.bizmodules.net |
|
|
andreas martin
Posts:57
|
| 10/18/2009 7:03 AM |
|
I am sorry. That did not work.
Some things did happen thogh, and I will explain them to you:
First the bad news:
All tag-counts are now malfunctioning.
All tags now show the same video-count, and I have figured out that they all show the video-count of the last tag added. Let's say I add the tag "fish" to a video, so that the total amount of videos tagged with "fish" is now 5. Then the video-count of ALL tags will say 5. If i add another tag to another video, making e.g. 13 videos have that specific tag, then the video-count of ALL tags will say 13.
The tags are supposed to get sorted into four classes based on how many tags they have, giving the tags different colors and sizes. This function is now malfunctioning. That is; ca. the first quarter of the tags get the "biggst" tag-class, the second quarter of the tags get the "second to biggest" tag-class and so forth. I must specify that the tags are not actually sorted into excact quarters. In fact, the distribution is like this: 15, 9, 13, 21 (from biggest class to smallest).
The good news is that now, if I remove a tag, the tag-count get's updated, in comparison to earlier. But the bad news continues. I still get a loose video-count not connected to a real tag.
If I click this tag-count I am shown all the videoes from which I have removed all tags. To specify, if I remove a tag from a video, but the video still has other tags, it does not show up in this loose "video-count-tag". But if I remove all tags from a video all together, the video shows up in the "loose-video-count-tag".
Are these problems with the tag-list and previously the serach-function only applying to me, or is it a common uvg-problem?
I really hope this can be sorted out quick, since we are only a day or two (tops) from the launch of our site.
Thanks for all help so far! |
|
|
|
|
Pengtsen R
Posts:11533
|
| 10/20/2009 3:33 AM |
|
I udpated the above post, try it again, it should work.
to fix the corrupted video count problem, run this query in Host - Sql:
update {databaseOwner}{objectQualifier}UVG_Tag set VideoCount = (Select count(*) from {databaseOwner}{objectQualifier}UVG_VideoTag where TagId = {databaseOwner}{objectQualifier}UVG_Tag.ItemId)
|
|
Pengtsen R
http://www.bizmodules.net |
|
|
andreas martin
Posts:57
|
| 10/21/2009 4:12 AM |
|
Now the tag-list displays correctly again, BUT the one corrupt videocount still shows.
That is; if a remove all tags from a video, that video shows up in the "loose"-video-count-tag...
It seems to me that there is something wrong with the code that clears tags. Perhaps the "tag-field" in some database-table isn't cleaned properly, but gets replaced by something, like or something. That way no tag-text displays, but all videos with all their tags removed get this, and therefor gather up in a tag with only the videocount visible..? That's my theory anyways :)
Another problem:
The compact videoplayer finds no videos. I don't know if this worked before we started tampering with the database, but maybe that could have something to do with it? |
|
|
|
|
andreas martin
Posts:57
|
| 10/21/2009 4:14 AM |
|
Update to a sentence in the post above:
...but gets replaced by something, like " & nbsp ; " or something. (I had to write the html-tag with spaces in between, or else it would show up as.. a space.. haha :) |
|
|
|
|
Pengtsen R
Posts:11533
|
| 10/21/2009 11:49 PM |
|
The compact videoplayer finds no videos. I don't know if this worked before we started tampering with the database, but maybe that could have something to do with it?
=========
What's your current setting of this module? a fixed video? or dynamically populated.
I don't fully understand what is happening now, can you show me some screenshots? |
|
Pengtsen R
http://www.bizmodules.net |
|
|
andreas martin
Posts:57
|
| 11/02/2009 8:44 AM |
|
For the compact-player, I have tried both fixed and dynamically. No videos are found. All my videos are in series. Could that have something to do with the problem?
----
The taglist-problem:
Your last SQL-update fixed the sorting error, and videocount, except for the "loose videocount".
By "videocount" I mean the count/number showing how many videos have been tagged with that specific tag. Token "videocount" in uvg_taglist.
By "loose videocount" I mean a count/number that shows up in the taglist, but it is NOT connected to a tag-"text".
A normal tag would display like this: "Football (3)", where "football" is what i refer to as "tag-text", and "(3)" is what I refer to as "videocount".
Let's call these two elements, when they appear togheter, a "complete tag". I have many complete tags.
The problm is that I have -one- instance of only a "videocount"! In other words, no "tag-text".
This "videocount" shows all, but only, videos which <<have previously>> had one or more tags, and <<later have had>> -all- their tags removed. This happens regardless of what tags the videoes has had before. Meaning; if one video has the tag "ball" and another video has the tag "car", and then I remove the tags from both videoes, they end up in the same "loose videocount".
I do not know what is causing this. Maybe some fields or something in the database is not cleared properly when the tag is removed. I don't know, but clearly some trace is left making UVG think it's a tag. UVG just doesn't have a name for the tag.
I hope this "loose videocount" can be removed from the taglist! |
|
|
|
|
Pengtsen R
Posts:11533
|
| 11/03/2009 11:41 PM |
|
about the compact player issue, can you give me your host password so I can check it online.
I don't fully understand, can you show me the url of your tag problem? |
|
Pengtsen R
http://www.bizmodules.net |
|
|
andreas martin
Posts:57
|
| 11/04/2009 6:42 AM |
|
Compact player issue:
It seems it works in dynamically mode, but not in fixed. I guess I was a little too quick when I responded that it doesn't work in either mode. But it is in fixed mode I would like to use it. This still does not work. How can I give you the login-info? I don't want to post that here. (btw, I do not have host login, only admin. Do you need host, or is admin ok?)
Taglist-issue:
You can find my taglist here:
http://web.nhhs.no/k7minutter/Sendinger/S%C3%B8kiarkivet/tabid/4243/language/en-US/Default.aspx
As you can see, there is a tag at the very start which only says (3). This tag includes the videos which has previously had tags (different tags), but later have had all their tags removed.
I want this tag-thingy to be gone :) |
|
|
|
|
Pengtsen R
Posts:11533
|
| 11/04/2009 7:19 AM |
|
about the 1st problem, click Contact Us in the bottom of this page.
about the 2nd problem, I'm not sure why it happens, but you can manually delete this tag since only this tag have this proboem.
run this query in Host - Sql:
delete UVG_VideoTag where tagid=157
delete UVG_Tag where ItemId = 157 |
|
Pengtsen R
http://www.bizmodules.net |
|
|
andreas martin
Posts:57
|
| 11/04/2009 1:40 PM |
|
Are you positive I should remove tagID 157?
When I hoover over the tag in question it says tagID 154..!?
Are you sure this will not only be a temporary solution. I mean, what stops this strange tag to be made again if I delete all tags from a video?
am |
|
|
|
|
Pengtsen R
Posts:11533
|
| 11/05/2009 1:08 AM |
|
you are right, 154.
I didn't see this problem before, so you can manually delete it this time, if it happens again there must be some problem. |
|
Pengtsen R
http://www.bizmodules.net |
|
|
andreas martin
Posts:57
|
| 11/05/2009 5:43 AM |
|
I ran the sql-code. The tag disappeared.
To test, I added a tag to a video, and the removed the tag.
..The problem re-appeared! |
|
|
|
|
|
| You are not authorized to post a reply. |
|
|
|
ActiveForums 3.7
|