[development] CCK and Views data structures screwed up

[Earl Miles]

Earl Miles wrote:
> Walt Daniels wrote:
>> I have a CCK content type and it has a bunch of entries in it. When I 
>> show
>> it in a view two of the entries are duplicated multiple times. I suspect
>> something is screwed up in the data structure.
>> Experiment number one. There were three copies of one entry so I 
>> decide to
>> clone that entry so as to not lose the data and then delete the original.
>> Doing so created three copies called Clone of ... and deleting the 
>> original
>> got rid of all three. Next step is create a new entry and copy the fields
>> from the clone into it. When that is submitted, I now have two copies 
>> (one
>> less than before). What is going on?
>>
>> Pathauto is turned on in case that has something to do with the problem.
>> There is only one entry in the alias table.
> 
> There's no way to answer this question without knowing every field, 
> filter, sort criteria and argument in your query.
> 
> It's really really easy to produce 'dups' in SQL and thus in Views; many 
> things could be doing it. Often it's taxonomy related, but any field 
> that can have multiple values can easily do it if not configured 
> appropriately.

I should amend: It's highly unlikely that the data structures are messed up.