I got those nasty error

abdelatifs - October 21, 2009 - 17:48
Project:Advanced Profile Kit
Version:6.x-1.0-beta2
Component:Views
Category:support request
Priority:normal
Assigned:Unassigned
Status:closed
Description

Hello guys,
anybody had those before?

* user warning: Unknown column 'node_comment_statistics.last_comment_timestamp' in 'field list' query: SELECT node.nid AS nid, node.type AS node_type, node.title AS node_title, history_user.timestamp AS history_user_timestamp, history_user.nid AS history_user_nid, node.created AS node_created, node.changed AS node_changed, node_comment_statistics.last_comment_timestamp AS unknown FROM node node INNER JOIN users users ON node.uid = users.uid LEFT JOIN history history_user ON node.nid = history_user.nid AND history_user.uid = 1 WHERE (node.status <> 0) AND (node.type not in ('uprofile')) AND (users.uid = 1) ORDER BY unknown DESC LIMIT 0, 5 in /Applications/MAMP/htdocs/aviisha-dev-repository/dev/sites/all/modules/views/includes/view.inc on line 755.
* warning: Invalid argument supplied for foreach() in /Applications/MAMP/htdocs/aviisha-dev-repository/dev/sites/all/modules/views/includes/query.inc on line 918.
* warning: Invalid argument supplied for foreach() in /Applications/MAMP/htdocs/aviisha-dev-repository/dev/sites/all/modules/views/includes/query.inc on line 893.
* warning: Invalid argument supplied for foreach() in /Applications/MAMP/htdocs/aviisha-dev-repository/dev/sites/all/modules/views/includes/query.inc on line 918.
* user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM comments comments WHERE .uid = 1 ) count_alias' at line 2 query: SELECT COUNT(*) FROM (SELECT FROM comments comments WHERE .uid = 1 ) count_alias in /Applications/MAMP/htdocs/aviisha-dev-repository/dev/sites/all/modules/views/includes/view.inc on line 729.
* user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM comments comments WHERE .uid = 1 LIMIT 0, 5' at line 2 query: SELECT FROM comments comments WHERE .uid = 1 LIMIT 0, 5 in /Applications/MAMP/htdocs/aviisha-dev-repository/dev/sites/all/modules/views/includes/view.inc on line 755.

thanks

#1

abdelatifs - October 21, 2009 - 18:06

Fixed,
the comment module wasn't enabled, just enable it if you see those warnings in the future.

#2

dddave - November 2, 2009 - 22:42
Status:active» fixed

#3

System Message - November 16, 2009 - 22:50
Status:fixed» closed

Automatically closed -- issue fixed for 2 weeks with no activity.

 
 

Drupal is a registered trademark of Dries Buytaert.