cms2day Forum - Community & Support rund ums cms2day

Zitat

Fatal error: Invalid SQL: SELECT post.*, user_option.*, wbb_user.*, user.*, rank.*, IFNULL(user.username, post.username) AS username,avatar.avatarID, avatar.avatarExtension, avatar.width, avatar.height, post_cache.messageCache, post.username FROM wbb1_1_post post LEFT JOIN wbb1_1_post_cache post_cache ON (post_cache.postID = post.postID) LEFT JOIN wcf1_user user ON (user.userID = post.userID) LEFT JOIN wbb1_1_user wbb_user ON (wbb_user.userID = post.userID) LEFT JOIN wcf1_user_option_value user_option ON (user_option.userID = post.userID) LEFT JOIN wcf1_user_rank rank ON (rank.rankID = user.rankID) LEFT JOIN wcf1_avatar avatar ON (avatar.avatarID = user.avatarID) WHERE post.postID IN (1243,1245,1246,1248,1249,1250,1256,1257,1266,1308,1310,1353,1354,1355) ORDER BY post.time
You get more information about the problem in our knowledge base: http://www.woltlab.com/help/?code=1267
Information:
error message: Invalid SQL: SELECT post.*, user_option.*, wbb_user.*, user.*, rank.*, IFNULL(user.username, post.username) AS username,avatar.avatarID, avatar.avatarExtension, avatar.width, avatar.height, post_cache.messageCache, post.username FROM wbb1_1_post post LEFT JOIN wbb1_1_post_cache post_cache ON (post_cache.postID = post.postID) LEFT JOIN wcf1_user user ON (user.userID = post.userID) LEFT JOIN wbb1_1_user wbb_user ON (wbb_user.userID = post.userID) LEFT JOIN wcf1_user_option_value user_option ON (user_option.userID = post.userID) LEFT JOIN wcf1_user_rank rank ON (rank.rankID = user.rankID) LEFT JOIN wcf1_avatar avatar ON (avatar.avatarID = user.avatarID) WHERE post.postID IN (1243,1245,1246,1248,1249,1250,1256,1257,1266,1308,1310,1353,1354,1355) ORDER BY post.time
error code: 1267
sql type: MySQLDatabase
sql error: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation 'ifnull'
sql error number: 1267
sql version:
file: /var/www/forum/wcf/lib/system/database/MySQLDatabase.class.php (11
php version: 5.3.3-7+squeeze13
wcf version: 1.1.9 (Tempest)
date: Sun, 03 Feb 2013 15:40:25 +0000
request: /forum/index.php?page=Thread&postID=1355
referer: http://craftplay.de/forum/index.php?page=Index
Stacktrace:
#0 /var/www/forum/lib/data/post/PostList.class.php(11: MySQLDatabase->sendQuery('SELECT??post.*,...')
#1 /var/www/forum/lib/data/post/ThreadPostList.class.php(80): PostList->readPosts()
#2 /var/www/forum/lib/page/ThreadPage.class.php(116): ThreadPostList->readPosts()
#3 /var/www/forum/wcf/lib/page/AbstractPage.class.php(90): ThreadPage->readData()
#4 /var/www/forum/wcf/lib/page/AbstractPage.class.php(46): AbstractPage->show()
#5 /var/www/forum/wcf/lib/util/RequestHandler.class.php(64): AbstractPage->__construct()
#6 /var/www/forum/wcf/lib/util/RequestHandler.class.php(92): RequestHandler->__construct('Thread', Array, 'page')
#7 /var/www/forum/index.php(: RequestHandler::handle(Array)
#8 {main}