数据库出错，麻烦各位帮我看看是怎么回事？Discuz! info: MySQL Query Error

Discuz! info: MySQL Query Error

User: admin
Time: 2009-11-14 2:13pm
Script: /notice.php

SQL: SELECT count(*) FROM [Table]promptmsgs WHERE uid='1' AND typeid IN ()
Error: 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 ')' at line 1
Errno.: 1064

Similar error report has been dispatched to administrator before.

到 http://faq.comsenz.com 搜索此错误的解决方案



自己解决了。。。还是百度厉害！


discuz!7.1进入提醒时提示“SELECT count(*) FROM [Table]promptmsgs WHERE uid='613' AND typeid IN ()”错误
Discuz! 升级语句的 MySQL 兼容导致的，请到“[工具]数据库->导入”执行以下SQL语句 REPLACE INTO cdb_prompttype (`id`, `key`, `name`, `script`) VALUES (1,'pm','私人消息','pm.php?filter=newpm');

REPLACE INTO cdb_prompttype (`id`, `key`, `name`, `script`) VALUES (2,'announcepm','公共消息','pm.php?filter=announcepm');

REPLACE INTO cdb_prompttype (`id`, `key`, `name`, `script`) VALUES (3,'task','论坛任务','task.php');

REPLACE INTO cdb_prompttype (`id`, `key`, `name`, `script`) VALUES (4,'systempm','系统消息','');

REPLACE INTO cdb_prompttype (`id`, `key`, `name`, `script`) VALUES (5,'friend','好友消息','');

REPLACE INTO cdb_prompttype (`id`, `key`, `name`, `script`) VALUES (6,'threads','帖子消息','');
复制代码然后到“[工具]更新缓存”更新系统缓存后即可。

厉害呀  这一下子就解决了！

百度一下！