View Issue Details

IDProjectCategoryView StatusLast Update
0005851OXID eShop (all versions)4.01. Database handlingpublic2023-12-06 12:09
Reporterhendrikfreytag Assigned To 
PrioritynormalSeveritytweakReproducibilityalways
Status resolvedResolutionwon't fix 
Product Version4.8.7 / 5.1.7 
Summary0005851: Table oxcaptcha is never cleared
DescriptionThe table oxcaptcha stores caching information for captchas generated for users without session. But it is never cleared when nobody uses the captcha function.
Steps To ReproduceGo to an article details page and make sure you don't have a session by deactivating cookies. The price alert function will generate a captcha which is stored to table oxcaptcha. But don't use the function and the captcha is never removed from db.
TagsNo tags attached.
ThemeAzure
BrowserAll
PHP VersionNot defined
Database VersionNot defined

Activities

suabo

2017-06-19 11:51

reporter   ~0012127

How to fix this Problem?

SvenBrunk

2023-12-06 12:08

administrator   ~0016025

Last edited: 2023-12-06 12:09

The Captcha module is currently phased out to the repository https://github.com/OXIDprojects/captcha-module/ and no longer officially supported.
I could think of a few possible ways to solve this issue:
- If the use-case that a non-logged in user using a captcha or even the whole functionality is so rare that your database is filled up with captchas from displayed, but never used captcha forms, think about removing the entire interaction or moving it to a place that needs to be intentionally called. (like an additional confirmation page or something like that)
- since the database entries are cleaned up if a non-logged in user tries to "solve" the captcha, even if it does not succeed, try setting up a cronjob that posts to such a form without a session
This might (dependent on how you do it) create one additional entry in the table, but clean all outdated ones.