Jump to:

1036 Posts in 810 Topics by 315 members

Forum Module

SilverStripe Forums » Forum Module » Forum not working with postgresql ?

Discuss the Forum Module.

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

Page: 1
Go to End
Author Topic: 839 Views
  • KC Scott
    Avatar
    Community Member
    2 Posts

    Forum not working with postgresql ? Link to this post

    Hi, New SS user here, I have installed version 2.4 CMS with the postgresql module and it is working. I installed the forum module and am now receiving this error when navigating to a forum page

    [5-1] ERROR: relation "post" does not exist
    [5-2] STATEMENT: SELECT COUNT(*) FROM Post JOIN SiteTree ForumPage ON Post.ForumID=ForumPage.ID WHERE Post.Content != 'NULL' and ForumPage.ParentID='10'

    I can fix that error by quoting the table names but then Postgresql complains about the join syntax.
    My first question is does Forum work with postgresql? Anyway, any ideas appreciated and thank you in advance.

    I'm willing to help test and troubleshoot any suggestions ( MY knowledge of SQL is limited )

    Freebsd 7 Apache 2.2 postgresql 8.3 php 5.3

    Thanks again - Kevin

  • Willr
    Avatar
    Forum Moderator
    5508 Posts

    Re: Forum not working with postgresql ? Link to this post

    YWhich version of the forum where you trying to use? We got Forum working cross database in trunk a while back. Sadly this work was not able to make the 0.3 release so for postgres you'll have to use trunk of forum.

    If you're using trunk and still encountering issues please make a new ticket on open.silverstripe.org with as much information (inc screenshots) as you can.

  • KC Scott
    Avatar
    Community Member
    2 Posts

    Re: Forum not working with postgresql ? Link to this post

    I was using 0.3. Trunk works! Thank you.

    839 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.