User panel stuff on forum
  5 posts on 1 page  1
Site Feedback
2007-08-23, 20:43
Member
226 posts

Registered:
Jun 2006
I'm having troubles opening the quakeworld.nu main website address. Whenever I do it pulls this instead of the page:

getnews:136
Duplicate entry '137' for key 1
SELECT news.newsID, DATE_FORMAT( DATE_ADD( news.newsDate, INTERVAL -8 HOUR ) , '%d %b %Y @ %H:%i' ) AS dateOfNews, news.newsAuthorID, news.newsHeadline, news.newsIntro, news.newsBody, news.newsCategoryID, news.newsHighlight, news.newsViews, punbb_users.username, punbb_users.nationiso, punbb_users.id, categories.categoryName, categories.categoryImg , COUNT(comments.commentID) AS numcomments FROM news LEFT OUTER JOIN comments ON comments.commentArticleID = news.newsID AND comments.commentArticleType = 'news' INNER JOIN punbb_users ON news.newsAuthorID=punbb_users.id INNER JOIN categories ON news.newsCategoryID=categories.categoryID WHERE news.newsStatus = 'C' GROUP BY news.newsID ORDER BY news.newsDate DESC LIMIT 0, 10

It just started as far as I know within the last couple of hours. Did anyone notice this?
--irc.quakenet.org #telefrag.me and #QWL | foogsQuakeWorld Ladder
2007-08-23, 21:20
Member
230 posts

Registered:
Jan 2006
Same here! Was like this when i tried 2,5 hours ago and it's still the same.
2007-08-23, 21:59
Member
20 posts

Registered:
May 2007
getnews:136
Duplicate entry '137' for key 1
SELECT news.newsID, DATE_FORMAT( DATE_ADD( news.newsDate, INTERVAL 1 HOUR ) , '%d %b %Y @ %H:%i' ) AS dateOfNews, news.newsAuthorID, news.newsHeadline, news.newsIntro, news.newsBody, news.newsCategoryID, news.newsHighlight, news.newsViews, punbb_users.username, punbb_users.nationiso, punbb_users.id, categories.categoryName, categories.categoryImg , COUNT(comments.commentID) AS numcomments FROM news LEFT OUTER JOIN comments ON comments.commentArticleID = news.newsID AND comments.commentArticleType = 'news' INNER JOIN punbb_users ON news.newsAuthorID=punbb_users.id INNER JOIN categories ON news.newsCategoryID=categories.categoryID WHERE news.newsStatus = 'C' GROUP BY news.newsID ORDER BY news.newsDate DESC LIMIT 0, 10


at 6:00 pm est
2007-08-24, 00:33
Member
4 posts

Registered:
Aug 2007
Yeah this has been fixed
2007-08-24, 11:04
Administrator
1864 posts

Registered:
Feb 2006
Hehe, guess i was using my test account
  5 posts on 1 page  1