-
Type:
Incident report
-
Resolution: Unresolved
-
Priority:
Trivial
-
None
-
Affects Version/s: 3.0.0alpha4
-
Component/s: Frontend (F)
File: report3.php
define('YEAR_LEFT_SHIFT', 5);
1. This user define should be moved to defines.inc.php
2. If YEAR_LEFT_SHIFT = -5
Then:
Error in query [SELECT * FROM service_alarms sa WHERE sa.serviceid='1' AND () ORDER BY sa.clock,sa.servicealarmid] [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 sa.clock,sa.servicealarmid' at line 1]
3. If YEAR_LEFT_SHIFT is large number
For example, YEAR_LEFT_SHIFT = 115
Then:
See issue.png
