Slash

On Oct 20, 2005, at 11:26 AM, David Pool wrote:



> I seem to recall there being the idea that Slashcode would pause long
> enough to call something a stable version once CSS was implemented.  
> Now
> that CSS has been done, any chance that we'll see a new stable release
> published?
>
> Thanks!
>
> David
>
>

Where'd you read *that*?

My (mis-?)understanding was that the moderation system overhaul is up  
next, and after it happens there could possibly be time for a release.

We haven't really thought about a release candidate for 2.5.  The
mod system overhaul will modularize the code somewhat, and it's
always nice to put a marker down after modularization instead of
before I suppose.
--=20
  Jamie McCarthy
 http://mccarthy.vg/
  jamie@...

Wow, you're going to call it 2.5? Isn't it really different enough to call
it 3.0? :-) 

-----Original Message-----
From: slashcode-general-admin@...
[mailto:slashcode-general-admin@...] On Behalf Of Jamie
McCarthy
Sent: Thursday, October 20, 2005 7:20 PM
To: Slashcode List
Subject: Re: [Slashcode-general] Stable release

We haven't really thought about a release candidate for 2.5.  The mod system
overhaul will modularize the code somewhat, and it's always nice to put a
marker down after modularization instead of before I suppose.
--
  Jamie McCarthy
 http://mccarthy.vg/
  jamie@...


-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________
Slashcode-general mailing list
Slashcode-general@...
https://lists.sourceforge.net/lists/listinfo/slashcode-general

I'm trying to install a new slashsite on a new RHEL server. New Apache,
MySQL, everything starting from scratch. So, starting from scratch,
everything seems to have gone well, up to installing the new site.
I didn't try a t_tags, just
cvs -z3 -d:pserver:anonymous@... co slash

Here's what happened, I'm not sure, is that error from the Time::ParseDate
module?

## ./install-slashsite -u slash
Argument "4'\nissymlink='/usr/bin/test -h'\nivdformat='"ld"'\nivsi..."
isn't numeric in integer multiplication (*) at
/usr/lib/perl5/5.8.0/Time/Local.pm line 26, <DATA> line 125.

[install options]

panic: end_shift at ./install-slashsite line 602, <GEN412> line 37.


plugins chosen:
1,4,7,9,11,13,14,15,17,18,19,20,21,22,26,27,28,29,30,32,33,34,36

On Oct 27, 2005, at 2:32 PM, Blake Carver wrote:

> I'm trying to install a new slashsite on a new RHEL server. New  
> Apache,
> MySQL, everything starting from scratch. So, starting from scratch,
> everything seems to have gone well, up to installing the new site.
> I didn't try a t_tags, just
> cvs -z3 -d:pserver:anonymous@...  
> co slash
>
> Here's what happened, I'm not sure, is that error from the  
> Time::ParseDate
> module?
>
> ## ./install-slashsite -u slash
> Argument "4'\nissymlink='/usr/bin/test -h'\nivdformat='"ld"'\nivsi..."
> isn't numeric in integer multiplication (*) at
> /usr/lib/perl5/5.8.0/Time/Local.pm line 26, <DATA> line 125.
>
> [install options]
>
> panic: end_shift at ./install-slashsite line 602, <GEN412> line 37.
>
>
> plugins chosen:
> 1,4,7,9,11,13,14,15,17,18,19,20,21,22,26,27,28,29,30,32,33,34,36

I have an up-to-date-as-of-16:47today cvs install on my laptop and I  
just wacked /usr/local/slash, cvs update'd, make install'd and  
install-slashsite'd a new site w/o any problems. So I don't think the  
problem's with Slash itself.

You didn't say exactly what versions of each LAMP you were running,  
nor how you build apache/mod_perl etc.

  Shane

> I have an up-to-date-as-of-16:47today cvs install on my laptop and I
> just wacked /usr/local/slash, cvs update'd, make install'd and
> install-slashsite'd a new site w/o any problems. So I don't think the
> problem's with Slash itself.
> You didn't say exactly what versions of each LAMP you were running,
> nor how you build apache/mod_perl etc.
>   Shane

Drat, forgot all my details. I built apache and mod_perl from sources
according to the INSTALL file. Perl came installed on the RHEL box
already. It's the perl-5.8.0-89.10 RPM. MySQL was an RPM as well,
mysql-3.23.58-15.RHEL3.1

I tried rolling back to a recent t_tag or two, the same errors kept up,
along with a bunch of sql errors from the defaults.sql

DBD::mysql::db do failed: You have an error in your SQL syntax near '; '
at line 1 at ./install-slashsite line 395.
 Failed on 'INSERT INTO vars (name, value, description) VALUES
('login_speed_limit', '20', 'How fast a user can create users, etc.'); '
 DBD::mysql::db do failed: You have an error in your SQL syntax near '; '
at line 1 at ./install-slashsite line 395.
 Failed on 'INSERT INTO vars (name, value, description) VALUES
('max_login_allowed', '10', 'How many forms a user can submit'); '

On Oct 27, 2005, at 5:03 PM, Blake Carver wrote:


>> I have an up-to-date-as-of-16:47today cvs install on my laptop and I
>> just wacked /usr/local/slash, cvs update'd, make install'd and
>> install-slashsite'd a new site w/o any problems. So I don't think the
>> problem's with Slash itself.
>> You didn't say exactly what versions of each LAMP you were running,
>> nor how you build apache/mod_perl etc.
>>   Shane
>>
>>
>
> Drat, forgot all my details. I built apache and mod_perl from sources
> according to the INSTALL file. Perl came installed on the RHEL box
> already. It's the perl-5.8.0-89.10 RPM. MySQL was an RPM as well,
> mysql-3.23.58-15.RHEL3.1
>

there's one problem. You should be running mysql v4.1x



> I tried rolling back to a recent t_tag or two, the same errors kept  
> up,
> along with a bunch of sql errors from the defaults.sql
>
> DBD::mysql::db do failed: You have an error in your SQL syntax near  
> '; '
> at line 1 at ./install-slashsite line 395.
>  Failed on 'INSERT INTO vars (name, value, description) VALUES
> ('login_speed_limit', '20', 'How fast a user can create users,  
> etc.'); '
>  DBD::mysql::db do failed: You have an error in your SQL syntax  
> near '; '
> at line 1 at ./install-slashsite line 395.
>  Failed on 'INSERT INTO vars (name, value, description) VALUES
> ('max_login_allowed', '10', 'How many forms a user can submit'); '
>

I think the mysql 3.x is your problem. Atleast, the start of it.

  Shane

>> Drat, forgot all my details. I built apache and mod_perl from sources
>> according to the INSTALL file. Perl came installed on the RHEL box
>> already. It's the perl-5.8.0-89.10 RPM. MySQL was an RPM as well,
>> mysql-3.23.58-15.RHEL3.1
>>
>
> there's one problem. You should be running mysql v4.1x


Holy crap, I can't believe I missed that. It never even occured to me that
mysql wouldn't be 4 on this machine. That's odd. Thanks for catching that
Shane.

That took care of my strange errors, now I seem to have messed up
DBD::mysql::db

"DBD::mysql::db do failed: Invalid default value for 'tid' at
./install-slashsite line 395."

I installed and reinstalled mysql, using rpms, which was my problem before
that shane caught.

MySQL-client-standard-4.1.15-0.rhel3
MySQL-shared-standard-4.1.15-0.rhel3
perl-DBD-MySQL-2.1021-3
MySQL-python-0.9.1-6
MySQL-server-standard-4.1.15-0.rhel3
libdbi-dbd-mysql-0.6.5-5
MySQL-devel-4.1.15-0.glibc23


/DBIx/Password.pm seems to be ok
I can connect to MySQL as the user/password listed in there.

Here's the error I get after running install-slashcode:
But the odd thing that's confusing me is, I "show tables" in the slash db
in mysql, and it shows
abusers....templates 53 rows in set (0.00 sec)
So it's like it makes 53 tables, gets to topics, and fails.


DBD::mysql::db do failed: Invalid default value for 'tid' at
./install-slashsite line 395.
The CREATE TABLE command below failed.  This almost certainly means
the rest of the slashsite installation will fail, so we're aborting.
This is probably because your SQL user associated with your
DBIx::Password user 'slash' lacks CREATE and/or DROP permissions.
Fix this, or whatever the problem is, and rerun install-slashsite.
Failed command: CREATE TABLE topics (   tid smallint UNSIGNED NOT NULL
DEFAULT 0 auto_increment,        parent_topic smallint UNSIGNED DEFAULT 0
NOT NULL,      name char(20) NOT NULL,        alttext char(40),      
default_image mediumint UNSIGNED DEFAULT 0 NOT NULL,    series tinyint
DEFAULT 0 NOT NULL,      PRIMARY KEY (tid)) TYPE=InnoDB

So I got all this fixed. There was an error in the SQL, and I was missing
a few perl modules, but it looks like my new site is on it's way.

Thanks for the help everyone.

-Blake

> I installed and reinstalled mysql, using rpms, which was my problem before
> that shane caught.
>
> MySQL-client-standard-4.1.15-0.rhel3
> MySQL-shared-standard-4.1.15-0.rhel3
> perl-DBD-MySQL-2.1021-3
> MySQL-python-0.9.1-6
> MySQL-server-standard-4.1.15-0.rhel3
> libdbi-dbd-mysql-0.6.5-5
> MySQL-devel-4.1.15-0.glibc23
>
>
> /DBIx/Password.pm seems to be ok
> I can connect to MySQL as the user/password listed in there.
>
> Here's the error I get after running install-slashcode:
> But the odd thing that's confusing me is, I "show tables" in the slash db
> in mysql, and it shows
> abusers....templates 53 rows in set (0.00 sec)
> So it's like it makes 53 tables, gets to topics, and fails.
>
>
> DBD::mysql::db do failed: Invalid default value for 'tid' at
> ./install-slashsite line 395.
> The CREATE TABLE command below failed.  This almost certainly means
> the rest of the slashsite installation will fail, so we're aborting.
> This is probably because your SQL user associated with your
> DBIx::Password user 'slash' lacks CREATE and/or DROP permissions.
> Fix this, or whatever the problem is, and rerun install-slashsite.
> Failed command: CREATE TABLE topics (   tid smallint UNSIGNED NOT NULL
> DEFAULT 0 auto_increment,        parent_topic smallint UNSIGNED DEFAULT 0
> NOT NULL,      name char(20) NOT NULL,        alttext char(40),
> default_image mediumint UNSIGNED DEFAULT 0 NOT NULL,    series tinyint
> DEFAULT 0 NOT NULL,      PRIMARY KEY (tid)) TYPE=InnoDB
>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by the JBoss Inc.
> Get Certified Today * Register for a JBoss Training Course
> Free Certification Exam for All Training Attendees Through End of 2005
> Visit http://www.jboss.com/services/certification for more information
> _______________________________________________
> Slashcode-general mailing list
> Slashcode-general@...
> https://lists.sourceforge.net/lists/listinfo/slashcode-general
>
>


-- 


-Blake Carver
LISNews.com

So I've got the latest CVS version of the code running on a new server
now. I also have my old site running on an old server (a t_tags about 2
years old). I've been going over Shane's upgrading docs, and it seems like
it's quite a job.

Is the slashcode/slash/sql/mysql/upgrades file current? It's over a year
old now, is there something newer I should use? What about upgrades.mine?

All I'm looking to do is take my topics/sections/stories/users/comments
from the old server and drop them into new server. I'm not concerned with
any of the themes or anything.

Any other advice anyone has would be appreciated.

Thanks
-Blake

On Oct 28, 2005, at 7:56 AM, Blake Carver wrote:

> So I've got the latest CVS version of the code running on a new server
> now. I also have my old site running on an old server (a t_tags  
> about 2
> years old). I've been going over Shane's upgrading docs, and it  
> seems like
> it's quite a job.
>
> Is the slashcode/slash/sql/mysql/upgrades file current? It's over a  
> year
> old now, is there something newer I should use? What about  
> upgrades.mine?

it's always current. use it. there is nothing else.

>
> All I'm looking to do is take my topics/sections/stories/users/ 
> comments
> from the old server and drop them into new server. I'm not  
> concerned with
> any of the themes or anything.
>
> Any other advice anyone has would be appreciated.

Like I told you on IRC, I think you are going about this *backward*  
and you're making more work for yourself.

Install 2.2.6 (or the same version that you have on your production  
server) on the new box.
Tarball the production slash setup all up. Untar it on the new.

Then follow all the upgrade documentation.

When you're done, minimally, you should be at section-topics level.  
You can continue from there, and you'd be running the slashcss. I'd  
recommend you go full bore and get up to date, since you're knee deep  
in it all anyway.

Just my $.02.
  Shane

I realaly don't know where to start on this one. I thought I had this
error fixed last night when I fixed MySQL, but today it's suddenly
returned. The only thing I've done was removed /usr/local/slash and did a
new cvs update. So last night I did see this error, but after starting
over with the slashcode today it's back. I didn't mess around with perl or
anything else.

I did the check out like this
cvs -d:pserver:anonymous@... co slash

# /usr/local/slash/bin/install-slashsite -u slash

ERROR: Argument "4'\nissymlink='/usr/bin/test
-h'\nivdformat='"ld"'\nivsi..." isn't numeric in integer multiplication
(*) at /usr/lib/perl5/5.8.0/Time/Local.pm line 34, <DATA> line 125.


It doesn't seem like that module (Time::Local) is messed up, I can get a
data out of it if I try:

perl -MTime::Local -e "print timelocal(0,0,0,15,6,2005),$/"

MySQL is the latest RPM available for RHEL,
MySQL-server-standard-4.1.15-0.rhel3. Same thing with Perl,
perl-5.8.0-89.10, but I did install Apache and mod_perl from source last
night from the latest available sources.

Thanks
Blake

lists@... (Blake Carver) writes:

> So I got all this fixed. There was an error in the SQL

Doh, I even made a note of that months ago:

# (And note that MySQL 4.0 allows an AUTO_INCREMENT column to be declared
# with a DEFAULT, but MySQL 4.1 throws an error on that formulation.)

but neglected to actually do anything about it.

I'll fix that now...
--=20
  Jamie McCarthy
 http://mccarthy.vg/
  jamie@...

lists@... (Blake Carver) writes:

> I realaly don't know where to start on this one. I thought I had this
> error fixed last night when I fixed MySQL, but today it's suddenly
> returned.

> # /usr/local/slash/bin/install-slashsite -u slash
>=20
> ERROR: Argument "4'\nissymlink=3D'/usr/bin/test
> -h'\nivdformat=3D'"ld"'\nivsi..." isn't numeric in integer multiplication
> (*) at /usr/lib/perl5/5.8.0/Time/Local.pm line 34, <DATA> line 125.

Your perl installation is hosed.

Possibly /usr/local/slash/bin/install-slashsite is using a different
perl in its #! line than you use by default (or last night)?  Check
for #!/usr/bin/perl vs. #!/usr/local/bin/perl, compare to `which perl`,
etc.

Read line 34 in the file identified above.  Time::Local is crashing
because it sees a massively broken %Config.  The likelihood that very
many perl modules are going to work is quite small.
--=20
  Jamie McCarthy
 http://mccarthy.vg/
  jamie@...