Here’s another weird thing I’ve noticed while cleaning out cruft from a Revo 2.0.8 site:
I deleted templates that weren’t being used, e.g. template #6. Then I’m going through the TVs to see if any of them aren’t being used, so I run a MySQL query like this:
mysql> SELECT * FROM modx_site_tmplvar_templates WHERE tmplvarid=9;
And the darndest thing... I get results that INCLUDE the template I just deleted, e.g.
+-----------+------------+------+
| tmplvarid | templateid | rank |
+-----------+------------+------+
| 9 | 6 | 0 |
+-----------+------------+------+
2 rows in set (0.00 sec)
I would think that deleting the parent template should have caused all associated rows in modx_site_tmplvar_templates to be deleted. Is this a bug? It seems like the association between those two tables isn’t defined correctly in the xPDO schema. Is that possible? Or is this expected behavior?
Thanks!
☆ A M B ☆
