-
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): -
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: ....