ApoY2k/speaktome — Issue #2: Fehler beim Löschen von Themen
Author: ApoY2k
Created: 2012-02-22 08:55:19+00:00
State: open
Labels: error

```php
Fatal error: Invalid SQL: SELECT user_notification.*, user.*, user_option.*, GROUP_CONCAT(user_notification_message.notificationType SEPARATOR ',') AS notificationTypes FROM wcf1_user_notification user_notification LEFT JOIN wcf1_user_notification_message user_notification_message ON (user_notification_message.notificationID = user_notification.notificationID) LEFT JOIN wcf1_user user ON (user.userID = user_notification.userID) LEFT JOIN wcf1_user_option_value user_option ON (user_option.userID = user.userID) WHERE user_notification.objectType = 'speak' AND user_notification.packageID = 113 AND user_notification.objectID IN() AND user_notification.eventName IN('mentioned') GROUP BY user_notification.notificationID
You get more information about the problem in our knowledge base: http://www.woltlab.com/help/?code=1064
Information:
error message: Invalid SQL: SELECT user_notification.*, user.*, user_option.*, GROUP_CONCAT(user_notification_message.notificationType SEPARATOR ',') AS notificationTypes FROM wcf1_user_notification user_notification LEFT JOIN wcf1_user_notification_message user_notification_message ON (user_notification_message.notificationID = user_notification.notificationID) LEFT JOIN wcf1_user user ON (user.userID = user_notification.userID) LEFT JOIN wcf1_user_option_value user_option ON (user_option.userID = user.userID) WHERE user_notification.objectType = 'speak' AND user_notification.packageID = 113 AND user_notification.objectID IN() AND user_notification.eventName IN('mentioned') GROUP BY user_notification.notificationID
error code: 1064
sql type: MySQLDatabase
sql 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 ') AND user_notification.eventName IN('mentio' at line 11
sql error number: 1064
sql version:
file: /var/www/virtual/rpg-city.de/htdocs/wcf/lib/system/database/MySQLDatabase.class.php (118)
php version: 5.2.6-1+lenny16
wcf version: 1.1.3 (Tempest)
date: Wed, 22 Feb 2012 07:50:18 +0000
request: /index.php?page=ThreadAction&action=delete&threadID=15476&url=index.php%3Fpage%3DModerationHiddenThreads%26pageNo%3D1%26sortField%3DlastPostTime%26sortOrder%3DDESC&t=39cbac11b6bdb126810a31ab7737b0bbcbde9ab7
referer: http://rpg-city.de/index.php?page=ModerationHiddenThreads
Stacktrace:
#0 /var/www/virtual/rpg-city.de/htdocs/wcf/lib/data/user/notification/NotificationHandler.class.php(161): MySQLDatabase->sendQuery('SELECT ...')
#1 /var/www/virtual/rpg-city.de/htdocs/lib/system/event/listener/SpeakToMeListener.class.php(343): NotificationHandler::revokeEvent(Array, 'speak', Array)
#2 /var/www/virtual/rpg-city.de/htdocs/lib/system/event/listener/SpeakToMeListener.class.php(111): SpeakToMeListener->removeSpeak('thread', 15476)
#3 /var/www/virtual/rpg-city.de/htdocs/wcf/lib/system/event/EventHandler.class.php(207): SpeakToMeListener->execute(Object(ThreadActionPage), 'ThreadActionPag...', 'assignVariables')
#4 /var/www/virtual/rpg-city.de/htdocs/wcf/lib/page/AbstractPage.class.php(73): EventHandler::fireAction(Object(ThreadActionPage), 'assignVariables')
#5 /var/www/virtual/rpg-city.de/htdocs/wcf/lib/page/AbstractPage.class.php(93): AbstractPage->assignVariables()
#6 /var/www/virtual/rpg-city.de/htdocs/lib/page/ThreadActionPage.class.php(77): AbstractPage->show()
#7 /var/www/virtual/rpg-city.de/htdocs/wcf/lib/page/AbstractPage.class.php(46): ThreadActionPage->show()
#8 /var/www/virtual/rpg-city.de/htdocs/wcf/lib/util/RequestHandler.class.php(64): AbstractPage->__construct()
#9 /var/www/virtual/rpg-city.de/htdocs/wcf/lib/util/RequestHandler.class.php(92): RequestHandler->__construct('ThreadAction', Array, 'page')
#10 /var/www/virtual/rpg-city.de/htdocs/index.php(8): RequestHandler::handle(Array)
#11 {main}