I get the following errror (3 times) after installing flashvideo.

user warning: Table 'vadev.upload' doesn't exist query: flashvideo_get_video_object /* Academy Admin : flashvideo_get_video_object */ SELECT fv.oid, f.filepath, fv.width, fv.height, f.fid FROM flashvideo fv LEFT JOIN files f ON f.fid = fv.fid LEFT JOIN upload u on u.fid = fv.fid WHERE (f.filemime = 'flv-application/octet-stream' OR f.filemime = 'application/octet-stream' OR f.filemime = 'application/x-flash-video' OR f.filemime = 'video/x-flv' OR f.filemime = 'video/mp4' ) AND (fv.status = 3) AND (fv.nid = 548) AND (fv.video_index = 0) AND (u.vid = 549) in /Applications/MAMP/htdocs/va/sites/all/modules/flashvideo/flashvideo.module on line 2071.

I looked at the code and it looks like its something to do with the logic around line 2059 in flashvideo.module:

2059: if (module_exists('filefield') && flashvideo_variable_get(NULL, 'flashvideo_filefield', 0)) { // Using FileField
2060: $video_file = flashvideo_get_video_file($nid, $index);
2061: }
2062: else { // They're using the core Upload module.

I think this is simply a case of I dont actually have core upload enabled on my site, and I just installed this, so no flashvideo_filefield variable is being set yet?

Comments

attheshow’s picture

attheshow commented
Category: bug » support
Status: Active » Postponed (maintainer needs more info)

I'm assuming you might have initially had the Upload module installed and then you removed it?

You need to have either Upload module turned on, OR FileField module installed and the "Use the CCK FileField module for uploads." checkbox should be checked under the "Universal Settings" for FlashVideo.

DavisImages’s picture

DavisImages commented

I am running into this same error...I uninstalled and reinstalled FlashVideo and still getting the error message. I cleared the cache also.

Where would I find the "Use the CCK FileField module for uploads." checkbox should be checked under the "Universal Settings" for FlashVideo
I looked and cant seem to find it? I have FileField module installed as well. Not sure about the Upload mod?

I am fairly new to Drupal and php so forgive me if I am over looking something basic.
Oh...the video shows and plays but the code/warning above shows up while I am admin and logged out of the site I want to use FlashVideo on.

Thanks,

Charlie

attheshow’s picture

attheshow commented

DavisImages,

Which version of the FlashVideo module are you using? I think the FileField integration was added for the 1.5 release.

You're not sure if you have the Upload module installed? You can find this out at http://YOURSITE/admin/build/modules.

-Mark

DavisImages’s picture

DavisImages commented

Mark,

I am using:
flashvideo-6.x-1.5-rc3.tar.gz

I do not have Upload in my modules - I have Filefield: filefield-6.x-3.1.tar.gz

Thanks,

Charlie

attheshow’s picture

attheshow commented

If you're using FlashVideo 6.x-1.5-rc3, you should be able to find the checkbox for "Use the CCK FileField module for uploads." at http://YOURSITE/admin/settings/flashvideo/universal

DavisImages’s picture

DavisImages commented

*SMACKS HEAD WITH KEYBOARD!!!*

Oh my! I must have been having a major blonde/old fart/brain dead moment!
I totally did not see the darn UNIVERSAL Tab next to the Content Type Settings tab!
Man...do I feel dumb! I was in a flurry to figure it out I did not even register that tab! Ugh

Thanks so so much Mark!!

All is right with the world and my website now!

*bows down humbly*

Charlie

attheshow’s picture

attheshow commented
Assigned: Unassigned » attheshow
Category: support » task
Status: Postponed (maintainer needs more info) » Needs work

Dear Charlie,

That's quite alright. I'm glad you got it working!

One good thing about this is that you've sort of called a usability issue to my attention. It seems to me that if a person installs the FlashVideo module and has FileField module installed and does NOT have Upload module installed, that this checkbox should get checked for the user by default. I'm going to see if I can make that happen.

-Mark

DavisImages’s picture

DavisImages commented
Assigned: attheshow » Unassigned
Category: task » support
Status: Needs work » Postponed (maintainer needs more info)

Cool...thanks again. I am glad to have something good come out of my silly experience!
Man I felt so goofy and lame when I realized how I missed that tab.
Oh well..I am glad to have it working as well.

I am building a site for a really good friend:
http://www.swassadventures.com
They do a web based show about geeky comic book friends and their mis-adventures!
:)
I am populating the webisode section now:
http://www.swassadventures.com/content/webisodes

This is the trailer:
http://www.swassadventures.com/content/hero-envy-trailer

Again thank you very much for all your help.

Drupal is so powerful yet simple to use and somewhat overwhelming at the same time!
I think that it is so simple that we/I tend to miss the obvious!
hehe

Charlie

attheshow’s picture

attheshow commented
Assigned: Unassigned » attheshow
Category: support » task
Status: Postponed (maintainer needs more info) » Fixed

Ok, that change has just been committed to the dev version.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.