Hello there,

After attempting to use the format in a view this error appears and won't display any content

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'name' in 'field list'

Any ideas?
Cheers

Comments

scottsawyer’s picture

scottsawyer
Primary language English
Location Atlanta
commented

I am also getting this error. Just installed a minute ago. The Block generated by Tagadellic seems to work, but the views throws this error.

If I find more info, I will post back.

tsavory’s picture

tsavory commented

any news have the same issue

muka’s picture

muka commented

Hi, can you export your view or at least describe what it should show ?

scorchio’s picture

scorchio commented

I had the same error appearing. You can reproduce this with:

  1. Create a new view: Show Content, select a content type which uses the taxonomy you would like to display.
  2. Switch off Create a page, turn on Create a block. Choose Tagadelic list of Fields from Display format. Click on Continue & edit.
  3. On preview the mentioned "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'name' in 'field list'" error will appear.

I've also found how to fix this:

  1. Edit the view; open the Advanced dropdown and add a new Relationship.
  2. Select the Content: Taxonomy terms on node relationship and apply.
  3. Select the vocabulary, tick Require this relationship and apply.

After that the tagcloud will show up and display the tags as usual.

bobr37’s picture

bobr37 commented

#4 worked perfectly. cheers scorchio

muka’s picture

muka commented
Assigned: Unassigned » muka
Status: Active » Closed (fixed)

I've update the dev codebase adding the default base table as default relationship.
Please, reopen if this cause any issue.