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.

Hosting Requirements /

What you need to consider when choosing a hosting provider and plan.

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

Host-Europe SSS 2.4.0 and sqlite fails


Go to End


11 Posts   6500 Views

Avatar
gaston

Community Member, 26 Posts

17 June 2010 at 8:03pm

Salut Andy,

SUCCESS!
Now it works

Ciao, Mathias

Avatar
apiening

Community Member, 60 Posts

18 June 2010 at 9:26am

YIPPIE !!!

good work, mate. keep me posted on the progress with your SQLite project.

Avatar
gaston

Community Member, 26 Posts

25 June 2010 at 10:27pm

Salut,

as a folowup and for completeness:
The Zend temp directory handling has to be set as the default points to /tmp which is not accessible in the shared environment:
include

// Zend_Cache temp directory setting 
	$_ENV['TMPDIR'] = TEMP_FOLDER; 

otherwise, the CMS editing will not work.

For completeness, here the _config.php file

<?php

global $project;
$project = 'mysite';

global $databaseConfig;
$databaseConfig = array(
	"type" => 'SQLite3Database',
	"server" => '', 
	"username" => '', 
	"password" => '', 
	"database" => 'SS_mysite',
	"path" => '/is/htdocs/wpxxxxxxx_XXXXXXXXXX/www/SStest/assets/.db',
);

// Sites running on the following servers will be
// run in development mode. See
// http://doc.silverstripe.org/doku.php?id=configuration
// for a description of what dev mode does.
Director::set_dev_servers(array(
	'localhost',
	'127.0.0.1'
));

MySQLDatabase::set_connection_charset('utf8');

// This line set's the current theme. More themes can be
// downloaded from http://www.silverstripe.org/themes/
SSViewer::set_theme('blackcandy');

// Set the site locale
i18n::set_locale('en_US');

// enable nested URLs for this site (e.g. page/sub-page/)
SiteTree::enable_nested_urls();

//MOW SQlite fix
SQLite3Database::$default_pragma['temp_store'] = "MEMORY"; 
SQLite3Database::$vacuum = false;

//MOW Zend_Cache temp directory setting 
	$_ENV['TMPDIR'] = TEMP_FOLDER; 

Enjoy! Mathias

Go to Top