Anonymous | Login | Signup for a new account | 2021-04-11 07:00 BST | ![]() |
Main | My View | View Issues | Change Log | Roadmap |
View Issue Details [ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||||
ID | Project | Category | View Status | Date Submitted | Last Update | ||||
0000118 | SiT! | reports | public | 2008-07-18 15:19 | 2008-07-22 15:08 | ||||
Reporter | kieran | ||||||||
Assigned To | paulh | ||||||||
Priority | high | Severity | minor | Reproducibility | have not tried | ||||
Status | closed | Resolution | fixed | ||||||
Platform | OS | OS Version | |||||||
Product Version | |||||||||
Target Version | 3.36 | Fixed in Version | 3.36 | ||||||
Summary | 0000118: SQL errors in year engineer export | ||||||||
Description | There 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 | ||||||||
Tags | No tags attached. | ||||||||
Attached Files | |||||||||
![]() |
|
paulh (administrator) 2008-07-18 19:54 |
Resolved in r3845 trunk and r3847 3.36 branch |
![]() |
|||
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 - 2021 MantisBT Team |