Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

We're retiring the forums!

The SilverStripe forums have passed their heyday. They'll stick around, but will be read only. We'd encourage you to get involved in the community via the following channels instead:

Forum Module /

Discuss the Forum Module.

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

Forum not working with postgresql ?

Go to End

3 Posts   1239 Views

KC Scott

Community Member, 2 Posts

21 July 2010 at 3:53am

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


Forum Moderator, 5523 Posts

21 July 2010 at 6:32pm

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 with as much information (inc screenshots) as you can.

KC Scott

Community Member, 2 Posts

22 July 2010 at 2:15am

I was using 0.3. Trunk works! Thank you.