Hi,
I am new at mediawiki.
I have postgres 9.3 installed and mediawiki 1.26.
I have created a table called pragas which has the following definition:
Column id_praga: Type private key integer
Column nome: Type character
I have added just 1 record to "pragas" table.
The table is created under Schemas/public.
I have granted access to my user within the database called "teste".
In my LocalSettings.php, I have the following:
wfLoadExtension( 'ExternalData' );
$edgDBServer['wikimedia'] = "localhost";
$edgDBServerType['wikimedia'] = "postgres";
$edgDBName['wikimedia'] = "wikimedia";
$edgDBUser['wikimedia'] = "teste";
$edgDBPass['wikimedia'] = "aaa";
I am trying to access the database through "get_db_data", as below:
"{{#get_db_data: db=wikimedia|from=pragas|data=nome=nome}}"
I am getting the following error:
[97e6ca33] /mediawiki/mediawiki-1.26.2/index.php?title=Main_Page&action=submit DBUnexpectedError from line 495 of /var/www/html/mediawiki/mediawiki-1.26.2/includes/db/DatabasePostgres.php: Unable to post new query to PostgreSQL
Backtrace:
- 0 /var/www/html/mediawiki/mediawiki-1.26.2/includes/db/Database.php(1032): DatabasePostgres->doQuery(string)
- 1 /var/www/html/mediawiki/mediawiki-1.26.2/includes/db/Database.php(1601): DatabaseBase->query(string, string)
- 2 /var/www/html/mediawiki/mediawiki-1.26.2/includes/db/Database.php(1690): DatabaseBase->select(string, array, array, string, array, array)
- 3 /var/www/html/mediawiki/mediawiki-1.26.2/includes/cache/LocalisationCache.php(1160): DatabaseBase->selectRow(string, array, array, string)
- 4 /var/www/html/mediawiki/mediawiki-1.26.2/includes/cache/LocalisationCache.php(349): LCStoreDB->get(string, string)
- 5 /var/www/html/mediawiki/mediawiki-1.26.2/includes/cache/LocalisationCache.php(263): LocalisationCache->loadItem(string, string)
- 6 /var/www/html/mediawiki/mediawiki-1.26.2/languages/Language.php(3299): LocalisationCache->getItem(string, string)
- 7 /var/www/html/mediawiki/mediawiki-1.26.2/includes/parser/Parser.php(2048): Language->linkPrefixExtension()
- 8 /var/www/html/mediawiki/mediawiki-1.26.2/includes/parser/Parser.php(2013): Parser->replaceInternalLinks2(string)
- 9 /var/www/html/mediawiki/mediawiki-1.26.2/includes/parser/Parser.php(1262): Parser->replaceInternalLinks(string)
- 10 /var/www/html/mediawiki/mediawiki-1.26.2/includes/parser/Parser.php(439): Parser->internalParse(string)
- 11 /var/www/html/mediawiki/mediawiki-1.26.2/includes/content/WikitextContent.php(331): Parser->parse(string, Title, ParserOptions, boolean, boolean, NULL)
- 12 /var/www/html/mediawiki/mediawiki-1.26.2/includes/content/AbstractContent.php(497): WikitextContent->fillParserOutput(Title, NULL, ParserOptions, boolean, ParserOutput)
- 13 /var/www/html/mediawiki/mediawiki-1.26.2/includes/EditPage.php(3627): AbstractContent->getParserOutput(Title, NULL, ParserOptions)
- 14 /var/www/html/mediawiki/mediawiki-1.26.2/includes/EditPage.php(2415): EditPage->getPreviewText()
- 15 /var/www/html/mediawiki/mediawiki-1.26.2/includes/EditPage.php(582): EditPage->showEditForm()
- 16 /var/www/html/mediawiki/mediawiki-1.26.2/includes/actions/EditAction.php(58): EditPage->edit()
- 17 /var/www/html/mediawiki/mediawiki-1.26.2/includes/actions/SubmitAction.php(40): EditAction->show()
- 18 /var/www/html/mediawiki/mediawiki-1.26.2/includes/MediaWiki.php(490): SubmitAction->show()
- 19 /var/www/html/mediawiki/mediawiki-1.26.2/includes/MediaWiki.php(287): MediaWiki->performAction(Article, Title)
- 20 /var/www/html/mediawiki/mediawiki-1.26.2/includes/MediaWiki.php(714): MediaWiki->performRequest()
- 21 /var/www/html/mediawiki/mediawiki-1.26.2/includes/MediaWiki.php(508): MediaWiki->main()
- 22 /var/www/html/mediawiki/mediawiki-1.26.2/index.php(41): MediaWiki->run()
- 23 {main}
I have already done all the changes suggested in FAQ and other links but the error continues the same.
Could anyone point me what am I missing or doing wrong? Or point me any link that could help me with this issue?
Thanks in advance