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   909 Views

Avatar
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

Avatar
Willr

Forum Moderator, 5513 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 open.silverstripe.org with as much information (inc screenshots) as you can.

Avatar
KC Scott

Community Member, 2 Posts

22 July 2010 at 2:15am

I was using 0.3. Trunk works! Thank you.