Data not visible + Export CSV throwing error

Hi 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:

1. What is the root cause of this issue?
2. How to prevent this in the future?
3. Has this issue been addressed in newer versions. ?
4. 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 11 months ago by kalashagrahari.