Video count in albums not right

Video Albums do not show the correct Video count.

If I upload a video direct into an album, it does not show in the albums video count.

Only seems to make a difference if I transfer the video into a new album, then create a new album and transfer them back! Then they show in the new album...

Anyone got any ideas on how to correct this?

Thank s- daihlo

This turns up in my email when I upload a video.

followed by a very long backtrace datalog...

Database error in

Query:

UPDATE `sys_albums`, `sys_albums_objects`
    				 SET `ObjCount` = `ObjCount` + 1
    				 WHERE `sys_albums`.`ID`=`sys_albums_objects`.`id_album` 
    				 AND `sys_albums_objects`.`id_object`=92
    				 AND `sys_albums`.`Type`='bx_videos'

I am having the same issue with my video albums.

My album is saying I have 8 videos in it when in fact I have 11, even after I log out and clean browser cache.

also:

Videos only show length of video after you play it once upon uploading.

also:

Stats say I have 6 videos yet I have 12.
When I log out and log back in the stats change.

Please follow the solution I've posted in this thread - http://www.boonex.com/unity/forums/topic/BxDolEmailTemplates.htm

UPDATE `sys_albums`, `sys_albums_objects`
    				 SET `ObjCount` = `ObjCount` + 1
    				 WHERE `sys_albums`.`ID`=`sys_albums_objects`.`id_album` 
    				 AND `sys_albums_objects`.`id_object`=92
    				 AND `sys_albums`.`Type`='bx_videos'

AlexT what about the video count being wrong in videos album?

After fixing mysql setting it shouldn't happen anymore.

Old values can be fixed through database only.

This seems to be for mysql errors and emails. I just want to fix the video count.