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
Comment #1
dries commentedFixed in CVS.
Comment #2
zw commentedIn 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
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:
Comment #3
zw commentedI 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
.
Comment #4
(not verified) commented