Flashvideo Views module with Views 2

Same problem here. I just get the [video] tag when displaying it in a view, even though looking at the node it displays the video correctly.

PS. moved this to Support in hope of some feedback or user solution.

I experience the same problem. I have a view with a field that displays the teasers of a nodes, but it simply prints [thumbnail]. The only alternative is contemplate, but I hope to achieve everything I want with Views only.

Regards,

Marius

I am having the same problem.

I get the error: flv video not supported

and the flashvideo/edit settings page won't come up anymore - totally blank. The main flashvideo module page comes up, but I can't edit of the settings anymore. Any clues?

Just to let you guys know, this will be my first priority to fix. I am hoping to have some time late next week to devote to FlashVideo. Hopefully I can have it fixed by then. Thanks.. Travis.

Fixed with latest version!

Just tried the new version and get the same problem. I assume you meant the fix was for the tags being displayed and instead of the video/thumbnail as most of the posts here mention. As post #4 however, seems an entirely different issue.

To reiterate, what i think is the problem we're having, is that we can see the video fine if we look directly at the node page. But if we put that node into a view, we just see the tag [video] or [thumbnail] output, instead of seeing the video displayed.

Can you suggest anything we might be doing wrong?

Ok. A bit more poking around generated this error, under the preview section, immediatley after selecting FlashVideo in the Fields box:
(Selecting thumbnail or video causes the same result)

* user warning: Column 'nid' in field list is ambiguous query: SELECT COUNT(*) FROM (SELECT nid, node_revisions.body AS node_revisions_body, node_revisions.format AS node_revisions_format, node.title AS node_title FROM d6_node node LEFT JOIN d6_node_revisions node_revisions ON node.vid = node_revisions.vid WHERE (node.status <> 0) AND (node.type in ('video')) ) AS count_alias in /var/www/vhosts/mydomain/httpdocs/sites/all/modules/views/includes/view.inc on line 652.

* user warning: Column 'nid' in field list is ambiguous query: SELECT nid, node_revisions.body AS node_revisions_body, node_revisions.format AS node_revisions_format, node.title AS node_title FROM d6_node node LEFT JOIN d6_node_revisions node_revisions ON node.vid = node_revisions.vid WHERE (node.status <> 0) AND (node.type in ('video')) LIMIT 0, 10 in /var/www/vhosts/mydomain/httpdocs/sites/all/modules/views/includes/view.inc on line 677.

(To be honest I didn't see the 'FlashVideo' option in the Add Fields, Group drop down list, before my last post. I assumed it would just work by including the field (ie. body) which had the [video] tag in.)

But using the FlashVideo option generates the above error. Is this the FlashVideo module or the Views module going wrong?

sampeckham...I can verify that views now works for me. I tested it both for thumbnail and video view, no problems. Maybe try clearing your cache will help. Or post an export of your view here, maybe there could be another setting in your view causing this error.

Regards,

Marius

Many thanks, I'll try that and report back. I did run update.php but forgot about the cache issue.

Clearing the cache didn't solve the problem. But, selecting only FlashVideo in the fields box does.

So here's my view that works, showing a list videos:

SELECT nid
 FROM d6_node node 
 WHERE (node.status <> 0) AND (node.type in ('video'))

Here's the view that doesn't work:

SELECT nid,
   node_revisions.teaser AS node_revisions_teaser,
   node_revisions.format AS node_revisions_format
 FROM d6_node node 
 LEFT JOIN d6_node_revisions node_revisions ON node.vid = node_revisions.vid
 WHERE (node.status <> 0) AND (node.type in ('video'))

Not sure why it's referencing node_revisions as I've just added the node.teaser field to this view, not a revision element, but I don't fully understand views ins and outs yet.

So basically video alone is fine but if I want the title, teaser, body or anything else in the view I get the error reported before.

Hope this helps.

ps. views is working fine for other cck types and other nodes.

Thanks, sampeckham.... I will check this out. That is why the fix is still in Beta right?... I will be away for about a week, but when I get back will dig into this problem.

Thanks,

Travis.

Hi,

I've come back to this module again after continuing to develop other parts of my site and I'm still getting the same problem with "ambiguous query" (see error message posted above).

This seems to be down to the view statement and the way it selects the node id. The first line of the view looks like this, when I'm trying to grab the FlashVideo field:

SELECT nid,
   node.title AS node_title
...

and looks like this if i take out the FlashVideo field

SELECT node.nid AS nid,
   node.title AS node_title

Playing around with this I noticed the error occurs each time the Select statement has SELECT nid, rather than SELECT node.nid AS nid,

Tried to find where this might be happening in your code, but I'm not a module developer so I didn't get very far. but hope this helps solve the problem.

S

Good information. Things have been a little slammed for me lately but I am trying to fix these issues one at a time. I think this will be next on my list for FlashVideo, but probably will not be able to get to it until next week sometime. When is your deadline for your project, sampeckham?

Thanks,

Travis.

Next week sounds good. It's one of my last two obstacles along with getting PayPal Pro to work with D6!!

I have been able to use the the flashvideo partially though with views, but it's not an ideal workaround. I'm currently adding videos to a separate content type (just called it video), with a body that only contains [video]. Then using views I can output this to a block by using the "Row Style: Node" rather than Field setting. This works fine, although ideally I want to add the video to the main content type that has a whole bunch of other fields and select the FlashVideo option in the fields setting, and that's where the problem above arises.

---
Also, as a slight side question, when I'm outputting Flashvideo in a node view on a page (not using views or blocks), I can use the php snippet from the settings page:

print flashvideo_get_video($node);

But in the event where some items don't have video content how would I evaluate that command or the node to test if video is present. Basically to avoid the "Video Temporarily Unavailable" as some items will never have video attached and some will. I'm looking for something along the lines of:

<?php if ($node->field_FLASHVIDEO != null): ?>
<div><?php print flashvideo_get_video($node); ?></div>
<?php endif; ?>

So I'm not sure what the field_FLASHVIDEO would be as it's not really a field?
---

Thanks

S

Hi Guys:

I still see [video] when I'm in a view, and only see my flash player when I click into the node.
What are you thinking of doing in this regard:
making the player visible?
showing a placeholder [thumbnail]?

I don't really have a preferred solution, but the [video] tag when in a view looks budget.
Out of curiosity: how does this related to the views2 plugin (ie: what does that do?)

Great module.

Don't see views options and fields too.
D6, Views2 and latest FlashVideo

subscribe, has latest FlashVideo, Drupal 6.6, Views 2, just [video] in teaser field in view

Waiting for solution, coz i have the same problem here...

The fix for this has been checked in. It will be in RC2.

Fixed with latest version.