Plugin: Slider Revolution - ProjectNami/projectnami GitHub Wiki

A small instruction page for making Slider Revolution to work. Instructions have been created for version: 5.2.4.1.

Database

In order to get the database to work, please add the following fields to these tables. You can do this with Microsoft SQL Server Management Studio.

wp_revsider_css

Column Name	Data type	Allow Nulls
advanced	nvarchar(MAX)	yes

wp_revsider_sliders

Column Name	Data type	Allow Nulls
type	nvarchar(MAX)	yes
settings	nvarchar(MAX)	yes

wp_revsider_slide

Column Name	Data type	Allow Nulls
settings	nvarchar(MAX)	yes

Files

Edit the following file or use the Git patch

revslider/includes/slider.class.php

Basically, we need to add an extra check for the type != 'template' lines because in Microsoft SQL, this doesn't include the rows that have NULL values. To include the NULL values, we can transform it to type != 'template' OR type IS NULL

Formating Line number : code

105: $where = $this->db->prepare("(alias = %s AND (type != 'template' OR type IS NULL))", array($alias));

281: $response = $wpdb->get_row($wpdb->prepare("SELECT * FROM ".RevSliderGlobals::$table_sliders." WHERE (alias = %s AND (type != 'template' OR type IS NULL))", $alias));

2795: //$where = "`type` != 'template'";

2796: $where = "type != 'template' OR type IS NULL";