Heute hatte ich folgende ME,ldung beim Aufruf eines Userprofils:
[code]
You get more information about the problem in our knowledge base: http://www.woltlab.com/help/?code=5
Information:
error message: Invalid SQL: SELECT myBlacklist.blackUserID, myWhitelist.whiteUserID,wbb_user.posts,session.requestURI, session.requestMethod, session.ipAddress, session.userAgent, rank.*, avatar.*,hisWhitelist.userID AS buddy, hisBlacklist.userID AS ignoredUser, GROUP_CONCAT(DISTINCT groups.groupID ORDER BY groups.groupID ASC SEPARATOR ',') AS groupIDs, GROUP_CONCAT(DISTINCT languages.languageID ORDER BY languages.languageID ASC SEPARATOR ',') AS languageIDs,user_option.*, user.* FROM wcf1_user user LEFT JOIN wcf1_user_blacklist myBlacklist ON (myBlacklist.userID = XXXXX AND myBlacklist.blackUserID = user.userID) LEFT JOIN wcf1_user_whitelist myWhitelist ON (myWhitelist.userID = XXXX AND myWhitelist.whiteUserID = user.userID) LEFT JOIN wbb1_1_user wbb_user ON (wbb_user.userID = user.userID) LEFT JOIN wcf1_avatar avatar ON (avatar.avatarID = user.avatarID) LEFT JOIN wcf1_session session ON (session.userID = user.userID AND session.packageID = 38 AND session.lastActivityTime > 1253017053) LEFT JOIN wcf1_user_rank rank ON (rank.rankID = user.rankID) LEFT JOIN wcf1_user_whitelist hisWhitelist ON (hisWhitelist.userID = user.userID AND hisWhitelist.whiteUserID = XXXXX) LEFT JOIN wcf1_user_blacklist hisBlacklist ON (hisBlacklist.userID = user.userID AND hisBlacklist.blackUserID = XXXXX) LEFT JOIN wcf1_user_to_groups groups ON (groups.userID = user.userID) LEFT JOIN wcf1_user_to_languages languages ON (languages.userID = user.userID) LEFT JOIN wcf1_user_option_value user_option ON (user_option.userID = user.userID) WHERE user.userID = XXXX GROUP BY user.userID LIMIT 1
error code: 5
sql type: MySQLDatabase
sql error: Out of memory (Needed 8388580 bytes)
sql error number: 5
sql version:
file: /customers/webs/cysys/www/rotetraenen.de/_subdomains/forumneu/wcf/lib/system/database/MySQLDatabase.class.php (116)
php version: 5.2.10
wcf version: 1.0.11 pl 1 (Horizon)
date: Tue, 15 Sep 2009 12:32:33 +0000
request: /index.php?page=User&userID=XXXX
referer: http://forum.rotetraenen.de/index.php?page=Index
Stacktrace:
#0 /customers/webs/cysys/www/rotetraenen.de/_subdomains/forumneu/wcf/lib/system/database/Database.class.php(116): MySQLDatabase->sendQuery('SELECT ?myBlack...', 1, 0)
#1 /customers/webs/cysys/www/rotetraenen.de/_subdomains/forumneu/wcf/lib/data/user/User.class.php(61): Database->getFirstRow('SELECT ?myBlack...')
#2 /customers/webs/cysys/www/rotetraenen.de/_subdomains/forumneu/wcf/lib/system/session/UserSession.class.php(31): User->__construct(XXXX, NULL, NULL, NULL)
#3 /customers/webs/cysys/www/rotetraenen.de/_subdomains/forumneu/wcf/lib/data/user/UserProfile.class.php(41): UserSession->__construct(XXXX, NULL, NULL, NULL)
#4 /customers/webs/cysys/www/rotetraenen.de/_subdomains/forumneu/wcf/lib/page/UserPage.class.php(48): UserProfile->__construct(XXXX, NULL, NULL, NULL, 'myBlacklist.bla...', ' LEFT JOIN wcf1...')
#5 /customers/webs/cysys/www/rotetraenen.de/_subdomains/forumneu/wcf/lib/page/AbstractPage.class.php(35): UserPage->readParameters()
#6 /customers/webs/cysys/www/rotetraenen.de/_subdomains/forumneu/wcf/lib/page/UserPage.class.php(37): AbstractPage->__construct()
#7 /customers/webs/cysys/www/rotetraenen.de/_subdomains/forumneu/wcf/lib/util/RequestHandler.class.php(63): UserPage->__construct()
#8 /customers/webs/cysys/www/rotetraenen.de/_subdomains/forumneu/wcf/lib/util/RequestHandler.class.php(91): RequestHandler->__construct('User', Array, 'page')
#9 /customers/webs/cysys/www/rotetraenen.de/_subdomains/forumneu/index.php(8): RequestHandler::handle(Array)
#10 {main}
[/code]
Die User- uind List-IDs habe ich ausge-X't, um Anonymität zu erhalten. Bei genaueren Fragen geb ich die aber gern raus ans Team. Fehler sagt "Out of Memory", und dem Server fehlen 8MB zum alloziieren. Nicht wirklich viel, irgendwas denke ich passt da noch nicht.
LG
Edit: Der Fehler taucht nur bei Usern auf, die in meiner Fruendesliste stehen, und in deren ich anscheinend auch vorhanden bin.
[code]
You get more information about the problem in our knowledge base: http://www.woltlab.com/help/?code=5
Information:
error message: Invalid SQL: SELECT myBlacklist.blackUserID, myWhitelist.whiteUserID,wbb_user.posts,session.requestURI, session.requestMethod, session.ipAddress, session.userAgent, rank.*, avatar.*,hisWhitelist.userID AS buddy, hisBlacklist.userID AS ignoredUser, GROUP_CONCAT(DISTINCT groups.groupID ORDER BY groups.groupID ASC SEPARATOR ',') AS groupIDs, GROUP_CONCAT(DISTINCT languages.languageID ORDER BY languages.languageID ASC SEPARATOR ',') AS languageIDs,user_option.*, user.* FROM wcf1_user user LEFT JOIN wcf1_user_blacklist myBlacklist ON (myBlacklist.userID = XXXXX AND myBlacklist.blackUserID = user.userID) LEFT JOIN wcf1_user_whitelist myWhitelist ON (myWhitelist.userID = XXXX AND myWhitelist.whiteUserID = user.userID) LEFT JOIN wbb1_1_user wbb_user ON (wbb_user.userID = user.userID) LEFT JOIN wcf1_avatar avatar ON (avatar.avatarID = user.avatarID) LEFT JOIN wcf1_session session ON (session.userID = user.userID AND session.packageID = 38 AND session.lastActivityTime > 1253017053) LEFT JOIN wcf1_user_rank rank ON (rank.rankID = user.rankID) LEFT JOIN wcf1_user_whitelist hisWhitelist ON (hisWhitelist.userID = user.userID AND hisWhitelist.whiteUserID = XXXXX) LEFT JOIN wcf1_user_blacklist hisBlacklist ON (hisBlacklist.userID = user.userID AND hisBlacklist.blackUserID = XXXXX) LEFT JOIN wcf1_user_to_groups groups ON (groups.userID = user.userID) LEFT JOIN wcf1_user_to_languages languages ON (languages.userID = user.userID) LEFT JOIN wcf1_user_option_value user_option ON (user_option.userID = user.userID) WHERE user.userID = XXXX GROUP BY user.userID LIMIT 1
error code: 5
sql type: MySQLDatabase
sql error: Out of memory (Needed 8388580 bytes)
sql error number: 5
sql version:
file: /customers/webs/cysys/www/rotetraenen.de/_subdomains/forumneu/wcf/lib/system/database/MySQLDatabase.class.php (116)
php version: 5.2.10
wcf version: 1.0.11 pl 1 (Horizon)
date: Tue, 15 Sep 2009 12:32:33 +0000
request: /index.php?page=User&userID=XXXX
referer: http://forum.rotetraenen.de/index.php?page=Index
Stacktrace:
#0 /customers/webs/cysys/www/rotetraenen.de/_subdomains/forumneu/wcf/lib/system/database/Database.class.php(116): MySQLDatabase->sendQuery('SELECT ?myBlack...', 1, 0)
#1 /customers/webs/cysys/www/rotetraenen.de/_subdomains/forumneu/wcf/lib/data/user/User.class.php(61): Database->getFirstRow('SELECT ?myBlack...')
#2 /customers/webs/cysys/www/rotetraenen.de/_subdomains/forumneu/wcf/lib/system/session/UserSession.class.php(31): User->__construct(XXXX, NULL, NULL, NULL)
#3 /customers/webs/cysys/www/rotetraenen.de/_subdomains/forumneu/wcf/lib/data/user/UserProfile.class.php(41): UserSession->__construct(XXXX, NULL, NULL, NULL)
#4 /customers/webs/cysys/www/rotetraenen.de/_subdomains/forumneu/wcf/lib/page/UserPage.class.php(48): UserProfile->__construct(XXXX, NULL, NULL, NULL, 'myBlacklist.bla...', ' LEFT JOIN wcf1...')
#5 /customers/webs/cysys/www/rotetraenen.de/_subdomains/forumneu/wcf/lib/page/AbstractPage.class.php(35): UserPage->readParameters()
#6 /customers/webs/cysys/www/rotetraenen.de/_subdomains/forumneu/wcf/lib/page/UserPage.class.php(37): AbstractPage->__construct()
#7 /customers/webs/cysys/www/rotetraenen.de/_subdomains/forumneu/wcf/lib/util/RequestHandler.class.php(63): UserPage->__construct()
#8 /customers/webs/cysys/www/rotetraenen.de/_subdomains/forumneu/wcf/lib/util/RequestHandler.class.php(91): RequestHandler->__construct('User', Array, 'page')
#9 /customers/webs/cysys/www/rotetraenen.de/_subdomains/forumneu/index.php(8): RequestHandler::handle(Array)
#10 {main}
[/code]
Die User- uind List-IDs habe ich ausge-X't, um Anonymität zu erhalten. Bei genaueren Fragen geb ich die aber gern raus ans Team. Fehler sagt "Out of Memory", und dem Server fehlen 8MB zum alloziieren. Nicht wirklich viel, irgendwas denke ich passt da noch nicht.
LG
Edit: Der Fehler taucht nur bei Usern auf, die in meiner Fruendesliste stehen, und in deren ich anscheinend auch vorhanden bin.