# PT-Online-schema errors

**URL:** <https://forums.percona.com/t/pt-online-schema-errors/30735>\
**Category:** Percona Toolkit\
**Tags:** closed-no-reply\
**Created:** [May 31, 2024, 5:58pm UTC](https://forums.percona.com/t/pt-online-schema-errors/30735 "2024-05-31T17:58:27Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![meyerder](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/meyerder/32/16994_2.png) [@meyerder](https://forums.percona.com/u/meyerder)\
**Post date:** [May 31, 2024, 5:58pm UTC](https://forums.percona.com/t/pt-online-schema-errors/30735/1 "2024-05-31T17:58:27Z")

</div>

FYI the link to report a bug is broken… I was going to attempt to file a bug report with online schema change… pt-online-schema-change 3.5.7

```auto
The area around that trigger is

    -- Replace single quotes in the email address
    SET @safe_email = REPLACE(NEW.Email, '''', '''''');

    -- Validate and prepare the IP address, using a default if the format is incorrect
    IF NEW.xx REGEXP '^(?:[0-9]{1,3}\\.){3}[0-9]{1,3}$' THEN
        SET valid_xx = NEW.xx;
    ELSE
        SET valid_xx = '1.1.1.1'; -- Use default IP if format is incorrect
    END IF;

```