谢谢minstrel和markwu的解答,我看能不能解决,如果没有问题再过来答复！
谢谢！

非常抱歉！
我前面写错得很厉害实际上mysql 是4.3.6 版本

minstrel请见谅!
 

服务器平台：Mysql3.xx + PHP4.xx + IIS6.x

我们的程序自plog0.32版开始升级至1.0再到现在的1.01
平台访问及操作越来越慢甚至不能登陆,很棘手的！

程式碼:

22-10-2005 10:53:41 ERROR - The following query = 
SELECT * FROM Plog_blogs WHERE id = '1'
generated the following error message = 
Lost connection to MySQL server during query

22-10-2005 10:53:42 ERROR - The following query = 
SELECT * FROM Plog_blogs WHERE id = '1'
generated the following error message = 
Lost connection to MySQL server during query

22-10-2005 10:53:57 ERROR - The following query = 
SELECT u.id AS id, u.user AS user, u.password AS password, u.email AS email,
                             u.about AS about, u.full_name AS full_name, u.properties AS properties,
                             u.resource_picture_id AS resource_picture_id,
                             IF(p.permission_id = 1, 1, 0 ) AS site_admin,
                             u.status AS status
                      FROM Plog_users u LEFT JOIN Plog_users_permissions p ON u.id = p.user_id
                      WHERE u.user = 'gibraltar'
generated the following error message = 
Lost connection to MySQL server during query

22-10-2005 11:00:31 ERROR - The following query = 
SELECT u.id AS id, u.user AS user, u.password AS password, u.email AS email,
                             u.about AS about, u.full_name AS full_name, u.properties AS properties,
                             u.resource_picture_id AS resource_picture_id,
                             IF(p.permission_id = 1, 1, 0 ) AS site_admin,
                             u.status AS status
                      FROM Plog_users u LEFT JOIN Plog_users_permissions p ON u.id = p.user_id
                      WHERE u.user = 'momoko'
generated the following error message = 
Lost connection to MySQL server during query

22-10-2005 11:03:06 ERROR - The following query = 
SELECT * FROM Plog_blogs WHERE id = '84'
generated the following error message = 
Lost connection to MySQL server during query

22-10-2005 11:03:31 ERROR - The following query = 
SELECT * FROM Plog_blogs WHERE id = '84'
generated the following error message = 
Lost connection to MySQL server during query

22-10-2005 11:06:04 ERROR - The following query = 
SELECT u.id AS id, u.user AS user, u.password AS password, u.email AS email,
                             u.about AS about, u.full_name AS full_name, u.properties AS properties,
                             u.resource_picture_id AS resource_picture_id,
                             IF(p.permission_id = 1, 1, 0 ) AS site_admin,
                             u.status AS status

请问sql_error.log里面有出现以上错误日志是何缘故？
恳请知道的朋友给与解答！
 

請問一下硬體環境是??CPU? RAM?? 還有資料庫版本??
要不要換個web server測試看看呢??

CPU Intel P4 2.4G
RAM 1G DDR
MYSQL 4.2

换了别的server试过,只是稍微好一点点,但也有卡住的时候！

另外安装的插件有:
authimage
recentcomments
secret
smileys
topreadposts

在0.32版本时候用plog并没有这个现象,但从0.32升级至1.0以后老是出问题!
CPU使用率达到99％－100％然后网站被卡死,服务器的其他网站也被卡死了
出现这种问题后就只好reboot!但过不了多久又被卡死

有没有人和我遇到的情况一样啊？
好郁闷的

服务器环境:
windows server2003
IIS 6.0
php4.2

我本来以为是通过什么软件发,

然后为了阻止垃圾评论,我在代码中加了段php代码,用来判断HTTP_REFERER是否来自本站,如果不是就禁止.

不过无效 ，垃圾评论还是有

 建议安装一个authimage插件,这样就会阻挡那些机器人发的垃圾

James大哥客气了，我当初没想到linux平台作业系统咧！
多谢提醒

好像还有比较简便的方法哦！
插入mp3档就可以在code编辑环境下这样啊：

程式碼:

<object id="mplayer" style="WIDTH: 345px; HEIGHT: 70px" codebase="http://activex.microsoft.com/activex/controls/mplayer/en/nsmp2inf.cab#Version=6,4,5,715" type="application/x-oleobject" height="1" standby="Loading Microsoft Windows Media Player components..." width="1" align="baseline" border="0" classid="CLSID:22d6f312-b0f6-11d0-94ab-0080c74c7e95" hidden="true"><param value="MP3档路径" name="FileName" /><param value="1" name="ShowControls" /><param value="0" name="ShowPositionControls" /><param value="1" name="ShowAudioControls" /><param value="1" name="ShowTracker" /><param value="0" name="ShowDisplay" /><param value="1" name="ShowStatusBar" /><param value="0" name="AutoSize" /><param value="0" name="ShowGotoBar" /><param value="0" name="ShowCaptioning" /><param value="1" name="AutoStart" /><param value="0" name="PlayCount" /><param value="0" name="AnimationAtStart" /><param value="0" name="TransparentAtStart" /><param value="0" name="AllowScan" /><param value="1" name="EnableContextMenu" /><param value="0" name="ClickToPlay" /><param value="1" name="InvokeURLs" /><param value="datawindow" name="DefaultFrame" /></object><br/>

MV也可以播放的！只不过修改一下文件路径和播放器的宽度和高度就好了啦！
我这里有预览啊!


seaspace

贊成lss的提議

看你們討論這麽開心，白癡的問一聲:Moblog是干嘛用的啊!
  大家不要倒哦... ...

請期待 1.1 版！謝謝！

谢谢  

能否在首頁增加所有文章的分頁功能,比如一共有200篇文章,我設置在首頁顯示為10篇文章,那麽首頁的分頁功能就自動分爲20頁的選項,類似搜索引擎的顯示！
就像這樣子啦!

程式碼:

上一页 1 2 3 4 5 6 7 8 9 10 11 下一页 

辛苦mark了... ...