Hi PvW,
It’s starting to get a bit frustrating working with DB-Replacer and ChatGPT. I’m getting a lot of "search string not found" errors, even on simple searches, and that can’t be right. The fun part is kind of slipping away, and ChatGPT just spits out a new regex example whenever I say "not captured," which also doesn’t capture anything, and then suddenly we get lucky. I admit I’m not fully familiar with this regex technology, but ChatGPT shouldn’t be making that many mistakes given its learning in that area. Is there something I can do or try to get DB-Replacer to accept things better and maybe more broadly? You mentioned something about:
"Your server seems to be naggy about whitespace. But normally you wouldn’t need all those '\s*' there. Probably a weird PHP or MySQL setting on your server."
Do you think trying to cleaning up whitespace, optimizing my database, etc., via phpMyAdmin would help, or should I contact my provider regarding the weird PHP settings? I’d really appreciate your thoughts.
Thanks...
I think it will be difficult to change PHP settings with these standard providers; maybe a `php.ini` in the root at specific points, but I don’t think they allow that for everyone. However, I’m free to configure my `php.ini` locally on MAMP, so I can make these large regex changes locally. Can you recommend some specific PHP settings that work well or not with DB-Replacer?
It would be cool to get DB-Replacer running optimally locally.
Well, I work completely normally with MAMP locally for this kind of thing, never on a live site. I’m still getting all these incredibly many errors "search string not found." I’m running an older version of PHP 8.1.29 / MySQL 8.0.35 could that be a factor? or whitespace in the DB
Could be. Sorry, but it is beyond my support to help you fix any setup or server issues you might have.
Don't run on older versions, as they have issues. If you run into issues, you'll have to fix them or have someone look into it for you.
This is beyond support for DB Replacer as it is not due to an issue or bug in DB Replacer.