Database Error from ver 1.4

  • F R

    (@frosado)


    4 weeks ago

    Hello. About one hour ago, the Insert PHP Code Snippets plugin for WordPress ver 1.4 started generating MySQL database errors every few seconds. The errors look as follows:

    DATE: Tue, 18 Feb 2025 15:12:28 -0400SITE: https://[REDACTED]IP: [REDACTED]UA: WordPress/6.7.2; https://[REDACTED]SCRIPT: /index.phpREQUEST: /?wp_scrape_key=[REDACTED]&wp_scrape_nonce=[REDACTED]————————————————– SELECT * FROM wp_xyz_ips_short_code WHERE insertionMethod = 1 AND status = 1Unknown column ‘insertionMethod’ in ‘where clause’ ————————————————–

    and

    DATE: Tue, 18 Feb 2025 15:12:37 -0400SITE: https://[REDACTED]IP: [REDACTED]UA: WordPress/6.7.2; https://[REDACTED]SCRIPT: /wp-cron.phpREQUEST: /wp-cron.php?doing_wp_cron=[REDACTED]————————————————– SELECT * FROM wp_xyz_ips_short_code WHERE insertionMethod = 1 AND status = 1Unknown column ‘insertionMethod’ in ‘where clause’ ————————————————–

    The same database error of “Unknown column ‘insertionMethod’ in ‘where clause'” keeps being generated multiple times per user session. There seems to be a problem with the version 1.4 plugin calling a database column that does not exist. Can this be fixed please? Thank you!

Viewing 2 replies - 1 through 2 (of 2 total)

  • Hello @frosado
    Thanks for reaching out. The error occurs because v1.4 introduced new database columns, including insertionMethod, which might not have been added during the upgrade.

    To fix this, please:

    1. Deactivate and reactivate the Insert PHP Code Snippet plugin. This will trigger the required database updates.
    2. Clear the plugin cache, if applicable.

    This should resolve the issue. If the problem persists, please let us know, and we’ll be happy to assist further.

    cristianoff

    (@cristianoff)

    Hi, I found the same error in the logs after my website was completely blocked.
    Renaming insert-php-code-snippet I solved the issue and fortunately the plugin was used only for testing.
    If I rollback directory rename, I suppose I will break the site again, and I cannot Activate since the site is not accessible when the plugin is in error.
    How can I proceed manually?

Viewing 2 replies - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.