本帖最后由 ljq1985 于 2009-11-14 10:36 编辑
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','帖子消息','');
复制代码然后到“[工具]更新缓存”更新系统缓存后即可。 |