Error message when using SQLPluging

Hi,

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/Core.pm line 47. at /var/www/foswiki/lib/Foswiki/Plugins/SqlPlugin/Core.pm line 47. Foswiki::Plugins::SqlPlugin::Core::new('Foswiki::Plugins::SqlPlugin::Core') called at /var/www/foswiki/lib/Foswiki/Plugins/SqlPlugin.pm line 37 Foswiki::Plugins::SqlPlugin::core() called at /var/www/foswiki/lib/Foswiki/Plugins/SqlPlugin.pm 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/Func.pm line 609 Foswiki::Func::__ANON__('Foswiki=HASH(0x1b8a100)', 'Foswiki::Attrs=HASH(0x298ae78)', 'Foswiki::Meta=HASH(0x25fe128)') called at /var/www/foswiki/lib/Foswiki.pm line 3160 Foswiki::_expandMacroOnTopicRendering('Foswiki=HASH(0x1b8a100)', 'SQL', 'query="SELECT * FROM test" database="etsback" ', 'Foswiki::Meta=HASH(0x25fe128)') called at /var/www/foswiki/lib/Foswiki.pm 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/Foswiki.pm line 2833 Foswiki::innerExpandMacros('Foswiki=HASH(0x1b8a100)', 'SCALAR(0x1afa638)', 'Foswiki::Meta=HASH(0x25fe128)') called at /var/www/foswiki/lib/Foswiki.pm 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/Meta.pm 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/View.pm 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/View.pm line 392 Foswiki::UI::View::view('Foswiki=HASH(0x1b8a100)') called at /var/www/foswiki/lib/Foswiki/UI.pm line 316 Foswiki::UI::__ANON__() called at /var/www/foswiki/lib/CPAN/lib/Error.pm line 379 eval {...} called at /var/www/foswiki/lib/CPAN/lib/Error.pm line 371 Error::subs::try('CODE(0x109bc30)', 'HASH(0x1b89cf8)') called at /var/www/foswiki/lib/Foswiki/UI.pm line 435 Foswiki::UI::_execute('Foswiki::Request=HASH(0x1b651e8)', 'CODE(0x1b64d50)', 'view', 1) called at /var/www/foswiki/lib/Foswiki/UI.pm line 274 Foswiki::UI::handleRequest('Foswiki::Request=HASH(0x1b651e8)') called at /var/www/foswiki/lib/Foswiki/Engine/CGI.pm 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