Jump to:

23471 Posts in 18937 Topics by 2878 members

General Questions

SilverStripe Forums » General Questions » Run Silverstripe Forum in PostgreSQL

General questions about getting started with SilverStripe that don't fit in any of the categories above.

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

Page: 1
Go to End
Author Topic: 553 Views
  • kerry
    Avatar
    Community Member
    6 Posts

    Run Silverstripe Forum in PostgreSQL Link to this post

    Hello.
    I use SilverStripe 3.0.3, forum is the latest from Github, postgreSQL 9.1, php 5.4.7.

    I have a problem to run the forum in PostgreSQL, what am I missing?

    I downloaded the module and integrated it with dev / build. Everything work so far with no problems, even in the admin area, the Forum will be displayed. Only when I go to the home page and click on the Sitetree, that brings me to the forum there is the Server Error Page shown and not more. Neither in the console or elsewhere is an error thrown.

    Do I need to change something somewhere eg: from MySQL to PostgreSQL in the forum? If i had to change something, where is this?
    Can someone please help me?

    Sorry for the bad english ;).

    lg Kerry

  • martimiz
    Avatar
    Forum Moderator
    1081 Posts

    Re: Run Silverstripe Forum in PostgreSQL Link to this post

    Hi kerry,

    Did you put the site in dev mode? That might shed some light on what the error might be...

    In your mysite/_config.php

    Director::set_environment_type("dev");

    Martine

  • kerry
    Avatar
    Community Member
    6 Posts

    Re: Run Silverstripe Forum in PostgreSQL Link to this post

    Yes I put the site in dev mode. But there is only one error but this error was there before I integrated the forum. But maybe you now what to do.

    [User Deprecated] DataObjectDecorator is deprecated. DataObjectDecorator is deprecated. Use DataExtension instead. Called from ReflectionClass->newInstance.

    Line 171 in C:\SilverStripe\framework\dev\Deprecation.php

    Source

    162          $level = self::$notice_level;
    163          if (!$level) $level = E_USER_DEPRECATED;
    164
    165          // Then raise the notice
    166          if(substr($string,-1) != '.') $string .= ".";
    167
    168          $string .= " Called from " . self::get_called_method_from_trace($backtrace, 2) . '.';
    169
    170          if($caller) {
    171             user_error($caller.' is deprecated.'.($string ? ' '.$string : ''), $level);   
    172          } else {
    173             user_error($string, $level);   
    174          }
    175          
    176       }
    177    }

    Thank you for the quick response.

    Kerry

  • kerry
    Avatar
    Community Member
    6 Posts

    Re: Run Silverstripe Forum in PostgreSQL Link to this post

    What I found out, is that the forum searches the css und the JS in the wrong domain/directory and it has the wrong port. The way to my path is this: localhost\Test\Silverstripe\themes\...

    but the forum search in localhost:8081\Test\themes

    where could I change this? or is something saved in the database because I changed the port a few weeks ago?
    The next thing is that I'm not use the simlpe theme is that a problem?

    Kerry

  • martimiz
    Avatar
    Forum Moderator
    1081 Posts

    Re: Run Silverstripe Forum in PostgreSQL Link to this post

    The error tells you that some code somewhere uses the DataObjectDecorator but in SS3.0 this class is no longer valid, in favor of the DataExtension class, so that code - whatever it is, is not really supported in SS3.0

    The bit in the errormessage that tells you where the error originates is missing from your post, so I don't know what the offending code is.

    The other problem might have something to do with the cache, because in SilverStripe paths are not stored in the database. Try a ?flush=1 or a ?flush=all and see if that helps...

    EDIT - I can't really say if the theme you're using has any influence - but that's easy to test by temporarilyt enabling the default (simple) theme and see what happens...

  • kerry
    Avatar
    Community Member
    6 Posts

    Re: Run Silverstripe Forum in PostgreSQL Link to this post

    I tried the ?flush=1 and the ?flush=all but the path is still the same wrong one. I send you the output of the firebug (image). The red text in the image is the wrong path.

    Is there anything else I could do?

    Or how can i change the forum theme?

    Maybe is there something to change, that the forum works in postgreSQL?
    Because in the _config.php of the forum there are these two lines:

    Object::add_static_var('Post', 'create_table_options', array('MySQLDatabase' => 'ENGINE=MyISAM'), true);
    Object::add_static_var('ForumThread', 'create_table_options', array('MySQLDatabase' => 'ENGINE=MyISAM'), true);

    Kerry

    Attached Files
  • kerry
    Avatar
    Community Member
    6 Posts

    Re: Run Silverstripe Forum in PostgreSQL Link to this post

    Now i have tried to start a new Homepage. I integreted the postgresql Modul and the Forum modul and a dev/build.
    Now i get this when i click on the Link(Sitetree) to the Forum:

    Has anyone an idea?

    Attached Files
  • Willr
    Avatar
    Forum Moderator
    5497 Posts

    Re: Run Silverstripe Forum in PostgreSQL Link to this post

    The forum hasn't fully been upgraded to 3.0 so some errors are still present. I haven't used forum with postgres before so likely issues. Please raise any errors as issues (if not already on it) on github.com (https://github.com/silverstripe/silverstripe-forum/issues)

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