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.

Forum Module

Discuss the Forum Module.

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

Forum don't work on version 2.3


Reply

2 Posts   1937 Views

Avatar
Kasutajanimi

27 January 2009 at 2:05am Community Member, 15 Posts

I had seen this error message when I tried to use forum module.
I delete only ' extends Email_Template ' from line 260 of forum/code/ForumRole.php coz of it make glitch (undefined class Email_Template).

[User Error] Couldn't run query: SELECT `SiteTree`.*, `GhostPage`.*, `BlogEntry`.*, `BlogHolder`.*, `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 `BlogEntry` ON `BlogEntry`.ID = `SiteTree`.ID LEFT JOIN `BlogHolder` ON `BlogHolder`.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 (HomepageForDomain REGEXP '(, ^) *silverstripe23\.non-existent-host *(,|$)') ORDER BY Sort LIMIT 1 | Table 'ancafe.blogentry' doesn't exist
GET /

Line 394 in Z:\home\non-existent-host\SilverStripe23\sapphire\core\model\MySQLDatabase.php
Source

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

Trace

* Couldn't run query: SELECT `SiteTree`.*, `GhostPage`.*, `BlogEntry`.*, `BlogHolder`.*, `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 `BlogEntry` ON `BlogEntry`.ID = `SiteTree`.ID LEFT JOIN `BlogHolder` ON `BlogHolder`.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 (HomepageForDomain REGEXP '(, ^) *silverstripe23\.non-existent-host *(,|$)') ORDER BY Sort LIMIT 1 | Table 'ancafe.blogentry' doesn't exist
Line 394 of MySQLDatabase.php
* MySQLDatabase->databaseError(Couldn't run query: SELECT `SiteTree`.*, `GhostPage`.*, `BlogEntry`.*, `BlogHolder`.*, `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 `BlogEntry` ON `BlogEntry`.ID = `SiteTree`.ID LEFT JOIN `BlogHolder` ON `BlogHolder`.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 (HomepageForDomain REGEXP '(,|^) *silverstripe23\.non-existent-host *(,|$)') ORDER BY Sort LIMIT 1 | Table 'ancafe.blogentry' doesn't exist,256)
Line 102 of MySQLDatabase.php
* MySQLDatabase->query(SELECT `SiteTree`.*, `GhostPage`.*, `BlogEntry`.*, `BlogHolder`.*, `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 `BlogEntry` ON `BlogEntry`.ID = `SiteTree`.ID LEFT JOIN `BlogHolder` ON `BlogHolder`.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 (HomepageForDomain REGEXP '(,|^) *silverstripe23\.non-existent-host *(,|$)') ORDER BY Sort LIMIT 1,256)
Line 97 of DB.php
* DB::query(SELECT `SiteTree`.*, `GhostPage`.*, `BlogEntry`.*, `BlogHolder`.*, `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 `BlogEntry` ON `BlogEntry`.ID = `SiteTree`.ID LEFT JOIN `BlogHolder` ON `BlogHolder`.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 (HomepageForDomain REGEXP '(,|^) *silverstripe23\.non-existent-host *(,|$)') ORDER BY Sort LIMIT 1)
Line 426 of SQLQuery.php
* SQLQuery->execute()
Line 2339 of DataObject.php
* DataObject->instance_get_one(HomepageForDomain REGEXP '(,|^) *silverstripe23\.non-existent-host *(,|$)',)
Line 2287 of DataObject.php
* DataObject::get_one(SiteTree,HomepageForDomain REGEXP '(,|^) *silverstripe23\.non-existent-host *(,|$)')
Line 40 of RootURLController.php
* RootURLController::get_homepage_urlsegment()
Line 24 of RootURLController.php
* RootURLController->handleRequest(HTTPRequest)
Line 257 of Director.php
* Director::handleRequest(HTTPRequest,Session)
Line 106 of Director.php
* Director::direct(/)
Line 111 of main.php

Avatar
Willr

27 January 2009 at 5:49pm Forum Moderator, 5511 Posts

Use the daily builds of the forum, the stable is very old now. You can find a link to download the latest build (same one that powers this forum) on the forum download page