Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By Chris11 on
Version 6.14.
I have only recently started using Drupal. I installed v6.13 but upgraded to v6.14 when it was released.
When I attempt to view Published Comments (admin/content/comment) I get the following error message:
user warning: Unknown column 'type' in 'field list' query: SELECT comments.cid AS cid, comments.subject AS comments_subject, comments.nid AS comments_nid, comments.name AS comments_name, comments.uid AS comments_uid, comments.homepage AS comments_homepage, nid, type, comment, comments.timestamp AS comments_timestamp FROM comments comments ORDER BY comments_timestamp DESC LIMIT 0, 50 in /usr/www/users/mysite/sites/all/modules/views/includes/view.inc on line 755.
Any idea what I have done wrong.
As additional information - if I go to the Approval Queue admin/content/comment/approval I get a "Page not found" error.
I have only beginner php experience.
Comments
I have set up another simple installation
I have set up another simple test site with the same modules and get the same error in the new site.
Having the same issue with 6.14
My situation is a little bit more complicated, as I use Prosepoint profile.
Though the error message is the same.
Found a quick fix
Go to Views page and disable admin_content_comment view.
Than comments approval will work again
Thanks. That worked
Thanks. That worked