This thing just came up at the top of the page.
Aug 1 2006
Quote:
* user warning: Got error 134 from storage engine query: SELECT r.tid, COUNT(DISTINCT(n.nid)) AS topic_count, SUM(l.comment_count) AS comment_count FROM node n INNER JOIN node_comment_statistics l ON n.nid = l.nid INNER JOIN term_node r ON n.nid = r.nid INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 2 AND na.realm = 'term_access'))) AND n.status = 1 AND n.type = 'forum' GROUP BY r.tid in /home/libcom/public_html/includes/database.mysql.inc on line 120.
* user warning: Got error 134 from storage engine query: SELECT DISTINCT(n.nid), ncs.last_comment_timestamp, IF (ncs.last_comment_uid != 0, u2.name, ncs.last_comment_name) AS last_comment_name, ncs.last_comment_uid FROM node n INNER JOIN users u1 ON n.uid = u1.uid INNER JOIN term_node tn ON n.nid = tn.nid INNER JOIN node_comment_statistics ncs ON n.nid = ncs.nid INNER JOIN users u2 ON ncs.last_comment_uid=u2.uid INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 2 AND na.realm = 'term_access'))) AND n.status = 1 AND tn.tid = 726 ORDER BY ncs.last_comment_timestamp DESC LIMIT 0, 1 in /home/libcom/public_html/includes/database.mysql.inc on line 120.
* user warning: Got error 134 from storage engine query: SELECT DISTINCT(n.nid), ncs.last_comment_timestamp, IF (ncs.last_comment_uid != 0, u2.name, ncs.last_comment_name) AS last_comment_name, ncs.last_comment_uid FROM node n INNER JOIN users u1 ON n.uid = u1.uid INNER JOIN term_node tn ON n.nid = tn.nid INNER JOIN node_comment_statistics ncs ON n.nid = ncs.nid INNER JOIN users u2 ON ncs.last_comment_uid=u2.uid INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 2 AND na.realm = 'term_access'))) AND n.status = 1 AND tn.tid = 748 ORDER BY ncs.last_comment_timestamp DESC LIMIT 0, 1 in /home/libcom/public_html/includes/database.mysql.inc on line 120.
Not sure what it means but I thought I should let people know.
Aug 1 2006
#2
Yeah, I get that too. I also can't access "latest content," and I have to access these forums through the link on the old ones. 
Aug 1 2006
#3
I got the same
Aug 1 2006
#4
Yep me too.
Aug 1 2006
#5
user warning: Got error 134 from storage engine query: SELECT r.tid, COUNT(DISTINCT(n.nid)) AS topic_count, SUM(l.comment_count) AS comment_count FROM node n INNER JOIN node_comment_statistics l ON n.nid = l.nid INNER JOIN term_node r ON n.nid = r.nid INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 2 AND na.realm = 'term_access'))) AND n.status = 1 AND n.type = 'forum' GROUP BY r.tid in /home/libcom/public_html/includes/database.mysql.inc on line 120.
user warning: Got error 134 from storage engine query: SELECT DISTINCT(n.nid), ncs.last_comment_timestamp, IF (ncs.last_comment_uid != 0, u2.name, ncs.last_comment_name) AS last_comment_name, ncs.last_comment_uid FROM node n INNER JOIN users u1 ON n.uid = u1.uid INNER JOIN term_node tn ON n.nid = tn.nid INNER JOIN node_comment_statistics ncs ON n.nid = ncs.nid INNER JOIN users u2 ON ncs.last_comment_uid=u2.uid INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 2 AND na.realm = 'term_access'))) AND n.status = 1 AND tn.tid = 726 ORDER BY ncs.last_comment_timestamp DESC LIMIT 0, 1 in /home/libcom/public_html/includes/database.mysql.inc on line 120.
user warning: Got error 134 from storage engine query: SELECT DISTINCT(n.nid), ncs.last_comment_timestamp, IF (ncs.last_comment_uid != 0, u2.name, ncs.last_comment_name) AS last_comment_name, ncs.last_comment_uid FROM node n INNER JOIN users u1 ON n.uid = u1.uid INNER JOIN term_node tn ON n.nid = tn.nid INNER JOIN node_comment_statistics ncs ON n.nid = ncs.nid INNER JOIN users u2 ON ncs.last_comment_uid=u2.uid INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 2 AND na.realm = 'term_access'))) AND n.status = 1 AND tn.tid = 748 ORDER BY ncs.last_comment_timestamp DESC LIMIT 0, 1 in /home/libcom/public_html/includes/database.mysql.inc on line 120.
Glad it's not just me! Also got an error going into "Culture".
Aug 1 2006
#6
BB wrote:
Also got an error going into "Culture".
Yeah, I can't access the Culture forum at all.
Aug 1 2006
#7
neither can I 
Aug 1 2006
#8
Bodach gun bhrigh wrote:
neither can I :sad:
So have you bought any good records lately?
Aug 1 2006
#9
I switched minimum cache time on. Have switched it off again.
Going to run some other stuff as well then switch it back on, let me know if you get more errors.
Aug 1 2006
#10
Working fine now.
It means one or more of the tables are fucked and someone needs to go to the MySQL command line interpreter and use the "repair" command.