“Table ‘mysite.wp_xcloner_scheduler’ doesn’t exist”

Weird, that table should have been installed at the plugin activation time.

While i look more into it, here is the mysql structure for the missing table, you can run it through phpmyadmin

CREATE TABLE IF NOT EXISTS mysite.wp_xcloner_scheduler (
id int(11) NOT NULL AUTO_INCREMENT,
name varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
recurrence varchar(10) CHARACTER SET latin1 NOT NULL,
params text CHARACTER SET latin1 NOT NULL,
start_at datetime,
remote_storage varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
hash varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
status int(1) NOT NULL,
last_backup varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (id)
)

make sure to replace the database and table prefix name before running it

• This reply was modified 8 years ago by XCloner.

Seems your mysql server might complain about the query above, could you try this new one and let me know if it still fails? Also, please let us know what mysql server you are running?

CREATE TABLE IF NOT EXISTS mysite.wp_xcloner_scheduler (
id int(11) NOT NULL AUTO_INCREMENT,
name varchar(255) NOT NULL,
recurrence varchar(10) NOT NULL,
params text NOT NULL,
start_at datetime,
remote_storage varchar(10) DEFAULT NULL,
hash varchar(10) DEFAULT NULL,
status int(1) NOT NULL,
last_backup varchar(100) DEFAULT NULL,
PRIMARY KEY (id)
)

I have updated the plugin package, so you could try that as well

• This reply was modified 8 years ago by XCloner.

I uninstalled plugin and re-installed on 2 of my sites and it now it is working without throwing an error. Something you did fixed it.

Thank you very much for the awesome quick support ?? I love Xcloner

Dave

Resolved… Thanks again

Awesome, i will mark this as resolved!

Had the same issue: “Table ‘mysite.wp_xcloner_scheduler’ doesn’t exist”.
Uninstalled, reinstalled and all seems to be good.
FYI – I carried out the normal plugin update, but then received the error.
I’m running multisite, so don’t know if that’d have an impact, but might be worth checking out the update process?
Either way, great plugin! Many thanks for your work.

It seems when updating the plugin from backend, WordPress does not call the activate action where it has the updated mysql query, so i’ve added a fix for the activation method to be called on XCloner Dashboard init, this should fix future upgrade issues

Apologies, think I spoke too soon since I am still receiving errors. Here’s an extract from my error_log:

[28-Feb-2017 06:36:06 UTC] WordPress database error Table 'user_database.multisite_xcloner_scheduler' doesn't exist for query SELECT * FROM multisite_xcloner_scheduler made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), include_once('/plugins/xcloner-backup-and-restore/xcloner.php'), run_xcloner, Xcloner->init, Xcloner->define_cron_hooks, Xcloner_Scheduler->update_multisite_cron_hooks, Xcloner_Scheduler->get_scheduler_list
[28-Feb-2017 08:34:35 UTC] WordPress database error Table 'user_database.multisite_5_xcloner_scheduler' doesn't exist for query SELECT * FROM multisite_5_xcloner_scheduler made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), include_once('/plugins/xcloner-backup-and-restore/xcloner.php'), run_xcloner, Xcloner->init, Xcloner->define_cron_hooks, Xcloner_Scheduler->update_multisite_cron_hooks, Xcloner_Scheduler->get_scheduler_list
[28-Feb-2017 08:51:12 UTC] WordPress database error Table 'user_database.multisite_11_xcloner_scheduler' doesn't exist for query SELECT * FROM multisite_11_xcloner_scheduler made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), include_once('/plugins/xcloner-backup-and-restore/xcloner.php'), run_xcloner, Xcloner->init, Xcloner->define_cron_hooks, Xcloner_Scheduler->update_multisite_cron_hooks, Xcloner_Scheduler->get_scheduler_list
[28-Feb-2017 08:52:40 UTC] WordPress database error Table 'user_database.multisite_6_xcloner_scheduler' doesn't exist for query SELECT * FROM multisite_6_xcloner_scheduler made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), include_once('/plugins/xcloner-backup-and-restore/xcloner.php'), run_xcloner, Xcloner->init, Xcloner->define_cron_hooks, Xcloner_Scheduler->update_multisite_cron_hooks, Xcloner_Scheduler->get_scheduler_list
[28-Feb-2017 09:18:20 UTC] WordPress database error Table 'user_database.multisite_2_xcloner_scheduler' doesn't exist for query SELECT * FROM multisite_2_xcloner_scheduler made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), include_once('/plugins/xcloner-backup-and-restore/xcloner.php'), run_xcloner, Xcloner->init, Xcloner->define_cron_hooks, Xcloner_Scheduler->update_multisite_cron_hooks, Xcloner_Scheduler->get_scheduler_list
[28-Feb-2017 09:31:10 UTC] WordPress database error Table 'user_database.multisite_13_xcloner_scheduler' doesn't exist for query SELECT * FROM multisite_13_xcloner_scheduler made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), include_once('/plugins/xcloner-backup-and-restore/xcloner.php'), run_xcloner, Xcloner->init, Xcloner->define_cron_hooks, Xcloner_Scheduler->update_multisite_cron_hooks, Xcloner_Scheduler->get_scheduler_list

Notice the first line is from before I found this thread this morning and then applied the uninstall/reinstall fix. But since then I’ve found additional errors, relating to my multisite install.

I’m wondering if I were to simply copy the recent ‘wp_xcloner_scheduler’ table to the appropriate multisite versions if this would fix the issue. My gut feel is that it would work, but this doesn’t feel like it’s the right solution, especially as I have 16 ‘sites’ running in my multisite setup. I’m guessing this wouldn’t hurt for now, but perhaps the installer/update script should check and loop through any multisite variations?

Cheers,

Derrick

Derrick, try and reinstall XCloner latest version and then go into one of your subsites directly to XCloner Dashboard, that should fix the missing tables

Please let me know if you still have issues after

I did post another update just now, so XCloner checks automatically on load for it’s db version and create the missing tables, see if this one helps

Hi Liuta. I carried out another uninstall/reinstall and saw that it has indeed created the additional sub-multisite tables. Only the initial table has any associated rows, all other sub-multisite tables are empty – hopefully that won’t be a problem??

Otherwise, I think it’s all good now & will keep an eye on the logs.

Many thanks!

Derrick

The table rows are initially empty, they will get filled in when you will set a schedule to run automatic backups on each site

Thank for confirming it’s working. Will mark this issue as resolved for now