I upgraded JobTrack and i was getting an error, something related to "no column isclosed'. I added through phpMyAdmin column 'isclosed' (TINYINT) to table 'states'. Now i have another error:

* user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 query: SELECT COUNT(DISTINCT(n.nid)) FROM node n LEFT JOIN comments c ON n.nid = c.nid AND (c.status = 0 OR c.status IS NULL) LEFT JOIN jobtrack_ticket t ON n.nid = t.nid WHERE n.status = 1 AND client = 1 AND t.state NOT IN () in D:\wamp\www\modules\jobtrack\jobtrack.module on line 1638.
* user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY last_updated DESC LIMIT 0, 50' at line 1 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 = 1 AND t.state NOT IN () ORDER BY last_updated DESC LIMIT 0, 50 in D:\wamp\www\modules\jobtrack\jobtrack.module on line 1638.

Comments

jeremy’s picture

jeremy commented
Status: Active » Fixed

You need to run update.php. This will create the necessary field, and properly populate it. Creating these fields manually is not advised!

blindvic’s picture

blindvic commented

i deleted the field and ran the update.php. Now i am getting another kind of errors:

* user warning: Unknown column 'isclosed' in 'where clause' query: SELECT sid FROM jobtrack_states WHERE isclosed = 1 in D:\wamp\www\modules\jobtrack\jobtrack.module on line 1554.
* user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 query: SELECT COUNT(DISTINCT(n.nid)) FROM node n LEFT JOIN comments c ON n.nid = c.nid AND (c.status = 0 OR c.status IS NULL) LEFT JOIN jobtrack_ticket t ON n.nid = t.nid WHERE n.status = 1 AND client = 1 AND t.state NOT IN () in D:\wamp\www\modules\jobtrack\jobtrack.module on line 1638.
* user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY last_updated DESC LIMIT 0, 50' at line 1 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 = 1 AND t.state NOT IN () ORDER BY last_updated DESC LIMIT 0, 50 in D:\wamp\www\modules\jobtrack\jobtrack.module on line 1638.

Can you tell me what to do to get rid off of them? Thanks

jeremy’s picture

jeremy commented

Be sure that you copied in the latest version of jobtrack.install. If so, force run update 6010, as this is where all these changes happen.

blindvic’s picture

blindvic commented
Status: Fixed » Closed (fixed)

I forced update 6010 and it's working now. Thanks!

jeremy’s picture

jeremy commented
Status: Closed (fixed) » Fixed

I'm glad to hear that worked.

Please leave fixed issues in a "fixed" state. This allows other people having similar problems to find this issue and solve their own problems. The issue will be automatically closed after two weeks.

Status: Fixed » Closed (fixed)

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