Conversation
supportHi team, We’ve noticed a critical issue: For one specific form, the entries are not visible in the CFDB7 dashboard. When we try to Export CSV , it throws the error “There has been a critical error on this website. Please check your site admin email inbox for instructions. If you continue to have problems, please try the support forums.” Other forms work fine — their data is visible and exports correctly. After investigation, we found that: The issue is caused by a corrupted serialized form_value in the db7_forms table. For example, we have the following values in table s:8 :\” eBookURL \”; s:152 :\” https://nftpreprod1.nfshtechglobal.com/?post_type=e-landing-page&p=11509&preview_id=11509&preview_nonce=46bf9a01d5&preview=true#downloadEbookForm \” With value s:152 (it means the format is string with length is 152), value https://nftpreprod1.nfshtechglobal.com/?post_type=e-landing-page&p=11509&preview_id=11509&preview_nonce=46bf9a01d5&preview=true#downloadEbookForm with length is 160 => Incorrect This broke unserialize() when the plugin tried to load or export the form entries. We have manually updated the record for now, but we’re looking for guidance on: What is the root cause of this issue? How to prevent this in the future? Has this issue been addressed in newer versions. ? As single table handles all records, such case can disrupt random form view and export functionality? WordPress version: 6.8.1 Plugin Version: 1.3.0 PHP Version: 8.3.23 Web Server: Apache (FPM/FastCGI) MySQL/MariaDB Version: 10.6.22-MariaDB Database Charset: utf8mb4 Database Collation: utf8mb4_unicode_520_ci This topic was modified 10 months, 3 weeks ago by kalashagrahari .
Also other forms didn’t got corrupted but only single form. How is this possible if all data are store in single table. Please explain.
I have experienced same issues you’ve described above and would like to know the cause and how to stop it happening again.
Also other forms didn’t got corrupted but only single form. How is this possible if all data are store in single table. Please explain.
I have experienced same issues you’ve described above and would like to know the cause and how to stop it happening again.