18 de Abril de 2014
Erro na base de dados - ACA-M
18 de Abril de 2014
MediaWiki internal error.

Original exception: exception 'DBQueryError' with message 'A database error has occurred
Query: CREATE TEMPORARY TABLE cats1( title VARCHAR(255) binary NOT NULL PRIMARY KEY)
TYPE=MEMORY
Function: SMW::getCategoryTable
Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MEMORY' at line 2 (h41mysql37.secureserver.net)
' in /home/content/a/c/a/acamorg/html/w/includes/Database.php:824
Stack trace:
#0 /home/content/a/c/a/acamorg/html/w/includes/Database.php(779): Database->reportQueryError('You have an err...', 1064, 'CREATE TEMPORAR...', 'SMW::getCategor...', false)
#1 /home/content/a/c/a/acamorg/html/w/extensions/SemanticMediaWiki/includes/storage/SMW_SQLStore.php(1600): Database->query('CREATE TEMPORAR...', 'SMW::getCategor...')
#2 /home/content/a/c/a/acamorg/html/w/extensions/SemanticMediaWiki/includes/storage/SMW_SQLStore.php(1899): SMWSQLStore->getCategoryTable(Array, Object(DatabaseMysql))
#3 /home/content/a/c/a/acamorg/html/w/extensions/SemanticMediaWiki/includes/storage/SMW_SQLStore.php(1030): SMWSQLStore->createSQLQuery(Object(SMWClassDescription), '`page` INNER JO...', '', Object(DatabaseMysql), Array)
#4 /home/content/a/c/a/acamorg/html/w/extensions/SemanticMediaWiki/includes/SMW_QueryProcessor.php(285): SMWSQLStore->getQueryResult(Object(SMWQuery))
#5 /home/content/a/c/a/acamorg/html/w/extensions/SemanticMediaWiki/includes/SMW_QueryProcessor.php(275): SMWQueryProcessor::getResultFromQuery(Object(SMWQuery), Array, Array, 2, true, 'ul')
#6 /home/content/a/c/a/acamorg/html/w/extensions/SemanticMediaWiki/includes/SMW_QueryProcessor.php(231): SMWQueryProcessor::getResultFromQueryString('[[Categoria:Com...', Array, Array, 2, true)
#7 /home/content/a/c/a/acamorg/html/w/extensions/SemanticMediaWiki/includes/SMW_GlobalFunctions.php(209): SMWQueryProcessor::getResultFromFunctionParams(Array, 2)
#8 [internal function]: smwfProcessInlineQueryParserFunction(Object(Parser), '[[Categoria:Com...', 'format=ul', 'sort=Data', 'order=desc', 'limit=5', 'searchlabel=')
#9 /home/content/a/c/a/acamorg/html/w/includes/Parser.php(3041): call_user_func_array('smwfProcessInli...', Array)
#10 [internal function]: Parser->braceSubstitution(Array)
#11 /home/content/a/c/a/acamorg/html/w/includes/Parser.php(2759): call_user_func(Array, Array)
#12 /home/content/a/c/a/acamorg/html/w/includes/Parser.php(2860): Parser->replace_callback('{{#ask: [[Categ...', Array)
#13 /home/content/a/c/a/acamorg/html/w/includes/Parser.php(3219): Parser->replaceVariables('{{#ask: [[Categ...', Array)
#14 [internal function]: Parser->braceSubstitution(Array)
#15 /home/content/a/c/a/acamorg/html/w/includes/Parser.php(2759): call_user_func(Array, Array)
#16 /home/content/a/c/a/acamorg/html/w/includes/Parser.php(2860): Parser->replace_callback('__NOEDITSECTION...', Array)
#17 /home/content/a/c/a/acamorg/html/w/includes/Parser.php(1033): Parser->replaceVariables('__NOEDITSECTION...', Array)
#18 /home/content/a/c/a/acamorg/html/w/includes/Parser.php(306): Parser->internalParse('__NOEDITSECTION...')
#19 /home/content/a/c/a/acamorg/html/w/skins/GuMax.php(257): Parser->parse('__NOEDITSECTION...', Object(Title), Object(ParserOptions), true, true)
#20 /home/content/a/c/a/acamorg/html/w/includes/SkinTemplate.php(463): GuMaxTemplate->execute()
#21 /home/content/a/c/a/acamorg/html/w/includes/OutputPage.php(696): SkinTemplate->outputPage(Object(OutputPage))
#22 /home/content/a/c/a/acamorg/html/w/includes/Wiki.php(301): OutputPage->output()
#23 /home/content/a/c/a/acamorg/html/w/index.php(90): MediaWiki->finalCleanup(Array, Object(LoadBalancer), Object(OutputPage))
#24 /home/content/a/c/a/acamorg/html/w/index.php5(1): require('/home/content/a...')
#25 {main}

Exception caught inside exception handler: exception 'DBUnexpectedError' with message 'Error in fetchObject(): Table 'mediawiki_acam.prop5' doesn't exist (h41mysql37.secureserver.net)' in /home/content/a/c/a/acamorg/html/w/includes/Database.php:953
Stack trace:
#0 /home/content/a/c/a/acamorg/html/w/extensions/SemanticMediaWiki/includes/storage/SMW_SQLStore.php(1130): Database->fetchObject(false)
#1 /home/content/a/c/a/acamorg/html/w/extensions/SemanticMediaWiki/includes/SMW_QueryProcessor.php(285): SMWSQLStore->getQueryResult(Object(SMWQuery))
#2 /home/content/a/c/a/acamorg/html/w/extensions/SemanticMediaWiki/includes/SMW_QueryProcessor.php(275): SMWQueryProcessor::getResultFromQuery(Object(SMWQuery), Array, Array, 2, true, 'ul')
#3 /home/content/a/c/a/acamorg/html/w/extensions/SemanticMediaWiki/includes/SMW_QueryProcessor.php(231): SMWQueryProcessor::getResultFromQueryString('[[Categoria:Com...', Array, Array, 2, true)
#4 /home/content/a/c/a/acamorg/html/w/extensions/SemanticMediaWiki/includes/SMW_GlobalFunctions.php(209): SMWQueryProcessor::getResultFromFunctionParams(Array, 2)
#5 [internal function]: smwfProcessInlineQueryParserFunction(Object(Parser), '[[Categoria:Com...', 'format=ul', 'sort=Data', 'order=desc', 'limit=5', 'searchlabel=')
#6 /home/content/a/c/a/acamorg/html/w/includes/Parser.php(3041): call_user_func_array('smwfProcessInli...', Array)
#7 [internal function]: Parser->braceSubstitution(Array)
#8 /home/content/a/c/a/acamorg/html/w/includes/Parser.php(2759): call_user_func(Array, Array)
#9 /home/content/a/c/a/acamorg/html/w/includes/Parser.php(2860): Parser->replace_callback('{{#ask: [[Categ...', Array)
#10 /home/content/a/c/a/acamorg/html/w/includes/Parser.php(3219): Parser->replaceVariables('{{#ask: [[Categ...', Array)
#11 [internal function]: Parser->braceSubstitution(Array)
#12 /home/content/a/c/a/acamorg/html/w/includes/Parser.php(2759): call_user_func(Array, Array)
#13 /home/content/a/c/a/acamorg/html/w/includes/Parser.php(2860): Parser->replace_callback('__NOEDITSECTION...', Array)
#14 /home/content/a/c/a/acamorg/html/w/includes/Parser.php(1033): Parser->replaceVariables('__NOEDITSECTION...', Array)
#15 /home/content/a/c/a/acamorg/html/w/includes/Parser.php(306): Parser->internalParse('__NOEDITSECTION...')
#16 /home/content/a/c/a/acamorg/html/w/skins/GuMax.php(257): Parser->parse('__NOEDITSECTION...', Object(Title), Object(ParserOptions), true, true)
#17 /home/content/a/c/a/acamorg/html/w/includes/SkinTemplate.php(463): GuMaxTemplate->execute()
#18 /home/content/a/c/a/acamorg/html/w/includes/OutputPage.php(696): SkinTemplate->outputPage(Object(OutputPage))
#19 /home/content/a/c/a/acamorg/html/w/includes/Exception.php(86): OutputPage->output()
#20 /home/content/a/c/a/acamorg/html/w/includes/Exception.php(111): MWException->reportHTML()
#21 /home/content/a/c/a/acamorg/html/w/includes/Exception.php(191): MWException->report()
#22 /home/content/a/c/a/acamorg/html/w/includes/Exception.php(225): wfReportException(Object(DBQueryError))
#23 [internal function]: wfExceptionHandler(Object(DBQueryError))
#24 {main}