First off I'd like to thank you for this module. However I seem to be encountering a warning error message when I try to add a client.
Steps to Reproduce
1. Install/Activate Jobtrack
2. Go to admin/jobtrack/clients
3. Click Add client
4. Enter client name, details, status: enabled
5. See warning message on admin/jobtrack/clients:

user warning: Unknown column 'extra' in 'field list' query: UPDATE drupal_jobtrack_client SET name = 'AnarchicQ', path = 'anarchicq', status = 1, integrate_email = 0, server_name = '', server_username = '', server_password = '', mailbox = 'INBOX', mailfrom = '', protocol = 0, extra = '/novalidate-cert', port = 0, autosubscribe = '', domains = '', notes = '' WHERE clid = 0 in /home/fanfixco/public_html/modules/jobtrack/jobtrack.admin.inc on line 206.

Thanks,
Rebecca G.

Comments

leevester’s picture

leevester commented

I had gotten this same type of message during some testing I was doing with JobTrack. It appeared to be caused by installing one version and then another version.

Problem cleared after I disabled the module (along with JobTrack Nag, which I had installed)
Uninstalled it completely using the administer > site building > modules > uninstall.
Then I re-enabled the Jobtrack module.

Problem cleared. Re-enabled JobTrack Nag and in my case the problem has not resurfaced.

geekgirlweb’s picture

geekgirlweb commented

Thanks for the advice leevester, it seems to be a problem with Nag. Since it's unnecessary module I think I'll just keep it uninstalled for now.

Correction it was the SMS module that was giving me a problem.

I uninstalled, and re-installed Jobtrack and attempted to add a client again. Still receiving an error message:

user warning: Unknown column 'extra' in 'field list' query: UPDATE drupal_jobtrack_client SET name = 'AnarchicQ', path = 'anarchicq', status = 1, integrate_email = 0, server_name = '', server_username = '', server_password = '', mailbox = 'INBOX', mailfrom = '', protocol = 0, extra = '/novalidate-cert', port = 0, autosubscribe = 'Becca', domains = '', notes = '' WHERE clid = 0 in /home/user/public_html/modules/jobtrack/jobtrack.admin.inc on line 206.

leevester’s picture

leevester commented

Probably a needless question, but did you make sure that all of the JobTrack tables where removed from the database after you uninstalled it?

geekgirlweb’s picture

geekgirlweb commented

Yup, I even went manually a second time and deleted the jobtrack tables. I removed all traces of jobtrack, and tried a fresh install, but I got that error message still.

jeremy’s picture

jeremy commented
Status: Active » Fixed

This was an old bug that should now be fixed. I recommend you completely uninstall the jobtrack module, and install the new support module.

Status: Fixed » Closed (fixed)

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