Add more headlines Error Message

dleeward - July 3, 2008 - 13:08
Project:E-Publish
Version:5.x-1.2
Component:Code
Category:bug report
Priority:normal
Assigned:Unassigned
Status:closed
Description

I get the following error message just under the title of the page when I try to add a headline:

user warning: Unknown column 'n.nid' in 'on clause' query: SELECT DISTINCT(n.nid) FROM node n, epublish_edition_node een INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 2 AND na.realm = 'nodeaccess_rid') OR (na.gid = 3 AND na.realm = 'nodeaccess_rid') OR (na.gid = 4 AND na.realm = 'nodeaccess_rid') OR (na.gid = 5 AND na.realm = 'nodeaccess_rid') OR (na.gid = 7 AND na.realm = 'nodeaccess_rid') OR (na.gid = 11 AND na.realm = 'nodeaccess_rid') OR (na.gid = 13 AND na.realm = 'nodeaccess_rid') OR (na.gid = 14 AND na.realm = 'nodeaccess_uid') OR (na.gid = 14 AND na.realm = 'nodeaccess_author') OR (na.gid = 2 AND na.realm = 'node_privacy_byrole_role') OR (na.gid = 3 AND na.realm = 'node_privacy_byrole_role') OR (na.gid = 4 AND na.realm = 'node_privacy_byrole_role') OR (na.gid = 5 AND na.realm = 'node_privacy_byrole_role') OR (na.gid = 7 AND na.realm = 'node_privacy_byrole_role') OR (na.gid = 11 AND na.realm = 'node_privacy_byrole_role') OR (na.gid = 13 AND na.realm = 'node_privacy_byrole_role') OR (na.gid = 14 AND na.realm = 'node_privacy_byrole_user') OR (na.gid = 0 AND na.realm = 'og_public'))) AND ( een.nid = n.nid AND een.eid='1' AND n.status='1' ) ORDER BY n.sticky DESC, n.created DESC in /home/leewarda/public_html/includes/database.mysql.inc on line 172.

#1

dleeward - July 3, 2008 - 13:25

This appears to be a permissions problem. I don't get the error when logged in as Administrator.

#2

dleeward - July 3, 2008 - 13:32
Category:support request» bug report
Priority:normal» critical

Although I'm not getting the error message, I'm still not able to add headlines even though the status mesage indicates I've added headlines.

#3

phd_hiren - August 22, 2008 - 07:06
Priority:critical» normal
Status:active» postponed (maintainer needs more info)

How to reproduce this error, I'm unable to find this error

#4

dleeward - October 6, 2008 - 18:06
Status:postponed (maintainer needs more info)» closed

Works now. Had to add section topics before adding headlines.

 
 

Drupal is a registered trademark of Dries Buytaert.