938 Posts in 271 Topics by 291 members
Forum Module
SilverStripe Forums » Forum Module » Forum not working with postgresql ?
Discuss the Forum Module.
Moderators: martimiz, Howard, Sean, Ryan M., biapar, Willr, Ingo, swaiba, simon_w
|
Page:
1
|
Go to End | |
| Author | Topic: | 571 Views |
-
Forum not working with postgresql ?
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
-
Re: Forum not working with postgresql ?
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.
-
Re: Forum not working with postgresql ?
22 July 2010 at 2:15am
I was using 0.3. Trunk works! Thank you.
| 571 Views | ||
|
Page:
1
|
Go to Top |
