Database error

  • Hey guys,

    I’m seeing tons of database errors like this on my logs:

    php[error] [21-Aug-2017 12:47:06 UTC] Erro de banco de dados do WordPress Table 'gopagoda.wp_gdbc_attempts' doesn't exist para a consulta SELECT Count(1) AS Hits, ClientIp FROM wp_gdbc_attempts WHERE CreatedDate > 1503319564 AND ( (ModuleId = 2 AND SectionId = 2) OR (ModuleId = 2 AND SectionId = 5) OR (ModuleId = 9 AND SectionId = 1) OR (ModuleId = 21 AND SectionId = 1) OR (ModuleId = 25 AND SectionId = 1) OR (ModuleId = 34 AND SectionId = 1) OR (ModuleId = 35 AND SectionId = 1) ) GROUP BY ClientIp feita por require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), include_once('/plugins/goodbye-captcha/goodbye-captcha.php'), GdbcBruteGuardian::startGuarding, GdbcDbAccessController::getLatestLoginAttempts, GdbcDbAccessController::executePreparedQuery

    Any idea what is it and how to fix it?

    Seems like it started after the last plugin update.

    Thanks!

Viewing 7 replies - 1 through 7 (of 7 total)
  • Thread Starter Rafael Fischmann

    (@rfischmann)

    Hello?…

    hi,
    you lost the main DB table used by WP Bruiser. I also had a similar issue but it was probably due to a mistake when i cleaned a lot of stuff in my DB. The problem is i couldn’t upgrade any other plugin because of this error.

    I solved it by uninstalling WP Bruiser completely so it cancels all the options and then make a clean reinstall from scratch, restore your options by setting them manually again. Make some screenshots of every panel, it’s the safest way imo. The table will be created again if your options are empty. At least it worked for me!

    If you are really sure about what you are doing you can dump the options and restore them after reinstall, by default they are in wp_options prefixed by ‘gdbc’. You can check them with `select * from wp_options like ‘gdbc%’. I did an extra backup like that but i preferred to enter the options by hand again so i’m sure i will not have any problem of version compatibility.

    Hope it helps.

    Thread Starter Rafael Fischmann

    (@rfischmann)

    You might be right, @herrvigg, but I haven’t manually touched my database nor used any optimization plugins in a long time. So I don’t know how could that be possible.

    How do I “completely uninstall WP Bruiser”? I don’t think deleting its folder from /wp-content/plugins/ is enough, is it?

    Thanks!

    Plugin Author MihChe

    (@mihche)

    Hi @rfischmann,

    It seems like when you updated the plugin some files got corrupted. It’s been a while since I’ve pushed this new revision and nobody else reported this issue.

    Just login through FTP and completely delete it from /wp-content/plugins/. That should be enough.
    Please let me know.

    ~Mihai

    Thread Starter Rafael Fischmann

    (@rfischmann)

    Doesn’t seem to be that, @mihche. I’ve just re-downloaded the plugin and replaced its folder. Git (which is the way I deploy code to my site) shows no change whatsoever in any of the files.

    Sounds like something in the database itself.

    In my case i uninstalled regularly from the plugin menu in WP. This deleted also the gdbc (Goodbye catcha) from the options. Then reinstall it and it should re-create everything properly.

    The residual options may create some problems when reinstalling. If you need to remove by hand just do first :

    select * from wp_options like 'gdbc%'

    Check you can delete this stuff and then do it:

    delete from wp_options like 'gdbc%'

    Thread Starter Rafael Fischmann

    (@rfischmann)

    Thanks, @herrvigg.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Database error’ is closed to new replies.