Uploaded image for project: 'eZ Publish / Platform'
  1. eZ Publish / Platform
  2. EZP-19565

Fatal error in function orderStatistics from ezorder.php

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Legacy > Webshop
    • Labels:
      None
    • Environment:

      Operating System: GNU/Linux
      PHP Version: 5.3.6 & 5.3.15
      Database and version: MySQL Community Server 5.5.27
      Browser (and version): -

      Description

      In the orderStatistics function from ezorder.php

      If you choice a date there is no product sold, you got a fatal error

      This is due to a SQL query with a WHERE id IN () empty

      Query error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY id ASC' at line 2.
      Query: SELECT id, section_id, owner_id, contentclass_id, name, published, modified, current_version, status, remote_id, language_mask, initial_language_id FROM ezcontentobject WHERE id IN ( ) ORDER BY id ASC

      Steps to reproduce
      • Go to Webshop tab in the backend
      • Choice 'Product statistics' in left menu
      • Select a date where is no product sold
      • Fatal Error: ....

        Attachments

          Activity

            People

            Assignee:
            nfrp Nicolas Pastorino
            Reporter:
            taenadil Xavier Van Herpe
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: