I'm in the process of trying to install Node Template and Leech. I have installed, uninstalled, and reinstalled both modules, and whenever I try to access Node Template I receive the following errors:

* user warning: Unknown column 's.is_template' in 'where clause' query: SELECT COUNT(n.nid) FROM node n INNER JOIN node_template s ON n.nid = s.nid WHERE s.is_template = 1 in /public_html/includes/database.mysql.inc on line 172.
* user warning: Unknown column 's.shared' in 'field list' query: SELECT n.nid, n.uid, n.type, 0 AS cid, 1 AS node, n.title, n.status, n.changed, s.shared FROM node n INNER JOIN node_template s ON n.nid = s.nid WHERE s.is_template = 1 ORDER BY changed DESC LIMIT 0, 50 in /public_html/includes/database.mysql.inc on line 172.

Any idea about what this is and how to correct it?

Thank you.

Comments

femrich’s picture

femrich commented
Priority: Normal » Critical

I'm still trying to fix this. I see that a previous user who experienced this was advised to update to v. 1.8, but seeing as how I am on 1.9 it doesn't seem this is an adequate solution.

Any advice for fixing this in the current version?

Thanks.

motou’s picture

motou commented
Assigned: Unassigned » motou

It's apparently the Drupal didn't install the database for node_template.

BTW: Could you specify the Drupal version?

There are two ways to get rid of it:

1. Use update.php under your installation directory and find the update for node_template.
2. Use phpmysql or tools alike to insert the mysql query in nodetemplate.sql, which comes with the module, it should look like:

CREATE TABLE `node_template` (
  `nid` int(10) unsigned NOT NULL,
  `is_template` tinyint(1) default '0',
  `shared` tinyint(1) default '0',
  PRIMARY KEY  (`nid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;