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've moved the forum!

Please use forum.silverstripe.org for any new questions (announcement).
The forum archive will stick around, but will be read only.

You can also use our Slack channel or StackOverflow to ask for help.
Check out our community overview for more options to contribute.

Forum Module /

Discuss the Forum Module.

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

Forum cannot be installed using Postgresql


Go to End


2 Posts   1496 Views

Avatar
sypou

Community Member, 10 Posts

11 October 2011 at 5:56pm

Hi all,

I cannot install the forum module. I use SS 2.4.5/Postgresql 8.3.5/Forum 0.3.0

Here is the message:

Building database dbmysite using PostgreSQL 8.3.5

Creating database tables
PageComment
ForumCategory
Post
Table Post: created
Field Post.ID: created as serial8 not null

.....
.....

[Warning] pg_query(): Query failed: ERROR: column "fulltext (Title" does not exist
GET /essaiforum/index.php/dev/build/?flush=1

Line 187 in C:\ms4w\Apache\htdocs\essaiforum\postgresql\code\PostgreSQLDatabase.php

.....
.....

Source

178 if(isset($_REQUEST['previewwrite']) && in_array(strtolower(substr($sql,0,strpos($sql,' '))), array('insert','update','delete','replace'))) {
179 Debug::message("Will execute: $sql");
180 return;
181 }
182
183 if(isset($_REQUEST['showqueries'])) {
184 $starttime = microtime(true);
185 }
186
187 $handle = pg_query($this->dbConn, $sql);
188
189 if(isset($_REQUEST['showqueries'])) {
190 $endtime = round(microtime(true) - $starttime,4);
191 Debug::message("\n$sql\n{$endtime}ms\n", false);
192 }
193

Trace

pg_query(Resource id #1146,CREATE TABLE "Post" ( "ID" serial8 not null, "ClassName" varchar(255) default 'Post' check ("ClassName" in ('Post')), "Created" timestamp, "LastEdited" timestamp, "Title" varchar(255), "Content" text, "Status" varchar(255) default 'Moderated' check ("Status" in ('Awaiting', 'Moderated', 'Rejected', 'Archived')), "NumViews" integer default 0, "IsSticky" smallint default 0, "IsReadOnly" smallint default 0, "IsGlobalSticky" smallint default 0, "ParentID" integer default 0, "TopicID" integer default 0, "ForumID" integer default 0, "AuthorID" integer default 0, primary key ("ID") ); create index ix_Post_ParentID ON "Post" ("ParentID"); create index ix_Post_TopicID ON "Post" ("TopicID"); create index ix_Post_ForumID ON "Post" ("ForumID"); create index ix_Post_AuthorID ON "Post" ("AuthorID"); create index ix_Post_SearchFields ON "Post" ("fulltext (Title","Content"); create index ix_Post_ClassName ON "Post" ("ClassName"); )
Line 187 of PostgreSQLDatabase.php

.....
.....

Any idea?

Thanks,

Sypou

Avatar
Willr

Forum Moderator, 5523 Posts

11 October 2011 at 6:46pm

Use the latest forum master release from the github page as it should include some fixes for exactly that. Just like most of the modules currently around, master is the one to use as they're all being used as 'stable' (apart from cms/sapphire).