DB Field not found error if Ananymous user try to fill guestbook

dkaswan - August 28, 2008 - 12:00
Project:Simple Guestbook
Version:5.x-1.x-dev
Component:Code
Category:bug report
Priority:normal
Assigned:Unassigned
Status:active
Description

DB Field not found error if Ananymous user try to fill guestbook.

user warning: Unknown column 'n.moderate' in 'where clause' query: SELECT COUNT(DISTINCT(id)) FROM simpleguestbook WHERE ((n.moderate != 1)) AND ( pid=0 AND status=1) in /opt/lampp/htdocs/drupal/includes/database.mysql.inc on line 172.
user warning: Unknown column 'n.moderate' in 'where clause' query: SELECT * FROM simpleguestbook WHERE ((n.moderate != 1)) AND ( pid=0 AND status=1 ) ORDER BY id DESC LIMIT 0, 10 in /opt/lampp/htdocs/drupal/includes/database.mysql.inc on line 172.

#1

RAD-X - October 9, 2008 - 09:39

I have similar problem:
DB Field not found error if Anonymous user try to read guestbook (guestbook homepage).

user warning: Unknown column 'n.nid' in 'on clause' query: SELECT COUNT(DISTINCT(id)) FROM simpleguestbook 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 = 1 AND na.realm = 'term_access'))) AND ( pid=0 AND status=1) in /home/fkvs/WWW/includes/database.mysql.inc on line 172.
user warning: Unknown column 'n.nid' in 'on clause' query: SELECT * FROM simpleguestbook 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 = 1 AND na.realm = 'term_access'))) AND ( pid=0 AND status=1 ) ORDER BY id DESC LIMIT 0, 20 in /home/fkvs/WWW/includes/database.mysql.inc on line 172.

Any solutions?

 
 

Drupal is a registered trademark of Dries Buytaert.