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.

Blog Module /

Discuss the Blog Module.

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

Blog Module Installation Problems...


Go to End


4 Posts   2876 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?