Hi, thanks for continuing the jobsearch module in Drupal. I appreciate it much.

I am seeing this log error, still everything seems to work fine on the user's end:

Table 'drupal.job' doesn't exist query: SELECT COUNT(*) FROM job WHERE nid = 172 AND uid = 1 in C:\Inetpub\wwwroot\BHRP\includes\database.mysql.inc on line 172.

Not sure where to go, true there is no 'job' table in my database, there is only a content-type table for jobs.
Any ideas? thanks

John A

Comments

kbahey’s picture

kbahey CreditAttribution: kbahey commented
Status: Active » Postponed (maintainer needs more info)

The table should be created automatically when you first enable the module.

If you can uninstall the module, do so, otherwise delete the row referring to it in the system table, and reinstall it again. Or better yet, install it on a clean Drupal site (fresh install).

Not any messages that you get when you enable it, or any watchdog messages relating to it.

If the table does not get created, please include this info and post it here.

goose2000’s picture

goose2000 CreditAttribution: goose2000 commented

I got around it but maybe some bug here still. I had used previous jobsearch modules for 4.7 . So I could not start fresh really. I did do a run on the update.php script when I was 1st installing. I don't think it worked right.

Anyway I took a look at the install script and found the table setup fucntion, converted that to a .sql script and ran it on the database, it worked and the error has ceased.

John

kbahey’s picture

kbahey CreditAttribution: kbahey commented
Title: missing table maybe? » Updating from versions prior to 5.x does not create db table
Status: Postponed (maintainer needs more info) » Fixed

Version 4.7 had no tables at all.

5.x introduced a new table, and therefore this caused what you are seeing.

I added a fix to update.php to create the tables.

Should be available in the tar ball about 12 hours from now.

thierry_gd’s picture

thierry_gd CreditAttribution: thierry_gd commented

Same problem : db tables not created

kbahey’s picture

kbahey CreditAttribution: kbahey commented
Status: Fixed » Postponed (maintainer needs more info)

In phpmyadmin, or mysql command line do:

SELECT name, schema_version FROM system WHERE name = 'job';

See what the schema version is.

You can just delete the row for job from the system table, and then try to install the module again. The table should be created this time.