各位前辈看一下，这是我们最近遇到的最主要的两个问题。
我们的系统配置是 win2000 iis5.0 php4.4.2 mysql5.0.18 已经加载 mbstring 模块和
gd 图像处理模块，mysql 数据库字符编码设置为 utf8-general，我不知道还可以提
供那些有用的信息，但现在问题是比较麻烦的。sql_error.log 已经达到 343KB，基
本上就是下面两种错误，当中文和英文、数字混合并且中间无空格时，贝叶斯训
练系统就会尝试把错误的字符串写入数据库，然后报错。
另外的错误似乎来自资源中心，用户反映并没有很严重的问题，但服务器管理员
称服务器CPU占用偶尔会跳跃到 50% 居高不下。
08-03-2006 08:15:12 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 lt_users u LEFT JOIN lt_users_permissions p ON u.id = p.user_id
WHERE u.id = ORDER BY blog_id
generated the following error message =
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY blog_id' at line 7
08-03-2006 16:10:55 ERROR - The following query =
INSERT INTO lt_bayesian_tokens (blog_id, token, spam_occurrences, nonspam_occurrences, prob) VALUES ('89', 'hanyiny?, '0', '1', '0.01')
generated the following error message =
Data too long for column 'token' at row 1
