After installing the latest release, this the the error I found in the "Submit Worklog" section:

* user warning: Table 'propertymanager1.worklog' doesn't exist query: SELECT * FROM worklog WHERE wlid=0 in C:\eclipse\workspace\PropertyManager1\includes\database.mysql.inc on line 120.
* user warning: Table 'propertymanager1.worklog_invoice' doesn't exist query: SELECT n.title, n.nid FROM node n LEFT JOIN worklog_invoice wi ON n.nid = wi.nid WHERE n.type='worklog-invoice' AND n.status = 1 AND (wi.closed = 0 OR n.nid=0) in C:\eclipse\workspace\PropertyManager1\includes\database.mysql.inc on line 120.

And here is what I saw when I went to "Submit Worklog Invoice":

user warning: Table 'propertymanager1.worklog' doesn't exist query: SELECT n.title, w.* FROM node n LEFT JOIN worklog w ON n.nid = w.nid LEFT JOIN worklog_invoice_map wim ON wim.worklog_nid = n.nid WHERE n.type='worklog' AND n.status = 1 AND (wim.invoice_nid IS NULL OR wim.invoice_nid = 0) in C:\eclipse\workspace\PropertyManager1\includes\database.mysql.inc on line 120.

I'm using Drupal 4.7.2.

Comments

Dave Cohen’s picture

Dave Cohen commented

The problem here is that workflow does not (yet) use the drupal install system. So the database tables are not created automatically when you enable the module.

For now, do something like:

mysql MY_DATABASE < modules/workflow/workflow.mysql

to install the tables.

rbryer’s picture

rbryer commented

In the current file set the worklog.mysql file does not contain all the required tables. It only has the table worklog defined

sime’s picture

sime
any/any
Location Melbourne
commented

Yep, can you please commit or post the worklog_invoice create statement?

sime’s picture

sime
any/any
Location Melbourne
commented

No urgency, I've rolled back to worklog.module version 1.4 so that I can review.

Dave Cohen’s picture

Dave Cohen commented
Assigned: Unassigned » Dave Cohen

Try the DRUPAL-4-7 version. That should be the latest. Unless I screwed up the cvs tags.

I haven't had time to keep any of my modules up to date with HEAD.

rbryer’s picture

rbryer commented
Status: Active » Closed (fixed)