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   1961 Views

Avatar
AdamMWMM

Community Member, 12 Posts

9 May 2009 at 4:55am

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

Community Member, 12 Posts

9 May 2009 at 4:58am

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

Community Member, 2 Posts

10 June 2009 at 2:51am

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

Community Member, 7 Posts

4 December 2009 at 9:49am

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?