I have just clean-installed drupal cvs. I've created a vocabulary with one term and assigned it to forums. When viewing http://drupal/index.php?q=forum I get following message:

user error: Unknown column 'tid' in 'field list'
query: SELECT tid, count(*) AS c FROM history h, node n, forum f WHERE f.nid = n.nid AND n.nid = h.nid AND n.type = 'forum' AND n.status = 1 AND h.uid = '1' GROUP BY tid in d:develdrupalincludesdatabase.mysql.inc on line 69.

When viewing the contents of the forum I get two:

user error: Unknown column 'f.tid' in 'where clause'
query: SELECT COUNT(DISTINCT(n.nid)) FROM node n, term_node r LEFT JOIN forum f ON n.nid = f.nid WHERE n.nid = r.nid AND ( (r.tid = '5' AND f.shadow = 1) OR f.tid = '5' ) AND n.status = 1 AND n.type = 'forum' in d:develdrupalincludesdatabase.mysql.inc on line 69.

user error: Unknown column 'f.tid' in 'field list'
query: SELECT n.nid, title, u.name AS name, u.uid AS uid, n.created AS timestamp, GREATEST(n.created, MAX(c.timestamp)) AS date_sort, COUNT(c.nid) AS num_comments, icon, n.comment AS comment_mode, f.tid FROM node n, term_node r LEFT JOIN users u ON n.uid = u.uid LEFT JOIN comments c ON c.nid = n.nid LEFT JOIN forum f ON n.nid = f.nid WHERE n.nid = r.nid AND ( (r.tid = '5' AND f.shadow = 1) OR f.tid = '5' ) AND n.status = 1 AND n.type = 'forum' GROUP BY n.nid ORDER BY date_sort DESC LIMIT 0, 25 in d:develdrupalincludesdatabase.mysql.inc on line 69.

Comments

dries’s picture

Assigned: Unassigned » dries

Fixed in CVS.

zw’s picture

In database.mysql the table forum got renamed to forum2. When I changed it back to forum I was able to preview a new post. When I submited it and went back to the homepage my Apache server keeps crashing Only local images are allowed. Just before the crash the processor runs for a 3s on 100% (Duron 950MHz). Neither restart of Apache nor MySQL helped. Renaming forum back to forum2 didn't help either. PhpMyAdmin works fine so I presume it could be a drupal problem and not my instalation. Could someone else test it? The steps to reproduce are:

  1. get current CVS version of drupal
  2. fill new database with database.mysql
  3. rename table forum2 to forum
  4. enable forum module
  5. create vocabulary, assign it to forum, create a term
  6. submit a post
  7. go back to homepage
zw’s picture

I can browse the admin pages, so I have deleted the post and the server stoped crashing when viewing the homepage, but there is nothing on it now Only local images are allowed..

Anonymous’s picture

Priority: Major » Normal