1010 Posts in 535 Topics by 307 members
|Go to End|
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
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.
22 July 2010 at 2:15am
I was using 0.3. Trunk works! Thank you.
|Go to Top|