Jump to:

1030 Posts in 805 Topics by 311 members

Forum Module

SilverStripe Forums » Forum Module » Forum cannot be installed using Postgresql

Discuss the Forum Module.

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

Page: 1
Go to End
Author Topic: 497 Views
  • sypou
    Avatar
    Community Member
    10 Posts

    Forum cannot be installed using Postgresql Link to this post

    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

  • Willr
    Avatar
    Forum Moderator
    5489 Posts

    Re: Forum cannot be installed using Postgresql Link to this post

    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).

    497 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.