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.

Hosting Requirements

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

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

Host-Europe SSS 2.4.0 and sqlite fails


Reply

11 Posts   2996 Views

Avatar
gaston

17 June 2010 at 8:03pm Community Member, 24 Posts

Salut Andy,

SUCCESS!
Now it works

Ciao, Mathias

Avatar
apiening

18 June 2010 at 9:26am Community Member, 60 Posts

YIPPIE !!!

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

Avatar
gaston

25 June 2010 at 10:27pm Community Member, 24 Posts

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