Upgrading D6 to D7 and Taxonomy Extras

A bit more looking around and I think the dev version sorts the problem of Web Links taking over the taxonomy term pages, and that the issue with the resultant links page showing empty categories of links apart from the general one is to do with the terms already associated with the links being put into Taxonomy Upgrade Extras on upgrade to D7. This doesn't seem to happen with the alpha 2 version for some reason - but I still think the base issue is the TAGs.

Thank you very much for your prompt reply and willingness to help. Sorry it's taken a couple of days to get back to you. With the assistance of a friend who is more of a coder than I am, we have solved the issue on my site (I hope).

To answer at least one of your questions re the alpha2 version, I did run the update script.
I have no screenshots from when I was experiencing the issues, but when I say Weblinks took over the taxonomy pages, this is what happened: I use Taxonomy menu to display a page of content related to that term. With the alpa2 version of Weblinks, instead of seeing "Startup" articles on the "Startup" page, I was seeing "Startup" Web links and nothing else.

I think installing the current dev version might have triggered rebuilding the taxonomy menu, or I might have done so.

I am now using 7.x-1.0-alpha2+45-dev. However, the Weblinks taxonomy was not right. I think this might not be a generic issue, but in case it helps anyone else, it seems this is what happened:

Somewhere in the D6 to D7 upgrade process Weblinks taxonomy ended up in Taxonomy Upgrade Extras. This seems to be why Weblinks puts all links in the general category with all the other categories showing (0) i.e. empty with the .dev version.

- the upgrade moved all the links to the terms to the Taxonomy Upgrade Extras (TUE)
- the weblinks content type removed the old weblinks taxonomy field and replaced it with a TUE field
- the old Weblinks taxonomy field could not be reactivated in the weblinks content type.

For future reference, we ran some scripts and this has fixed the issue. Some of this will need changing if someone else wants to use it as it is quite specific to my site at present.

step 1.
Run this script in phpmyadmin

-- Taxonomy 13 - weblinks
INSERT INTO field_data_taxonomy_weblinks
(entity_type,bundle,deleted,entity_id,revision_id,language,delta,taxonomy_weblinks_tid)
SELECT te.*
FROM field_data_taxonomyextra te
INNER JOIN taxonomy_term_data td ON te.taxonomyextra_tid=td.tid
WHERE td.vid=13
and te.entity_id not in (select tv.entity_id from field_data_taxonomy_weblinks tv INNER JOIN taxonomy_term_data ttd ON tv.taxonomy_weblinks_tid=ttd.tid WHERE ttd.vid=13)
;

INSERT INTO field_revision_taxonomy_weblinks
(entity_type,bundle,deleted,entity_id,revision_id,language,delta,taxonomy_weblinks_tid)
SELECT te.* FROM field_revision_taxonomyextra te
INNER JOIN taxonomy_term_data td ON te.taxonomyextra_tid=td.tid
WHERE td.vid=13
and te.entity_id not in (select tv.entity_id from field_revision_taxonomy_weblinks tv INNER JOIN taxonomy_term_data ttd ON tv.taxonomy_weblinks_tid=ttd.tid WHERE ttd.vid=13)
;

DELETE te, tr
FROM field_data_taxonomyextra te
INNER JOIN field_revision_taxonomyextra tr
INNER JOIN taxonomy_term_data td
WHERE te.taxonomyextra_tid=td.tid
AND tr.taxonomyextra_tid=td.tid
AND td.vid=13;

step 2
Run the following in Devel's run PHP script

$param = array();
//$param['field_name'] = 'taxonomyextra';
$param['id'] = '34';
$instances = field_read_instances($param);
foreach ($instances as $instance) {
// print ($instance )." -- ";
print ($instance['id'] )." -- ";
print ($instance['field_id'] )." -- ";
print ($instance['field_name'] )." -- ";
print ($instance['entity_type'] )." -- ";
print ($instance['bundle'] )." -- ";
print ($instance['deleted'] )." \n";

$instance2= array();
$instance2['field_id'] = 9;
$instance2['field_name'] = 'taxonomy_weblinks';
$instance2['bundle'] ='weblinks';
$instance2['entity_type'] = 'node';
field_create_instance($instance2);

print "created \n";
}

step 3
Remove extra taxomony terms from weblinks content type

Thanks for the detailed response, and for the link to the info on getting taxonomy terms out of taxonomy upgrade extras (we found that very useful as a starting point for the script I posted). Your comments all make sense.

I wouldn't be surprised if the update failed on my site as we did it several times, differently each time. A bit of a learning curve but I think we have sorted most of it out now.

I can't identify which dblog messages were issued during the upgrade nor any specific to weblinks. If there is a way to find them, I can dig through the list for you but I'm unsure what I'm looking for or how to filter to bring them up, sorry. And thanks for your persistent help. This is a great module and has always been easy and effective to use.

Thanks, I looked for "update" filter but there are none, sorry. And thanks again for your responses.