Javelin of Deadly Force

[Banaticus]

http://lorebook.lotro.com/wiki/Skill...f_Deadly_Force

Unexpected non-MediaWiki exception encountered, of type "Exception"
exception 'Exception' with message 'Query failed: Unknown column 'Array' in 'where clause'. Query=

SELECT
t.trait_id AS trait_id,
t.name AS name,
t.description AS description,
tne.display_name AS nature
FROM lotro_lore_trait AS t
LEFT JOIN lotro_game_enum_traitnature AS tne ON t.nature = tne.id_number
LEFT JOIN lotro_game_enum_skillcharacter isticcategory AS tce ON t.category = tce.id_number
LEFT JOIN lotro_game_ready_for_web AS rfw ON t.wc_name = rfw.wc_name
LEFT JOIN lotro_lore_race_characteristic AS rc ON rc.characteristic_id = t.trait_id
LEFT JOIN lotro_lore_race AS r ON rc.race_id = r.race_id
LEFT JOIN lotro_game_ready_for_web AS rfw2 ON r.wc_name = rfw2.wc_name
LEFT JOIN lotro_lore_class_characteristi c AS cc ON cc.characteristic_id = t.trait_id
LEFT JOIN lotro_lore_class AS c ON c.class_id = cc.class_id
LEFT JOIN lotro_game_ready_for_web AS rfw3 ON c.wc_name = rfw3.wc_name
LEFT JOIN lotro_lore_mp_class_trait AS mct ON mct.trait_id = t.trait_id
LEFT JOIN lotro_lore_mp_class AS mc ON mc.class_id = mct.class_id
WHERE t.trait_id IN ( Array )
AND ( rfw.ready_for_web = 1
OR rfw3.ready_for_web = 1
OR rfw2.ready_for_web = 1
OR mc.ready_for_web = 1 )
' in /www/lorebook.lotro.com/volume2_book9/includes/extensions/LorebookDb.class.php:433
Stack trace:
#0 /www/lorebook.lotro.com/volume2_book9/includes/extensions/LorebookDb.class.php(301): LorebookDb->processQuery(Object(mysqli) , '? SELECT? ...')
#1 /www/lorebook.lotro.com/volume2_book9/includes/extensions/LorebookExtensionManager.class .php(2266): LorebookDb->processGameQuery('? SELECT? ...')
#2 /www/lorebook.lotro.com/volume2_book9/includes/extensions/parser/TraitParser.class.php(677): LorebookExtensionManager->processGameQuery('? SELECT? ...')
#3 /www/lorebook.lotro.com/volume2_book9/includes/extensions/parser/TraitParser.class.php(93): TraitParser->loadBaseData(Array, false)
#4 /www/lorebook.lotro.com/volume2_book9/includes/extensions/parser/SkillParser.class.php(212): TraitParser->showLinkView(Array)
#5 /www/lorebook.lotro.com/volume2_book9/includes/extensions/parser/SkillParser.class.php(391): SkillParser->getTooltipBody(Array)
#6 /www/lorebook.lotro.com/volume2_book9/includes/extensions/parser/LorebookParser.class.php(170): SkillParser->showLongView('1879135904')
#7 /www/lorebook.lotro.com/volume2_book9/includes/extensions/LorebookExtensionManager.class .php(955): LorebookParser->parse(NULL, Array, Object(Parser))
#8 /www/lorebook.lotro.com/volume2_book9/includes/extensions/LorebookExtensionFunctions.php (285): LorebookExtensionManager->parseSkillTag(NULL, Array, Object(Parser))
#9 [internal function]: wfParseSkillTag(NULL, Array, Object(Parser))
#10 /www/mediawiki/includes/parser/Parser.php(3243): call_user_func_array('wfParseS killTag', Array)
#11 /www/mediawiki/includes/parser/Preprocessor_DOM.php(1026): Parser->extensionSubstitution(Array , Object(PPFrame_DOM))
#12 /www/mediawiki/includes/parser/Parser.php(2632): PPFrame_DOM->expand(Object(PPNode_DOM), 0)
#13 /www/mediawiki/includes/parser/Parser.php(875): Parser->replaceVariables('?<skill id="187...')
#14 /www/lorebook.lotro.com/volume2_book9/includes/extensions/parser/OfficialParser.class.php(43): Parser->internalParse('?<skill id="187...')
#15 /www/lorebook.lotro.com/volume2_book9/includes/extensions/LorebookExtensionManager.class .php(348): OfficialParser->parse('?<skill id="187...', Array, Object(Parser))
#16 /www/lorebook.lotro.com/volume2_book9/includes/extensions/LorebookExtensionFunctions.php (113): LorebookExtensionManager->parseOfficialTag('?<skill id="187...', Array, Object(Parser))
#17 [internal function]: wfParseOfficialTag('?<skill id="187...', Array, Object(Parser))
#18 /www/mediawiki/includes/parser/Parser.php(3243): call_user_func_array('wfParseO fficial...', Array)
#19 /www/mediawiki/includes/parser/Preprocessor_DOM.php(1026): Parser->extensionSubstitution(Array , Object(PPFrame_DOM))
#20 /www/mediawiki/includes/parser/Parser.php(2632): PPFrame_DOM->expand(Object(PPNode_DOM), 0)
#21 /www/mediawiki/includes/parser/Parser.php(875): Parser->replaceVariables('?<seo title="It...')
#22 /www/lorebook.lotro.com/volume2_book9/includes/extensions/parser/NoeditParser.class.php(31): Parser->internalParse('?<seo title="It...')
#23 /www/lorebook.lotro.com/volume2_book9/includes/extensions/LorebookExtensionManager.class .php(323): NoeditParser->parse('?<seo title="It...', Array, Object(Parser))
#24 /www/lorebook.lotro.com/volume2_book9/includes/extensions/LorebookExtensionFunctions.php (106): LorebookExtensionManager->parseNoeditTag('?<seo title="It...', Array, Object(Parser))
#25 [internal function]: wfParseNoeditTag('?<seo title="It...', Array, Object(Parser))
#26 /www/mediawiki/includes/parser/Parser.php(3243): call_user_func_array('wfParseN oeditTa...', Array)
#27 /www/mediawiki/includes/parser/Preprocessor_DOM.php(1026): Parser->extensionSubstitution(Array , Object(PPFrame_DOM))
#28 /www/mediawiki/includes/parser/Parser.php(2632): PPFrame_DOM->expand(Object(PPNode_DOM), 0)
#29 /www/mediawiki/includes/parser/Parser.php(875): Parser->replaceVariables('<noedit>?<s eo t...')
#30 /www/mediawiki/includes/parser/Parser.php(327): Parser->internalParse('<noedit>?<se o t...')
#31 /www/mediawiki/includes/Article.php(3557): Parser->parse('<noedit>?<seo t...', Object(Title), Object(ParserOptions), true, true, 173463)
#32 /www/mediawiki/includes/Article.php(979): Article->outputWikiText('<noedit>?<s eo t...')
#33 /www/mediawiki/includes/Wiki.php(461): Article->view()
#34 /www/mediawiki/includes/Wiki.php(63): MediaWiki->performAction(Object(OutputPa ge), Object(Article), Object(Title), Object(User), Object(WebRequest))
#35 /www/mediawiki/index.php(116): MediaWiki->initialize(Object(Title), Object(Article), Object(OutputPage), Object(User), Object(WebRequest))
#36 {main}

[Banaticus]

I thought the new data dump might fix this, but it's still not working as intended.

[Duwis]

I thought the new data dump might fix this, but it's still not working as intended.

Known issue that is being fixed soon.

[Fredelas]

What a truly bizarre query. Joining to the same (presumably long but lean) table 3 times on the same varchar column using 3 different aliases is an awful lot of work. The poor index on the lotro_game_ready_for_web.wc_na me column must be getting the **** beat out of it!

I have a new respect for the Lorebook developers now, because the database you're given to work with looks like a real mine field!

[Ravenhall]

There's all kinds of goodies in that post for those of the Black Hats. I'd really recommend vaping this thread and changing something to prevent fatals from dumping to the browser.

[Re-adjusts White Hat]

[Banaticus]

There's all kinds of goodies in that post for those of the Black Hats.

Yes, I'd also recommend deleting the Lorebook page then recreating it "soon".

[TheFrank]

*begins poking around lorebook*