Worked on everything except wp_posts table

Hi Delicious Brains –

I’m using your plugin to change URLs for a site I just moved. I was able to find and replace on all tables except for the wp_posts table. Size of the table is (1428.52 MB), if that matters. I get the error “An error occurred processing your request. Try decreasing the “Max Page Size”, or contact support.”

I tried setting the Max Size to minimum 1000, but I have the same problem. My Help info and Debug Results are below. Any help would be greatly appreciated!

Thanks,
Mary

Begin System Info

-- WordPress Configuration

Site URL: [hidden]
Home URL: [hidden]
Multisite: No
Version: 6.9
Language: en_US
Table Prefix: Length: 3
WP_DEBUG: Enabled
Memory Limit: 40M

-- Better Search Replace Configuration

Plugin Version: 1.4.10
Max Page Size: 1000

-- Server Configuration

Operating System: Linux
PHP Version: 8.3.28
MySQL Version: 8.0.44
Server Software: Apache

-- PHP Configuration

Memory Limit: 512M
Post Max Size: 516M
Upload Max Filesize: 512M
Time Limit: 60
Max Input Vars: 1000
Display Errors: N/A

-- WordPress Active Plugins

Akismet Anti-spam: Spam Protection: 5.6
Better Search Replace: 1.4.10
Carousel Slider Block: 2.0.6
CatFolders Document Gallery: 2.0.4
CatFolders Pro - WP Media Folders: 2.5.3.1
CoBlocks: 3.1.16
Conditional Menus: 1.2.6
Content Control: 2.6.5
CSS Hero: 5.1.0
Debug Log Manager Tool: 2.0.1
Duplicate Page: 4.5.6
Formidable API: 1.18
Formidable Datepicker Options: 3.0
Formidable Export View to CSV: 1.10
Formidable Form Action Automation: 2.09
Formidable Forms: 6.26.1
Formidable Forms Pro: 6.26.2
Formidable Geolocation: 1.3.4
Formidable Google Sheets: 1.0.5
Formidable Logs: 1.0.4
Formidable PDFs: 2.0.6
Formidable Registration: 3.0.1
Formidable Stripe: 3.1.8
Formidable Surveys: 1.1.5
Formidable Test Mode: 1.0
Formidable Visual Views: 5.8
Gravatar Enhanced: 0.13.0
Jetpack VaultPress Backup: 3.7.1
Layout Grid: 1.8.5
Online Active Users: 3.1
Select Specific List Page Block: 1.0
ShortPixel Image Optimizer: 6.4.1
Table Sorter: 2.3
Temporary Login Without Password: 1.9.7
WPCode Pro: 2.3.2.1
WP File Manager: 8.0.2
WP Mail SMTP Pro: 4.7.1
WP phpMyAdmin: 5.2.2.01

-- WordPress Inactive Plugins

Classic Editor: 1.6.7
Duplicator Pro: 4.5.23.2
Formidable AI: 2.1
Jetpack: 15.3.1
Jetpack Protect: 4.4.1
Members: 3.2.18
Query Monitor: 3.20.2
Restrict Usernames Emails Characters: 4.1.2
The Bluehost Plugin: 4.5.1
URL Shortify: 1.11.4
User Switching: 1.11.1
WordPress Importer: 0.9.5
WP Crontrol: 1.20.0
WP Mail Logging: 1.15.0 End System Info

—————-

Error Stack Trace
Error Message

PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 598016 bytes) in /home2/pwumximy/public_html/wp-includes/class-wpdb.php on line 2328
Location
File:
Line: 2328Stack Trace
1 Unknown:0Error occurred in /home2/pwumximy/public_html/wp-includes/class-wpdb.php on line 2328

—————-

Error Stack Trace
Error Message

PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 598016 bytes) in /home2/pwumximy/public_html/wp-includes/class-wpdb.php on line 2328
Location
File:
Line: 2328Stack Trace
1 Unknown:0Error occurred in /home2/pwumximy/public_html/wp-includes/class-wpdb.php on line 2328

—————-

WordPress database error Commands out of sync; you can’t run this command now for query SHOW FULL COLUMNS FROM wp_options made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->maybe_dispatch_async_request, ActionScheduler_OptionLock->set

—————-

WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM wp_options WHERE option_name = ‘action_scheduler_lock_async-request-runner’ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->maybe_dispatch_async_request, ActionScheduler_OptionLock->set, ActionScheduler_OptionLock->get_existing_lock

—————-

WordPress database error Commands out of sync; you can’t run this command now for query SELECT option_value FROM wp_options WHERE option_name = ‘action_scheduler_lock_async-request-runner’ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->maybe_dispatch_async_request, ActionScheduler_Lock->is_locked, ActionScheduler_OptionLock->get_expiration, ActionScheduler_OptionLock->get_existing_lock