Hackeinbau Service

Huhuh

habe gerade jemanden ein wb2lite installiert. Klappte alles wunderbar. Habe dann aufeinmal als ich auf Mitglied geklickt habe die meldung.



Fatal error: Invalid SQL: SELECT boardID, c, title, IF(b.posts>0 AND c>0,ROUND((100/b.posts)*c),0) AS percentBoard, IF(b.posts>0 AND c>0,ROUND((100/u.posts)*c),0) AS percentPersonal FROM ( SELECT p.userID, boardID, COUNT(postID) AS c FROM wbb1_1_post p INNER JOIN wbb1_1_thread USING(threadID) WHERE p.userID = 1 GROUP BY boardID ORDER BY c DESC LIMIT 5 ) x INNER JOIN wbb1_1_board b USING(boardID) INNER JOIN wbb1_1_user u USING(userID)
Information:

error message: Invalid SQL: SELECT boardID, c, title, IF(b.posts>0 AND c>0,ROUND((100/b.posts)*c),0) AS percentBoard, IF(b.posts>0 AND c>0,ROUND((100/u.posts)*c),0) AS percentPersonal FROM ( SELECT p.userID, boardID, COUNT(postID) AS c FROM wbb1_1_post p INNER JOIN wbb1_1_thread USING(threadID) WHERE p.userID = 1 GROUP BY boardID ORDER BY c DESC LIMIT 5 ) x INNER JOIN wbb1_1_board b USING(boardID) INNER JOIN wbb1_1_user u USING(userID)
error code: 1052
sql type: MySQLDatabase
sql error: Column 'boardID' in field list is ambiguous
sql error number: 1052
sql version:
file: /usr/export/www/vhosts/funnetwork/hosting/derbierdeckel/wcf/lib/system/database/MySQLDatabase.class.php (116)
php version: 5.2.9
wcf version: 1.0.10 (Horizon)
date: Fri, 29 May 2009 21:41:13 +0000
request: /index.php?page=User&userID=1
referer: http://derbierdeckel.de.funpic.de/index.…ID=1&highlight=
Stacktrace:
#0 /usr/export/www/vhosts/funnetwork/hosting/derbierdeckel/lib/system/event/listener/UserBoardActivityUserPageListener.class.php(6: MySQLDatabase->sendQuery('SELECT ?boardID...')
#1 /usr/export/www/vhosts/funnetwork/hosting/derbierdeckel/lib/system/event/listener/UserBoardActivityUserPageListener.class.php(2: UserBoardActivityUserPageListener->readData()
#2 /usr/export/www/vhosts/funnetwork/hosting/derbierdeckel/wcf/lib/system/event/EventHandler.class.php(193): UserBoardActivityUserPageListener->execute(Object(UserPage), 'UserPage', 'readData')
#3 /usr/export/www/vhosts/funnetwork/hosting/derbierdeckel/wcf/lib/page/AbstractPage.class.php(55): EventHandler::fireAction(Object(UserPage), 'readData')
#4 /usr/export/www/vhosts/funnetwork/hosting/derbierdeckel/wcf/lib/page/UserPage.class.php(73): AbstractPage->readData()
#5 /usr/export/www/vhosts/funnetwork/hosting/derbierdeckel/wcf/lib/page/AbstractPage.class.php(74): UserPage->readData()
#6 /usr/export/www/vhosts/funnetwork/hosting/derbierdeckel/wcf/lib/page/UserPage.class.php(169): AbstractPage->show()
#7 /usr/export/www/vhosts/funnetwork/hosting/derbierdeckel/wcf/lib/page/AbstractPage.class.php(36): UserPage->show()
#8 /usr/export/www/vhosts/funnetwork/hosting/derbierdeckel/wcf/lib/page/UserPage.class.php(37): AbstractPage->__construct()
#9 /usr/export/www/vhosts/funnetwork/hosting/derbierdeckel/wcf/lib/util/RequestHandler.class.php(63): UserPage->__construct()
#10 /usr/export/www/vhosts/funnetwork/hosting/derbierdeckel/wcf/lib/util/RequestHandler.class.php(91): RequestHandler->__construct('User', Array, 'page')
#11 /usr/export/www/vhosts/funnetwork/hosting/derbierdeckel/index.php(: RequestHandler::handle(Array)
#12 {main}

was genau weisst aber nicht?

is wieder weg hab das letzte installierte runter geworfen


danke schön trotzdem Andy