slashcode-general — This is the general discussion list. Install questions welcome.

Re: [Slashcode-general] Yet another question, SQL error

[Chris N. <pu...@po...>]

At 19:19 -0800 2001.11.05, Derek J. Balling wrote:
>>I am not sure what should be in CHANGES or INSTALL ... it should not be an
>>issue in upgrading.  It was not for me.  What exactly did you upgrade
>>from/to?
>
>2.1.0 -> 2.1.1

Unfortunately, we have no specific upgrade procedure between various beta
versions.  If people could send me any problems they have, like this one, I
can list them in INSTALL and CHANGEs.

Thanks,

-- 
Chris Nandor                      pu...@po...    http://pudge.net/
Open Source Development Network    pu...@os...     http://osdn.com/

[Slashcode-general] slash 2.2.0

[Chris N. <pu...@po...>]

Hi everybody.  This here is a last call for slash 2.2.0.  If you want
something fixed for slash 2.2.0, now is the last chance to file a bug
report.  This is only for important bugs, or installation/upgrading bugs.
Please as usual file it on SourceForge, and then let me know via email so I
don't miss it.  :-)

-- 
Chris Nandor                      pu...@po...    http://pudge.net/
Open Source Development Network    pu...@os...     http://osdn.com/

Re: [Slashcode-general] Yet another question, SQL error

[Derek J. B. <dr...@me...>]

At 11:42 AM -0800 11/4/01, Brian Aker wrote:
>On Sun, 2001-11-04 at 11:12, Derek J. Balling wrote:
>>  Anyone know anything about this, which is flowing through my error logs?
>ALTER TABLE accesslog add section varchar(30) DEFAULT 'index' NOT NULL;
>
>You will need to do this to any site that is upgrading from alpha/beta
>versions of 2.2.

Cool! Thanks!

FWIW, this probably ought to be in either CHANGES or INSTALL. :-/

D

-- 
+---------------------+-----------------------------------------+
| dr...@me...  | "Thou art the ruins of the noblest man  |
|  Derek J. Balling   |  That ever lived in the tide of times.  |
|                     |  Woe to the hand that shed this costly  |
|                     |  blood" - Julius Caesar Act 3, Scene 1  |
+---------------------+-----------------------------------------+

Re: [Slashcode-general] Yet another question, SQL error

[Brian A. <br...@ta...>]

On Sun, 2001-11-04 at 11:12, Derek J. Balling wrote:
> Anyone know anything about this, which is flowing through my error logs?
ALTER TABLE accesslog add section varchar(30) DEFAULT 'index' NOT NULL;

You will need to do this to any site that is upgrading from alpha/beta
versions of 2.2.
	-Brian

-- 
_______________________________________________________
Brian Aker, br...@ta... 
Slashdot Senior Developer
Seattle, Washington
http://tangent.org/~brian/
Email/Jabber br...@ta...
_______________________________________________________
You can't grep a dead tree.

[Slashcode-general] Yet another question, SQL error

[Derek J. B. <dr...@me...>]

Anyone know anything about this, which is flowing through my error logs?

DBD::mysql::db do failed: Unknown column 'section' in 'field list' at 
/usr/local/lib/perl5/site_perl/5.6.1/i686-linux/Slash/DB/Utility.pm 
line 531.

[Sun Nov  4 19:11:26 2001] [error] 
:Slash::DB::Utility:/usr/local/lib/perl5/site_perl/5.6.1/i686-linux/Slash/DB/Utility.pm:521:INSERT 
/*! DELAYED */ INTO accesslog 
(section,op,ts,dat,subnetid,query_string,user_agent,host_addr,uid) 
VALUES(
   'index',
   'about',
   now(),
   NULL,
   '065c95008f7a5e70e32658f5aaf1fafa',
   '0',
   '0',
   'fa75c82ac8e8fa7888c8e431a166cc00',
   '1')


-- 
+---------------------+-----------------------------------------+
| dr...@me...  | "Thou art the ruins of the noblest man  |
|  Derek J. Balling   |  That ever lived in the tide of times.  |
|                     |  Woe to the hand that shed this costly  |
|                     |  blood" - Julius Caesar Act 3, Scene 1  |
+---------------------+-----------------------------------------+

Re: [Slashcode-general] AC front-page question

[Derek J. B. <dr...@me...>]

In mine it's in site/SITENAME/tasks, and appears to get run by slashd 
every 3 minutes.

d


>Speaking of freshenup.pl, I don't have such a file on my system at 
>all, seemingly even in the originally unpacked tar balls. Where and 
>what should it be?
>
>Barry
>
>At 09:31 AM 11/4/2001 -0800, Derek J. Balling wrote:
>>OK, so I've enabled Slash::Apache::IndexHandler to allow 
>>index.shtml to be created by freshenup.pl, except that - even after 
>>a restart of apache and of slashd, it is still grabbing its block 
>>contents from somewhere "stale", which still contain the "default" 
>>values for things like features and quicklinks.
>>
>>Anyone have any idea what I'm doing wrong, and how to fix it? I 
>>spent so much time logged in that I didn't even think to check that 
>>before I went live, and now the front page looks kinda dorky. :-)

-- 
+---------------------+-----------------------------------------+
| dr...@me...  | "Thou art the ruins of the noblest man  |
|  Derek J. Balling   |  That ever lived in the tide of times.  |
|                     |  Woe to the hand that shed this costly  |
|                     |  blood" - Julius Caesar Act 3, Scene 1  |
+---------------------+-----------------------------------------+

Re: [Slashcode-general] AC front-page question

[barry <sla...@i1...>]

Speaking of freshenup.pl, I don't have such a file on my system at all, 
seemingly even in the originally unpacked tar balls. Where and what should 
it be?

Barry

At 09:31 AM 11/4/2001 -0800, Derek J. Balling wrote:
>OK, so I've enabled Slash::Apache::IndexHandler to allow index.shtml to be 
>created by freshenup.pl, except that - even after a restart of apache and 
>of slashd, it is still grabbing its block contents from somewhere "stale", 
>which still contain the "default" values for things like features and 
>quicklinks.
>
>Anyone have any idea what I'm doing wrong, and how to fix it? I spent so 
>much time logged in that I didn't even think to check that before I went 
>live, and now the front page looks kinda dorky. :-)
>
>d
>
>--
>+---------------------+-----------------------------------------+
>| dr...@me...  | "Thou art the ruins of the noblest man  |
>|  Derek J. Balling   |  That ever lived in the tide of times.  |
>|                     |  Woe to the hand that shed this costly  |
>|                     |  blood" - Julius Caesar Act 3, Scene 1  |
>+---------------------+-----------------------------------------+
>
>_______________________________________________
>Slashcode-general mailing list
>Sla...@li...
>https://lists.sourceforge.net/lists/listinfo/slashcode-general

[Slashcode-general] AC front-page question

[Derek J. B. <dr...@me...>]

OK, so I've enabled Slash::Apache::IndexHandler to allow index.shtml 
to be created by freshenup.pl, except that - even after a restart of 
apache and of slashd, it is still grabbing its block contents from 
somewhere "stale", which still contain the "default" values for 
things like features and quicklinks.

Anyone have any idea what I'm doing wrong, and how to fix it? I spent 
so much time logged in that I didn't even think to check that before 
I went live, and now the front page looks kinda dorky. :-)

d

-- 
+---------------------+-----------------------------------------+
| dr...@me...  | "Thou art the ruins of the noblest man  |
|  Derek J. Balling   |  That ever lived in the tide of times.  |
|                     |  Woe to the hand that shed this costly  |
|                     |  blood" - Julius Caesar Act 3, Scene 1  |
+---------------------+-----------------------------------------+

Re: [Slashcode-general] where is html for "older stuff" boxes generated?

[barry <sla...@i1...>]

At 10:47 AM 11/4/2001 -0500, Jamie McCarthy wrote:

ahh yeah grep -- must've fallen asleep at the switch. grep and I are good 
friends as my bash history file  will prove :)

Anyway, what I did was reinstate the line I had removed, now in my link 
that I want to generate just a search form, I use the url:

http://site/search.pl?op=onlyForm

which seems to do the trick. the risk of course is that some later version 
will have an op with that name, but the benefit is I get what I want and I 
didn't change the code, which as we just saw, can have unintended side. 
effects.

Barry

>sla...@i1... (barry) writes:
>
> > Oh you know what - I took that line out a couple of days ago
> > because i wanted http://[site]/search.pl to end up with an
> > empty list so it is just a plain old search form. I guess
> > this is an unintended side effect. Is there another way to
> > do that?
>
>Well, you might try only zeroing out $form->{op} if no
>$form->{start} value is specified, or maybe if there are no
>$form keys at all.  That would make it only go blank if
>search.pl really was called by itself, no parameters.
>
>As you mentioned, the getOlderStories template could use an
>"op=stories" parameter added to that URL.  That won't hurt
>anything, it'll just make it work with your version of
>search.pl.
>
>You'll want to look through other templates for search.pl URLs
>as well.  Whenever you make a change, grep is your friend :)
>--
>  Jamie McCarthy
>  ja...@mc...
>
>_______________________________________________
>Slashcode-general mailing list
>Sla...@li...
>https://lists.sourceforge.net/lists/listinfo/slashcode-general

Re: [Slashcode-general] where is html for "older stuff" boxes generated?

[Jamie M. <ja...@mc...>]

sla...@i1... (barry) writes:

> Oh you know what - I took that line out a couple of days ago
> because i wanted http://[site]/search.pl to end up with an
> empty list so it is just a plain old search form. I guess
> this is an unintended side effect. Is there another way to
> do that?

Well, you might try only zeroing out $form->{op} if no
$form->{start} value is specified, or maybe if there are no
$form keys at all.  That would make it only go blank if
search.pl really was called by itself, no parameters.

As you mentioned, the getOlderStories template could use an
"op=stories" parameter added to that URL.  That won't hurt
anything, it'll just make it work with your version of
search.pl.

You'll want to look through other templates for search.pl URLs
as well.  Whenever you make a change, grep is your friend :)
--
 Jamie McCarthy
 ja...@mc...

Re: [Slashcode-general] where is html for "older stuff" boxes generated?

[barry <sla...@i1...>]

At 03:58 PM 11/3/2001 -0500, Jamie McCarthy wrote:

Oh you know what - I took that line out a couple of days ago because i 
wanted http://[site]/search.pl to end up with an empty list so it is just a 
plain old search form. I guess this is an unintended side effect. Is there 
another way to do that?

Thanks,

Barry

>Sounds like a bug in search.pl.  The latest in CVS has this line
>in main():
>
>     $form->{op} ||= 'stories';
>
>Is that present in whatever version you're using?
>--
>  Jamie McCarthy
>  ja...@mc...
>
>_______________________________________________
>Slashcode-general mailing list
>Sla...@li...
>https://lists.sourceforge.net/lists/listinfo/slashcode-general

Re: [Slashcode-general] where is html for "older stuff" boxes generated?

[Jamie M. <ja...@mc...>]

sla...@i1... (barry) writes:

> http://[site]/search.pl?section=&start=10, which gives me no
> results in the list under the search form.
> 
> However, if I try the url:
> http://[site]/search.pl?op=stories&section=&start=10, I get
> proper results.

Sounds like a bug in search.pl.  The latest in CVS has this line
in main():

    $form->{op} ||= 'stories';

Is that present in whatever version you're using?
--
 Jamie McCarthy
 ja...@mc...

Re: [Slashcode-general] couple more poll questions...

[Rob \CmdrTaco\ M. <ma...@sl...>]

On Saturday 03 November 2001 02:59 pm, Brian Aker wrote:
> On Sat, 2001-11-03 at 11:38, barry wrote:
> > 1) is it possible to have a section-specific poll?
>
> Somewhat. You can have poll appear in a section by editting
> the qid field in sections (I only know how to do this in
> the DB, but I would think there is admin interface somewhere
> that does this).

It used to be in the section editor.  A drop down list of poll titles.  Not 
sure if it got lost over the years since we never used it (and frankly 
administering a list of that length is awkward at best)

Re: [Slashcode-general] where is html for "older stuff" boxes generated?

[barry <sla...@i1...>]

I noticed the line in getOlderStories template:

<BR><A HREF="[% constants.rootdir %]/search.pl?section=[% section.section 
%]&start=[% start %]">

doesn't really work. In my case, it generates the url: 
http://[site]/search.pl?section=&start=10, which gives me no results inthe 
list under the search form.

However, if I try the url: 
http://[site]/search.pl?op=stories&section=&start=10, I get proper results.

Am I misunderstanding something, or is this a bug in the template that I 
need to correct?

Thanks!

Barry

At 03:32 PM 11/3/2001 -0500, you wrote:
>"Older Stories" is also known as the "index_more" block.  The *_more
>blocks are displayed in index.pl by calling portalbox() which is a
>function in Slash::Utility::Display.  That specific block has its
>contents generated on the fly by getOlderStories() which is in
>Slash.pm.
>--
>  Jamie McCarthy
>  ja...@mc...
>
>_______________________________________________
>Slashcode-general mailing list
>Sla...@li...
>https://lists.sourceforge.net/lists/listinfo/slashcode-general

Re: [Slashcode-general] where is html for "older stuff" boxes generated?

[Jamie M. <ja...@mc...>]

"Older Stories" is also known as the "index_more" block.  The *_more
blocks are displayed in index.pl by calling portalbox() which is a
function in Slash::Utility::Display.  That specific block has its
contents generated on the fly by getOlderStories() which is in
Slash.pm.
--
 Jamie McCarthy
 ja...@mc...

[Slashcode-general] where is html for "older stuff" boxes generated?

[barry <sla...@i1...>]

thanks!

Barry

Re: [Slashcode-general] couple more poll questions...

[Brian A. <br...@ta...>]

On Sat, 2001-11-03 at 11:38, barry wrote:
> 1) is it possible to have a section-specific poll?
Somewhat. You can have poll appear in a section by editting
the qid field in sections (I only know how to do this in 
the DB, but I would think there is admin interface somewhere
that does this).

There is more support for this that I started, but its not
finished yet.

> 2) I see that if the poll's qid matches a story id,then the poll will 
> appear with the story. Is there a place where I can cut and past the story 
> is easily to insert in this field?
Which version?

There is a sid reference in pollquestions that is used to match a poll
to a story. There should have been a story->poll relationship
in the schema to make this easier (aka a story can own a poll).

	-Brian

-- 
_______________________________________________________
Brian Aker, br...@ta... 
Slashdot Senior Developer
Seattle, Washington
http://tangent.org/~brian/
Email/Jabber br...@ta...
_______________________________________________________
You can't grep a dead tree.

[Slashcode-general] couple more poll questions...

[barry <sla...@i1...>]

1) is it possible to have a section-specific poll?

2) I see that if the poll's qid matches a story id,then the poll will 
appear with the story. Is there a place where I can cut and past the story 
is easily to insert in this field?

thanks!

Barry

[Slashcode-general] is there a way to delete polls

[barry <sla...@i1...>]

... short of manually editing the db? for now, I am just deleting the 
questions and ansswers in the poll editor, but that doesn't really remove 
any counts.

thanks!

Barry

[Slashcode-general] sec level for editors?

[barry <sla...@i1...>]

What is the right sec level to assign to a person I want to be able to 
manage submissions (edit, post, etc) but nothing else?

thanks!

Barry

Re: [Slashcode-general] mod_gzip

[Micah Y. <yo...@ho...>]

RE: HOWTO in previous message

Someone might want to stick that in the FAQ.  It's fairly easy and definitely 
worth doing, but doesn't seem to be concisely documented anywhere outside of 
my notes. :-)

-- 
Like to travel?                        http://TravTalk.org
Micah Yoder Internet Development       http://yoderdev.com

[Slashcode-general] mod_gzip

[Micah Y. <yo...@ho...>]

should have followed up to the list.  He got it working.  Relevant details:

> What is the best way to compile mod_gzip into apache?

this should do it (adapted from my notes):

copy mod_gzip.c into Apache/src/modules/extra/

Apache directory:

./configure

mod_perl Directory:

perl Makefile.PL APACHE_SRC=/home/micah/source/apache_1.3.20 DO_HTTPD=1 
USE_APACI=1 PERL_MARK_WHERE=1 EVERYTHING=1
make
make install

Apache directory:

./configure --prefix=/usr/local/apache 
--activate-module=src/modules/perl/libperl.a 
--activate-module=src/modules/extra/mod_gzip.o
make
make install




in the main httpd.conf file include all this:
=====
# Mod_gzip
mod_gzip_on Yes
mod_gzip_minimum_file_size 300
mod_gzip_maximum_file_size 0
mod_gzip_maximum_inmem_size 100000
mod_gzip_item_include file \.htm$
mod_gzip_item_include file \.html$
mod_gzip_item_include file \.php$
mod_gzip_item_include file \.pl$
mod_gzip_item_include mime ^text/.*
mod_gzip_item_include mime ^application/x-httpd-php
mod_gzip_item_include mime ^httpd/unix-directory$
mod_gzip_item_include handler ^perl-script$
mod_gzip_item_include handler ^server-status$
mod_gzip_item_exclude mime ^image/.*
mod_gzip_item_exclude file \.rdf$
mod_gzip_dechunk yes
mod_gzip_temp_dir /tmp
mod_gzip_keep_workfiles No
===============

and in EACH Slash <VirtualHost> include this:
==============
    mod_gzip_item_exclude reqheader Content-Type:multipart/form-data
    mod_gzip_item_exclude reqheader 
Content-Type:application/x-www-form-urlencoded
==============

The last one is all in one line.  It's necessary because there's a bug in 
POST operations under gzip and mod_perl, so they need to be disabled.

-- 
Like to travel?                        http://TravTalk.org
Micah Yoder Internet Development       http://yoderdev.com

[Slashcode-general] oracle support?

[Terry D. <td...@bi...>]

I have seen remnants of rumors about oracle support.  What is the 
reality of this?  Anyone successfully using oracle for slashcode?  Any 
tips or recommendations if I take this step?

-- 
Terry Davis
Systems Administrator
BirdDog Solutions, Inc.
(402) 829-6059
www.birddog.com

Re: [Slashcode-general] mod_gzip (Micah?)

[Jason H. <ja...@ne...>]

Yoderdev.com (Micah Yoder) uses it on his hosted sites.  He also reads
this list regularly.

-jh

--
Jason Huckaby

NErock.com Webmaster
Portland, ME
(207) 415-3142

Re: [Slashcode-general] mod_gzip

[Don S. <do...@se...>]

Yes that is where I heard of it.  The article didn't mention any
instructions or howto though.  I'm referring to the article posted on
10/24.

If there is another one, the search doesn't seem to help.  It doesn't even
find the article from 10/24.  :p

Don.

On Fri, 2 Nov 2001, shane wrote:

> At 10:46 AM 11/2/2001 -0600, Don Seiler wrote:
> >I've only recently heard of the benefits of using mod_gzip with slash.
> >[...]
> >  I'd like to know.
>
> there was an article on slashcode.com about it.
>
>
>
> _______________________________________________
> Slashcode-general mailing list
> Sla...@li...
> https://lists.sourceforge.net/lists/listinfo/slashcode-general
>