I have a problem in which items in a view are listed 6 times each. Had this problem about 3 years ago but I don't remember the solution. Seem to recall that it may have had something to do with dates. All modules and core are up to date.

Two screenshots are shown here: http://babcock.wisc.edu/node/754

Any thoughts would be greatly appreciated.

Comments

nevets’s picture

Are you using repeating dates?

Are they really the same node (I ask because the "event type" column is not always the same even though the title is)

dckantor’s picture

Definitely the same node. Don't know why the event type is only included in one of the 6 listings.

robertcfi’s picture

In the fields there should be something to check to only display one item.

dckantor’s picture

Can you be more specific. Do you mean in the field settings in the views interface or do you mean in the basic settings where you can specify how many per page to show. This second place (per page in basic) doesn't seem to have any effect on the repetition issue.

thanks

imro’s picture

I faced the same issue right now. each item was displayed 6 times, I am creating view for displaying new products in ubercart. In my case was the problem SKU(product key) field in view. I have observed issue after adding this field and issue disapeards after removing SKU field from view. You should find field that causes problem in your view.

dckantor’s picture

I don't have a sku in the view. I have noticed though that one of the fields (event type) has an entry for only one of the multiple entries - the other ones have a blank in the event field.

dckantor’s picture

I have solved the problem by unchecking and then re-checking "group multiple values" in one of my content type fields (event type). Yes it just winds up with the settings the same as they were but apparently kicking it reminds it what the setting means.

trillex’s picture

I'm having the exact same issue, but unticking, saving and ticking does not work at all. It works fine if I'm not grouping the results, but it becomes a terrible mess.

Funny thing, it's replicated exactly 6 times, which seems like a bug.

Using the latest release modules for Drupal 7

sagigreen’s picture

hi,

i am using webform and taking the data from the DB with views,
when creating one event everything works fine, when creating the second event i get 8 duplicates of each item, i tried changing one of the events and then i see that 4 of my 8 duplicates are in the old version of it and the rest is in the new version,

any new insights?

Sagi Green
VP Biz Dev
Crazy Designs
info@crazydesigns.biz
www.crazydesigns.biz

amir0220’s picture

Checking the "Distinct" checkbox in Advanced->Other->Query Settings->Settings did it for me.

Hope this helps.

Sohal Khatwani’s picture

Worked Well - Thanks!

omkarms’s picture

This Worked for me.

Thanks

frederico’s picture

Thank you Amir!