Community

Site Very Slow - Notice: Undefined offset: 0 in taxonomy_field_views_data()

Hi Everyone,

I have a website with a lot of taxonomy data - and a lot of relationships between taxonomy terms and nodes.

I am getting this "notice" during page refreshes on the site. I am also experiencing painfully slow reloading times when logged in as an admin that I believe stem from this.

This is the full error: Notice: Undefined offset: 0 in taxonomy_field_views_data() (line 433 of /home/nmchost/public_html/_SITES/mainesportscommission/sites/all/modules/views/modules/taxonomy.views.inc).

Leading me to believe it has something to do with views.

Background
This is essentially a giant database of sports venues.
Because this website has so many taxonomy items (about 400 venues, thousands of cities, and various other categories) I used Taxonomy CSV to import the items http://drupal.org/project/taxonomy_csv

Some of the taxonomy I imported with taxonomy CSV had fields that related to other taxonomy items. For example, when I imported venues (each with a city) - the field city references the city taxonomy type.

Visible Problem
Here are some images to a visible problem I can see when editing my "event" content type - there are two notices that come up and two fields that have this issue. The vocabulary displays twice for the field taxonomy term reference.
Vocabulary displays twice (bad): http://i107.photobucket.com/albums/m310/boon4376/Music/Stuff/Embedding%2...
Vocabulary Displays once as it should: http://i107.photobucket.com/albums/m310/boon4376/Music/Stuff/Embedding%2...
All vocabulary (there are no duplicate vocabs with the same name, the reference field is trying to reference the same vocabulary twice): http://i107.photobucket.com/albums/m310/boon4376/Music/Stuff/Embedding%2...

Is There a DB Fix?
Because I have already added (a lot of) content to the site, I cannot "re-do" this field reference. Is there a correction I can make directly in the database to fix this problem? I need to make these fields only attempt to reference the vocabulary once I believe.
I believe the system is running into a problem with this causing the ~20 second hang during non-cached page reloads.

Thanks in advance!

Comments

Did you get resolve?

Did you get resolve?

nobody click here