8bitkid,
You probably need to be more specific about what you are searching for. % is normally a wild card in SQL so it’s probably trying to load an excessive amount of data and overwhelming the memory of the server.
would you have a recommendation for an alternate search query that would be appropriate to identify two spaces trailing after a period?
many thanks.
I just had the same problem with the Memory size error, but I think I don;t have an way to reduce the query, as I am making a change to hard-coded URLs in the content table… anyone have ideas?
Specifically I have about 2,500 “posts” from 2.5 years of publishing, and over half of them have hard-coded links to a pages using a directory structure that was changed.
Everything went fine on the Dev site (and Dev DB) which is much smaller, but when I tried to run it on the Live DB it couldn’t handle the size is seems.
—
Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 92015563 bytes) in /home/content/90/3970090/html/wp-content/plugins/search-and-replace/search-and-replace.php on line 641
—
Please HELP!
Thanks
Good news – figured out a way to parse the terms more specifically and just ran the function 8 different times. nice.