After latest update the sum Σ (sigma) sign is showing as
& Sigma ;
Spaces added so it doesn't convert to the sign in all reports.
After latest update the sum Σ (sigma) sign is showing as
& Sigma ;
Spaces added so it doesn't convert to the sign in all reports.
We do not seem to replicate this.
Is the sigma sign coming from your preferences or from the dbr.sum.prefix
command?
--
myDBR Team
I have tried replacing it with either the sign or the html code for it - the result is always the same
Preferences sorry - happening to all our users however.
Do you have "Σ" set as a preference?
What is the output of:
select value, count(*)
from mydbr_options
where name like '%sumprefix%'
group by value
if you got 's:7:"Σ";' there, you can convert it to Σ:
update mydbr_options
set value='s:2:"Σ";'
where value = 's:7:"Σ";';
--
myDBR Team
value count(*)
s:3:"sum"; 2
s:7:"& Sigma ;"; 4 -- added spaces as otherwise it converts to the Σ symbol
# 2
As you can see I changed it to sum for now.
myDBR no longer dedoces the HTML values for the aggregate prefixes. Old myDBR default installations (pre 3.6.0 Oct 2012) used the 'Σ' as a prefix. Since then, the default has been an empty string.
If you want to continue to use the 'Σ' as the prefix you can use the GUI for that. If you want to set it manually, use format 's:2:"Σ";'.
The option format is a PHP serialized string where the 's' means string and the number after ':' tells the length of the string. Your manual version s:7:"& Sigma ;" misses change in the length.
--
myDBR Team
You must log in to post.