If I direct access a Client Ticket page, going to /jobtrack/CLIENTPATH, of a disabled Client I see an error message.
<ul>
<li>Unexpected error, client is non-numeric: CLIENTPATH</li>
<li>user warning: Unknown column 'CLIENTPATH' in 'where clause' query: SELECT COUNT(*) FROM node n LEFT JOIN jobtrack_ticket t ON n.nid = t.nid INNER JOIN node_comment_statistics l ON n.nid = l.nid INNER JOIN users u ON n.uid = u.uid LEFT JOIN comments c ON n.nid = c.nid WHERE (c.status = 0 OR c.status IS NULL) AND n.status = 1 AND n.type = 'jobtrack_ticket' AND client = CLIENTPATH AND t.state != 4 in /home/vhosts/SITENAME/drupal/sites/all/modules/jobtrack/jobtrack.module on line 1243.</li>
<li>user warning: Unknown column 'CLIENTPATH' in 'where clause' query: SELECT DISTINCT(n.nid), n.title, n.type, n.changed, n.uid, u.name, GREATEST(n.changed, l.last_comment_timestamp) AS last_updated, l.comment_count, t.state, t.priority, t.assigned FROM node n LEFT JOIN jobtrack_ticket t ON n.nid = t.nid INNER JOIN node_comment_statistics l ON n.nid = l.nid INNER JOIN users u ON n.uid = u.uid LEFT JOIN comments c ON n.nid = c.nid WHERE (c.status = 0 OR c.status IS NULL) AND n.status = 1 AND n.type = 'jobtrack_ticket' AND client = CLIENTPATH AND t.state != 4 ORDER BY last_updated DESC LIMIT 0, 50 in /home/vhosts/SITENAME/drupal/sites/all/modules/jobtrack/jobtrack.module on line 1243.</li>
</ul>
Where CLIENTPATH is the path I assigned to the client, but it's wrong because looking at the code it should be CLIENT ID.
Cheers
Comments
Comment #1
subcomandante commentedPrevious post was a bit crap.
If I direct access a Client Ticket page, going to /jobtrack/CLIENTPATH, of a disabled Client I see an error message.
Where CLIENTPATH is the path I assigned to the client, but it's wrong because looking at the code it should be CLIENT ID.
Cheers
Comment #2
jeremy commentedThanks, I'll take a look before the next release.
Comment #3
jeremy commentedFix committed.