How to fix revolution slider MySQL Fatal error: Uncaught exception ‘Exception’ with message ‘fetch

Today I was playing around with Revolution Slider and had trouble getting it to run in my Multisite test environment.

Upon activation this error would pop up:

“Fatal error: Uncaught exception ‘Exception’ with message ‘fetch – <b>Unknown column ‘type’ in ‘where clause'</b><br>—<br> Query: select * from wp_revslider_sliders where type !=

To solve this edit revslider.php located in revslider root directory:

Add

$rsv = get_option('rs_version', 0);
if(version_compare($revSliderVersion, $rsv, '>')){
RevSliderFront::createDBTables();
RevSliderPluginUpdate::do_update_checks();
update_option('rs_version', $revSliderVersion);
}

Right before:

add_action('plugins_loaded', array( 'RevSliderFront', 'createDBTables' )); //add update checks
add_action('plugins_loaded', array( 'RevSliderPluginUpdate', 'do_update_checks' )); //add update checks

Also add:

update_option('revslider_table_version', '1.0.0');

right before php closing tag.

Here is how it should look:

Screen Shot

Deactivate and reactivate Revolution Slider.
This should fix the error.

 

Related Posts

Powered By Related Posts for WordPress

One Reply to “How to fix revolution slider MySQL Fatal error: Uncaught exception ‘Exception’ with message ‘fetch”

Leave a Reply

Your email address will not be published. Required fields are marked *