Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- try {
- checkAccess($theDatabase, $theQuery);
- $connection->connect();
- $theQuery =~ m/(.*)/;
- $theQuery = $1;
- my $sth = $connection->{db}->prepare_cached($theQuery) or
- throw Error::Simple("Can't prepare cmd '$theQuery': ".$connection->{db}->errstr);
- $sth->execute(@bindVals) or
- throw Error::Simple("Can't execute cmd '$theQuery': ".$connection->{db}->errstr);
- # cache this statement under the given id
- $cache{$theId} = {
- sth => $sth,
- connection => $connection,
- } if $theId;
- if($sth->{NUM_OF_FIELDS}) {
- # select statement
- $result = formatResult($params, $sth);
- } else {
- # non-select statement
- $result = $sth->rows();
- }
- } catch Error::Simple with {
- writeDebug("CAUGHT EX");
- my $msg = shift->{-text};
- #$msg =~ s/ at .*?$//gs;
- $result = inlineError($msg);
- };
- | 2012-08-03T13:04:36Z warning | Max recursive depth reached: <noautolink><span class='foswikiAlert'>ERROR: DBD::mysql::st execute failed: 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 'database="gotham...', 'CODE(0x100a1f098)', 'Foswiki::Meta=HASH(0x100c62ce8)', 16' at line 1 at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki/Plugins/SqlPlugin/Core.pm line 141.
- at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki/Plugins/SqlPlugin/Core.pm line 141
- Foswiki::Plugins::SqlPlugin::Core::__ANON__() called at /Users/kip/perl/lib/perl5/Error.pm line 415
- eval {...} called at /Users/kip/perl/lib/perl5/Error.pm line 407
- Error::subs::try('CODE(0x100eef008)', 'HASH(0x100eef2c0)') called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki/Plugins/SqlPlugin/Core.pm line 166
- Foswiki::Plugins::SqlPlugin::Core::handleSQL('Foswiki=HASH(0x100a3f450)', 'Foswiki::Attrs=HASH(0x100eef320)', 'EditBoxScore', 'Gothams', 'Foswiki::Meta=HASH(0x100c62ce8)') called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki/Plugins/SqlPlugin.pm line 57
- Foswiki::Plugins::SqlPlugin::handleSQL('Foswiki=HASH(0x100a3f450)', 'Foswiki::Attrs=HASH(0x100eef320)', 'EditBoxScore', 'Gothams', 'Foswiki::Meta=HASH(0x100c62ce8)') called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki/Func.pm line 611
- Foswiki::Func::__ANON__('Foswiki=HASH(0x100a3f450)', 'Foswiki::Attrs=HASH(0x100eef320)', 'Foswiki::Meta=HASH(0x100c62ce8)') called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki.pm line 3122
- Foswiki::_expandMacroOnTopicRendering('Foswiki=HASH(0x100a3f450)', 'SQL', 'database="gotham...\', \'CODE(0x100a1f098)\', \'Foswiki::Meta...', 'Foswiki::Meta=HASH(0x100c62ce8)') called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki.pm line 2998
- Foswiki::_processMacros('Foswiki=HASH(0x100a3f450)', '<noautolink><span class=\'foswikiAlert\'>ERROR: DBD::mysql::s...', 'CODE(0x100a1f098)', 'Foswiki::Meta=HASH(0x100c62ce8)', 1) called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki.pm line 3016
- Foswiki::_processMacros('Foswiki=HASH(0x100a3f450)', '<noautolink><span class=\'foswikiAlert\'>ERROR: DBD::mysql::s...', 'CODE(0x100a1f098)', 'Foswiki::Meta=HASH(0x100c62ce8)', 2) called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki.pm line 3016
- Foswiki::_processMacros('Foswiki=HASH(0x100a3f450)', '<noautolink><span class=\'foswikiAlert\'>ERROR: DBD::mysql::s...', 'CODE(0x100a1f098)', 'Foswiki::Meta=HASH(0x100c62ce8)', 3) called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki.pm line 3016
- Foswiki::_processMacros('Foswiki=HASH(0x100a3f450)', '<noautolink><span class=\'foswikiAlert\'>ERROR: DBD::mysql::s...', 'CODE(0x100a1f098)', 'Foswiki::Meta=HASH(0x100c62ce8)', 4) called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki.pm line 3016
- Foswiki::_processMacros('Foswiki=HASH(0x100a3f450)', '<noautolink><span class=\'foswikiAlert\'>ERROR: DBD::mysql::s...', 'CODE(0x100a1f098)', 'Foswiki::Meta=HASH(0x100c62ce8)', 5) called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki.pm line 3016
- Foswiki::_processMacros('Foswiki=HASH(0x100a3f450)', '<noautolink><span class=\'foswikiAlert\'>ERROR: DBD::mysql::s...', 'CODE(0x100a1f098)', 'Foswiki::Meta=HASH(0x100c62ce8)', 6) called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki.pm line 3016
- Foswiki::_processMacros('Foswiki=HASH(0x100a3f450)', '<noautolink><span class=\'foswikiAlert\'>ERROR: DBD::mysql::s...', 'CODE(0x100a1f098)', 'Foswiki::Meta=HASH(0x100c62ce8)', 7) called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki.pm line 3016
- Foswiki::_processMacros('Foswiki=HASH(0x100a3f450)', '<noautolink><span class=\'foswikiAlert\'>ERROR: DBD::mysql::s...', 'CODE(0x100a1f098)', 'Foswiki::Meta=HASH(0x100c62ce8)', 8) called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki.pm line 3016
- Foswiki::_processMacros('Foswiki=HASH(0x100a3f450)', '<noautolink><span class=\'foswikiAlert\'>ERROR: DBD::mysql::s...', 'CODE(0x100a1f098)', 'Foswiki::Meta=HASH(0x100c62ce8)', 9) called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki.pm line 3016
- Foswiki::_processMacros('Foswiki=HASH(0x100a3f450)', '<noautolink><span class=\'foswikiAlert\'>ERROR: DBD::mysql::s...', 'CODE(0x100a1f098)', 'Foswiki::Meta=HASH(0x100c62ce8)', 10) called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki.pm line 3016
- Foswiki::_processMacros('Foswiki=HASH(0x100a3f450)', '<noautolink><span class=\'foswikiAlert\'>ERROR: DBD::mysql::s...', 'CODE(0x100a1f098)', 'Foswiki::Meta=HASH(0x100c62ce8)', 11) called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki.pm line 3016
- Foswiki::_processMacros('Foswiki=HASH(0x100a3f450)', '<noautolink><span class=\'foswikiAlert\'>ERROR: DBD::mysql::s...', 'CODE(0x100a1f098)', 'Foswiki::Meta=HASH(0x100c62ce8)', 12) called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki.pm line 3016
- Foswiki::_processMacros('Foswiki=HASH(0x100a3f450)', '<noautolink><span class=\'foswikiAlert\'>ERROR: DBD::mysql::s...', 'CODE(0x100a1f098)', 'Foswiki::Meta=HASH(0x100c62ce8)', 13) called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki.pm line 3016
- Foswiki::_processMacros('Foswiki=HASH(0x100a3f450)', '<noautolink><span class=\'foswikiAlert\'>ERROR: DBD::mysql::s...', 'CODE(0x100a1f098)', 'Foswiki::Meta=HASH(0x100c62ce8)', 14) called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki.pm line 3016
- Foswiki::_processMacros('Foswiki=HASH(0x100a3f450)', '<noautolink><span class=\'foswikiAlert\'>ERROR: DBD::mysql::s...', 'CODE(0x100a1f098)', 'Foswiki::Meta=HASH(0x100c62ce8)', 15) called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki.pm line 3016
- Foswiki::_processMacros('Foswiki=HASH(0x100a3f450)', '<!--\x{a} * Set BSID=%URLPARAM{bsid}%\x{a}-->\x{a}%SQL{database="gotham...', 'CODE(0x100a1f098)', 'Foswiki::Meta=HASH(0x100c62ce8)', 16) called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki.pm line 2795
- Foswiki::innerExpandMacros('Foswiki=HASH(0x100a3f450)', 'SCALAR(0x100a20080)', 'Foswiki::Meta=HASH(0x100c62ce8)') called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki.pm line 3304
- Foswiki::expandMacros('Foswiki=HASH(0x100a3f450)', '<!--\x{a} * Set BSID=%URLPARAM{bsid}%\x{a}-->\x{a}%SQL{database="gotham...', 'Foswiki::Meta=HASH(0x100c62ce8)') called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki/Meta.pm line 3143
- Foswiki::Meta::expandMacros('Foswiki::Meta=HASH(0x100c62ce8)', '<!--\x{a} * Set BSID=%URLPARAM{bsid}%\x{a}-->\x{a}%SQL{database="gotham...') called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki/UI/View.pm line 412
- Foswiki::UI::View::_prepare('<!--\x{a} * Set BSID=%URLPARAM{bsid}%\x{a}-->\x{a}%SQL{database="gotham...', 'Foswiki::Meta=HASH(0x100c62ce8)', 0) called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki/UI/View.pm line 392
- Foswiki::UI::View::view('Foswiki=HASH(0x100a3f450)') called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki/UI.pm line 316
- Foswiki::UI::__ANON__() called at /Users/kip/perl/lib/perl5/Error.pm line 415
- eval {...} called at /Users/kip/perl/lib/perl5/Error.pm line 407
- Error::subs::try('CODE(0x100804d20)', 'HASH(0x100a3f000)') called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki/UI.pm line 435
- Foswiki::UI::_execute('Foswiki::Request=HASH(0x100a2a588)', 'CODE(0x1008b4530)', 'view', 1) called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki/UI.pm line 274
- Foswiki::UI::handleRequest('Foswiki::Request=HASH(0x100a2a588)') called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki/Engine/CGI.pm line 41
- Foswiki::Engine::CGI::run('Foswiki::Engine::CGI=HASH(0x1008e30f0)') called </span></noautolink> |
- | 2012-08-03T13:04:36Z warning | Max recursive depth reached: <noautolink><span class='foswikiAlert'>ERROR: DBD::mysql::st execute failed: 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 'database="gotham...') called at /Users/kip/dev/www/src/foswiki/Release01x01/core' at line 1 at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki/Plugins/SqlPlugin/Core.pm line 141.
- at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki/Plugins/SqlPlugin/Core.pm line 141
- Foswiki::Plugins::SqlPlugin::Core::__ANON__() called at /Users/kip/perl/lib/perl5/Error.pm line 415
- eval {...} called at /Users/kip/perl/lib/perl5/Error.pm line 407
- Error::subs::try('CODE(0x100eb8878)', 'HASH(0x100eb8e48)') called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki/Plugins/SqlPlugin/Core.pm line 166
- Foswiki::Plugins::SqlPlugin::Core::handleSQL('Foswiki=HASH(0x100a3f450)', 'Foswiki::Attrs=HASH(0x100eef308)', 'EditBoxScore', 'Gothams', 'Foswiki::Meta=HASH(0x100c62ce8)') called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki/Plugins/SqlPlugin.pm line 57
- Foswiki::Plugins::SqlPlugin::handleSQL('Foswiki=HASH(0x100a3f450)', 'Foswiki::Attrs=HASH(0x100eef308)', 'EditBoxScore', 'Gothams', 'Foswiki::Meta=HASH(0x100c62ce8)') called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki/Func.pm line 611
- Foswiki::Func::__ANON__('Foswiki=HASH(0x100a3f450)', 'Foswiki::Attrs=HASH(0x100eef308)', 'Foswiki::Meta=HASH(0x100c62ce8)') called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki.pm line 3122
- Foswiki::_expandMacroOnTopicRendering('Foswiki=HASH(0x100a3f450)', 'SQL', 'database="gotham...\') called at /Users/kip/dev/www/src/foswi...', 'Foswiki::Meta=HASH(0x100c62ce8)') called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki.pm line 2998
- Foswiki::_processMacros('Foswiki=HASH(0x100a3f450)', '<noautolink><span class=\'foswikiAlert\'>ERROR: DBD::mysql::s...', 'CODE(0x100a1f098)', 'Foswiki::Meta=HASH(0x100c62ce8)', 1) called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki.pm line 3016
- Foswiki::_processMacros('Foswiki=HASH(0x100a3f450)', '<noautolink><span class=\'foswikiAlert\'>ERROR: DBD::mysql::s...', 'CODE(0x100a1f098)', 'Foswiki::Meta=HASH(0x100c62ce8)', 2) called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki.pm line 3016
- Foswiki::_processMacros('Foswiki=HASH(0x100a3f450)', '<noautolink><span class=\'foswikiAlert\'>ERROR: DBD::mysql::s...', 'CODE(0x100a1f098)', 'Foswiki::Meta=HASH(0x100c62ce8)', 3) called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki.pm line 3016
- Foswiki::_processMacros('Foswiki=HASH(0x100a3f450)', '<noautolink><span class=\'foswikiAlert\'>ERROR: DBD::mysql::s...', 'CODE(0x100a1f098)', 'Foswiki::Meta=HASH(0x100c62ce8)', 4) called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki.pm line 3016
- Foswiki::_processMacros('Foswiki=HASH(0x100a3f450)', '<noautolink><span class=\'foswikiAlert\'>ERROR: DBD::mysql::s...', 'CODE(0x100a1f098)', 'Foswiki::Meta=HASH(0x100c62ce8)', 5) called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki.pm line 3016
- Foswiki::_processMacros('Foswiki=HASH(0x100a3f450)', '<noautolink><span class=\'foswikiAlert\'>ERROR: DBD::mysql::s...', 'CODE(0x100a1f098)', 'Foswiki::Meta=HASH(0x100c62ce8)', 6) called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki.pm line 3016
- Foswiki::_processMacros('Foswiki=HASH(0x100a3f450)', '<noautolink><span class=\'foswikiAlert\'>ERROR: DBD::mysql::s...', 'CODE(0x100a1f098)', 'Foswiki::Meta=HASH(0x100c62ce8)', 7) called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki.pm line 3016
- Foswiki::_processMacros('Foswiki=HASH(0x100a3f450)', '<noautolink><span class=\'foswikiAlert\'>ERROR: DBD::mysql::s...', 'CODE(0x100a1f098)', 'Foswiki::Meta=HASH(0x100c62ce8)', 8) called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki.pm line 3016
- Foswiki::_processMacros('Foswiki=HASH(0x100a3f450)', '<noautolink><span class=\'foswikiAlert\'>ERROR: DBD::mysql::s...', 'CODE(0x100a1f098)', 'Foswiki::Meta=HASH(0x100c62ce8)', 9) called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki.pm line 3016
- Foswiki::_processMacros('Foswiki=HASH(0x100a3f450)', '<noautolink><span class=\'foswikiAlert\'>ERROR: DBD::mysql::s...', 'CODE(0x100a1f098)', 'Foswiki::Meta=HASH(0x100c62ce8)', 10) called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki.pm line 3016
- Foswiki::_processMacros('Foswiki=HASH(0x100a3f450)', '<noautolink><span class=\'foswikiAlert\'>ERROR: DBD::mysql::s...', 'CODE(0x100a1f098)', 'Foswiki::Meta=HASH(0x100c62ce8)', 11) called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki.pm line 3016
- Foswiki::_processMacros('Foswiki=HASH(0x100a3f450)', '<noautolink><span class=\'foswikiAlert\'>ERROR: DBD::mysql::s...', 'CODE(0x100a1f098)', 'Foswiki::Meta=HASH(0x100c62ce8)', 12) called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki.pm line 3016
- Foswiki::_processMacros('Foswiki=HASH(0x100a3f450)', '<noautolink><span class=\'foswikiAlert\'>ERROR: DBD::mysql::s...', 'CODE(0x100a1f098)', 'Foswiki::Meta=HASH(0x100c62ce8)', 13) called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki.pm line 3016
- Foswiki::_processMacros('Foswiki=HASH(0x100a3f450)', '<noautolink><span class=\'foswikiAlert\'>ERROR: DBD::mysql::s...', 'CODE(0x100a1f098)', 'Foswiki::Meta=HASH(0x100c62ce8)', 14) called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki.pm line 3016
- Foswiki::_processMacros('Foswiki=HASH(0x100a3f450)', '<noautolink><span class=\'foswikiAlert\'>ERROR: DBD::mysql::s...', 'CODE(0x100a1f098)', 'Foswiki::Meta=HASH(0x100c62ce8)', 15) called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki.pm line 3016
- Foswiki::_processMacros('Foswiki=HASH(0x100a3f450)', '<!--\x{a} * Set BSID=%URLPARAM{bsid}%\x{a}-->\x{a}%SQL{database="gotham...', 'CODE(0x100a1f098)', 'Foswiki::Meta=HASH(0x100c62ce8)', 16) called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki.pm line 2795
- Foswiki::innerExpandMacros('Foswiki=HASH(0x100a3f450)', 'SCALAR(0x100a20080)', 'Foswiki::Meta=HASH(0x100c62ce8)') called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki.pm line 3304
- Foswiki::expandMacros('Foswiki=HASH(0x100a3f450)', '<!--\x{a} * Set BSID=%URLPARAM{bsid}%\x{a}-->\x{a}%SQL{database="gotham...', 'Foswiki::Meta=HASH(0x100c62ce8)') called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki/Meta.pm line 3143
- Foswiki::Meta::expandMacros('Foswiki::Meta=HASH(0x100c62ce8)', '<!--\x{a} * Set BSID=%URLPARAM{bsid}%\x{a}-->\x{a}%SQL{database="gotham...') called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki/UI/View.pm line 412
- Foswiki::UI::View::_prepare('<!--\x{a} * Set BSID=%URLPARAM{bsid}%\x{a}-->\x{a}%SQL{database="gotham...', 'Foswiki::Meta=HASH(0x100c62ce8)', 0) called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki/UI/View.pm line 392
- Foswiki::UI::View::view('Foswiki=HASH(0x100a3f450)') called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki/UI.pm line 316
- Foswiki::UI::__ANON__() called at /Users/kip/perl/lib/perl5/Error.pm line 415
- eval {...} called at /Users/kip/perl/lib/perl5/Error.pm line 407
- Error::subs::try('CODE(0x100804d20)', 'HASH(0x100a3f000)') called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki/UI.pm line 435
- Foswiki::UI::_execute('Foswiki::Request=HASH(0x100a2a588)', 'CODE(0x1008b4530)', 'view', 1) called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki/UI.pm line 274
- Foswiki::UI::handleRequest('Foswiki::Request=HASH(0x100a2a588)') called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki/Engine/CGI.pm line 41
- Foswiki::Engine::CGI::run('Foswiki::Engine::CGI=HASH(0x1008e30f0)') called </span></noautolink> |
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement