Note: I have 3 sites running on managed DO databases and all are doing fine except for this issue.

I have reviewed the WordPress error log and engaged the author of the Vimeography Pro plugin and after reviewing the site as an Admin here what he concluded:

“
This is a simple WordPress database insert that really would only fail if the table doesn’t exist or you’ve otherwise made some modifications to the $wpdb global.

I would recommend your developer look closely at the database structure to be sure there is a table called wp_vimeography_pro_meta with the correct structure.

  public static function create_vimeography_pro_gallery($id) {
    global $wpdb;

    $row = $wpdb->insert(
      $wpdb->vimeography_pro_meta,
      array(
        'gallery_id' => $id,
        'per_page'   => 20,
        'sort'       => 'default',
        'direction'  => 'desc',
        'playlist'   => 0,
        'allow_downloads' => 0,
        'enable_search' => 0,
        'enable_tags' => 0
      ),
      array('%d', '%d', '%s', '%s', '%d', '%d', '%d', '%d')
    );

    if ( ! $row ) {
      throw new Vimegraphy_Exception( __('Your Vimeography Pro gallery settings could not be saved.') );
    }

    return TRUE;
  }
"

It all started with the following persistent Wordpress error:

An error of type E_ERROR was caused in line 38 of the file /var/www/html/wp-content/plugins/vimeography-pro/lib/admin/view/gallery/new.php. Error message: Uncaught Error: Class 'Vimegraphy_Exception' not found in /var/www/html/wp-content/plugins/vimeography-pro/lib/admin/view/gallery/new.php:38
Stack trace:
#0 /var/www/html/wp-includes/class-wp-hook.php(288): Vimeography_Pro_Gallery_New->create_vimeography_pro_gallery(10)
#1 /var/www/html/wp-includes/class-wp-hook.php(312): WP_Hook->apply_filters('', Array)
#2 /var/www/html/wp-includes/plugin.php(478): WP_Hook->do_action(Array)
#3 /var/www/html/wp-content/plugins/vimeography/lib/admin/controllers/gallery/new.php(48): do_action('vimeography-pro...', 10)
#4 /var/www/html/wp-content/plugins/vimeography-pro/lib/admin/view/gallery/new.php(12): Vimeography_Gallery_New->__construct()
#5 /var/www/html/wp-content/plugins/vimeography/lib/admin/menu.php(112): Vimeography_Pro_Gallery_New->__construct()
#6 /var/www/html/wp-includes/class-wp-hook.php(288): Vimeography_Admin_Menu->load_new_gallery_page('')
#7 /var/www/html/wp-includes/class-wp-hook.php(312): WP_Hook->apply_filters('', Array)
#8 /var/www/html/wp-includes/plugi

I’ve tried the following in the global SQL mode in the Settings page of the Database Cluster Digitalocean cluster but it hasn’t helped:
1) Traditional
2) ANSI, NOZEROINDATE, NOZERODATE, ERRORFORDIVISIONBYZERO,NOENGINE_SUBSTITUTION

Thanks
James