When i build a file type view, i am getting an error generated.

user warning: Unknown column 'type' in 'field list' query: SELECT files.fid AS fid, type, nid, vid FROM files files LIMIT 0, 10 in /var/www/docs/sites/all/modules/views/includes/view.inc on line 771.

It's a simple view that just uses the first option in Fields which is, Content: Folder File (field_filedepot_file).

I'm looking to be able to create a list of all currently published documents. Do not want to include old versions.

CommentFileSizeAuthor
sample_view.txt1.5 KBrockitdev

Comments

blainelang’s picture

blainelang commented

Where are you getting the 'type' field from - as the error indicates, that field does not exist.

rockitdev’s picture

rockitdev commented

The views UI seems to be generating it.

the view i attempted to create was quite simple. I started with a new view which had a type of "file", and tried adding a single field which was the Content: Folder File (field_filedepot_file) field and that's the error that is getting thrown.

This is occuring with Views 6.x-2.10

rockitdev’s picture

rockitdev commented

has filedepot been tested to work with views, or is it at the current time only been tested to work within the filedepot UI?

blainelang’s picture

blainelang commented

I have used it to generate a view and was going to write it up as a blog post on our site. I did not have any issues other then needing to create a custom php template to show the attachments in my view.

rockitdev’s picture

rockitdev commented

hhhmmm... wonder was is going so odd in my view... basically, i just need to be able to create lists of documents to output on various pages.

we're start our project of migrating www.cdha.nshealth.ca over to drupal soon and one of the last remaining pieces of functionality we were missing was a document management system. luckily, filedepot has come out recently.

tdombos’s picture

tdombos commented

subscribe

blainelang’s picture

blainelang commented
Status: Active » Fixed

Moving this to fixed - it was reported on one of the early releases.

Status: Fixed » Closed (fixed)

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