Details
-
Bug
-
Resolution: Fixed
-
Medium
-
None
-
None
-
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: ....