Jump to:

546 Posts in 2222 Topics by 237 members

Hosting Requirements

SilverStripe Forums » Hosting Requirements » Host-Europe SSS 2.4.0 and sqlite fails

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

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

Page: 1 2
Go to End
Author Topic: 2808 Views
  • gaston
    Avatar
    Community Member
    24 Posts

    Re: Host-Europe SSS 2.4.0 and sqlite fails Link to this post

    Salut Andy,

    SUCCESS!
    Now it works

    Ciao, Mathias

  • apiening
    Avatar
    Community Member
    55 Posts

    Re: Host-Europe SSS 2.4.0 and sqlite fails Link to this post

    YIPPIE !!!

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

  • gaston
    Avatar
    Community Member
    24 Posts

    Re: Host-Europe SSS 2.4.0 and sqlite fails Link to this post

    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

    2808 Views
Page: 1 2
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.