SiT! Bugs

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0000118SiT!reportspublic2008-07-18 15:192008-07-22 15:08
Reporterkieran 
Assigned Topaulh 
PriorityhighSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOSOS Version
Product Version 
Target Version3.36Fixed in Version3.36 
Summary0000118: SQL errors in year engineer export
DescriptionThere are two SQL errors in yearly_engineer_export.php:

Warning: MySQL Query Error: SELECT i.id AS incid, i.title AS title, u.realname AS realname, u.id AS userid, i.opened AS opened, i.closed AS closed FROM `users` AS u, `incidents` AS i WHERE u.id = i.owner AND ((i.opened >= 1214866800 AND i.opened <= 1216335600) OR (i.closed >= 1214866800 AND i.closed <= 1216335600)) AND ((users.id=1)) ORDER BY realname, i.id ASC Unknown column 'users.id' in 'where clause' in /home/kieran/Code/sitracker/trunk/htdocs/reports/yearly_engineer_export.php on line 382

Warning: !Error: MySQL Query Error in (SELECT distinct(incidentid) AS incid FROM `updates` AS u, `incidents` AS i WHERE u.incidentid = i.id AND u.bodytext LIKE "External ID%" AND ((i.opened >= 1214866800 AND i.opened <= 1216335600) OR (i.closed >= 1214866800 AND i.closed <= 1216335600)) AND ((incidents.owner=1)) GROUP BY incidentid): Unknown column 'incidents.owner' in 'where clause' in /home/kieran/Code/sitracker/trunk/includes/functions.inc.php on line 3418
TagsNo tags attached.
Attached Files

- Relationships

-  Notes
User avatar (0000044)
paulh (administrator)
2008-07-18 19:54

Resolved in r3845 trunk and r3847 3.36 branch

- Issue History
Date Modified Username Field Change
2008-07-18 15:19 kieran New Issue
2008-07-18 19:54 paulh Note Added: 0000044
2008-07-18 19:54 paulh Assigned To => paulh
2008-07-18 19:54 paulh Status new => resolved
2008-07-18 19:54 paulh Resolution open => fixed
2008-07-18 19:54 paulh Fixed in Version => 3.36
2008-07-22 15:08 ivan Status resolved => closed


Copyright © 2000 - 2019 MantisBT Team
Powered by Mantis Bugtracker