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