Jump to:
| Project: | Node Template |
| Version: | 5.x-1.9 |
| Component: | Code |
| Category: | support request |
| Priority: | critical |
| Assigned: | motou |
| Status: | active |
Issue Summary
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
#1
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.
#2
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;