Re: [Slashcode-general] 500 errors on admin.pl?op=edit

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<font size="-1"><font face="Arial">Hi Shane,<br>
<br>
Thanks for the advice, however:<br>
<br>
</font></font><big><font size="-1"><big><tt>$VAR1 = {<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Submit' =&gt; 1,<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Print' =&gt; 1,<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Login' =&gt; 1,<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'FAQ' =&gt; 1,<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'PollBooth' =&gt; 1,<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Search' =&gt; 1,<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Validator' =&gt; 1,<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Admin' =&gt; 1,<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Stats' =&gt; 1,<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'PubKey' =&gt; 1,<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Subscribe' =&gt; 1,<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Zoo' =&gt; 1,<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Rating' =&gt; 1,<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Messages' =&gt; 1,<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'ResKey' =&gt; 1,<br>
<b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Blob' =&gt; 1,</b><br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Events' =&gt; 1,<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Hof' =&gt; 1,<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Sections' =&gt; 1,<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Journal' =&gt; 1<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; };</tt></big></font></big><font size="-1"><font face="Arial"><br>
<br>
I did try to reinstall Blob with the install-plugin script, but no
change.&nbsp; Blob is part of the default install, anyway, and from this
line:<br>
<br>
</font></font>&nbsp; <tt>&nbsp; &nbsp;&nbsp;&nbsp; if ($constants-&gt;{plugin}{Blob}) {</tt><br>
<br>
&nbsp;If blob wasn't installed, that would return false and that block
wouldn't run.&nbsp; It's running, but it's failing.&nbsp; Here is the section of
code from $PERLLIB/Slash/DB/MySQL.pm that appears to be failing.&nbsp; The
specific lines that are failing with the errors I mentioned earlier are
in bold with their line number in the right margin.&nbsp; (My apologies to
anyone using ASCII mail)<br>
<br>
<br>
<tt>########################################################<br>
<br>
# This method is used to grandfather in old-style sid's,<br>
# automatically converting them to stoids.<br>
sub getStoidFromSidOrStoid {<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; my($self, $id) = @_;<br>
<b>&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; return $id if $id =~
/^\d+$/;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9900</b><br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return $self-&gt;getStoidFromSid($id);<br>
}<br>
<br>
# This method does the conversion efficiently.&nbsp; There are three<br>
# likely levels of caching here, to minimize the impact of this<br>
# backwards-compatibility feature as much as possible:&nbsp; a RAM<br>
# cache in this Slash::DB::MySQL object (set to never expire,<br>
# since this data is tiny and never changes);&nbsp; memcached (ditto,<br>
# but just with a very long expiration time); and MySQL's query<br>
# cache (which expires only when the stories table is written,<br>
# hopefully only every few minutes).&nbsp; Only if all those fail<br>
# will it actually put any load on the DB.<br>
sub getStoidFromSid {<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; my($self, $sid) = @_;<br>
&nbsp;<b> &nbsp;&nbsp; &nbsp;&nbsp; if (my $stoid = $self-&gt;{_sid_conversion_cache}{$sid})
{&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9915</b><br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return $stoid;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; my($mcd, $mcdkey);<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if ($mcd = $self-&gt;getMCD()) {<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $mcdkey = "$self-&gt;{_mcd_keyprefix}:sid:";<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if (my $answer = $mcd-&gt;get("$mcdkey$sid")) {<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $self-&gt;{_sid_conversion_cache}{$sid} =
$answer;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return $answer;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; my $sid_q = $self-&gt;sqlQuote($sid);<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; my $stoid = $self-&gt;sqlSelect("stoid", "stories",
"sid=$sid_q");<br>
&nbsp; &nbsp;<b>&nbsp; &nbsp;&nbsp; $self-&gt;{_sid_conversion_cache}{$sid} =
$stoid;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9928</b><br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; my $exptime = 7 * 86400;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $mcd-&gt;set("$mcdkey$sid", $stoid, $exptime) if $mcd;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return $stoid;<br>
}</tt><br>
<br>
It would appear that in the code you pointed out, $sid is being sent
with an uninitialized value, or it's not being passed to this function
-- every line referencing that value is blank.&nbsp; I'm not versed enough
in the intricacies of Slash to be able to figure out why this may be.&nbsp;
One thing I can think of is if there isn't a story id to pass.&nbsp; This is
a fresh install, but there are the two initial stories.&nbsp; Plus, isn't
this link ('New' from the admin bar) supposed to create a new story?&nbsp;
Or am I mistaken in its purpose?<br>
<br>
I'm also getting the same issue when I try to approve a new submission,
once I hit the Preview button.&nbsp; Errors are similar:<br>
<br>
<tt>Use of uninitialized value in join or string at
/usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi/Slash/DB/MySQL.pm
line 9544.<br>
Use of uninitialized value in substitution (s///) at
/usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi/Slash/Utility/Data.pm
line 2971.<br>
[Wed Aug&nbsp; 2 18:14:10 2006] [error] Can't call method "getFilesForStory"
on an undefined value at $SLASH_PREFIX/$SLASHSITE/htdocs/admin.pl line
1442.\n<br>
</tt><br>
And about two dozen instances of this Apache::Registry error:<br>
<br>
<tt>Wed Aug 2 18:14:10 2006 _genericGets table_prime='session'
table='sessions' param_table='' values: $VAR1 = [ 'lasttitle', 'uid' ];
row: $VAR1 = { 'uid' =&gt; '2', 'lasttitle' =&gt; 'Test submission' };
caller_info='Slash::Utility::Display line 1266
Apache::ROOTsitename::admin_2epl line 1387
Apache::ROOTsitename::admin_2epl line 233
Apache::ROOTsitename::admin_2epl line 2291 Apache::Registry line 149
Apache::Registry line 149 main line 1 main line 1'</tt><br>
<br>
Seems to be the same root cause, no value passed to getFilesForStory
via $sid.&nbsp; What is $sid supposed to propagate from?<br>
<br>
Thanks again,<br>
<br>
Josh<br>
<br>
shane wrote:
<blockquote cite="mid...@lo..."
 type="cite"><br>
  <div>
  <div>On Aug 2, 2006, at 4:12 AM, Josh Stedman wrote:</div>
  <br class="Apple-interchange-newline">
  <blockquote type="cite"><font size="-1"><font face="Arial">[...]<br>
On the "New" link in backslash, which links to admin.pl?op=edit, I'm
getting a 500 error.&nbsp; The errors from the error log appear to be in the
slash MySQL module:<br>
    <br>
Use of uninitialized value in pattern match (m//) at
/usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi/Slash/DB/MySQL.pm
line 9900.<br>
Use of uninitialized value in hash element at
/usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi/Slash/DB/MySQL.pm
line 9915.<br>
Use of uninitialized value in hash element at
/usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi/Slash/DB/MySQL.pm
line 9928.<br>
[Wed Aug&nbsp; 2 07:52:50 2006] [error] Can't call method "getFilesForStory"
on an undefined value at $SLASH_PREFIX/$SITENAME/htdocs/admin.pl line
1442.\n<br>
[...]</font></font></blockquote>
  <br>
  </div>
  <div>You need to install the Slash::Blob plugin - or verify that it
is already installed.</div>
  <div><br class="khtml-block-placeholder">
  </div>
  <div>perl -MSlash::Test=slash -le 'print Dumper
$constants-&gt;{plugin}'</div>
  <div><br class="khtml-block-placeholder">
  </div>
  <div>from the command line will give you a list of what plugins are
installed on your site (if your site's virtual user is different from
'slash' then replace it in that command).</div>
  <div><br class="khtml-block-placeholder">
  </div>
  <div>If you grep admin.pl for 'getFilesForStory':</div>
  <div><br class="khtml-block-placeholder">
  </div>
  <div>&nbsp; &nbsp; &nbsp;&nbsp; &nbsp;if ($constants-&gt;{plugin}{Blob}) {</div>
  <div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; my $blobdb = getObject("Slash::Blob");</div>
  <div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; my $files = $blobdb-&gt;getFilesForStory($sid);</div>
  <div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $attached_files = slashDisplay('attached_files',
{ files =&gt; $files }, { Return =&gt; 1});</div>
  <div>&nbsp; &nbsp; &nbsp; &nbsp; }</div>
  <div><br class="khtml-block-placeholder">
  </div>
  <div><br class="khtml-block-placeholder">
  </div>
  <div><br class="khtml-block-placeholder">
  </div>
  <div><br class="khtml-block-placeholder">
  </div>
  <div>&nbsp;Shane</div>
  <div><br class="khtml-block-placeholder">
  </div>
  <br>
  <pre wrap=""><hr size="4" width="90%">
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT &amp; business topics through brief surveys -- and earn cash
<a class="moz-txt-link-freetext"
 href="http://www.techsay.com/default.php?page=join.php&amp;p=sourceforge&amp;CID=DEVDEV">http://www.techsay.com/default.php?page=join.php&amp;p=sourceforge&amp;CID=DEVDEV</a></pre>
  <pre wrap=""><hr size="4" width="90%">
_______________________________________________
Slashcode-general mailing list
<a class="moz-txt-link-abbreviated"
 href="mailto:Sla...@li...">Sla...@li...</a>
<a class="moz-txt-link-freetext"
 href="https://lists.sourceforge.net/lists/listinfo/slashcode-general">https://lists.sourceforge.net/lists/listinfo/slashcode-general</a>
  </pre>
</blockquote>
</body>
</html>