Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

We've moved the forum!

Please use forum.silverstripe.org for any new questions (announcement).
The forum archive will stick around, but will be read only.

You can also use our Slack channel or StackOverflow to ask for help.
Check out our community overview for more options to contribute.

Forum Module /

Discuss the Forum Module.

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

Installation Issues


Go to End


8 Posts   2933 Views

Avatar
moonlight

Community Member, 5 Posts

21 April 2010 at 9:29am

Edited: 21/04/2010 9:31am

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

Avatar
Kalileo

Community Member, 127 Posts

22 April 2010 at 6:11am

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

Avatar
moonlight

Community Member, 5 Posts

23 April 2010 at 8:12am

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.

Avatar
Kalileo

Community Member, 127 Posts

23 April 2010 at 12:54pm

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.

Avatar
moonlight

Community Member, 5 Posts

24 April 2010 at 5:12am

Thank you Kalileo,

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

Avatar
davidm2010

Community Member, 107 Posts

14 July 2010 at 2:45am

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.

Avatar
davidm2010

Community Member, 107 Posts

17 July 2010 at 11:35pm

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

Avatar
itobe

Community Member, 4 Posts

23 July 2010 at 4:57am

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?