I am brand new to Drupal, but experience in Joomla! I am tryi ngto implement the job module with jobs plus. Essentially I want a front end that will be able to display jobs to be applied to and a section for recruiters to go in and view applications, post jobs, etc. I thought I installed the modules correctly, however, I am getting the following error message on EVERY PAGE of my site. Please help!!



    * user warning: Table 'edgepoint11.cache_job_country' doesn't exist query: SELECT data, created, headers, expire FROM cache_job_country WHERE cid = 'node/1' in /home/content/g/n/a/gnacron/html/includes/database.mysql.inc on line 174.
    * user warning: Unknown column 'j.field_job_address_country' in 'field list' query: SELECT j.field_job_address_country FROM node n LEFT JOIN content_type_job j ON n.nid=j.nid WHERE n.status=1 in /home/content/g/n/a/gnacron/html/includes/database.mysql.inc on line 174.
    * user warning: Table 'edgepoint11.cache_job_country' doesn't exist query: LOCK TABLES cache_job_country WRITE in /home/content/g/n/a/gnacron/html/includes/database.mysql.inc on line 174.
    * user warning: Table 'edgepoint11.cache_job_country' doesn't exist query: UPDATE cache_job_country SET data = '<ul class=\"links\"><li class=\"first last 1\"><a href=\"/?q=node/1&amp;country=all\" class=\"1 active\">All countries</a></li>\n</ul>', created = 1255102324, expire = -1, headers = '' WHERE cid = 'node/1' in /home/content/g/n/a/gnacron/html/includes/database.mysql.inc on line 174.
    * user warning: Unknown column 'field_job_address_country' in 'field list' query: SELECT field_job_address_country FROM content_type_job WHERE nid=1 in /home/content/g/n/a/gnacron/html/includes/database.mysql.inc on line 174.

Comments

Macronomicus’s picture

Macronomicus commented
Project: Jobs » Job Plus Job Board System
Version: » 6.x-1.x-dev

Wrong forum

HumanTex’s picture

HumanTex commented

@macrocosm... no it's not in the wrong forum, as I'm getting similar errors. Notice the last line for "field_job_address_country".

Even after adding a "jobs_address" as a new address content type, it doesn't seem to be sufficient for the modules to get things working, and there are still DB columns missing for it and others. I've followed the install steps and get tons of 'doesn't exist' errors after a fresh install of all the jobs modules (as of today's 6.x-1.x-dev package).

First, I get no Jobs page at ://mySite/jobs - just a 404 page-not-found. I have 2 menu entries under Create Content, with both of them named "Job Application'... and a 3rd entry without any name/label, or nothing resembling a clickable link at all. I assume it's job related since it wasn't there before the install. Under the 'content type' list there are 2 similar entries - "job_appln" and "jobappln", along with "Resume"... but there isn't one listed as "job". Not a big deal until I find out that I can't create a new one either, as I'm warned that 'job' would be a duplicate?!? (presumably that's the unknown 'content type' without a link)

Clicking on the 'Job Country/Province Report', for example, gives me...

user warning: Table 'htdrupal.htdrupal_content_type_job' doesn't exist query: SELECT * FROM htdrupal_node n INNER JOIN htdrupal_content_type_job j ON n.nid=j.nid WHERE j.field_job_address_country ='' OR j.field_job_address_province='' AND n.type='job' in C:\xampp\htdocs\htdrupal\sites\all\modules\jobplus\jobplus.module on line 303.

There are plenty of those popping up after the install. Either there are several coding errors, I'm missing something obvious, or the install instructions are not accurate and/or complete enough to get a working install from scratch. Is there a known working version if the dev package is broken? I'm inclined to stay away from the 'listings' replacement module since there's functions I'd like to use that it doesn't currently have.

NewZeal’s picture

NewZeal commented

I suggest you uninstall and start over. Make sure that the content copy module is enabled. Sometimes if it is not enabled before the module is installed then the module misses the crucial first step. This is being fixed in the listing_job module. Jobplus is now being deprecated in favour of listing_job.

Also disable jobplus cache. This function was never implemented.

Macronomicus’s picture

Macronomicus commented

@HumanTex
It was in the wrong cue ... when I posted that it moved here. Now you are in the correct place.
Cheers!