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.
> 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
Also do you have to alter or create your own theme to control what the homepage is?
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 :-)
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
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
Ahhh I see. I didn't know it was actually creating files. I assumed
everything other than assets like images was in the DB. :-)