Error installing Job and Asset [#70655]

After installing all of the modules ERP requires this is the message I got when I enabled the Asset and Job module:

user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(`nid`) )' at line 15 query: CREATE TABLE IF NOT EXISTS job ( `nid` int(10) unsigned NOT NULL default '0', `cid` int(10) unsigned NOT NULL default '0', `job_id` int(10) NOT NULL default '0', `priority` varchar(128) NOT NULL, `due_date` int(12) NOT NULL DEFAULT '0', `job_type` varchar(20) NOT NULL, `job_status` varchar(20) NOT NULL, `oid` int(10) unsigned NOT NULL default '0', `customer` varchar(20) NOT NULL, `job_desc` text, `actions` text, `state` varchar(128) NOT NULL PRIMARY KEY (`nid`) ); in C:\eclipse\workspace\PropertyManager1\includes\database.mysql.inc on line 120.

Comments

Comment #1

RyanR commented 24 June 2006 at 21:10

OK. It appears that there are some module dependencies. I enabled just the two I wanted to play with but that doesn't work. I'm not sure where all of the dependecies are so I enabled all modules and the error above went away. Now I have two more problems:

1. If I go to create content and select Supplier I get this error:
Fatal error: Call to undefined function book_toc() in C:\eclipse\workspace\PropertyManager1\modules\erp\supplier\supplier.module on line 192

2. If I go to create content and click on create job I see this error:

* warning: Invalid argument supplied for foreach() in C:\eclipse\workspace\PropertyManager1\modules\node.module on line 359.
* warning: implode() [function.implode]: Bad arguments. in C:\eclipse\workspace\PropertyManager1\modules\node.module on line 363.
* user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 query: SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE in C:\eclipse\workspace\PropertyManager1\includes\database.mysql.inc on line 120.

3. If I select customer I get this error:

Fatal error: Call to undefined function book_toc() in C:\eclipse\workspace\PropertyManager1\modules\erp\customer\customer.module on line 517

I have just a standard 4.7.2 installation with the required and optional modules specified in the installation notes.