Advertisement
Guest User

Untitled

a guest
Aug 3rd, 2012
43
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 16.50 KB | None | 0 0
  1. try {
  2. checkAccess($theDatabase, $theQuery);
  3.  
  4. $connection->connect();
  5. $theQuery =~ m/(.*)/;
  6. $theQuery = $1;
  7.  
  8. my $sth = $connection->{db}->prepare_cached($theQuery) or
  9. throw Error::Simple("Can't prepare cmd '$theQuery': ".$connection->{db}->errstr);
  10.  
  11. $sth->execute(@bindVals) or
  12. throw Error::Simple("Can't execute cmd '$theQuery': ".$connection->{db}->errstr);
  13.  
  14. # cache this statement under the given id
  15. $cache{$theId} = {
  16. sth => $sth,
  17. connection => $connection,
  18. } if $theId;
  19.  
  20. if($sth->{NUM_OF_FIELDS}) {
  21. # select statement
  22. $result = formatResult($params, $sth);
  23. } else {
  24. # non-select statement
  25. $result = $sth->rows();
  26. }
  27.  
  28.  
  29. } catch Error::Simple with {
  30.  
  31. writeDebug("CAUGHT EX");
  32.  
  33. my $msg = shift->{-text};
  34. #$msg =~ s/ at .*?$//gs;
  35. $result = inlineError($msg);
  36. };
  37.  
  38. | 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.
  39. at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki/Plugins/SqlPlugin/Core.pm line 141
  40. Foswiki::Plugins::SqlPlugin::Core::__ANON__() called at /Users/kip/perl/lib/perl5/Error.pm line 415
  41. eval {...} called at /Users/kip/perl/lib/perl5/Error.pm line 407
  42. 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
  43. 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
  44. 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
  45. 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
  46. 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
  47. 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
  48. 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
  49. 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
  50. 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
  51. 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
  52. 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
  53. 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
  54. 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
  55. 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
  56. 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
  57. 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
  58. 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
  59. 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
  60. 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
  61. 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
  62. 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
  63. 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
  64. 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
  65. 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
  66. 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
  67. Foswiki::UI::View::view('Foswiki=HASH(0x100a3f450)') called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki/UI.pm line 316
  68. Foswiki::UI::__ANON__() called at /Users/kip/perl/lib/perl5/Error.pm line 415
  69. eval {...} called at /Users/kip/perl/lib/perl5/Error.pm line 407
  70. Error::subs::try('CODE(0x100804d20)', 'HASH(0x100a3f000)') called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki/UI.pm line 435
  71. 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
  72. Foswiki::UI::handleRequest('Foswiki::Request=HASH(0x100a2a588)') called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki/Engine/CGI.pm line 41
  73. Foswiki::Engine::CGI::run('Foswiki::Engine::CGI=HASH(0x1008e30f0)') called </span></noautolink> |
  74. | 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.
  75. at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki/Plugins/SqlPlugin/Core.pm line 141
  76. Foswiki::Plugins::SqlPlugin::Core::__ANON__() called at /Users/kip/perl/lib/perl5/Error.pm line 415
  77. eval {...} called at /Users/kip/perl/lib/perl5/Error.pm line 407
  78. 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
  79. 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
  80. 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
  81. 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
  82. 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
  83. 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
  84. 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
  85. 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
  86. 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
  87. 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
  88. 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
  89. 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
  90. 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
  91. 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
  92. 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
  93. 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
  94. 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
  95. 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
  96. 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
  97. 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
  98. 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
  99. 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
  100. 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
  101. 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
  102. 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
  103. Foswiki::UI::View::view('Foswiki=HASH(0x100a3f450)') called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki/UI.pm line 316
  104. Foswiki::UI::__ANON__() called at /Users/kip/perl/lib/perl5/Error.pm line 415
  105. eval {...} called at /Users/kip/perl/lib/perl5/Error.pm line 407
  106. Error::subs::try('CODE(0x100804d20)', 'HASH(0x100a3f000)') called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki/UI.pm line 435
  107. 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
  108. Foswiki::UI::handleRequest('Foswiki::Request=HASH(0x100a2a588)') called at /Users/kip/dev/www/src/foswiki/Release01x01/core/lib/Foswiki/Engine/CGI.pm line 41
  109. Foswiki::Engine::CGI::run('Foswiki::Engine::CGI=HASH(0x1008e30f0)') called </span></noautolink> |
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement