I got those nasty error
| Project: | Advanced Profile Kit |
| Version: | 6.x-1.0-beta2 |
| Component: | Views |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
Jump to:
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
Fixed,
the comment module wasn't enabled, just enable it if you see those warnings in the future.
#2
#3
Automatically closed -- issue fixed for 2 weeks with no activity.