Thanks for all your help -- that issue has been resolved ---
But the system is so slow I can't use it --- and I replaced the theme as one of you guys thought that was the problem -- but to open a screen -- it takes 45 seconds to 2 minutes to go from screen to screen --
My sites are going to the main site login when they used to go to their own login -- I am about ready to give up on wpmu -- I have been struggling with this site for 4 years now -- and it is one thing after another that comes up --
I am so frustrated -- we thought the category issue is what was making it so slow -- but it is slower now than it ever has been
The way I look at this --- it is ok to have these --
because the post tag and listing could have the same term_id
for instance in DB283
term-id 609 is Panama
term-id 1107 is United Kingdom -
Location could be Panama
and there could be a post-tag of Panama also
same with 1107
What do you think?
I show the ones you identified as fixed -- but I still show two that have term-id issues according to the sql -- 48, 283
Now these are not category issues -- the common term-id is between post tags and listings [attachment=1288091,118885][attachment=1288091,118886]
That plugin is not accurate for some reason --- I had it installed and it did not return items even though they were there - -the best way is to run it on the whole db.
One of your staff wrote the following sql which can also be used to double check
SELECT * FROM wp_48_term_taxonomy WHERE term_id IN ( SELECT a.term_id FROM wp_48_term_taxonomy a JOIN wp_48_term_taxonomy b on b.term_id = a.term_id AND b.taxonomy <> a.taxonomy ) ORDER BY wp_48_term_taxonomy.term_id ASC
Thank you for the detailed post. I would like to correct the record. I did not mix all those issues. Support did because somewhere along the road they felt they were all related.
The reason I thought the crons were causing the issues is because I was under the impression that the reason we put the crons in place was so the term-id process would run -- and I was thinking that process is what was bringing the system to a crawl.
Back to the main issue:
So you have tested all the categories on blog 48 and they now allow you to edit it?
I have not tested all 120 or so sites - but i do know that there are a half a dozen of the action in sites/city - business. sites such as jacksonvillebusiness mapped to actioninjacksonville.com, jacksonvillerealestate etc. that do have problems so I assume they all do.
make sure you read -- the three or four previous comments of mine -- I am not sure if this will help you but I found it and thought I would relay it