View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005851 | OXID eShop (all versions) | 4.01. Database handling | public | 2014-08-13 15:28 | 2023-12-06 12:09 |
| Reporter | hendrikfreytag | Assigned To | |||
| Priority | normal | Severity | tweak | Reproducibility | always |
| Status | resolved | Resolution | won't fix | ||
| Product Version | 4.8.7 / 5.1.7 | ||||
| Summary | 0005851: Table oxcaptcha is never cleared | ||||
| Description | The 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 Reproduce | Go 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. | ||||
| Tags | No tags attached. | ||||
| Theme | Azure | ||||
| Browser | All | ||||
| PHP Version | Not defined | ||||
| Database Version | Not defined | ||||
|
|
How to fix this Problem? |
|
|
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. |
