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.

Forum Module

Discuss the Forum Module.

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

Forum not working with postgresql ?


Reply

3 Posts   868 Views

Avatar
KC Scott

21 July 2010 at 3:53am Community Member, 2 Posts

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

Avatar
Willr

21 July 2010 at 6:32pm Forum Moderator, 5511 Posts

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.

Avatar
KC Scott

22 July 2010 at 2:15am Community Member, 2 Posts

I was using 0.3. Trunk works! Thank you.