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