Jump to:

1036 Posts in 810 Topics by 315 members

Forum Module

SilverStripe Forums » Forum Module » Installation Issues

Discuss the Forum Module.

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

Page: 1
Go to End
Author Topic: 1716 Views
  • moonlight
    Avatar
    Community Member
    5 Posts

    Installation Issues Link to this post

    Hi Guys,

    If anyone could help me with my installation issue that would be great. Module downloaded and unpacked off-server, 'forum' folder uploaded to root (permissions 755, but tried with even 777), then root/db/build?flush=1 ran and also root?flush=1
    Version: 2.3.7

    --------------Start error code--------------

    [User Error] Couldn't run query: SELECT `SiteTree`.*, `GhostPage`.*, `Forum`.*, `ForumHolder`.*, `ErrorPage`.*, `RedirectorPage`.*, `VirtualPage`.*, `SiteTree`.ID, if(`SiteTree`.ClassName,`SiteTree`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree` LEFT JOIN `GhostPage` ON `GhostPage`.ID = `SiteTree`.ID LEFT JOIN `Forum` ON `Forum`.ID = `SiteTree`.ID LEFT JOIN `ForumHolder` ON `ForumHolder`.ID = `SiteTree`.ID LEFT JOIN `ErrorPage` ON `ErrorPage`.ID = `SiteTree`.ID LEFT JOIN `RedirectorPage` ON `RedirectorPage`.ID = `SiteTree`.ID LEFT JOIN `VirtualPage` ON `VirtualPage`.ID = `SiteTree`.ID WHERE (`SiteTree`.URLSegment = '') ORDER BY Sort LIMIT 1 Table 'riglarc1_ss.Forum' doesn't exist
    GET /potp/silverstripe-v2.3.7/admin

    Line 401 in /home/riglarc1/public_html/potp/silverstripe-v2.3.7/sapphire/core/model/MySQLDatabase.php

    Source

    392    }
    393    
    394    function databaseError($msg, $errorLevel = E_USER_ERROR) {
    395       // try to extract and format query
    396       if(preg_match('/Couldn\'t run query: ([^\|]*)\|\s*(.*)/', $msg, $matches)) {
    397          $formatter = new SQLFormatter();
    398          $msg = "Couldn't run query: \n" . $formatter->formatPlain($matches[1]) . "\n\n" . $matches[2];
    399       }
    400       
    401       user_error($msg, $errorLevel);
    402    }
    403 }
    404
    405 /**
    406 * A result-set from a MySQL database.
    407 * @package sapphire
    Trace

    Couldn't run query: SELECT `SiteTree`.*, `GhostPage`.*, `Forum`.*, `ForumHolder`.*, `ErrorPage`.*, `RedirectorPage`.*, `VirtualPage`.*, `SiteTree`.ID, if(`SiteTree`.ClassName,`SiteTree`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree` LEFT JOIN `GhostPage` ON `GhostPage`.ID = `SiteTree`.ID LEFT JOIN `Forum` ON `Forum`.ID = `SiteTree`.ID LEFT JOIN `ForumHolder` ON `ForumHolder`.ID = `SiteTree`.ID LEFT JOIN `ErrorPage` ON `ErrorPage`.ID = `SiteTree`.ID LEFT JOIN `RedirectorPage` ON `RedirectorPage`.ID = `SiteTree`.ID LEFT JOIN `VirtualPage` ON `VirtualPage`.ID = `SiteTree`.ID WHERE (`SiteTree`.URLSegment = '') ORDER BY Sort LIMIT 1 Table 'riglarc1_ss.Forum' doesn't exist
    Line 401 of MySQLDatabase.php
    MySQLDatabase->databaseError(Couldn't run query: SELECT `SiteTree`.*, `GhostPage`.*, `Forum`.*, `ForumHolder`.*, `ErrorPage`.*, `RedirectorPage`.*, `VirtualPage`.*, `SiteTree`.ID, if(`SiteTree`.ClassName,`SiteTree`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree` LEFT JOIN `GhostPage` ON `GhostPage`.ID = `SiteTree`.ID LEFT JOIN `Forum` ON `Forum`.ID = `SiteTree`.ID LEFT JOIN `ForumHolder` ON `ForumHolder`.ID = `SiteTree`.ID LEFT JOIN `ErrorPage` ON `ErrorPage`.ID = `SiteTree`.ID LEFT JOIN `RedirectorPage` ON `RedirectorPage`.ID = `SiteTree`.ID LEFT JOIN `VirtualPage` ON `VirtualPage`.ID = `SiteTree`.ID WHERE (`SiteTree`.URLSegment = '') ORDER BY Sort LIMIT 1 | Table 'riglarc1_ss.Forum' doesn't exist,256)
    Line 102 of MySQLDatabase.php
    MySQLDatabase->query(SELECT `SiteTree`.*, `GhostPage`.*, `Forum`.*, `ForumHolder`.*, `ErrorPage`.*, `RedirectorPage`.*, `VirtualPage`.*, `SiteTree`.ID, if(`SiteTree`.ClassName,`SiteTree`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree` LEFT JOIN `GhostPage` ON `GhostPage`.ID = `SiteTree`.ID LEFT JOIN `Forum` ON `Forum`.ID = `SiteTree`.ID LEFT JOIN `ForumHolder` ON `ForumHolder`.ID = `SiteTree`.ID LEFT JOIN `ErrorPage` ON `ErrorPage`.ID = `SiteTree`.ID LEFT JOIN `RedirectorPage` ON `RedirectorPage`.ID = `SiteTree`.ID LEFT JOIN `VirtualPage` ON `VirtualPage`.ID = `SiteTree`.ID WHERE (`SiteTree`.URLSegment = '') ORDER BY Sort LIMIT 1,256)
    Line 120 of DB.php
    DB::query(SELECT `SiteTree`.*, `GhostPage`.*, `Forum`.*, `ForumHolder`.*, `ErrorPage`.*, `RedirectorPage`.*, `VirtualPage`.*, `SiteTree`.ID, if(`SiteTree`.ClassName,`SiteTree`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree` LEFT JOIN `GhostPage` ON `GhostPage`.ID = `SiteTree`.ID LEFT JOIN `Forum` ON `Forum`.ID = `SiteTree`.ID LEFT JOIN `ForumHolder` ON `ForumHolder`.ID = `SiteTree`.ID LEFT JOIN `ErrorPage` ON `ErrorPage`.ID = `SiteTree`.ID LEFT JOIN `RedirectorPage` ON `RedirectorPage`.ID = `SiteTree`.ID LEFT JOIN `VirtualPage` ON `VirtualPage`.ID = `SiteTree`.ID WHERE (`SiteTree`.URLSegment = '') ORDER BY Sort LIMIT 1)
    Line 426 of SQLQuery.php
    SQLQuery->execute()
    Line 2531 of DataObject.php
    DataObject->instance_get_one(`SiteTree`.URLSegment = '',)
    Line 2468 of DataObject.php
    DataObject::get_one(SiteTree,`SiteTree`.URLSegment = '',1,)
    Line 1094 of SiteTree.php
    SiteTree::get_by_url()
    Line 215 of CMSMain.php
    CMSMain->generateDataTreeHints()
    Line 143 of CMSMain.php
    CMSMain->SiteTreeAsUL()
    call_user_func_array(Array,Array)
    Line 408 of ViewableData.php
    ViewableData->XML_val(SiteTreeAsUL,,1)
    Line 294 of .cache.home.riglarc1.public_html.potp.silverstripe-v2.3.7.cms.templates.Includes.CMSMain_left.ss
    include(/tmp/silverstripe-cache-home-riglarc1-public_html-potp-silverstripe-v2.3.7/.cache.home.riglarc1.public_html.potp.silverstripe-v2.3.7.cms.templates.Includes.CMSMain_left.ss)
    Line 357 of SSViewer.php
    SSViewer->process(CMSMain)
    Line 773 of ViewableData.php
    ViewableData->renderWith(Array)
    Line 448 of LeftAndMain.php
    LeftAndMain->Left()
    call_user_func_array(Array,Array)
    Line 408 of ViewableData.php
    ViewableData->XML_val(Left,,1)
    Line 59 of .cache.home.riglarc1.public_html.potp.silverstripe-v2.3.7.cms.templates.LeftAndMain.ss
    include(/tmp/silverstripe-cache-home-riglarc1-public_html-potp-silverstripe-v2.3.7/.cache.home.riglarc1.public_html.potp.silverstripe-v2.3.7.cms.templates.LeftAndMain.ss)
    Line 357 of SSViewer.php
    SSViewer->process(CMSMain)
    Line 172 of Controller.php
    Controller->handleAction(HTTPRequest)
    Line 129 of RequestHandler.php
    RequestHandler->handleRequest(HTTPRequest)
    Line 119 of Controller.php
    Controller->handleRequest(HTTPRequest)
    Line 280 of Director.php
    Director::handleRequest(HTTPRequest,Session)
    Line 121 of Director.php
    Director::direct(/admin)
    Line 118 of main.php

    ----------stop error code----------

    Any ideas?

    Thanks kindly,
    Tom

  • Kalileo
    Avatar
    Community Member
    127 Posts

    Re: Installation Issues Link to this post

    You haven't said which forum version you have installed.

    Keep in mind that the latest trunk is for SS 2.4 RC1 and might not work with 2.3.7

  • moonlight
    Avatar
    Community Member
    5 Posts

    Re: Installation Issues Link to this post

    Thanks for replying Kalileo.

    I'm using 2.5, however this is the info displayer on the SilverStripe website.

    Latest release
    Version: [v0.2.5]
    Date: 2010-01-22
    Compatible with: SilverStripe 2.3
    Download: forum-v0.2.5.tar.gz
    Subversion access: http://svn.silverstripe.com/open/modules/forum/tags/0.2.5/
    Older release(s)
    Version: [v0.2.4]
    Date: 2009-11-25
    Compatible with: SilverStripe 2.3.3, 2.3.4, 2.3.5
    Download: forum-v0.2.4.tar.gz
    Subversion access: http://svn.silverstripe.com/open/modules/forum/tags/0.2.4

    So is there anywhere that I can find a version explicitly compatible with 2.3.7?

    Thanks for your help.

  • Kalileo
    Avatar
    Community Member
    127 Posts

    Re: Installation Issues Link to this post

    The version should be fine already. Your error is that the table "'riglarc1_ss.Forum' doesn't exist".

    Make sure you are logged in as admin and that you successfully ran /dev/build (/db/... is deprecated). You should see the usual output listing tables and fields. If you cannot log in then make sure you've set your project to 'dev' mode.

    Then make sure you have indeed cleared the cache. If you have a /silverstripe_cache folder delete all content manually.

  • moonlight
    Avatar
    Community Member
    5 Posts

    Re: Installation Issues Link to this post

    Thank you Kalileo,

    It would seem that /dev/build was the issue. All is working correctly now.

  • davidm2010
    Avatar
    Community Member
    107 Posts

    Re: Installation Issues Link to this post

    I am using 2.4 and trying to instal forum-trunk-r107084, when a do my dev/build, I get a website error. No error messages on the web page, just doesn seem to build.

    I do have dataobject loader, SWFUpload installed (working), and this is a new install, not an upgrade.

  • davidm2010
    Avatar
    Community Member
    107 Posts

    Re: Installation Issues Link to this post

    Forum Module Working - Not sure why, but it installed.

  • itobe
    Avatar
    Community Member
    4 Posts

    Re: Installation Issues Link to this post

    Hey there,
    i have similar problems with the module.

    I have a fresh installed SS 2.4.0 with Blog and UserForms Module.

    Now i wanted to get the forum module, uploaded the directory named "forum" to the root dir and tried to run mysite.com/dev/build, but the only thing i got was this error:

    Website Error
    There has been an error
    The website server has not been able to respond to your request.

    I tried that with two versions, but all the same problems... forum-trunk-r107084.tar.gz and forum-0.3-r106922.tar.gz

    i think its a problem with the _config.php file, if i comment out the following two lines, the /dev/build runs through, but the access to /admin returns the same error as mentioned above:
    //DataObject::add_extension('Member', 'ForumRole');
    //Object::add_extension('Member_Validator', 'ForumRole_Validator');

    Can anybody help me?

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