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

subcomandante’s picture

Previous 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.

  • Unexpected error, client is non-numeric: CLIENTPATH
  • 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.
  • 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.

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

jeremy’s picture

Assigned: Unassigned » jeremy
Priority: Minor » Normal

Thanks, I'll take a look before the next release.

jeremy’s picture

Status: Active » Fixed

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.