WordPress database error Unknown column ‘insertionMethod’

  • delaitec

    (@delaitec)


    1 year, 1 month ago

    Hello.

    My website is staying at Hostgator in a CPANEL

    Checking my WordPress hosting I realized that there were many backups of the databases created at the root of the hosting “before the public_html folder”.

    At the same time as these backups “I didn’t ask” were created, there was also a “error_log” file that contained the error below:
    Does anyone know how to say this, can be someone trying to access the site from the outside? or some plugin that may have caused this error.

    I don’t know if you have a relationship with the backups, but as time they beat, it may be related.

    Can anyone help me?

    [04-Apr-2025 16:44:08 UTC] WordPress database error Unknown column 'insertionMethod' in 'where clause' for query SELECT * FROM tst_xyz_ips_short_code WHERE insertionMethod = 1 AND status = 1 made by include('phar:///usr/local/bin/wp/php/boot-phar.php'), include('phar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/wp-cli.php'), WP_CLI\bootstrap, WP_CLI\Bootstrap\LaunchRunner->process, WP_CLI\Runner->start, WP_CLI\Runner->load_wordpress, require('wp-settings.php'), include_once('/plugins/insert-php-code-snippet/insert-php-code-snippet.php'), require('/plugins/insert-php-code-snippet/shortcode-handler.php')
Viewing 3 replies - 1 through 3 (of 3 total)
  • George Appiah

    (@gappiah)

    1 year, 1 month ago

    At the same time as these backups “I didn’t ask” were created,

    Can you give the full file name of one of these backups? That could give a clue as to what created these backups.

    Because of the location where the backup files are stored, my suspicion is that either cPanel itself (built-in cPanel backup feature) or a cPanel-provided tool (eg WordPress Toolkit, Softaculous, Fantastico, etc) created these backups… and not a WordPress backup plugin (note that WordPress itself has no backup feature).

    … there was also a “error_log” file that contained the error below:

    Does anyone know how to say this, can be someone trying to access the site from the outside? or some plugin that may have caused this error.

    I don’t believe the error and the backups are related.

    As for the error, that’s from the “Insert PHP Code Snippet” plugin, and a similar issue was reported (along with a suggested fix from the plugin’s author) here: https://ww.wp.xz.cn/support/topic/database-error-from-ver-1-4/

    If the suggested fix doesn’t work for you, I’ll recommend making a new post in the plugin’s own support forum so its author and user community can assist you: https://ww.wp.xz.cn/support/plugin/insert-php-code-snippet/

    Good luck!

    Thread Starter delaitec

    (@delaitec)

    1 year, 1 month ago

    Hello @gappiah

    The name of the file are:
    cpuser_test.184338444958.sql.gz

    This is a backup of my site database.

    And the file are saved on cpanel root: (/home/cpuser/)
    Not on the site folder, or public_html folder, is on main root.

    Moderator threadi

    (@threadi)

    1 year, 1 month ago

    WordPress does not create any backups. Plugins that do this usually create them within the WordPress directory. Based on the file names you described, I would guess that these backups are created via the server maintenance software cPanel that you use. Check its manual to see if and how backups are created there.

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

The topic ‘WordPress database error Unknown column ‘insertionMethod’’ is closed to new replies.