Blog

If you are running your site on SilverStripe CMS and need to migrate it to another machine but don't know how, you are at the right place.

{mobile_block=responsive_ad_728_90}

In the following steps we're going to describe how to migrate SilverStripe to new server:

1) Backup the database

2) Restore the database to another server

3) Copy all files to new server

4) Set permissions for folders assets and silverstripe-cache:

chmod 777 assets
 
chmod 777 silverstripe-cache

A couple days ago we received an email from Twitter, informing us that someone had tried to reset password on our twitter account.

The email was:

{mobile_block=responsive_ad_728_90}

Hi,

Twitter believes that your account may have been compromised by a website or service not associated with Twitter. We've reset your password to prevent others from accessing your account.

There are many situations when it is needed to update one table from another table with SQL. We're providing the way we use all the time and it is also clear for understanding even for SQL beginners.

Here is the SQL code for updating one table from another table, just replace table and column names:

UPDATE t1
SET Column1 = t2.Column1
FROM Table1 t1 INNER JOIN Table2 t2
ON t1.Column2 = t2.Column2
WHERE t1.Column3 = 'something'

{mobile_block=responsive_ad_2_300_250}

Syntax Highlighter is a fully functional self-contained code syntax highlighter in JavaScript developed by Alex Gorbatchev (http://alexgorbatchev.com/SyntaxHighlighter/) 
 
In our previous articles we described how to integrate Syntax Highlighter into SilverStripe CMS and how to remove green icon in Syntax Highligher.
 
However, many users reported that some browsers (Chromium, Firefox...) have problems with displaying scrollbars in Syntax Highligher.

{mobile_block=responsive_ad_728_90}

As developers, we often work with SQL Server stored procedures. The SQL Server stored procedures can have many purposes.

One of them is to perform some logical operations and to return true or false value. The problem is that there is no boolean datatype so the only way is that stored procedure returns bit datatype.

Here is an example of stored procedure that will return bit value that could be used instead of boolean:

{mobile_block=responsive_ad_2_300_250}