| Anonymous | Login | Signup for a new account | 2020-10-01 07:25 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 | |||||||||
 Relationships |
|
 Relationships |
|
Notes |
|
 (0000044)paulh (administrator) 2008-07-18 19:54 |
Resolved in r3845 trunk and r3847 3.36 branch |
|
Notes |
|
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 |
|
Issue History |
| Copyright © 2000 - 2020 MantisBT Team |
|