装备现在怎么玩
我的邮箱一段时间每天收到一些这样的邮件，好象是说贴子列表页面的问题，请哪位朋友能帮帮我吗？邮件是这样的。There seems to have been a problem with the database of your Discuz! Board
Discuz! info: MySQL Query Error
Time: 2006-2-20 11:13am
Script: /forumdisplay.php
SQL: INSERT INTO cdb_sessions (sid, ip1, ip2, ip3, ip4, uid, username, groupid, styleid, invisible, action, lastactivity, fid, tid)
VALUES ('5GDWrq', '61', '135', '146', '205', '0', '', '7', '2', '', '2', '1140405198', '18', '')
Error:Duplicate entry '5GDWrq' for key 1
Errno.:1062
Please check-up your MySQL server and forum scripts, similar errors will not be reported again in recent 24 hours
If you have troubles in solving this problem, please visit Discuz! Community http://www.Discuz.net.
下面是我的forumdisplay文件
<?php/* :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: :: Crossday Discuz! Board :: :: (c) 2001-2005 Comsenz Technology Ltd (www.discuz.com) :: :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: :: Author:Crossday (tech@discuz.com) Cnteacher (cnteacher@discuz.com) :: :: Version: 2.5F 2004/10/01 05:15 :: ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::*///fix:BY pk0909/*1 公告作者连接问题2 accessmask的问题*/define('CURRSCRIPT','forumdisplay');require './include/common.php';require DISCUZ_ROOT.'./include/forum.php';$discuz_action = 2;$fadvert = $forum['fadvert'];$fadverts = $forum['fadverts'];if(isset($showoldetails)) { switch ($showoldetails) { case 'no': setcookie('onlinedetail', 0, $timestamp + 86400 * 365, $cookiepath, $cookiedomain); break; case 'yes': setcookie('onlinedetail', 1, $timestamp + 86400 * 365, $cookiepath, $cookiedomain); break; }} else { $showoldetails = false;}if(!$forum['fid'] || $forum['type'] == 'group' || ($adminid<>1 && !$forum)) { showmessage('forum_nonexistence', NULL, 'HALTED');}if($forum['type'] == 'forum') { $navigation = "» $forum"; $navtitle = ' - '.strip_tags($forum['name']);} else { $forumup = $_DCACHE['forums'][$forum['fup']]['name']; $navigation = "» <a href="forumdisplay.php?fid=$forum">$forumup</a> » $forum"; $navtitle = ' - '.strip_tags($forumup).' - '.strip_tags($forum['name']);}if($forum['password'] && $action == 'pwverify') { if($pw != $forum['password']) { showmessage('forum_passwd_incorrect', NULL, 'HALTED'); } else { setcookie("fidpw$fid", $pw, 0, $cookiepath, $cookiedomain); showmessage('forum_passwd_correct', "forumdisplay.php?fid=$fid"); }}if($forum['viewperm'] && !strstr($forum['viewperm'], "\t$groupid\t") && !$forum['allowview']) { showmessage('forum_nopermission', NULL, 'HALTED');}if(!empty($forum['password']) && $forum['password'] != $_COOKIE["fidpw$fid"]) { include template('forumdisplay_passwd'); exit();}$ismoderator = modcheck($discuz_user);$moderatedby = moddisplay($forum['moderator'], 'forumdisplay');$postcredits = $forum['postcredits'] != -1 ? $forum['postcredits'] : $postcredits;$replycredits = $forum['replycredits'] != -1 ? $forum['replycredits'] : $replycredits;$subexists = 0;foreach($_DCACHE['forums'] as $sub) { if($sub['type'] == 'sub' && $sub['fup'] == $fid && ($accessmasks || !$hideprivate || !$sub['viewperm'] || strstr($sub['viewperm'], "\t$groupid\t") || strstr($sub['users'], "\t$discuz_uid\t"))) { $sublist = array(); $sql = $accessmasks ? "SELECT f.fid, f.fup, f.type, f.icon, f.name, f.description,f.bgmusic,f.bgmusicurl,f.bgmusicloop, f.moderator, f.threads, f.posts, f.lastpost, f.viewperm, a.allowview FROM $table_forums f LEFT JOIN $table_access a ON a.uid='$discuz_uid' AND a.fid=f.fid WHERE fup='$fid' AND status='1' AND type='sub' ORDER BY f.displayorder" : "SELECT fid, fup, type, icon, name, description,bgmusic,bgmusicurl,bgmusicloop, moderator, threads,color, posts, lastpost, viewperm FROM $table_forums WHERE fup='$fid' AND status='1' AND type='sub' ORDER BY displayorder"; $query = $db->query($sql); while($sub = $db->fetch_array($query)) { if(forum($sub)) { $sublist[] = $sub; $subexists = 1; } } break; }}$page = intval($page) ? intval($page) : 1;$start_limit = ($page - 1) * $tpp;$announcement_list = array();if($page == 1&& $_DCACHE['announcements_forum']) { foreach($_DCACHE['announcements_forum'] as $ann) { $ann['authorencode'] = rawurlencode($ann['author']); $ann['starttime'] = gmdate("$dateformat $timeformat", $ann['starttime'] + ($timeoffset * 3600)); $announcement_list[] = $ann ; }} $forumdisplayadd = $filteradd = '';if(!empty($filter)) { if(is_numeric($filter)) { $forumdisplayadd .= "&filter=$filter"; $filteradd = "AND lastpost>='".($timestamp - $filter)."'"; } elseif($filter == 'digest') { $forumdisplayadd .= "&filter=digest"; $filteradd = "AND digest>'0'"; }} else { $filter = '';}$ascdesc == 'ASC' ? $forumdisplayadd .= "&ascdesc=$ascdesc" : $ascdesc = 'DESC';if($whosonlinestatus == 2 || $whosonlinestatus == 3) { $whosonlinestatus = 0; $onlineinfo = explode("\t", $onlinerecord); $detailstatus = ((!isset($_COOKIE['onlinedetail']) && $onlineinfo < 500) || ($_COOKIE['onlinedetail'] || $showoldetails == 'yes')) && $showoldetails != 'no'; if($detailstatus) { updatesession(); @include language('actions'); $whosonline = array(); $forumname = strip_tags($forum['name']); $query = $db->query("SELECT uid, groupid, username, invisible, lastactivity, action FROM $table_sessions WHERE uid>'0' AND fid='$fid' AND invisible='0'"); if($db->num_rows($query)) { $whosonlinestatus = 1; while($online = $db->fetch_array($query)) { $online['icon'] = isset($_DCACHE['onlinelist'][$online['groupid']]) ? $_DCACHE['onlinelist'][$online['groupid']] : $_DCACHE['onlinelist']; $online['action'] = $actioncode[$online['action']]; $online['lastactivity'] = gmdate($timeformat, $online['lastactivity'] + ($timeoffset * 3600)); $whosonline[] = $online; } } unset($online); }} else { $whosonlinestatus = 0;}if($discuz_uid && $newpm) { require DISCUZ_ROOT.'./include/pmprompt.php';}if(!empty($filter)) { $query = $db->query("SELECT COUNT(*) FROM $table_threads WHERE fid='$fid' $filteradd"); $threadcount = $db->result($query, 0);} else { $threadcount = $forum['threads'];}$multipage = multi($threadcount, $tpp, $page, "forumdisplay.php?fid=$fid$forumdisplayadd");$separatepos = 0;$threadlist = array();$colorarray = array('', 'red', 'orange', 'yellow', 'green', 'cyan', 'blue', 'purple', 'gray');$query = $db->query("SELECT t.*, p.rate FROM $table_threads t USE INDEX(displayorder) LEFT JOIN $table_posts p USING(tid, dateline) WHERE t.fid='$fid' $filteradd ORDER BY t.displayorder DESC, t.lastpost $ascdesc LIMIT $start_limit, $tpp ");while($thread = $db->fetch_array($query)) { $thread['dateline1'] = $thread['dateline'];$thread['icon'] = isset($_DCACHE['icons'][$thread['iconid']]) ? '<img src="'.SMDIR.'/'.$_DCACHE['icons'][$thread['iconid']].'" align="absmiddle">' : ' '; $thread['lastposterenc'] = rawurlencode($thread['lastposter']); $postsnum = $thread['replies'] + 1; if($postsnum> $ppp) { $pagelinks = ''; $topicpages = ceil($postsnum / $ppp); for ($i = 1; $i <= $topicpages; $i++) { $pagelinks .= "<a href="viewthread.php?tid=$thread&page=$i&fpage=$page">$i</a> "; if($i == 6) { $i = $topicpages + 1; } } if($topicpages > 6) { $pagelinks .= " .. <a href="viewthread.php?tid=$thread&page=$topicpages&fpage=$page">$topicpages</a> "; } $thread['multipage'] = ' ( <img src="'.IMGDIR.'/multipage.gif" align="absmiddle" boader="0"> '.$pagelinks.')'; } else { $thread['multipage'] = ''; } if($thread['highlight']) { $string = sprintf('%02d', $thread['highlight']); $stylestr = sprintf('%03b', $string); $thread['highlight'] = 'style="'; $thread['highlight'] .= $stylestr ? 'font-weight: bold;' : ''; $thread['highlight'] .= $stylestr ? 'font-style: italic;' : ''; $thread['highlight'] .= $stylestr ? 'text-decoration: underline;' : ''; $thread['highlight'] .= $string ? 'color: '.$colorarray[$string] : ''; $thread['highlight'] .= '"'; } else { $thread['highlight'] = ''; } if($thread['closed']) { $thread['new'] = 0; if($thread['closed'] > 1) { $thread['moved'] = $thread['tid']; $thread['tid'] = $thread['closed']; $thread['replies'] = '-'; $thread['views'] = '-'; } else { $thread['moved'] = 0; } $thread['folder'] = 'lock_folder.gif'; } else { $thread['folder'] = 'folder.gif'; if($lastvisit < $thread['lastpost'] && !strstr($_COOKIE['oldtopics'], "\t$thread\t")) { $thread['new'] = 1; $thread['folder'] = 'red_'.$thread['folder']; } else { $thread['new'] = 0; } if($thread['replies'] > $thread['views']) { $thread['views'] = $thread['replies']; } if($thread['replies'] >= $hottopic) { $thread['folder'] = 'hot_'.$thread['folder']; } } if($thread['attachment']) { require_once DISCUZ_ROOT.'./include/attachment.php'; $thread['attachment'] = attachtype($thread['attachment']).' '; } else { $thread['attachment'] = ''; } $thread = cutstr($thread,77); $thread['dateline'] = gmdate($dateformat, $thread['dateline'] + $timeoffset * 3600); $thread['lastpost'] = gmdate("$dateformat $timeformat", $thread['lastpost'] + $timeoffset * 3600); if($thread['displayorder'] > 0) { $separatepos++; } $threadlist[] = $thread;}$check[$filter] = 'selected="selected"';$ascdesc == 'ASC' ? $check['asc'] = 'selected="selected"' : $check['desc'] = 'selected="selected"';$forumselect = $forumjump ? forumselect() : NULL;$usesigcheck = $signature ? 'checked' : NULL;$allowpost = (!$forum['postperm'] && $allowpost) || ($forum['postperm'] && strstr($forum['postperm'], "\t$groupid\t")) || $forum['allowpost'];include template('forumdisplay');?>
本人小坛简阳论坛：http://www.jy0832.com
QQ：80411235
希望哪位热心的朋友能帮帮我。在下不胜感激。
[ 本帖最后由 ygz731 于 2006-2-28 09:06 编辑 ] 收到好多哟，现又列出一个。帮自已顶下。
There seems to have been a problem with the database of your Discuz! BoardDiscuz! info: MySQL Query ErrorUser: 花花Time: 2006-2-27 10:36pmScript: /viewthread.phpSQL: UPDATE cdb_stats SET count=count+1 WHERE (type='total' AND var='hits')OR (type='month' AND var='200602') OR (type='week' AND var='1') OR (type='hour' AND var='22')Error:Lost connection to MySQL server during queryErrno.:2013Please check-up your MySQL server and forum scripts, similar errors will not be reported again in recent 24 hoursIf you have troubles in solving this problem, please visit Discuz! Community http://www.Discuz.net. 再列出一个。肯请哪位仁兄帮忙。有谢。
There seems to have been a problem with the database of your Discuz! BoardDiscuz! info: MySQL Query ErrorTime: 2006-2-27 10:36pmScript: /redirect.phpSQL: SELECT sid, uid AS sessionuid, groupid, groupid='6' AS ipbanned, styleid FROM cdb_sessions WHERE sid='kbx3CN' AND CONCAT_WS('.',ip1,ip2,ip3,ip4)='222.208.46.101'Error:Lost connection to MySQL server during queryErrno.:2013Please check-up your MySQL server and forum scripts, similar errors will not be reported again in recent 24 hoursIf you have troubles in solving this problem, please visit Discuz! Community http://www.Discuz.net. 我以前也收到过。好象是MYSQL错误吧！ 不知道，帮你顶。 帮顶～～ qq币拿来啊,哈哈,我教你,如果论坛可以正常访问,不出现错误,哪就关闭系统上的错误邮件发送功能吧,具体看config.ini.php 关闭接受MYSQL错误报告就可以。这个很正常的没什么。 哈哈 原帖由 fengshen34 于 2006-2-28 11:29 发表
关闭接受MYSQL错误报告就可以。这个很正常的没什么。
正解哦
页:
[1]