Jump to content

V3.2.3 Daily Performance


PPH

Recommended Posts

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 :(

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated