From: Eric D. <eri...@ja...> - 2004-12-19 21:57:16
|
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? 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 All the sites are on the same machine, but one is generating this error and won't display anything other than an error page. Ideas? |
From: Shane <sh...@lo...> - 2004-12-20 13:01:26
|
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... |
From: Eric D. <eri...@ja...> - 2004-12-21 20:08:01
|
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. > > |
From: Eric D. <eri...@ja...> - 2004-12-21 20:32:56
|
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....... > |
From: Shane <sh...@lo...> - 2004-12-21 21:51:46
|
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 > Sla...@li... > https://lists.sourceforge.net/lists/listinfo/slashcode-general > |
From: Eric D. <eri...@ja...> - 2004-12-22 04:14:47
|
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. > |
From: Eric D. <eri...@ja...> - 2004-12-22 17:26:15
|
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 >> >> |
From: Jamie M. <ja...@mc...> - 2004-12-23 04:00:43
|
eri...@ja... (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/ ja...@mc... |
From: Eric D. <eri...@ja...> - 2004-12-23 04:58:43
|
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. > > |
From: Jamie M. <ja...@mc...> - 2004-12-22 14:17:03
|
sh...@lo... (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/ ja...@mc... |
From: Shane <sh...@lo...> - 2004-12-22 14:54:22
|
On Dec 22, 2004, at 9:16 AM, Jamie McCarthy wrote: > sh...@lo... (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 |
From: Eric D. <eri...@ja...> - 2004-12-22 17:23:56
|
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))' > > |