Thumbnail Attaching to Wrong Node
| Project: | FlashVideo |
| Version: | 5.x-2.8-rc3 |
| Component: | Code |
| Category: | bug report |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
Hello, currently I'm having an issue with thumbnails attaching to the wrong node. For example, video could be uploaded to node 104, however the thumbnail for that video can be seen attached to node 100 (even if this node has no video). Every video after that will attach that many behind, i.e. 105 will have a thumbnail at 101, 106 at 102, etc.
The odd thing is the teaser of 104 still shows the thumbnail as normal, and the node it appears to be attached to, 100, shows a "thumbnail not available" image. If I delete the thumbnail from 100, then the 104 teaser show the "thumbnail not available". It seems my database is a bit off kilter, but I'm unsure how it got that way, or to correct it.
If someone could tell me the different ids (fids, nids, and oids), this might help.
Another suspect is possibly having to deal with another quirk. Sometimes the attaching of video hangs, and won't complete until I hit submit on the node. It seems that when I do this it creates two of the same video on the node. This could be goofing up my database, I'm unsure.
Any help is greatly appreciated. This is breaking the video option on the website we're trying to launch in the next couple of weeks.
Thanks!
#1
Some more info:
The node that the thumbnail is incorrectly attaching to also calls up the video player with no playlist id, for instance it calls on:
file=http://www.yoursite.com/index.php?q=getplaylist/
instead of
file=http://www.yoursite.com/index.php?q=getplaylist/104 (or whatever the number is needed)
#2
Looking through my database, I notice that the fids and oids sometimes don't match up, is this related? or is this normal?
#3
I'm starting to figure this out. It seems the issue revolves around nid's and vid's. If a video is attached to a node, this will work as normal, however if another node has the same vid number as the original node's nid, the thumbnail(s) will appear attached to this other node.
For instance:
Video is uploaded and attached to the node 104 (nid=104).
If node 100 (nid=100) has a vid of 104, then the thumbnails will appear attached to node 100.
Vid's usually equal the nid's, unless you use revisions (is this correct?), so if you make any revisions, your vid's will start to differ from the nid's and possibly give you the problem that I'm having.
So now I ask, how do I fix this? Do I need to stop using revisions? And how do I get my auto-increments for nid and vid to sync up again?
Please help if you can.
#4
Here is my current work-around for this bug, in case anyone else is experiencing this.
Since this bug seems to happen when there is a difference between nid's and vid's, I've disabled revisions (as per http://drupal.org/node/289466 ) and then adjusted the nid and vid fields in the "sequences" table of the database so that they coincide again.
#5
We had a fix for vid insertion into the Upload table for the D6 version of the module. Perhaps we just need to create a patch for D5?
http://drupal.org/cvs?commit=169850