[Slashcode-development] newbie question -Slash installation throws error about sections table missing, schema.sql has no reference to sections table

[Imtiaz Khan <khanimtiaz@gm...>]

OK I tried to install slashcode with all modules selected (this is at the
install-slashsite stage) and got an error:

Error:Slash::Install:/usr/local/lib/perl5/site_perl/5.8.8/i686-linux/Slash/Install.pm:368:virtuser='virtslash'
-- hostinfo='Localhost via UNIX socket' -- Table 'slashdb.sections' doesn't
exist -- INSERT into sections (section, artcount, title) VALUES ('newsvac',
0, 'NewsVac Links')
Which was called
by:Slash::Install:/usr/local/lib/perl5/site_perl/5.8.8/i686-linux/Slash/Install.pm:167
=== (NewsVac) Failed on :INSERT into sections (section, artcount, title)
VALUES ('newsvac', 0, 'NewsVac Links'):



The site is working but maybe sections isn't.

I checked /usr/local/slash/sql/mysql/schema.sql and there's no table named
sections being created there. This is the CVS checkout from about four days
back. Could this be a broken source problem?

-Imtiaz

[Slashcode-development] newbie question -Slash installation throws error about sections table missing, schema.sql has no reference to sections table

[Imtiaz Khan <khanimtiaz@gm...>]

OK I tried to install slashcode with all modules selected (this is at the
install-slashsite stage) and got an error:

Error:Slash::Install:/usr/local/lib/perl5/site_perl/5.8.8/i686-linux/Slash/Install.pm:368:virtuser='virtslash'
-- hostinfo='Localhost via UNIX socket' -- Table 'slashdb.sections' doesn't
exist -- INSERT into sections (section, artcount, title) VALUES ('newsvac',
0, 'NewsVac Links')
Which was called
by:Slash::Install:/usr/local/lib/perl5/site_perl/5.8.8/i686-linux/Slash/Install.pm:167
=== (NewsVac) Failed on :INSERT into sections (section, artcount, title)
VALUES ('newsvac', 0, 'NewsVac Links'):



The site is working but maybe sections isn't.

I checked /usr/local/slash/sql/mysql/schema.sql and there's no table named
sections being created there. This is the CVS checkout from about four days
back. Could this be a broken source problem?

-Imtiaz

Re: [Slashcode-development] newbie question -Slash installation throws error about sections table missing, schema.sql has no reference to sections table

[Imtiaz Khan <khanimtiaz@gm...>]

must be the CVS checkout as when using slashcode-2.2.6 I was able to install
without any errors and now sections, topics, blocks etc all show up fine.

For the packaging department :) probably need the CVS tree fixed

-Imtiaz

On 9/13/06, Imtiaz Khan <khanimtiaz@...> wrote:
>
> OK I tried to install slashcode with all modules selected (this is at the
> install-slashsite stage) and got an error:
>
> Error:Slash::Install:/usr/local/lib/perl5/site_perl/5.8.8/i686-linux/Slash/Install.pm:368:virtuser='virtslash'
> -- hostinfo='Localhost via UNIX socket' -- Table 'slashdb.sections'
> doesn't exist -- INSERT into sections (section, artcount, title) VALUES
> ('newsvac', 0, 'NewsVac Links')
> Which was called
> by:Slash::Install:/usr/local/lib/perl5/site_perl/5.8.8/i686-linux/Slash/Install.pm:167
>
> === (NewsVac) Failed on :INSERT into sections (section, artcount, title)
> VALUES ('newsvac', 0, 'NewsVac Links'):
>
>
>
> The site is working but maybe sections isn't.
>
> I checked /usr/local/slash/sql/mysql/schema.sql and there's no table named
> sections being created there. This is the CVS checkout from about four days
> back. Could this be a broken source problem?
>
> -Imtiaz
>



-- 
Bye for now
Imtiaz A. Khan
=============
I just need enough to tide me over until I need more.
                -- Bill Hoest
Lack of money is the root of all evil.
                -- George Bernard Shaw

So you think that money is the root of all evil.
Have you ever asked what is the root of money?
                -- Ayn Rand

All I want is a little more than I'll ever get.

Re: [Slashcode-development] newbie question -Slash installation throws error about sections table missing, schema.sql has no reference to sections table

[shane <shane@lo...>]

On Sep 13, 2006, at 4:08 AM, Imtiaz Khan wrote:

> must be the CVS checkout as when using slashcode-2.2.6 I was able  
> to install without any errors and now sections, topics, blocks etc  
> all show up fine.
>
> For the packaging department :) probably need the CVS tree fixed
>
> -Imtiaz
>
> On 9/13/06, Imtiaz Khan <khanimtiaz@...> wrote:
> OK I tried to install slashcode with all modules selected (this is  
> at the install-slashsite stage) and got an error:
>
> Error:Slash::Install:/usr/local/lib/perl5/site_perl/5.8.8/i686- 
> linux/Slash/Install.pm:368:virtuser='virtslash' --  
> hostinfo='Localhost via UNIX socket' -- Table 'slashdb.sections'  
> doesn't exist -- INSERT into sections (section, artcount, title)  
> VALUES ('newsvac', 0, 'NewsVac Links')
> Which was called by:Slash::Install:/usr/local/lib/perl5/site_perl/ 
> 5.8.8/i686-linux/Slash/Install.pm:167
> === (NewsVac) Failed on :INSERT into sections (section, artcount,  
> title) VALUES ('newsvac', 0, 'NewsVac Links'):
>
>
>
> The site is working but maybe sections isn't.
>
> I checked /usr/local/slash/sql/mysql/schema.sql and there's no  
> table named sections being created there. This is the CVS checkout  
> from about four days back. Could this be a broken source problem?
>
> -Imtiaz
>
>

You want to use the last T-tag from CVS. Get a checkout of slash- 
HEAD. Then read the INSTALL. Make sure you understand what it says  
about how slash does versions and re-visioning. Don't use 2.2.6  
version of Slash. (See list-serve archives for prior in-depth  
discussion on why that's a bad thing to start off at, at this day and  
age.)

Then, decide whether you want to run the latest  T-tag, R-tag or  
HEAD. Grab whichever you've chosen from CVS.

Wipe your current install - rm -fR /usr/local/slash
make install the src.
drop and create the mysql database that your virtual user is to use.
run install-slashsite.

install *ONLY* the default plugins.

The install will work, and the site will function, and it will have  
the "latest CSS" that you mentioned in another post.

Now, go read the Nexus/topic information articles on Lottadot. http:// 
slash.lottadot.com/

You'll want create topic nexus's, for each skin (aka section). Think  
of it as 'section == 'a skinned nexus'.

You can either create the skins by hand (by SQL inserts) or you can  
grab the Skin's editor from http://cvs.lottadot.com/ (follow the  
instructions to install it). That'll give you a GUI interface to  
manage your skins.

That's it.

Once you are at the point where the site's setup, the subdomains are  
setup, the Nexus and skins are setup for the subdomains *then* you  
can go and try experimenting with extra plugins. But even then, I'd  
recommend you do that on a development system, especially if the  
plugin is not included w/ the standard distro. And if you find you  
like the plugin, then install it using the install-plugin tool (after  
you've backed up) on your production webserver.

  Shane

Re: [Slashcode-development] newbie question -Slash installation throws error about sections table missing, schema.sql has no reference to sections table

[Imtiaz A khan <khanimtiaz@gm...>]

Hi Shane,
Here's what I did :

   1. checked out the latest R tag from the CVS tree
          * cvs
            -d:pserver:anonymous@...:/cvsroot/slashcode
            login
          * cvs
            -d:pserver:anonymous@...:/cvsroot/slashcode
            co -P -r *R_2_5_0_94* slash
   2. removed older instances of the install by dropping the slashdb
      database and the /usr/local/slash directory as well as removing
      the Include statements from Apache.
   3. did a make followed by make install
   4. did a install-slashsite -u virtuser
   5. added Include to Apache and restarted Apache
   6. started slash

Now the problem I am facing are:

    * I dont have a sections table in slashdb
    * I dont have a sections.pl
    * subsequently if I go to edit a section I get the 404 "/The
      requested URL (sections.pl?op=list) was not found."/

I am assuming that I should be selecting the sections plugin in the list 
of plugins when prompted to do so, but you were categorical about not 
doing so. Please advise if I should answer 'a' when asked the question 
/"Hit 'a' to select all, otherwise select comma separated numbers or 'q' 
to quit" /or 'q' during install-slashsite

Thanks a lot for your help I'm sure it's just a little more effort and 
I'll be able to make subdomains and get to using slashcode to run my 
websites.

Warm Regards
Imtiaz
919821540543


shane wrote:

>
> On Sep 13, 2006, at 4:08 AM, Imtiaz Khan wrote:
>
>> must be the CVS checkout as when using slashcode-2.2.6 I was able to 
>> install without any errors and now sections, topics, blocks etc all 
>> show up fine.
>>
>> For the packaging department :) probably need the CVS tree fixed
>>
>> -Imtiaz
>>
>> On 9/13/06, *Imtiaz Khan* <khanimtiaz@... 
>> <mailto:khanimtiaz@...>> wrote:
>>
>>     OK I tried to install slashcode with all modules selected (this
>>     is at the install-slashsite stage) and got an error:
>>
>>     Error:Slash::Install:/usr/local/lib/perl5/site_perl/5.8.8/i686-linux/Slash/Install.pm:368:virtuser='virtslash'
>>     -- hostinfo='Localhost via UNIX socket' -- Table
>>     'slashdb.sections' doesn't exist -- INSERT into sections
>>     (section, artcount, title) VALUES ('newsvac', 0, 'NewsVac Links')
>>     Which was called
>>     by:Slash::Install:/usr/local/lib/perl5/site_perl/5.8.8/i686-linux/Slash/Install.pm:167
>>
>>     === (NewsVac) Failed on :INSERT into sections (section, artcount,
>>     title) VALUES ('newsvac', 0, 'NewsVac Links'):
>>
>>
>>
>>     The site is working but maybe sections isn't.
>>
>>     I checked /usr/local/slash/sql/mysql/schema.sql and there's no
>>     table named sections being created there. This is the CVS
>>     checkout from about four days back. Could this be a broken source
>>     problem?
>>
>>     -Imtiaz
>>
>>
>>
>
> You want to use the last T-tag from CVS. Get a checkout of slash-HEAD. 
> Then read the INSTALL. Make sure you understand what it says about how 
> slash does versions and re-visioning. Don't use 2.2.6 version of 
> Slash. (See list-serve archives for prior in-depth discussion on why 
> that's a bad thing to start off at, at this day and age.)
>
> Then, decide whether you want to run the latest  T-tag, R-tag or HEAD. 
> Grab whichever you've chosen from CVS.
>
> Wipe your current install - rm -fR /usr/local/slash
> make install the src.
> drop and create the mysql database that your virtual user is to use.
> run install-slashsite.
>
> install *ONLY* the default plugins.
>
> The install will work, and the site will function, and it will have 
> the "latest CSS" that you mentioned in another post.
>
> Now, go read the Nexus/topic information articles on 
> Lottadot. http://slash.lottadot.com/ 
>
> You'll want create topic nexus's, for each skin (aka section). Think 
> of it as 'section == 'a skinned nexus'.
>
> You can either create the skins by hand (by SQL inserts) or you can 
> grab the Skin's editor from http://cvs.lottadot.com/ (follow the 
> instructions to install it). That'll give you a GUI interface to 
> manage your skins.
>
> That's it.  
>
> Once you are at the point where the site's setup, the subdomains are 
> setup, the Nexus and skins are setup for the subdomains *then* you can 
> go and try experimenting with extra plugins. But even then, I'd 
> recommend you do that on a development system, especially if the 
> plugin is not included w/ the standard distro. And if you find you 
> like the plugin, then install it using the install-plugin tool (after 
> you've backed up) on your production webserver.
>
>  Shane
>
>
>
>
>------------------------------------------------------------------------
>
>-------------------------------------------------------------------------
>Using Tomcat but need to do more? Need to support web services, security?
>Get stuff done quickly with pre-integrated technology to make your job easier
>Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
>http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
>
>------------------------------------------------------------------------
>
>_______________________________________________
>Slashcode-development mailing list
>Slashcode-development@...
>https://lists.sourceforge.net/lists/listinfo/slashcode-development
>  
>

Re: [Slashcode-development] newbie question -Slash installation throws error about sections table missing, schema.sql has no reference to sections table

[shane <shane@lo...>]

On Sep 13, 2006, at 11:48 PM, Imtiaz A khan wrote:

>
> Hi Shane,
> Here's what I did :
> checked out the latest R tag from the CVS tree
> cvs -d:pserver:anonymous@...:/cvsroot/ 
> slashcode login
> cvs -d:pserver:anonymous@...:/cvsroot/ 
> slashcode co -P -r R_2_5_0_94 slash
> removed older instances of the install by dropping the slashdb  
> database and the /usr/local/slash directory as well as removing the  
> Include statements from Apache.
> did a make followed by make install
> did a install-slashsite -u virtuser
> added Include to Apache and restarted Apache
> started slash
>
> Now the problem I am facing are:
> I dont have a sections table in slashdb
> I dont have a sections.pl
> subsequently if I go to edit a section I get the 404 "The requested  
> URL (sections.pl?op=list) was not found."

Sections.pl, as well as any section* is depricated in that version of  
Slash.

You want to setup you *skins* and Topic Nexus's.

> I am assuming that I should be selecting the sections plugin in the  
> list of plugins when prompted to do so, but you were categorical  
> about not doing so. Please advise if I should answer 'a' when asked  
> the question "Hit 'a' to select all, otherwise select comma  
> separated numbers or 'q' to quit" or 'q' during install-slashsite

You want to install only the default list of plugins. Do not add any.  
I think you'd just 'press q'.

>
> Thanks a lot for your help I'm sure it's just a little more effort  
> and I'll be able to make subdomains and get to using slashcode to  
> run my websites.

Because the section stuff is depricated, that's why I was suggesting  
you grab the skins editor. I wrote it for inclusion into the standard  
code. It's been submitted to the OSTG crew, I'm sure when they have  
time to look at it it'll get included in the standard distribution of  
code. Until then, that's why I mentioned you can go grab it. It's a  
GUI to let you setup your skins. Otherwise, you'll have to do similar  
to this:

INSERT INTO skins (skid, nexus, name, title, issue, url, hostname,  
cookiedomain, last_rewrite)              VALUES  
(29,13,'convention','Convention','yes','','','',20040110235000);

where an topic already exists at the skins.tid that you are  
specifying that points to a tid in table topic_nexus.

The topic stuff you can setup w/ the httpd slash-admin gui. But the  
skins, unless you grab that plugin, you'll have to create using SQL.  
Don't forget to setup the CSS for each too.

INSERT INTO css (rel, type, media, file, title, skin, page, admin,  
theme, ctid, ordernum, ie_cond) VALUES ('stylesheet','text/ 
css','screen, projection','foobar.css','','foorbar','','no','',2,0,'');

etc.

If you haven't looked at how to create a theme for your site, you may  
want to look at it. Over time, having a seperate theme for your site,  
rather then it using the slashcode theme, can be very time saving if  
you plan to make cosmetic changes to your site. If you don't plan on  
lots of cosmetic changes, nor template changes, then I don't know  
that I'd bother with a theme. theme-howto: http://slash.lottadot.com/ 
article.pl?sid=03/06/17/224243

  Shane



--
My slashcode stuff: http://slash.lottadot.com/
Slashcode faq: http://slash.lottadot.com/slash-faq
How to ask a question: http://www.catb.org/~esr/faqs/smart- 
questions.html#before