Error executing query DELETE FROM _duplicator_packages

  • Resolved hommealone

    (@hommealone)


    1 year, 9 months ago

    Hi. I created a duplicator package from the old site. I excluded the duplicator package tables from the package. (Was that a mistake?)

    While trying the install on a new server, I get this error message in Step 4:

    Error executing query DELETE FROM [duplicated database name]_duplicator_packages WHERE 1 = 1 LIMIT 500. Table '[new database name].[duplicated database name]_duplicator_packages' doesn't exist.

    In Step 2 under “Import and Update“, I’ve tried all combinations of enabling/disabling the two options (import and update) for the “[duplicated database name]_duplicator_packages” table, but I get the same result each way.

    Is there anything I can do besides starting over from scratch?

    Here’s the log file (with specifics redacted):

    ********************************************************************************
DUPLICATOR LITE: INSTALL-LOG
STEP-3 START @ 05:29:25
NOTICE: Do NOT post to public sites or forums
********************************************************************************
CHARSET SERVER:	"utf8mb4"
CHARSET CLIENT:	"utf8mb4"
********************************************************************************
OPTIONS:
SKIP PATH REPLACE_____: false
DISALLOW_FILE_EDIT____: [value = 1], [inWpConfig = 1]
DISALLOW_FILE_MODS____: [value = ], [inWpConfig = ]
AUTOSAVE_INTERVAL_____: [value = 60], [inWpConfig = ]
WP_POST_REVISIONS_____: [value = 1], [inWpConfig = ]
FORCE_SSL_ADMIN_______: [value = ], [inWpConfig = ]
WP_AUTO_UPDATE_CORE___: [value = false], [inWpConfig = ]
WP_CACHE______________: [value = 1], [inWpConfig = 1]
WPCACHEHOME___________: [value = /], [inWpConfig = ]
WP_DEBUG______________: [value = ], [inWpConfig = 1]
WP_DEBUG_LOG__________: [value = ], [inWpConfig = ]
WP_DEBUG_DISPLAY______: [value = 1], [inWpConfig = ]
WP_DISABLE_FATAL_ERROR_HANDLER: [value = ], [inWpConfig = ]
SCRIPT_DEBUG__________: [value = ], [inWpConfig = ]
CONCATENATE_SCRIPTS___: [value = ], [inWpConfig = ]
SAVEQUERIES___________: [value = ], [inWpConfig = ]
ALTERNATE_WP_CRON_____: [value = ], [inWpConfig = ]
DISABLE_WP_CRON_______: [value = 1], [inWpConfig = 1]
WP_CRON_LOCK_TIMEOUT__: [value = 60], [inWpConfig = ]
COOKIE_DOMAIN_________: [value = ], [inWpConfig = ]
WP_MEMORY_LIMIT_______: [value = 256M], [inWpConfig = 1]
WP_MAX_MEMORY_LIMIT___: [value = 256M], [inWpConfig = ]
WP_TEMP_DIR___________: [value = ], [inWpConfig = ]
********************************************************************************

********************************************************************************
CHUNK PARAMS:
maxIteration__________: 0
timeOut_______________: 5000
throttling____________: 2
rowsPerPage___________: 1000
********************************************************************************

CHUNK ACTION: CURRENT [cleanup_trans][][]
CLEAN OPTIONS [[old-dbname]_options]
	option_name LIKE "\_transient%"
	option_name LIKE "\_site\_transient%"
	option_name IN ("duplicator_ui_view_state","duplicator_package_active","duplicator_settings","duplicator_is_pro_enable_notice_dismissed")
DATABASE OPTIONS DELETED [ROWS:     0]
CHUNK ACTION: CURRENT [cleanup_extra][][]
CLEANUP EXTRA
	- SKIP DROP VIEWS
	- SKIP DROP PROCS
	- SKIP DROP FUNCS
CHUNK ACTION: CURRENT [cleanup_packages][][]
EMPTY PACKAGES TABLE
CLEAN PACKAGES
DB QUERY [ERROR][/path/to/root/public_html/dup-installer/classes/database/class.db.php:639] MSG: Table '[new-dbname].[old-dbname]_duplicator_packages' doesn't exist
	SQL: DELETE FROM [old-dbname]_duplicator_packages WHERE 1 = 1 LIMIT 500
TRACE[1] CLASS___: DUPX_DB::mysqli_query      FILE: /path/to/root/public_html/dup-installer/classes/database/class.db.php[475]
TRACE[2] CLASS___: DUPX_DB::queryNoReturn     FILE: /path/to/root/public_html/dup-installer/classes/database/class.db.php[683]
TRACE[3] CLASS___: DUPX_DB::chunksDelete      FILE: /path/to/root/public_html/dup-installer/src/Core/Deploy/Database/DbCleanup.php[141]
TRACE[4] CLASS___: Duplicator\Installer\Core\Deploy\Database\DbCleanup::emptyDuplicatorPackages FILE: /path/to/root/public_html/dup-installer/src/Core/Deploy/Database/DbCleanup.php[68]
TRACE[5] CLASS___: Duplicator\Installer\Core\Deploy\Database\DbCleanup::cleanupPackages FILE: /path/to/root/public_html/dup-installer/classes/chunk/class.chunk.s3.manager.php[54]
TRACE[6] CLASS___: DUPX_chunkS3Manager->action FILE: /path/to/root/public_html/dup-installer/classes/chunk/class.chunkingmanager.php[100]
TRACE[7] CLASS___: DUPX_ChunkingManager->start FILE: /path/to/root/public_html/dup-installer/ctrls/classes/class.ctrl.s3.funcs.php[102]
TRACE[8] CLASS___: DUPX_S3_Funcs->updateWebsite FILE: /path/to/root/public_html/dup-installer/ctrls/classes/class.ctrl.ajax.php[216]
TRACE[9] CLASS___: DUPX_Ctrl_ajax::actions    FILE: /path/to/root/public_html/dup-installer/ctrls/classes/class.ctrl.ajax.php[93]
TRACE[10] CLASS___: DUPX_Ctrl_ajax::controller FILE: /path/to/root/public_html/dup-installer/main.installer.php[56]


EXCEPTION ERROR:  Error executing query DELETE FROM [old-dbname]_duplicator_packages WHERE 1 = 1 LIMIT 500.<br/>Table '[new-dbname].[old-dbname]_duplicator_packages' doesn't exist
	FILE:/path/to/root/public_html/dup-installer/classes/database/class.db.php[477]
	TRACE:
#0 /path/to/root/public_html/dup-installer/classes/database/class.db.php(683): DUPX_DB::queryNoReturn()
#1 /path/to/root/public_html/dup-installer/src/Core/Deploy/Database/DbCleanup.php(141): DUPX_DB::chunksDelete()
#2 /path/to/root/public_html/dup-installer/src/Core/Deploy/Database/DbCleanup.php(68): Duplicator\Installer\Core\Deploy\Database\DbCleanup::emptyDuplicatorPackages()
#3 /path/to/root/public_html/dup-installer/classes/chunk/class.chunk.s3.manager.php(54): Duplicator\Installer\Core\Deploy\Database\DbCleanup::cleanupPackages()
#4 /path/to/root/public_html/dup-installer/classes/chunk/class.chunkingmanager.php(100): DUPX_chunkS3Manager->action()
#5 /path/to/root/public_html/dup-installer/ctrls/classes/class.ctrl.s3.funcs.php(102): DUPX_ChunkingManager->start()
#6 /path/to/root/public_html/dup-installer/ctrls/classes/class.ctrl.ajax.php(216): DUPX_S3_Funcs->updateWebsite()
#7 /path/to/root/public_html/dup-installer/ctrls/classes/class.ctrl.ajax.php(93): DUPX_Ctrl_ajax::actions()
#8 /path/to/root/public_html/dup-installer/main.installer.php(56): DUPX_Ctrl_ajax::controller()
#9 {main}

AJAX ACTION [webupdate] FAIL, MESSAGE: Error executing query DELETE FROM [old-dbname]_duplicator_packages WHERE 1 = 1 LIMIT 500.<br/>Table '[new-dbname].[old-dbname]_duplicator_packages' doesn't exist
-------------------------

LOG-TIME[/path/to/root/public_html/dup-installer/src/Core/Bootstrap.php:72] RESET TIME
LOG-TIME[/path/to/root/public_html/dup-installer/ctrls/ctrl.base.php:227][DELTA:   0.01506]  MESSAGE:END RENDER PAGE
Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support devdavidam

    (@devdavidam)

    Hi @hommealone, it would be better to create a new package without filtering that table. However, if you want to proceed with the one you already have you should be able to finish the installation by entering Advanced Mode and after Step 2 create the mentioned table manually after which continue with the installation.

    Thread Starter hommealone

    (@hommealone)

    Thanks for your reply! I ended up needing to start over, but then it worked. Much appreciated!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Error executing query DELETE FROM _duplicator_packages’ is closed to new replies.