Title: Multisite bug Last modified: May 16, 2020 --- # Multisite bug * [annabelle75](https://wordpress.org/support/users/annabelle75/) * (@annabelle75) * [6 years ago](https://wordpress.org/support/topic/multisite-bug-7/) * The Error: * 1) Install Multisite 2) Install wpforms-db 3) Network activate wpforms-db * It’ll then iterate through all the blogs and create the wp_%_wpforms_db table. * The problem is if, after network activating it, go and create more sites, the activate loop isn’t called and so wpforms_db doesn’t work for each new multisite. * A simple hack is to check if the table exists in the WPFormsDB_save, if not then create it. Starting on line 101 * ``` if( $wpform->get_var("SHOW TABLES LIKE '$table_name'") != $table_name ) { WPFormsDB_create_table(); } ``` * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fmultisite-bug-7%2F%3Foutput_format%3Dmd&locale=en_US) to see the link]_ Viewing 1 replies (of 1 total) * Thread Starter [annabelle75](https://wordpress.org/support/users/annabelle75/) * (@annabelle75) * [6 years ago](https://wordpress.org/support/topic/multisite-bug-7/#post-12845846) * Couldn’t figure out how to upload, so for anyone who isn’t comfortable editing source files, the final wp-content/plugins/database-for-wpforms/database-for- wp-forms.php can be saved and uploaded to your own site… * Hope this is okay to post here! Apologies if not. * ``` download_csv_file(); } new WPFormsDB_Wp_Main_Page; } } function WPFormsDB_create_table(){ global $wpdb; $wpform = apply_filters( 'WPFormsDB_database', $wpdb ); $table_name = $wpform->prefix.'wpforms_db'; if( $wpform->get_var("SHOW TABLES LIKE '$table_name'") != $table_name ) { $charset_collate = $wpform->get_charset_collate(); $sql = "CREATE TABLE $table_name ( form_id bigint(20) NOT NULL AUTO_INCREMENT, form_post_id bigint(20) NOT NULL, form_value longtext NOT NULL, form_date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, PRIMARY KEY (form_id) ) $charset_collate;"; require_once( ABSPATH . 'wp-admin/includes/upgrade.php' ); dbDelta( $sql ); } add_option( 'WPFormsDB_view_install_date', date('Y-m-d G:i:s'), '', 'yes'); } function WPFormsDB_on_activate( $network_wide ){ global $wpdb; if ( is_multisite() && $network_wide ) { // Get all blogs in the network and activate plugin on each one $blog_ids = $wpdb->get_col( "SELECT blog_id FROM $wpdb->blogs" ); foreach ( $blog_ids as $blog_id ) { switch_to_blog( $blog_id ); WPFormsDB_create_table(); restore_current_blog(); } } else { WPFormsDB_create_table(); } // Add custom capability $role = get_role( 'administrator' ); $role->add_cap( 'WPFormsDB_access' ); } register_activation_hook( __FILE__, 'WPFormsDB_on_activate' ); function WPFormsDB_on_deactivate() { // Remove custom capability from all roles global $wp_roles; foreach( array_keys( $wp_roles->roles ) as $role ) { $wp_roles->remove_cap( $role, 'WPFormsDB_access' ); } } register_deactivation_hook( __FILE__, 'WPFormsDB_on_deactivate' ); function WPFormsDB_save( $fields, $entry, $form_id ) { global $wpdb; $wpform = apply_filters( 'WPFormsDB_database', $wpdb ); $table_name = $wpform->prefix.'wpforms_db'; $upload_dir = wp_upload_dir(); // added by Annabelle75 5/16/2020 to fix multisite issue if( $wpform->get_var("SHOW TABLES LIKE '$table_name'") != $table_name ) { WPFormsDB_create_table(); } if ( $fields ) { $data = $fields; $uploaded_files = array(); $form_data = array(); $form_data['WPFormsDB_status'] = 'unread'; foreach ($data as $key => $d) { $d['value'] = is_array( $d['value'] ) ? implode(',', $d['value']) : $d['value']; $bl = array('\"',"\'",'/','\\','"',"'"); $wl = array('"',''','/', '\','"','''); $d['value'] = str_replace($bl, $wl, $d['value'] ); $form_data[ $d['name'] ] = $d['value']; } /* WPFormsDB before save data. */ $form_data = apply_filters('WPFormsDB_before_save_data', $form_data); do_action( 'WPFormsDB_before_save_data', $form_data ); $form_post_id = $form_id; $form_value = serialize( $form_data ); $form_date = current_time('Y-m-d H:i:s'); $wpform->insert( $table_name, array( 'form_post_id' => $form_post_id, 'form_value' => $form_value, 'form_date' => $form_date ) ); /* WPFormsDB after save data */ $insert_id = $wpform->insert_id; do_action( 'WPFormsDB_after_save_data', $insert_id ); } } add_action( 'wpforms_process_entry_save', 'WPFormsDB_save', 10, 3 ); /** * Plugin settings link * @param array $links list of links * @return array of links */ function wpformsdb_settings_link( $links ) { $forms_link = 'WPForms DB'; array_unshift($links, $forms_link); return $links; } $plugin = plugin_basename(__FILE__); add_filter("plugin_action_links_$plugin", 'wpformsdb_settings_link' ); add_action( 'admin_notices', 'wpformsdb_admin_notice' ); add_action('admin_init', 'wpformsdb_view_ignore_notice' ); function wpformsdb_admin_notice() { $install_date = get_option( 'WPFormsDB_view_install_date', ''); $install_date = date_create( $install_date ); $date_now = date_create( date('Y-m-d G:i:s') ); $date_diff = date_diff( $install_date, $date_now ); if ( $date_diff->format("%d") < 7 ) { return false; } if ( ! get_option( 'wpformsdb_view_ignore_notice' ) ) { echo '

'; printf(__( 'Awesome, you\'ve been using WPForms DB for more than 1 week. Ma 'https://wordpress.org/plugins/database-for-wpforms/'); echo "

"; } } function wpformsdb_view_ignore_notice() { if ( isset($_GET['wpformsdb-ignore-notice']) && '0' == $_GET['wpformsdb-ignore-notice'] ) { update_option( 'wpformsdb_view_ignore_notice', 'true' ); } } ``` Viewing 1 replies (of 1 total) The topic ‘Multisite bug’ is closed to new replies. * ![](https://ps.w.org/database-for-wpforms/assets/icon-256x256.png?rev=2065506) * [Database Addon For WPForms ( wpforms entries ) - WPFormsDB](https://wordpress.org/plugins/database-for-wpforms/) * [Support Threads](https://wordpress.org/support/plugin/database-for-wpforms/) * [Active Topics](https://wordpress.org/support/plugin/database-for-wpforms/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/database-for-wpforms/unresolved/) * [Reviews](https://wordpress.org/support/plugin/database-for-wpforms/reviews/) ## Tags * [bugfix](https://wordpress.org/support/topic-tag/bugfix/) * 1 reply * 1 participant * Last reply from: [annabelle75](https://wordpress.org/support/users/annabelle75/) * Last activity: [6 years ago](https://wordpress.org/support/topic/multisite-bug-7/#post-12845846) * Status: not resolved