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.

Installing SilverStripe /

Getting SilverStripe up and running on your computer and on your web server.

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

You need mod_rewrite to use friendly URLs with SilverStripe, but it is not enabled.


Reply


2 Posts   2256 Views

Avatar
gerrymax

Community Member, 1 Post

27 November 2010 at 6:54am

Hello,

Trying to install latest version. Software looks awsome by the way.

I'm having issues right after the install, I get the following error:

[User Error] Couldn't run query: ALTER TABLE "Page" RENAME "_obsolete_Page" Table 'concep22_voyagesalm.Page' doesn't exist
POST /Projets/ALM2/install.php

I'm hosted at JustHost. I have contacted them andthey told me this : mod_rewrite is enabled by default on all our servers, it looks like there is some problem with script you are trying to install, please make sure that you have uploaded all needed files and contact it's developers.

I'have looked somewhere in the forum and tried to add this in my .htaccess :
### SILVERSTRIPE START ###
<Files *.ss>
   Order deny,allow
   Deny from all
   Allow from 127.0.0.1
</Files>

<Files web.config>
   Order deny,allow
   Deny from all
</Files>

ErrorDocument 404 /assets/error-404.html
ErrorDocument 500 /assets/error-500.html

<IfModule mod_alias.c>
   RedirectMatch 403 /silverstripe-cache(/|$)
</IfModule>

<IfModule mod_rewrite.c>
   RewriteEngine On
   RewriteBase /Projets/ALM2

   RewriteCond %{REQUEST_URI} ^(.*)$
   RewriteCond %{REQUEST_FILENAME} !-f
   RewriteRule .* sapphire/main.php?url=%1&%{QUERY_STRING} [L,R]
</IfModule>
### SILVERSTRIPE END ###

(the R)

Still not working.

When I go back to the install page, it gives me this still :

Line 526 in /home/concep22/public_html/Projets/ALM2/sapphire/core/model/MySQLDatabase.php

Source
517    }
518    
519    function databaseError($msg, $errorLevel = E_USER_ERROR) {
520       // try to extract and format query
521       if(preg_match('/Couldn\'t run query: ([^\|]*)\|\s*(.*)/', $msg, $matches)) {
522          $formatter = new SQLFormatter();
523          $msg = "Couldn't run query: \n" . $formatter->formatPlain($matches[1]) . "\n\n" . $matches[2];
524       }
525       
526       user_error($msg, $errorLevel);
527    }
528    
529    /**
530     * Return a boolean type-formatted string
531     *
532     * @param array $values Contains a tokenised list of info about this data type

Can someone please help me ?

thanks a lot,

Geraldine

Avatar
Sean

Forum Moderator, 922 Posts

28 November 2010 at 2:45pm

Hi there,

After the installation has failed, have you tried browsing to the site anyway?
You could also try this: http://mysite.com/dev/build?flush=all

That will attempt to rebuild the database, which by the looks of it seems to be incomplete given the MySQL errors there.

Cheers,
Sean