数据库错误在 vBulletin 3.6.8:
Invalid SQL:
SELECT SQL_CALC_FOUND_ROWS
issue.*, issuenote.issuenoteid, issuenote.dateline,
IF(user.username IS NOT NULL, user.username, issuenote.username) AS username, issuenote.userid,
issuenote.type AS notetype, issuenote.isfirstnote, issuenote.pagetext,
project.title_clean AS projecttitle_clean
, IF(issueassign.issueid IS NULL, 0, 1) AS isassigned
FROM vbb_pt_issuenote AS issuenote
INNER JOIN vbb_pt_issue AS issue ON (issuenote.issueid = issue.issueid)
INNER JOIN vbb_pt_project AS project ON (project.projectid = issue.projectid)
LEFT JOIN vbb_user AS user ON (user.userid = issuenote.userid)
LEFT JOIN vbb_pt_issueassign AS issueassign ON
(issueassign.issueid = issue.issueid AND issueassign.userid = 1)
WHERE issuenote.visible = 'visible' AND (issue.projectid = 1 AND ((issue.issuetypeid = 'bug' AND (issue.visible IN ('visible','private','moderation','deleted'))) OR (issue.issuetypeid = 'feature' AND (issue.visible IN ('visible','private','moderation','deleted'))) OR (issue.issuetypeid = 'task' AND (issue.visible IN ('visible','private','moderation','deleted')))))
ORDER BY issuenote.dateline DESC
LIMIT 0, 15;
MySQL 错误 : Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation 'if'
错误号 : 1267
日期 : Thursday, November 8th 2007 @ 10:36:44 AM
脚本 :
http://www.dolc.eu/bbs/project.php
来源 :
http://www.dolc.eu/bbs/index.php?langid=3
IP 地址 : 88.73.72.254
用户名 : dolc
类名 : vB_Database