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

Avatar
gaston

Community Member, 24 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, 24 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