PPH Posted August 8, 2007 Share Posted August 8, 2007 We just upgraded to 3.2.3 by copying the full install 3.2.3 download over our 3.2.2 install and have found that when viewing daily performance in the admin reports section we have this above the results: 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 Copying the 3.2.2 daily_performance.php file back eliminates this. Tried to check it on the demo, but it shows 3.2.2 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.