Slash

On Dec 19, 2004, at 4:56 PM, Eric Dannewitz wrote:

> Ok, I bit the bullet and converted to the section slash code from the 
> previous version. It went fairly well, except now I have a few issues.
>
> Three sites are converted, and seem to run alright, but there are no 
> stories on the main index. Do I need to go through and change 
> something to get them to appear on the main index?

This happened to me, too. I don't remember the sol'n, unfortunately. It 
may have been posted on lottadot w/ the information from when we 
switched. You can try there later this afternoon (it's down, NFS 
server's down for some reason as of this morning).

> Second, one site is refusing to start up. I get this message in the 
> Apache Logs:
>
> [Sun Dec 19 22:01:15 2004] [error] Byte order is not compatible at 
> ../../lib/Storable.pm (autosplit into ../../lib/auto/Storable/thaw.al) 
> line 363, at 
> /usr/local/lib/perl5/site_perl/5.8.5/mach/Slash/DB/MySQL.pm line 
> 11423\n

I don't recall running into that one...

No, the site is on the same machine. I have 4 slash sites on it. And 3 
of them migrated no problem. The 4th site is giving me issues with User 
ID 2, which is my primary user....me!

Hmm, I'll have to check out the Friend/Foe things.......

Oliver M. Bolzer wrote:

>Did the one site run previously on another machine ?
>I recently resurrected my slashcode development environment on my new box,
>which is running a 64-bit amd64 environment and had the same error hit me.
>It seems that stuff stored in BLOBS using the Storable interface is actually
>serialized in an architecture dependant way. I had to manually remove
>all Friend/Foe relationships by clearing the people column of the
>users_info table. (Easy to do on a single-user dev install)
>
>If the same thing is biting you, you could come up with a simple script
>maually thawing and storing the BLOB data using the nstore() method of
>Storable on the old architecture.
>  
>

Well, something is totally messed with that user. I get it to log in, 
and I get:
*This page was generated by a Squadron of Uber Squirrels for ()

*
Going to Friends/Fans/Foes results in an Apache error and in the error 
log I get:

[Tue Dec 21 20:45:33 2004] [error] Can't use an undefined value as an 
ARRAY reference at /usr/local/slash/site/www.jazz-sax.com/htdocs/zoo.pl 
line 192.\n

I can't get the user to view INFO, or Homepage, or Comments. It will 
come up with a login message over and over again.

Yes, I did reset my cookies and clear my browsing Cache.

This is really odd.......

Eric Dannewitz wrote:

> No, the site is on the same machine. I have 4 slash sites on it. And 3 
> of them migrated no problem. The 4th site is giving me issues with 
> User ID 2, which is my primary user....me!
>
> Hmm, I'll have to check out the Friend/Foe things.......
>

try something like

perl -MSlash::Test={slashsitevirtualusername} -le 'my 
$u=$slashdb->getUser(2); print Dumper($u); my 
$z=getObject("Slash::Zoo"); my $friends=$z->getRelationships(2,FRIEND); 
print Dumper($friends);'

and post that somewhere where we can all view it.

btw, I show # $Id: zoo.pl,v 1.50 2004/12/09 17:36:33 jamiemccarthy Exp 
$ in my cvs co as what we have running here.

On Dec 21, 2004, at 3:32 PM, Eric Dannewitz wrote:

> Well, something is totally messed with that user. I get it to log in, 
> and I get:
> *This page was generated by a Squadron of Uber Squirrels for ()
>
> *
> Going to Friends/Fans/Foes results in an Apache error and in the error 
> log I get:
>
> [Tue Dec 21 20:45:33 2004] [error] Can't use an undefined value as an 
> ARRAY reference at 
> /usr/local/slash/site/www.jazz-sax.com/htdocs/zoo.pl line 192.\n
>
> I can't get the user to view INFO, or Homepage, or Comments. It will 
> come up with a login message over and over again.
>
> Yes, I did reset my cookies and clear my browsing Cache.
>
> This is really odd.......
>
> Eric Dannewitz wrote:
>
>> No, the site is on the same machine. I have 4 slash sites on it. And 
>> 3 of them migrated no problem. The 4th site is giving me issues with 
>> User ID 2, which is my primary user....me!
>>
>> Hmm, I'll have to check out the Friend/Foe things.......
>>
>
>
>
>
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real 
> users.
> Discover which products truly live up to the hype. Start reading now. 
> http://productguide.itmanagersjournal.com/
> _______________________________________________
> Slashcode-general mailing list
> Slashcode-general@...
> https://lists.sourceforge.net/lists/listinfo/slashcode-general
>

Interesting results.......

freebsd# perl -MSlash::Test={slash} -le 'my $u=$slashdb->getUser(2); 
print Dumper($u); my $z=getObject("Slash::Zoo"); my 
$friends=$z->getRelationships(2,FRIEND); print Dumper($friends);'
skin 11 has artcount_max of 0 at 
/usr/local/lib/perl5/site_perl/5.8.5/mach/Slash/DB/MySQL.pm line 10874.
$VAR1 = undef;

Magic number checking on storable string failed at ../../lib/Storable.pm 
(autosplit into ../../lib/auto/Storable/thaw.al) line 363, at 
/usr/local/lib/perl5/site_perl/5.8.5/mach/Slash/DB/MySQL.pm line 11423


Shane wrote:

> try something like
>
> perl -MSlash::Test={slashsitevirtualusername} -le 'my 
> $u=$slashdb->getUser(2); print Dumper($u); my 
> $z=getObject("Slash::Zoo"); my 
> $friends=$z->getRelationships(2,FRIEND); print Dumper($friends);'
>
> and post that somewhere where we can all view it.
>
> btw, I show # $Id: zoo.pl,v 1.50 2004/12/09 17:36:33 jamiemccarthy Exp 
> $ in my cvs co as what we have running here.
>

shane@... (Shane) writes:

> try something like
>=20
> perl -MSlash::Test=3D{slashsitevirtualusername} -le 'my=20
> $u=3D$slashdb->getUser(2); print Dumper($u); my=20
> $z=3DgetObject("Slash::Zoo"); my $friends=3D$z->getRelationships(2,FRIEND=
);=20
> print Dumper($friends);'
>=20
> and post that somewhere where we can all view it.

Redact the 'passwd' field first, but yes, that would be helpful :)

BTW, Shane, Slash::Test instantiates plugin objects of the same name
automagically (you can thank pudge for that), so a shorter version
would be:

perl -MSlash::Test=3Dslashsitevirtualusername -le 'print Dumper($slashdb->g=
etUser(2)); print Dumper($zoo->getRelationships(2, FRIEND))'
--=20
  Jamie McCarthy
 http://mccarthy.vg/
  jamie@...

On Dec 22, 2004, at 9:16 AM, Jamie McCarthy wrote:

> shane@... (Shane) writes:
>
>> try something like
>>
>> perl -MSlash::Test={slashsitevirtualusername} -le 'my
>> $u=$slashdb->getUser(2); print Dumper($u); my
>> $z=getObject("Slash::Zoo"); my 
>> $friends=$z->getRelationships(2,FRIEND);
>> print Dumper($friends);'
>>
>> and post that somewhere where we can all view it.
>
> Redact the 'passwd' field first, but yes, that would be helpful :)
>
> BTW, Shane, Slash::Test instantiates plugin objects of the same name
> automagically (you can thank pudge for that), so a shorter version
> would be:
>
> perl -MSlash::Test=slashsitevirtualusername -le 'print 
> Dumper($slashdb->getUser(2)); print Dumper($zoo->getRelationships(2, 
> FRIEND))'

Ah, good to know. Thanks (and thanks Pudge :)

That Slash:Test is a mighty handy little tool.

  Shane

Thanks guys, I think we are getting closer

freebsd# perl -MSlash::Test=slash -le 'print 
Dumper($slashdb->getUser(2)); print 
Dumper($zoo->getRelationships(2,FRIEND))'
skin 11 has artcount_max of 0 at 
/usr/local/lib/perl5/site_perl/5.8.5/mach/Slash/DB/MySQL.pm line 10874.
$VAR1 = undef;

Magic number checking on storable string failed at ../../lib/Storable.pm 
(autosplit into ../../lib/auto/Storable/thaw.al) line 363, at 
/usr/local/lib/perl5/site_perl/5.8.5/mach/Slash/DB/MySQL.pm line 11423
freebsd#


Jamie McCarthy wrote:

>Redact the 'passwd' field first, but yes, that would be helpful :)
>
>BTW, Shane, Slash::Test instantiates plugin objects of the same name
>automagically (you can thank pudge for that), so a shorter version
>would be:
>
>perl -MSlash::Test=slashsitevirtualusername -le 'print Dumper($slashdb->getUser(2)); print Dumper($zoo->getRelationships(2, FRIEND))'
>  
>

freebsd# perl -MSlash::Test=slash -le 'my $u=$slashdb->getUser(2); print 
Dumper($u); my $z=getObject("Slash::Zoo"); my 
$friends=$z->getRelationships(2,FRIEND); print Dumper($friends);'
skin 11 has artcount_max of 0 at 
/usr/local/lib/perl5/site_perl/5.8.5/mach/Slash/DB/MySQL.pm line 10874.
$VAR1 = undef;

Magic number checking on storable string failed at ../../lib/Storable.pm 
(autosplit into ../../lib/auto/Storable/thaw.al) line 363, at 
/usr/local/lib/perl5/site_perl/5.8.5/mach/Slash/DB/MySQL.pm line 11423
freebsd#




Shane wrote:

> change Test={slash} to Test=slash
>
> On Dec 21, 2004, at 11:14 PM, Eric Dannewitz wrote:
>
>> Interesting results.......
>>
>> freebsd# perl -MSlash::Test={slash} -le 'my $u=$slashdb->getUser(2); 
>> print Dumper($u); my $z=getObject("Slash::Zoo"); my 
>> $friends=$z->getRelationships(2,FRIEND); print Dumper($friends);'
>> skin 11 has artcount_max of 0 at 
>> /usr/local/lib/perl5/site_perl/5.8.5/mach/Slash/DB/MySQL.pm line 10874.
>> $VAR1 = undef;
>>
>> Magic number checking on storable string failed at 
>> ../../lib/Storable.pm (autosplit into 
>> ../../lib/auto/Storable/thaw.al) line 363, at 
>> /usr/local/lib/perl5/site_perl/5.8.5/mach/Slash/DB/MySQL.pm line 11423
>>
>>

ericdano@... (Eric Dannewitz) writes:

> freebsd# perl -MSlash::Test=3Dslash -le 'my $u=3D$slashdb->getUser(2); pr=
int=20
> Dumper($u); my $z=3DgetObject("Slash::Zoo"); my=20
> $friends=3D$z->getRelationships(2,FRIEND); print Dumper($friends);''

OK...

> skin 11 has artcount_max of 0 at=20
> /usr/local/lib/perl5/site_perl/5.8.5/mach/Slash/DB/MySQL.pm line 10874.

You should probably fix that;  open up a mysql client and

    UPDATE skins SET artcount_max=3D15 WHERE skid=3D11;

or something like that.  Not sure why the update script didn't set it
properly for you.  Or maybe your skin with skid=3D11 is bogus somehow?

> $VAR1 =3D undef;

So getUser() returned undef

> Magic number checking on storable string failed at ../../lib/Storable.pm=
=20
> (autosplit into ../../lib/auto/Storable/thaw.al) line 363, at=20
> /usr/local/lib/perl5/site_perl/5.8.5/mach/Slash/DB/MySQL.pm line 11423

That's this line:

    $answer->{people} =3D thaw($answer->{people});

So the data is almost certainly bad in your database for the user with
uid 2.  But you earlier said:

> freebsd# echo 'select people from users_info where uid=3D2' | mysql slash=
 | cat -v
> people
> NULL

which doesn't make any sense.

OK, what I would do is this.  Turn on MySQL logging if it isn't
already.  This will hurt performance on a production website
but we're just debugging here.  Add this to your my.cnf file:

    log =3D /var/log/mysql/mysql.log

and restart mysqld.  Then re-run the Slash::Test command above and
check mysql.log to make sure it has lines that look vaguely like
this:

   196966 Query       SELECT * FROM users,users_comments,users_hits,users_i=
ndex,users_info,users_prefs WHERE (users.uid=3D'2' AND users_comments.uid=
=3D'2' AND users_index.uid=3D'2' AND users_info.uid=3D'2' AND users_prefs.u=
id=3D'2' AND users_hits.uid=3D'2')
   196966 Query       SELECT  name, value    FROM users_param   WHERE uid =
=3D '2'
   196966 Query       SELECT  acl FROM users_acl WHERE uid =3D '2'

If that looks right, you have to start trying to find where that
data comes from that breaks thaw().  Open up MySQL.pm and start
editing _getUser_do_selects().  Right before the "if
($answer->{people})" line, insert a

    print Dumper($answer);

so you can see the raw data... then re-run the Slash::Test and
see what that outputs.
--=20
  Jamie McCarthy
 http://mccarthy.vg/
  jamie@...

Well, when I run this:

SELECT * FROM users,users_comments,users_hits,users_index,users_info,users_prefs WHERE (users.uid='2' AND users_comments.uid='2' AND users_index.uid='2' AND users_info.uid='2' AND users_prefs.uid='2' AND users_hits.uid='2')

I get nothing. Hmmm.........




Jamie McCarthy wrote:

>OK, what I would do is this.  Turn on MySQL logging if it isn't
>already.  This will hurt performance on a production website
>but we're just debugging here.  Add this to your my.cnf file:
>
>    log = /var/log/mysql/mysql.log
>
>and restart mysqld.  Then re-run the Slash::Test command above and
>check mysql.log to make sure it has lines that look vaguely like
>this:
>
>   196966 Query       SELECT * FROM users,users_comments,users_hits,users_index,users_info,users_prefs WHERE (users.uid='2' AND users_comments.uid='2' AND users_index.uid='2' AND users_info.uid='2' AND users_prefs.uid='2' AND users_hits.uid='2')
>   196966 Query       SELECT  name, value    FROM users_param   WHERE uid = '2'
>   196966 Query       SELECT  acl FROM users_acl WHERE uid = '2'
>
>If that looks right, you have to start trying to find where that
>data comes from that breaks thaw().  Open up MySQL.pm and start
>editing _getUser_do_selects().  Right before the "if
>($answer->{people})" line, insert a
>
>    print Dumper($answer);
>
>so you can see the raw data... then re-run the Slash::Test and
>see what that outputs.
>  
>