• I have one primary page in multisite wordpress. I am trying to clone it. Unfortunately, from each table only some of the rows are cloned. There are no errors in the server logs. For example, in the table “wp_options” I have 281 rows. The plugin clones only 13 of them. In the plugin logs I see such strange entries:

    ?	GENERATING create table query for wp_2_options:CREATE TABLE wp_2_options ( option_id bigint(20) unsigned NOT NULL AUTO_INCREMENT, option_name varchar(191) NOT NULL DEFAULT '', option_value longtext NOT NULL, autoload varchar(20) NOT NULL DEFAULT 'yes', PRIMARY KEY (option_id), UNIQUE KEY option_name (option_name), KEY autoload (autoload) ) ENGINE=InnoDB AUTO_INCREMENT=99678 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci
    ? SELECTED 282 with query:SELECT COUNT(*) rows_qty FROM wp_options WHERE 1=1
    ? SAVING batch for ns_cloner_rows_process with 282 items.
    ? UPDATING ns_cloner_rows_process_progress_c0faabca2cb932efcee159b474b0edcb{"total":282,"completed":0}
    ? QUEUEING 282 rows from wp_options to wp_2_options

    ? PRELOADING rows for wp_options with query:SELECT wp_options.* FROM wp_options WHERE option_id > 99150 ORDER BY option_id ASC LIMIT 250
    ? PRELOADED 13 rows for wp_options
    ? UPDATING ns_cloner_rows_process_progress_c0faabca2cb932efcee159b474b0edcb{"total":282,"completed":5}
    ? PERFORMED 1 replacements in wp_2_options
    ? UPDATING ns_cloner_rows_process_progress_c0faabca2cb932efcee159b474b0edcb{"total":282,"completed":10}
    ? PRELOADING rows for wp_options with query:SELECT wp_options.* FROM wp_options WHERE option_id > 99677 ORDER BY option_id ASC LIMIT 250
    ? PRELOADED 0 rows for wp_options
    ? WRITING notice:Missing row 13 in wp_options - could not be preloaded
    ? SKIPPING row 13 in wp_options because content was empty
    ? PRELOADING rows for wp_options with query:SELECT wp_options.* FROM wp_options WHERE option_id > 99677 ORDER BY option_id ASC LIMIT 250
    ? PRELOADED 0 rows for wp_options
    ? WRITING notice:Missing row 14 in wp_options - could not be preloaded
    ? SKIPPING row 14 in wp_options because content was empty

    ... etc.

    I have used your plugin with other sites and this is the first time I have encountered something like this. Why is there this strange condition in these sql queries?

    WHERE option_id > 99150
    WHERE option_id > 99677
    WHERE option_id > 99677
    WHERE option_id > 99677
    ... and so to the end

    I also don’t understand why the plugin adds such a row in the “wp_options” table:

    option_id | option_name | option_value
    99677 | wp_2_user_roles | a:12:{s:13:"administrator"...

    It seems that the plugin later clone only those rows from this table if they have id>99677.

Viewing 1 replies (of 1 total)
  • Plugin Author Never Settle

    (@neversettle)

    Hey @pepe80

    Thanks for bringing this up. Could you please confirm if the missing options have content in them. Empty options will not be cloned over to the target site. Please also confirm if you have set the filter ns_cloner_rows_where to set the id greater than 99677

Viewing 1 replies (of 1 total)
  • You must be logged in to reply to this topic.