Only some of the rows are cloned and strange entry “wp_2_user_roles”
-
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 KEYoption_name
(option_name
), KEYautoload
(autoload
) ) ENGINE=InnoDB AUTO_INCREMENT=99678 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci
? SELECTED 282 with query:SELECT COUNT(*) rows_qty FROMwp_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.* FROMwp_options
WHEREoption_id
> 99150 ORDER BYoption_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.* FROMwp_options
WHEREoption_id
> 99677 ORDER BYoption_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.* FROMwp_options
WHEREoption_id
> 99677 ORDER BYoption_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
WHEREoption_id
> 99677
WHEREoption_id
> 99677
WHEREoption_id
> 99677
... and so to the endI 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.
- You must be logged in to reply to this topic.