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

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

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.

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.

Thank you Kalileo,

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

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.

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

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?