New Foswiki release 2.1.6 is available with important security fixes.
Sourceforge foswiki email lists being discontinued. Subscribe to the new Foswiki announce and discuss lists at MailingLists
This question about Using an extension: Task closed

Error message when using SQLPluging


just installed Foswiki on a new Amazon web server. I also installed SQLPlugin

When ever I include the SQL command into a web page I get the following error message and the page would not display at all:

"Foswiki detected an internal error - please check your Foswiki logs and webserver logs for more information.

Can't use an undefined value as a HASH reference"

This happens even if I just include %SQL% so I am assuming this has nothing to do how I have setup my database or the the like. What could be the problem.

Here is what I get in the error.log:
| | 2014-11-25T14:32:11Z warning | Can't use an undefined value as a HASH reference at /var/www/foswiki/lib/Foswiki/Plugins/SqlPlugin/ line 47. at /var/www/foswiki/lib/Foswiki/Plugins/SqlPlugin/ line 47. Foswiki::Plugins::SqlPlugin::Core::new('Foswiki::Plugins::SqlPlugin::Core') called at /var/www/foswiki/lib/Foswiki/Plugins/ line 37 Foswiki::Plugins::SqlPlugin::core() called at /var/www/foswiki/lib/Foswiki/Plugins/ line 52 Foswiki::Plugins::SqlPlugin::__ANON__('Foswiki=HASH(0x1b8a100)', 'Foswiki::Attrs=HASH(0x298ae78)', 'TestTopic', 'SimUETS', 'Foswiki::Meta=HASH(0x25fe128)') called at /var/www/foswiki/lib/Foswiki/ line 609 Foswiki::Func::__ANON__('Foswiki=HASH(0x1b8a100)', 'Foswiki::Attrs=HASH(0x298ae78)', 'Foswiki::Meta=HASH(0x25fe128)') called at /var/www/foswiki/lib/ line 3160 Foswiki::_expandMacroOnTopicRendering('Foswiki=HASH(0x1b8a100)', 'SQL', 'query="SELECT * FROM test" database="etsback" ', 'Foswiki::Meta=HASH(0x25fe128)') called at /var/www/foswiki/lib/ line 3036 Foswiki::_processMacros('Foswiki=HASH(0x1b8a100)', '-- AdminUser - 25 Nov 2014\x{a}\x{a}wwwww\x{a}\x{a}sdsdfdsf\x{a}\x{a}Support\x{a}\x{a}%SQL...', 'CODE(0x1aec0c0)', 'Foswiki::Meta=HASH(0x25fe128)', 16) called at /var/www/foswiki/lib/ line 2833 Foswiki::innerExpandMacros('Foswiki=HASH(0x1b8a100)', 'SCALAR(0x1afa638)', 'Foswiki::Meta=HASH(0x25fe128)') called at /var/www/foswiki/lib/ line 3342 Foswiki::expandMacros('Foswiki=HASH(0x1b8a100)', '-- AdminUser - 25 Nov 2014\x{a}\x{a}wwwww\x{a}\x{a}sdsdfdsf\x{a}\x{a}Support\x{a}\x{a}%SQL...', 'Foswiki::Meta=HASH(0x25fe128)') called at /var/www/foswiki/lib/Foswiki/ line 3103 Foswiki::Meta::expandMacros('Foswiki::Meta=HASH(0x25fe128)', '-- AdminUser - 25 Nov 2014\x{a}\x{a}wwwww\x{a}\x{a}sdsdfdsf\x{a}\x{a}Support\x{a}\x{a}%SQL...') called at /var/www/foswiki/lib/Foswiki/UI/ line 412 Foswiki::UI::View::_prepare('-- AdminUser - 25 Nov 2014\x{a}\x{a}wwwww\x{a}\x{a}sdsdfdsf\x{a}\x{a}Support\x{a}\x{a}%SQL...', 'Foswiki::Meta=HASH(0x25fe128)', 0) called at /var/www/foswiki/lib/Foswiki/UI/ line 392 Foswiki::UI::View::view('Foswiki=HASH(0x1b8a100)') called at /var/www/foswiki/lib/Foswiki/ line 316 Foswiki::UI::__ANON__() called at /var/www/foswiki/lib/CPAN/lib/ line 379 eval {...} called at /var/www/foswiki/lib/CPAN/lib/ line 371 Error::subs::try('CODE(0x109bc30)', 'HASH(0x1b89cf8)') called at /var/www/foswiki/lib/Foswiki/ line 435 Foswiki::UI::_execute('Foswiki::Request=HASH(0x1b651e8)', 'CODE(0x1b64d50)', 'view', 1) called at /var/www/foswiki/lib/Foswiki/ line 274 Foswiki::UI::handleRequest('Foswiki::Request=HASH(0x1b651e8)') called at /var/www/foswiki/lib/Foswiki/Engine/ line 74 Foswiki::Engine::CGI::run('Foswiki::Engine::CGI=HASH(0x15569e8)') called |

-- RalfMartin - 25 Nov 2014

Bug task at Tasks.Item13116

-- MichaelDaum - 25 Nov 2014

I have the same problem and my Foswiki is also running on AWS. I have checked that the hotfix as sugested in Tasks.Item13116 is implemented and it is.

-- HenroRitchie - 18 Aug 2015

QuestionForm edit

Subject Using an extension
Extension SqlPlugin
Version Foswiki 1.1.9
Status Task closed
Related Topics Tasks.Item13116
Topic revision: r3 - 18 Aug 2015, HenroRitchie - This page was cached on 19 Aug 2018 - 23:15.

The copyright of the content on this website is held by the contributing authors, except where stated elsewhere. See Copyright Statement. Creative Commons License    Legal Imprint    Privacy Policy