user warning: Key column 'nid' doesn't exist in table query: CREATE TABLE publicbookings_clients ( `client_id` INT auto_increment DEFAULT NULL, `record_id` INT unsigned NOT NULL, `secondary_records` VARCHAR(64) NOT NULL, `uid` INT unsigned NOT NULL, `passphrase` VARCHAR(12) NOT NULL, `first_name` VARCHAR(32) NOT NULL, `last_name` VARCHAR(32) NOT NULL, `phone` VARCHAR(10) NOT NULL, `email` VARCHAR(64) NOT NULL, `comments` TEXT NOT NULL, `created` DATETIME NOT NULL, `modified` DATETIME NOT NULL, PRIMARY KEY (nid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /Library/WebServer/Documents/drupal/includes/database.inc on line 509.

Comments

seath_49’s picture

seath_49 commented

The same for me, any idea?

neruocomp’s picture

neruocomp commented

I get the same problem too.

vlooivlerke’s picture

vlooivlerke commented

Same here

bdhook’s picture

bdhook commented

You can get the module to work correctly by modifying one line in the code.

Locate the following line in publicbookings.install:

'primary key' => array('nid'),

Change it to:

'primary key' => array('client_id'),

Note that you will need to run the module's uninstall feature, and then re-enable it in order to have it create the proper table.

4drian’s picture

4drian commented
Status: Active » Fixed

The fix mentioned by bdhook seems to be in the current dev build - marking as fixed?

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

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

kenorb’s picture

kenorb commented

Had the same problem.
Thanks.