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

Fatal error in function orderStatistics from ezorder.php

    XMLWordPrintable

Details

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Medium Medium
    • None
    • None
    • Legacy > Webshop
    • None
    • 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

            nfrp nfrp
            taenadil taenadil
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: