Ticket #96 (closed defect: fixed)
pm error
| Reported by: | Webmaster@… | Owned by: | somebody |
|---|---|---|---|
| Priority: | major | Milestone: | |
| Component: | buddyloo | Version: | |
| Keywords: | Cc: |
Description
Hab update installiert und wollte mal ne pn an mich selber schicken dann kommt das ?
Fatal error: Invalid SQL: SELECT user.username, userOption81 AS realname FROM wcf1_user_option_value value NATURAL JOIN wcf1_user user WHERE userOption81 IN ('Michael') AND userID != 2 AND ( userOption82 = 0 OR ( SELECT COUNT(*) FROM wcf1_user_whitelist white WHERE white.userID = value.userID AND white.whiteUserID = 2 ) )
You get more information about the problem in our knowledge base: http://www.woltlab.com/help/?code=1052 Information:
error message: Invalid SQL: SELECT user.username, userOption81 AS realname FROM wcf1_user_option_value value NATURAL JOIN wcf1_user user WHERE userOption81 IN ('Michael') AND userID != 2 AND ( userOption82 = 0 OR ( SELECT COUNT(*) FROM wcf1_user_whitelist white WHERE white.userID = value.userID AND white.whiteUserID = 2 ) ) error code: 1052 sql type: MySQLDatabase sql error: Column 'userID' in where clause is ambiguous sql error number: 1052 sql version: file: /www/htdocs/w005e672/wbb/wcf/lib/system/database/MySQLDatabase.class.php (116) php version: 5.2.5 wcf version: 1.0.6 date: Sun, 06 Apr 2008 10:52:23 +0000 request: /index.php?form=PMNew referer: http://www.saarlaendertreff.de/index.php?form=PMNew Stacktrace:
#0 /www/htdocs/w005e672/wbb/wcf/lib/system/event/listener/BuddylooRealnameRecipientsListener.class.php(49): MySQLDatabase->sendQuery('SELECT??user.us...') #1 /www/htdocs/w005e672/wbb/wcf/lib/system/event/listener/BuddylooRealnameRecipientsListener.class.php(20): BuddylooRealnameRecipientsListener?->replaceRecipients('Michael') #2 /www/htdocs/w005e672/wbb/wcf/lib/system/event/EventHandler.class.php(193): BuddylooRealnameRecipientsListener?->execute(Object(PMNewForm), 'PMNewForm', 'readFormParamet...') #3 /www/htdocs/w005e672/wbb/wcf/lib/form/AbstractForm.class.php(56): EventHandler::fireAction(Object(PMNewForm), 'readFormParamet...') #4 /www/htdocs/w005e672/wbb/wcf/lib/form/CaptchaForm.class.php(34): AbstractForm->readFormParameters() #5 /www/htdocs/w005e672/wbb/wcf/lib/form/MessageForm.class.php(42): CaptchaForm?->readFormParameters() #6 /www/htdocs/w005e672/wbb/wcf/lib/form/PMNewForm.class.php(71): MessageForm?->readFormParameters() #7 /www/htdocs/w005e672/wbb/wcf/lib/form/PMNewForm.class.php(87): PMNewForm->readFormParameters() #8 /www/htdocs/w005e672/wbb/wcf/lib/form/AbstractForm.class.php(88): PMNewForm->submit() #9 /www/htdocs/w005e672/wbb/wcf/lib/form/CaptchaForm.class.php(78): AbstractForm->readData() #10 /www/htdocs/w005e672/wbb/wcf/lib/form/MessageForm.class.php(181): CaptchaForm?->readData() #11 /www/htdocs/w005e672/wbb/wcf/lib/form/PMNewForm.class.php(260): MessageForm?->readData() #12 /www/htdocs/w005e672/wbb/wcf/lib/page/AbstractPage.class.php(74): PMNewForm->readData() #13 /www/htdocs/w005e672/wbb/wcf/lib/form/MessageForm.class.php(221): AbstractPage->show() #14 /www/htdocs/w005e672/wbb/wcf/lib/form/PMNewForm.class.php(399): MessageForm?->show() #15 /www/htdocs/w005e672/wbb/wcf/lib/page/AbstractPage.class.php(36): PMNewForm->show() #16 /www/htdocs/w005e672/wbb/wcf/lib/util/RequestHandler.class.php(62): AbstractPage->construct() #17 /www/htdocs/w005e672/wbb/wcf/lib/util/RequestHandler.class.php(84): RequestHandler?->construct('PMNew', Array, 'form') #18 /www/htdocs/w005e672/wbb/index.php(8): RequestHandler::handle(Array) #19 {main}
