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.

Forum Module /

Discuss the Forum Module.

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

Forum cannot be installed using Postgresql


Reply


2 Posts   669 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, 5513 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).