Hi,

This node looks like something I've been looking for a long time but I am having problems installing it. I keep getting errors along the line of: "user warning: Table 'reserves.node_expire' doesn't exist query:"

I'm running 5.x with PHP 4 and I've checked my database tables and indeed the reserves.node_expiry table doesn't exist. I installed the module as per every other module and as per the README. Am I missing something?

Thanks

Comments

astoltz’s picture

astoltz commented

Your install of Drupal must have something wrong with it. To manually add the table, run the following two SQL commands:

ALTER TABLE node_expire
CHANGE nid nid INT( 10 ) NOT NULL,
ADD expiresec IVARCHAR(10) NOT NULL,
ADD expiremode ENUM( 'date', 'onupdate', 'none' ) NOT NULL DEFAULT 'none',
ADD isroot TINYINT( 1 ) NOT NULL DEFAULT '0',
ADD lastnotify INT( 10 ) NOT NULL DEFAULT '0',
DROP INDEX nid,
ADD PRIMARY KEY (nid);
INSERT IGNORE INTO node_expire (nid, expiremode) (SELECT nid, 'none' FROM node);

astoltz’s picture

astoltz commented

Sorry, these are the commands:
CREATE TABLE node_expire (
nid int(10) unsigned NOT NULL,
expire datetime default NULL,
expiresec VARCHAR(10) NOT NULL,
expiremode enum('date','onupdate','none') NOT NULL default 'none',
isroot tinyint(1) NOT NULL default '0',
lastnotify int(10) NOT NULL default '0',
PRIMARY KEY (nid)
) ENGINE=MyISAM;
INSERT IGNORE INTO node_expire (nid, expiremode) (SELECT nid, 'none' FROM node);

pnc999’s picture

pnc999 commented

Thanks andyl56

That second set of commands worked perfectly.

astoltz’s picture

astoltz commented
Status: Active » Closed (fixed)