Daily Performance Report error

[serverx]

im getting this error on Daily Performance Report :

 

select cal . tdy as date , IFNULL( tac . tac , 0 ) as neworders , IFNULL( tdo . tdo , 0 ) as newdomains , IFNULL( tic . tic , 0 ) as newinvoices , IFNULL( tip . tip , 0 ) as paidinvoices , IFNULL( tti . tti , 0 ) as newtickets , IFNULL( tcr . tcr , 0 ) as cancelations from ( SELECT DATE( `date` ) as tdy FROM tblemails GROUP BY DATE( `date` ) DESC ) cal LEFT JOIN ( SELECT count( id ) AS tac , DATE( `date` ) as tdy FROM tblorders GROUP BY DATE( `date` ) ) tac ON cal . tdy = tac . tdy LEFT JOIN ( SELECT count( id ) AS tdo , DATE( `registrationdate` ) as tdy FROM tbldomains GROUP BY DATE( `registrationdate` ) ) tdo ON cal . tdy = tdo . tdy LEFT JOIN ( select SUM( total ) as tic , DATE( `date` ) as tdy from tblinvoices GROUP BY DATE( `date` ) ) tic ON cal . tdy = tic . tdy LEFT JOIN ( select SUM( total ) as tip , DATE( `datepaid` ) as tdy from tblinvoices GROUP BY DATE( `datepaid` ) ) tip ON cal . tdy = tip . tdy LEFT JOIN ( select count( id ) as tti , DATE( `date` ) as tdy from tbltickets GROUP BY DATE( `date` ) ) tti ON cal . tdy = tti . tdy LEFT JOIN ( select count( id ) as tcr , DATE( `date` ) as tdy from tblcancelrequests GROUP BY DATE( `date` ) ) tcr ON cal . tdy = tcr . tdy LIMIT 0, 30

 

how i can correct it?

Thanks

[disenioweb]

have you modified the report ?

[Matt]

This was fixed in a previous upgrade so looks like you haven't updated all your files.

 

Matt