Topic on Template talk:Main page

Unable to post new query to PostgreSQL

2
Thiagomerino (talkcontribs)

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:

  1. 0 /var/www/html/mediawiki/mediawiki-1.26.2/includes/db/Database.php(1032): DatabasePostgres->doQuery(string)
  2. 1 /var/www/html/mediawiki/mediawiki-1.26.2/includes/db/Database.php(1601): DatabaseBase->query(string, string)
  3. 2 /var/www/html/mediawiki/mediawiki-1.26.2/includes/db/Database.php(1690): DatabaseBase->select(string, array, array, string, array, array)
  4. 3 /var/www/html/mediawiki/mediawiki-1.26.2/includes/cache/LocalisationCache.php(1160): DatabaseBase->selectRow(string, array, array, string)
  5. 4 /var/www/html/mediawiki/mediawiki-1.26.2/includes/cache/LocalisationCache.php(349): LCStoreDB->get(string, string)
  6. 5 /var/www/html/mediawiki/mediawiki-1.26.2/includes/cache/LocalisationCache.php(263): LocalisationCache->loadItem(string, string)
  7. 6 /var/www/html/mediawiki/mediawiki-1.26.2/languages/Language.php(3299): LocalisationCache->getItem(string, string)
  8. 7 /var/www/html/mediawiki/mediawiki-1.26.2/includes/parser/Parser.php(2048): Language->linkPrefixExtension()
  9. 8 /var/www/html/mediawiki/mediawiki-1.26.2/includes/parser/Parser.php(2013): Parser->replaceInternalLinks2(string)
  10. 9 /var/www/html/mediawiki/mediawiki-1.26.2/includes/parser/Parser.php(1262): Parser->replaceInternalLinks(string)
  11. 10 /var/www/html/mediawiki/mediawiki-1.26.2/includes/parser/Parser.php(439): Parser->internalParse(string)
  12. 11 /var/www/html/mediawiki/mediawiki-1.26.2/includes/content/WikitextContent.php(331): Parser->parse(string, Title, ParserOptions, boolean, boolean, NULL)
  13. 12 /var/www/html/mediawiki/mediawiki-1.26.2/includes/content/AbstractContent.php(497): WikitextContent->fillParserOutput(Title, NULL, ParserOptions, boolean, ParserOutput)
  14. 13 /var/www/html/mediawiki/mediawiki-1.26.2/includes/EditPage.php(3627): AbstractContent->getParserOutput(Title, NULL, ParserOptions)
  15. 14 /var/www/html/mediawiki/mediawiki-1.26.2/includes/EditPage.php(2415): EditPage->getPreviewText()
  16. 15 /var/www/html/mediawiki/mediawiki-1.26.2/includes/EditPage.php(582): EditPage->showEditForm()
  17. 16 /var/www/html/mediawiki/mediawiki-1.26.2/includes/actions/EditAction.php(58): EditPage->edit()
  18. 17 /var/www/html/mediawiki/mediawiki-1.26.2/includes/actions/SubmitAction.php(40): EditAction->show()
  19. 18 /var/www/html/mediawiki/mediawiki-1.26.2/includes/MediaWiki.php(490): SubmitAction->show()
  20. 19 /var/www/html/mediawiki/mediawiki-1.26.2/includes/MediaWiki.php(287): MediaWiki->performAction(Article, Title)
  21. 20 /var/www/html/mediawiki/mediawiki-1.26.2/includes/MediaWiki.php(714): MediaWiki->performRequest()
  22. 21 /var/www/html/mediawiki/mediawiki-1.26.2/includes/MediaWiki.php(508): MediaWiki->main()
  23. 22 /var/www/html/mediawiki/mediawiki-1.26.2/index.php(41): MediaWiki->run()
  24. 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

This post was hidden by Kghbln (history)