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.

Blog Module

Discuss the Blog Module.

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

Blog Module Installation Problems...


Reply

4 Posts   1952 Views

Avatar
AdamMWMM

9 May 2009 at 4:55am Community Member, 12 Posts

Hey there. If this is a dup, I apologize, I didn't see it anywhere else.

I am trying to install the blog module, and after everything is uploaded and I run the /dev/build I get the following error:

[Notice] Undefined variable: _SESSION
GET /newumd/dev/build

Line 120 in /usr/www/users/mwmm/newumd/sapphire/core/control/Director.php

Source

111          @file_get_contents('php://input')
112       );
113       
114       // @todo find better way to extract HTTP headers
115       if(isset($_SERVER['HTTP_ACCEPT'])) $req->addHeader("Accept", $_SERVER['HTTP_ACCEPT']);
116       if(isset($_SERVER['CONTENT_TYPE'])) $req->addHeader("Content-Type", $_SERVER['CONTENT_TYPE']);
117       if(isset($_SERVER['HTTP_REFERER'])) $req->addHeader("Referer", $_SERVER['HTTP_REFERER']);
118
119       // Load the session into the controller
120       $session = new Session($_SESSION);
121       $result = Director::handleRequest($req, $session);
122       $session->inst_save();
123
124       // Return code for a redirection request
125       if(is_string($result) && substr($result,0,9) == 'redirect:') {
126          $response = new HTTPResponse();
Trace

Director::direct(/dev/build)
Line 115 of main.php

Then when I try to get to the admin section, I get this:

[User Error] Couldn't run query: SELECT `SiteTree`.*, `GhostPage`.*, `BlogEntry`.*, `BlogHolder`.*, `ErrorPage`.*, `RedirectorPage`.*, `VirtualPage`.*, `UserDefinedForm`.*, `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 `ErrorPage` ON `ErrorPage`.ID = `SiteTree`.ID LEFT JOIN `RedirectorPage` ON `RedirectorPage`.ID = `SiteTree`.ID LEFT JOIN `VirtualPage` ON `VirtualPage`.ID = `SiteTree`.ID LEFT JOIN `UserDefinedForm` ON `UserDefinedForm`.ID = `SiteTree`.ID WHERE (`SiteTree`.URLSegment = '') ORDER BY Sort LIMIT 1 Table 'mwmm_newumdurham.BlogEntry' doesn't exist
GET /newumd/admin

Line 400 in /usr/www/users/mwmm/newumd/sapphire/core/model/MySQLDatabase.php

Source

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

Couldn't run query: SELECT `SiteTree`.*, `GhostPage`.*, `BlogEntry`.*, `BlogHolder`.*, `ErrorPage`.*, `RedirectorPage`.*, `VirtualPage`.*, `UserDefinedForm`.*, `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 `ErrorPage` ON `ErrorPage`.ID = `SiteTree`.ID LEFT JOIN `RedirectorPage` ON `RedirectorPage`.ID = `SiteTree`.ID LEFT JOIN `VirtualPage` ON `VirtualPage`.ID = `SiteTree`.ID LEFT JOIN `UserDefinedForm` ON `UserDefinedForm`.ID = `SiteTree`.ID WHERE (`SiteTree`.URLSegment = '') ORDER BY Sort LIMIT 1 Table 'mwmm_newumdurham.BlogEntry' doesn't exist
Line 400 of MySQLDatabase.php
MySQLDatabase->databaseError(Couldn't run query: SELECT `SiteTree`.*, `GhostPage`.*, `BlogEntry`.*, `BlogHolder`.*, `ErrorPage`.*, `RedirectorPage`.*, `VirtualPage`.*, `UserDefinedForm`.*, `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 `ErrorPage` ON `ErrorPage`.ID = `SiteTree`.ID LEFT JOIN `RedirectorPage` ON `RedirectorPage`.ID = `SiteTree`.ID LEFT JOIN `VirtualPage` ON `VirtualPage`.ID = `SiteTree`.ID LEFT JOIN `UserDefinedForm` ON `UserDefinedForm`.ID = `SiteTree`.ID WHERE (`SiteTree`.URLSegment = '') ORDER BY Sort LIMIT 1 | Table 'mwmm_newumdurham.BlogEntry' doesn't exist,256)
Line 102 of MySQLDatabase.php
MySQLDatabase->query(SELECT `SiteTree`.*, `GhostPage`.*, `BlogEntry`.*, `BlogHolder`.*, `ErrorPage`.*, `RedirectorPage`.*, `VirtualPage`.*, `UserDefinedForm`.*, `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 `ErrorPage` ON `ErrorPage`.ID = `SiteTree`.ID LEFT JOIN `RedirectorPage` ON `RedirectorPage`.ID = `SiteTree`.ID LEFT JOIN `VirtualPage` ON `VirtualPage`.ID = `SiteTree`.ID LEFT JOIN `UserDefinedForm` ON `UserDefinedForm`.ID = `SiteTree`.ID WHERE (`SiteTree`.URLSegment = '') ORDER BY Sort LIMIT 1,256)
Line 104 of DB.php
DB::query(SELECT `SiteTree`.*, `GhostPage`.*, `BlogEntry`.*, `BlogHolder`.*, `ErrorPage`.*, `RedirectorPage`.*, `VirtualPage`.*, `UserDefinedForm`.*, `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 `ErrorPage` ON `ErrorPage`.ID = `SiteTree`.ID LEFT JOIN `RedirectorPage` ON `RedirectorPage`.ID = `SiteTree`.ID LEFT JOIN `VirtualPage` ON `VirtualPage`.ID = `SiteTree`.ID LEFT JOIN `UserDefinedForm` ON `UserDefinedForm`.ID = `SiteTree`.ID WHERE (`SiteTree`.URLSegment = '') ORDER BY Sort LIMIT 1)
Line 426 of SQLQuery.php
SQLQuery->execute()
Line 2374 of DataObject.php
DataObject->instance_get_one(`SiteTree`.URLSegment = '',)
Line 2320 of DataObject.php
DataObject::get_one(SiteTree,`SiteTree`.URLSegment = '',1,)
Line 1073 of SiteTree.php
SiteTree::get_by_url()
Line 228 of CMSMain.php
CMSMain->generateDataTreeHints()
Line 149 of CMSMain.php
CMSMain->SiteTreeAsUL()
call_user_func_array(Array,Array)
Line 409 of ViewableData.php
ViewableData->XML_val(SiteTreeAsUL,,1)
Line 260 of .cache.usr.www.users.mwmm.newumd.cms.templates.Includes.CMSMain_left.ss
include(/var/tmp/silverstripe-cache-usr-www-users-mwmm-newumd/.cache.usr.www.users.mwmm.newumd.cms.templates.Includes.CMSMain_left.ss)
Line 354 of SSViewer.php
SSViewer->process(CMSMain)
Line 774 of ViewableData.php
ViewableData->renderWith(Array)
Line 445 of LeftAndMain.php
LeftAndMain->Left()
call_user_func_array(Array,Array)
Line 409 of ViewableData.php
ViewableData->XML_val(Left,,1)
Line 59 of .cache.usr.www.users.mwmm.newumd.cms.templates.LeftAndMain.ss
include(/var/tmp/silverstripe-cache-usr-www-users-mwmm-newumd/.cache.usr.www.users.mwmm.newumd.cms.templates.LeftAndMain.ss)
Line 354 of SSViewer.php
SSViewer->process(CMSMain)
Line 175 of Controller.php
Controller->handleAction(HTTPRequest)
Line 107 of RequestHandler.php
RequestHandler->handleRequest(HTTPRequest)
Line 122 of Controller.php
Controller->handleRequest(HTTPRequest)
Line 277 of Director.php
Director::handleRequest(HTTPRequest,Session)
Line 121 of Director.php
Director::direct(/admin)
Line 115 of main.php

Thanks for any insight/assistance you can offer!

- Adam

Avatar
AdamMWMM

9 May 2009 at 4:58am Community Member, 12 Posts

Follow-up:

If I delete out the blog folder the rest of my site, including the admin section, works fine again.

I am stumped, as I literally have made no changes to the blog module at all. I simply unzipped and uploaded.

Avatar
sasdaman

10 June 2009 at 2:51am Community Member, 2 Posts

Hi,

I get something similiar after extraction into site root folder and running database build when selecting the new blog tab I see the following error attached.

Any ideas what is going on!? It's stating something about a template which im using the tutorial one for my site. Could it be that I need to specify the blackcandy_blog theme??

Any help would be greatly appreciated.

Cheers,

Sas

Attached Files
Avatar
talknmime

4 December 2009 at 9:49am Community Member, 7 Posts

I'm having the same issue. All I've done is unzip the blog module into my webroot folder and then rebuilt the database. Now I can't access the CMS. I've searched the interwebs but haven't found any answers. Can anyone help?