Tags required?

1 view
Skip to first unread message

Anthony Cunningham

unread,
Mar 3, 2008, 12:02:30 PM3/3/08
to steercm...@googlegroups.com
Im trying to do an initial install of Steer. Everything seems to install ok.
I get to the admin make some pages and what not. But when I go to the
frontend I get sql errors from actAsTaggable:

Fatal error: Uncaught exception 'PropelException' with message ' [wrapped:
Could not execute query [Native Error: Invalid use of group function] [User
Info: SELECT tag.NAME, COUNT(tagging.ID), UPPER(tag.NAME) FROM tag, tagging
WHERE tag.ID=tagging.TAG_ID GROUP BY tagging.TAG_ID ORDER BY
COUNT(tagging.ID) DESC,UPPER(tag.NAME) ASC]]' in
/usr/local/php5/lib/php/symfony/vendor/propel/util/BasePeer.php:458 Stack
trace: #0
/Library/WebServer/__Documents/dev.steercms.local/plugins/sfPropelActAsTagga
bleBehaviorPlugin/lib/model/om/BaseTagPeer.php(189):
BasePeer::doSelect(Object(Criteria), Object(MySQLConnection)) #1
/Library/WebServer/__Documents/dev.steercms.local/plugins/sfPropelActAsTagga
bleBehaviorPlugin/lib/model/TagPeer.php(125):
BaseTagPeer::doSelectRS(Object(Criteria)) #2
/Library/WebServer/__Documents/dev.steercms.local/plugins/steerCMSFoundation
Plugin/lib/helper/steerCMSTagsHelper.php(56): TagPeer::getAllWithCount() #3
/Library/WebServer/__Documents/dev.steercms.local/plugins/steerCMSSimplyBlue
Theme/templates/_tags.php(2 in
/usr/local/php5/lib/php/symfony/vendor/propel/util/BasePeer.php on line 458

Also do you have to alter or create your own theme to control what the home
page is?

--

Anthony Cunningham
Senior Designer

Kernacopia Ltd.
PO Box 323
103 Professional Parkway
Marysville, OH 43040

t: 937.644.3016
f: 937.644.3012
c: 614.578.4498

ant...@kernacopia.com
http://www.kernacopia.com

----------------------------------------------------------------------------
© All Rights Reserved
Information herein, including any attachments, is considered confidential.
Unauthorized reproduction, derivative creation, disclosure, or circulation
of said information is strictly prohibited and protected by Federal
copyright law and regulation.


konny.zurcher

unread,
Mar 5, 2008, 6:07:38 PM3/5/08
to Steer CMS Users
Hi Anthony,

Which version of Steer CMS did you install?

- the Standbox
- the SVN trunk version

And also what php version and database version are you using?

Cheers,

Konny Zurcher
Steer CMS - Development Team
> anth...@kernacopia.comhttp://www.kernacopia.com

Anthony Cunningham

unread,
Mar 6, 2008, 3:33:27 PM3/6/08
to steercm...@googlegroups.com
On 3/5/08 6:07 PM, "konny.zurcher" <ko...@wranglers.com.au> wrote:

> Which version of Steer CMS did you install?
>
> - the Standbox
> - the SVN trunk version
>
> And also what php version and database version are you using?

Sanbox
PHP 5.2.2
MySQL 4.1.20
OS X 10.4.10
Apache 1.3.33

-ant


Konny Zurcher

unread,
Mar 6, 2008, 5:09:18 PM3/6/08
to steercm...@googlegroups.com
Hi Anthony,

Thanks for that info.

You said in the mail before that the installation was ok. Did you get any errors after using the build command at all?

$ symfony propel-build-all-load backend

Because it's not mandatory to add tags to an object.

Also do you have to alter or create your own theme to control what the home
page is?

There are two standard themes, for the frontend, delivered with Steer CMS. But for your own design you can add another one.


Cheers,

Konny Zurcher
Steer CMS - Development Team

Ant Cunningham

unread,
Mar 6, 2008, 7:23:04 PM3/6/08
to steercm...@googlegroups.com

> You said in the mail before that the installation was ok. Did you get any
> errors after using the build command at all?
>
> $ symfony propel-build-all-load backend

Yes. Well I got the error about actasnested set not being registered. But I
resolved it. All though for the life of me I cant remember what I did to fix
it. IT may have been that behaviors werent enabled in propel.ini, but I also
might be confusing this with something else I was in the midst of just
before or after trying to give this a quick spin.

> Because it's not mandatory to add tags to an object.
>

I wouldn't think that it wouldn't be. I havent even looked at the code yet
to decipher what the actual problem is...

>
> There are two standard themes, for the frontend, delivered with Steer CMS. But
> for your own design you can add another one.
>
> http://www.steercms-project.org/developer-documentation/themes

I saw that already, but that's not really what im asking unless there are
more properties not listed in the wiki.

For example, I was trying to add a test page with the content "Hello
World!". I wanted this to be the content for the content region on the home
page.

I created the project root, then attempted to create a page/content. Id did
this successfully and can see my content at the slug I provided. However my
intent was not to provide a slug but to create the content for the home
page.

Thinking perhaps there was a default slug I tired home, /, and root. That
did not work. Then I though well maybe the home page content is static by
default and simply includes either the static content or the result of
whatever you put in the region within the theme (for example an
include_component call). Id didnt really get far enough to look into either
of themes provided to see what it was actually doing. This isnt problem with
the app so much as it is the current lack of documentation. But that's just
matter of time :-)


Konny Zurcher

unread,
Mar 6, 2008, 8:06:15 PM3/6/08
to steercm...@googlegroups.com
Hi Anthony,

As I understand you. You created a SITE DIRECTORY under CONTENT in the CMS. Then added a site page to it with title and slug. 

Then as your structure would be as an example:

site_directory
|_ testfolder
|_page (title + slug)

You would get to that page by using:

http://localhost/testfolder/{slug}

To see the page in the frontend it needs to be published first. The slug is not the contend (slug = filename). Is only used for how to get to that page.

To EDIT the content of that particular page go to the list where you see your created page and click on the ICON on the left side of the page. You should get a function list like that:

    *  rename
    * edit html
    * edit code
    * template
    * copy
    * properties
    * versions
    * publish
    * send to queue
    * delete

If you go to EDIT HTML you can add your page content.  Also if you want to see the created page in the navigation on the frontpage you have to go to the NAVIGATION menu option and drag whatever you want to "Navigation: Displayed". Also another thing is that the first page in a separate directory needs to be a index.html when using the navigation.

Hope that helps so far. 

In the newest version of SteerCMS (new Sandbox version soon), which is available out of SVN TRUNK, this was made much more clear how to use. 

The documentation will be extended soon to provide more details about usability in the new layout :-)

Cheers,

Konny Zurcher
Steer CMS - Development Team

Ant Cunningham

unread,
Mar 6, 2008, 8:32:02 PM3/6/08
to steercm...@googlegroups.com


On 3/6/08 8:06 PM, "Konny Zurcher" <ko...@wranglers.com.au> wrote:

> Hi Anthony,
>
> As I understand you. You created a SITE DIRECTORY under CONTENT in the CMS.
> Then added a site page to it with title and slug. 
>
> Then as your structure would be as an example:
>
> site_directory
> |_ testfolder
> |_page (title + slug)
>
> You would get to that page by using:
>
> http://localhost/testfolder/{slug}
>

> [...]


>
> Hope that helps so far. 

No I understand all that. If I point my browser to the slug url I can see
the page no problem. My issue is I want to edit what shows up on the root
page (http://domain/). Not in some other level of the hierarchy like
/folder/slug. It wasn't clear to me how to do this. Maybe I just missed
making a page right off the bat and made a folder instead?

>
> In the newest version of SteerCMS (new Sandbox version soon), which is
> available out of SVN TRUNK, this was made much more clear how to use.

I ran into the same problem with an export of the SVN. A day or so after
this but I will revisit when I have time.


 
>
> The documentation will be extended soon to provide more details about
> usability in the new layout :-)

Documentation is always good :-)

-ant


Konny Zurcher

unread,
Mar 6, 2008, 9:33:38 PM3/6/08
to steercm...@googlegroups.com
Hi Anthony,

To change the content of the root index page do the following in the
CMS:

Go to root in the content area and create a Site Directory, then add
a Site Page to that directory with:

Title: whatever you want here
Slug: index.html <= needs be be called like that for the first page

Then add content to that page. After publishing that page and going
to http://localhost/ you should see that page directly now.

Cheers,

Konny Zurcher
Steer CMS - Development Team

Ant Cunningham

unread,
Mar 6, 2008, 9:37:03 PM3/6/08
to steercm...@googlegroups.com
On 3/6/08 9:33 PM, "Konny Zurcher" <ko...@wranglers.com.au> wrote:
>
> Title: whatever you want here
> Slug: index.html <= needs be be called like that for the first page

Ahhh I see. I didn't know it was actually creating files. I assumed
everything other than assets like images was in the DB. :-)


Konny Zurcher

unread,
Mar 6, 2008, 10:01:03 PM3/6/08
to steercm...@googlegroups.com
Hi Anthony,

Sorry for the confusion here. The index.html is the only one special. Has to do with the file the webserver looks for when pointing to a directory and that is by default called index.html.

To the structure:

- Site Directory => Is all saved in VFS (Virtual File System) which means, as you said, in Database
- System Directory => These are files and assets you upload, and these are saved as real files in the created system file structure

In case you install the SVN trunk version here a short explanation and screenshots what changed:


This will be soon available also as Sandbox Version.

Cheers,

Konny Zurcher
Steer CMS - Development Team


Reply all
Reply to author
Forward
0 new messages