Can you check if there are overrides in atum, so that frontend + backend overrides sum up to 34?

Hello,

I have check, but there is no override in de administrator template atum.
So the sum is still not okay (2+2+19=23 <> 34).
Regards,
Peter

Hi @peterhulst,
could you check the database table #__template_overrides - how many rows do you have?

SELECT * FROM `#__template_overrides` WHERE `state` = 0;

An option would be a missing extension record (so that we have orphaned items):

SELECT `o`.*, `e`.`name`, `e`.`element` FROM `#__template_overrides` as `o`
LEFT JOIN `#__extensions` as `e`
ON `o`.`extension_id` = `e`.`extension_id`
WHERE `o`.`state` = 0;

Note: When execute SQL commands, you have to replace #__ with your specific database prefix.

If possible, please post the query results here.

In version 5.4.6 the numbers changed a bit:
Expected result
Individual: 3+3+19=25
Override(s) to check: 23
Actual result
Individual: 2+2+19=23
Override(s) to check: 36

Result of first query:
SELECT * FROM #__template_overrides WHERE state = 0;
see:
github47549_query1.txt

Result of second query:
SELECT o.*, e.name, e.element FROM #__template_overrides as o
LEFT JOIN #__extensions as e
ON o.extension_id = e.extension_id
WHERE o.state = 0;
see:
github47549_query2.txt

github47549_query1.txt
github47549_query2.txt

Regards,
Peter

In version 5.4.6 the numbers changed a bit:
Expected result
Individual: 3+3+19=25
Override(s) to check: 25
Actual result
Individual: 3+3+19=25
Override(s) to check: 36

Result of first query:
SELECT * FROM #__template_overrides WHERE state = 0;
see:
github47549_query1.txt

Result of second query:
SELECT o.*, e.name, e.element FROM #__template_overrides as o
LEFT JOIN #__extensions as e
ON o.extension_id = e.extension_id
WHERE o.state = 0;
see:
github47549_query2.txt

github47549_query1.txt
github47549_query2.txt

Regards,
Peter

It looks as there are two more site templates (ja_purity_iv and t3_blank). These also have a valid extension id.

Total: 36

So the sum is correct. Is it possible that these two template extensions have been disabled? That would make sense, and I can reproduce it too.

Hello @heelc29,

You are completely right. Both templates are disabled. When I enable them, the counting of the overrides is correct.
Thank you for the analysis.
I will complete this issue.

Regards,
Peter

Great that you found the reason. But i would still classify it as a bug to be fixed. The count should not include disabled templates

Great that you found the reason. But i would still classify it as a bug to be fixed. The count should not include disabled templates

I agree with you @brianteeman . Now that the cause is known, it should be easily to fix.

please can you re-open this fir visibility and then hopefully someone will write a fix