Hallo,
habe da ein kleines Problem irgendwie fehlt da eine Datenbanktabelle oder ? nur wo ist sie hin ?
Sobald man auf FReunde geht oder in der Mitgliederliste auf Freunde geht kommt der Fehler , wäre echt super wenn mir jemand sagen könnte was ich da machen kann .
gruß marky
PHP
Fatal error: Invalid SQL: SELECT user.userID,
lastActivityTime AS lastActivityTimeSortField
FROM wcf1_user_whitelist whitelist
LEFT JOIN user
ON (user.userID = whitelist.whiteUserID)
LEFT JOIN wcf1_user wcf_user
ON (wcf_user.userID = user.userID) LEFT JOIN wcf1_user_option_value user_option
ON (user_option.userID = user.userID) LEFT JOIN wbb1_1_user wbb_user
ON (wbb_user.userID = user.userID)
WHERE whitelist.userID = 1
AND whitelist.confirmed = 1
AND user.userID IS NOT NULL
ORDER BY user.achievementPoints DESC, user.userID LIMIT 30
You get more information about the problem in our knowledge base: http://www.woltlab.com/help/?code=1146
Information:
error message: Invalid SQL: SELECT user.userID,
lastActivityTime AS lastActivityTimeSortField
FROM wcf1_user_whitelist whitelist
LEFT JOIN user
ON (user.userID = whitelist.whiteUserID)
LEFT JOIN wcf1_user wcf_user
ON (wcf_user.userID = user.userID) LEFT JOIN wcf1_user_option_value user_option
ON (user_option.userID = user.userID) LEFT JOIN wbb1_1_user wbb_user
ON (wbb_user.userID = user.userID)
WHERE whitelist.userID = 1
AND whitelist.confirmed = 1
AND user.userID IS NOT NULL
ORDER BY user.achievementPoints DESC, user.userID LIMIT 30
error code: 1146
sql type: MySQLDatabase
sql error: Table 'db410863170.user' doesn't exist
sql error number: 1146
sql version:
file: /homepages/42/d383548994/htdocs/catzs/wcf/lib/system/database/MySQLDatabase.class.php (118)
php version: 5.2.17
wcf version: 1.1.9 (Tempest)
date: Fri, 08 Jun 2012 11:39:47 +0000
request: /index.php?page=UserFriendList&userID=1
referer: http://www.catzs.de/index.php?page=User&userID=1
Stacktrace:
#0 /homepages/42/d383548994/htdocs/catzs/wcf/lib/page/MyFriendsListPage.class.php(68): MySQLDatabase->sendQuery('SELECT??user.us...', 30, 0)
#1 /homepages/42/d383548994/htdocs/catzs/wcf/lib/page/MembersListPage.class.php(407): MyFriendsListPage->getUserIDs()
#2 /homepages/42/d383548994/htdocs/catzs/wcf/lib/page/MembersListPage.class.php(178): MembersListPage->readMembers()
#3 /homepages/42/d383548994/htdocs/catzs/wcf/lib/page/MyFriendsListPage.class.php(81): MembersListPage->readData()
#4 /homepages/42/d383548994/htdocs/catzs/wcf/lib/page/AbstractPage.class.php(90): MyFriendsListPage->readData()
#5 /homepages/42/d383548994/htdocs/catzs/wcf/lib/page/MembersListPage.class.php(215): AbstractPage->show()
#6 /homepages/42/d383548994/htdocs/catzs/wcf/lib/page/UserFriendListPage.class.php(57): MembersListPage->show()
#7 /homepages/42/d383548994/htdocs/catzs/wcf/lib/page/AbstractPage.class.php(46): UserFriendListPage->show()
#8 /homepages/42/d383548994/htdocs/catzs/wcf/lib/page/MyFriendsListPage.class.php(31): AbstractPage->__construct()
#9 /homepages/42/d383548994/htdocs/catzs/wcf/lib/util/RequestHandler.class.php(64): MyFriendsListPage->__construct()
#10 /homepages/42/d383548994/htdocs/catzs/wcf/lib/util/RequestHandler.class.php(92): RequestHandler->__construct('UserFriendList', Array, 'page')
#11 /homepages/42/d383548994/htdocs/catzs/index.php(8): RequestHandler::handle(Array)
#12 {main}