Closed (fixed)
Project:
Jobtrack
Version:
6.x-1.2
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
19 Feb 2009 at 21:47 UTC
Updated:
13 Apr 2009 at 16:50 UTC
After ugrade from 1.1 to 1.2, get this error:
user warning: Unknown column 'integrate_email' in 'field list' query: SELECT clid, name, status, integrate_email, mailfrom FROM jobtrack_client ORDER BY name ASC LIMIT 0, 50 in /home/myhostingacct/public_html/myclient/sites/all/modules/jobtrack/jobtrack.admin.inc on line 14.
Did run update.php right away
Comments
Comment #1
greta_drupal commentedI added the column to the db manually, but can you tell me what the field specs should be?
Comment #2
greta_drupal commentedI just made the field tinyint(1) and left other attributes alone. The error cleared, but I would like to make sure I have it set up properly/precisely.
Comment #3
greta_drupal commentedThe outgoing email notification does not appear to be working for subscribers. I have the inbound email suppressed, and have entered 2 of my own email addresses (separated by comma) for auto subscribe, as a test. Neither received the alerts, nor did any of my Users.
On a recent jobticket update (comment), I selected all of my users under the Subscribed option. (I have only 1 client set up.) Is the email notification suppose to be triggered by the Subscribed settings selected (using that user's drupal account email) or by what is in the auto subscriber field?
In my test, neither is working.
The job ticket notification does appear to be going to the Assignee and admin -- I am getting them to those email address, which are different from the 2 test ones I set up for auto-subscribe.
Thank you!
Comment #4
jeremy commentedRegarding the missing database field, this should have been automatically created when you upgraded to 1.2. If not, run the 6007 update manually (got to update.php, and select it from the drop down).
When auto-assigning users, you can only auto-assign users that exist on your website. You can't just add arbitrary email addresses -- it is not clear to me if this is what you are trying to do. The module needs to do some validation at this step, but I've not had time to cleanup the admin interfaces yet. (You should be entering user names, not email addresses. On my live system they are one and the same, so I likely did not provide clear documentation.)
Comment #5
jeremy commentedNo further feedback, assuming things are now working for you -- closing this issue.