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

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.

Thank you Kalileo,

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

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