This is an observation that might help others, not a question.
(But it is not a 'Discussion', hence posting it under 'Questions' - apologies if this is Bad Practice - feel free to move or re-categorise if necessary).
This is now re classified as a question!
I wanted to use some Template Variables that I had set up in an old site in a new site.
I transferred the contents of the following tables from one site to another using phpMyAdmin:
site_tmplvars
site_tmplvar_contentvalues
site_tmplvar_templates
Unfortunately not all my template variables appeared in managers Elements tree.
It turned out that I had applied Categories to the TVs in the old site. The new site had the same Categories in it, but they had been created manually and had different IDs in the database tables. Changing the IDs in the 'categories' table to match those in the old site fixed the problem.
If I discover that changing the IDs in the 'categories' table to match those in the old site causes some awful, unforseen problem with the new site I will amend this post.
Should I have done this?
[ed. note: andytough last edited this post 13 years, 8 months ago.]
