We are receiving these error codes in the header of Videos and Timeline pages inc/classes/BxDolVoteReactions.php on line 54, inc/classes/BxDolTemplate.php on line 3740 ... Where do we troubleshoot to fix
I'm trying to embed a YouTube video, and received an error:
Notice: unserialize(): Error at offset 452 of 452 bytes in /home/bravohos/public_html/clickandshare.net/modules/boonex/videos/classes/BxVideosTemplate.php on line 64
This is the error that is displayed on the homepage:
Notice: unserialize(): Error at offset 452 of 452 bytes in /home/bravohos/public_html/clickandshare.net/modules/boonex/videos/classes/BxVideosModule.php on line 188
This indicates that a corrupted serialized string is stored in your database (or cache) and is causing an error when being unserialized. This typically happens due to one of the following reasons:
A string was truncated or cut off
Character encoding issues occurred
A database backup or restore operation failed to preserve serialized string lengths correctly
Solution:
Clear all caches and try again. If you use Memcache, restart the Memcache server to clear its cache as well.
Example: To identify broken serialized entries in your options table:
SELECT name, value FROM sys_options WHERE value LIKE'a:%'OR value LIKE'O:%';
Check database character encoding:
Make sure your database tables and columns use the correct charset and collation, ideally utf8mb4_unicode_ci or similar. Encoding issues can cause serialized strings to get truncated.
Check for PHP mbstring extension:
If your data contains multibyte or special characters, ensure the mbstring PHP extension is installed and enabled, as its absence can cause unserialize issues.
I'm trying to embed a YouTube video, and received an error:
Notice: unserialize(): Error at offset 452 of 452 bytes in /home/bravohos/public_html/clickandshare.net/modules/boonex/videos/classes/BxVideosTemplate.php on line 64
This is the error that is displayed on the homepage:
Notice: unserialize(): Error at offset 452 of 452 bytes in /home/bravohos/public_html/clickandshare.net/modules/boonex/videos/classes/BxVideosModule.php on line 188
About Issue:
This indicates that a corrupted serialized string is stored in your database (or cache) and is causing an error when being unserialized. This typically happens due to one of the following reasons:
Solution:
Clear all caches and try again. If you use Memcache, restart the Memcache server to clear its cache as well.
Example: To identify broken serialized entries in your options table:
SELECT name, value FROM sys_options WHERE value LIKE 'a:%' OR value LIKE 'O:%';Check database character encoding:
Make sure your database tables and columns use the correct charset and collation, ideally
utf8mb4_unicode_cior similar. Encoding issues can cause serialized strings to get truncated.Check for PHP
mbstringextension:If your data contains multibyte or special characters, ensure the
mbstringPHP extension is installed and enabled, as its absence can cause unserialize issues.Pertform server audit:
go to: https://example.com/studio/dashboard.php and click on button "server audit" and post the result here
Maibe you ned to reinstall php-fpm
https://github.com/kabballa/PHP-UNA
Debugging Recommendation:
While debugging in a development environment, it’s fine to enable detailed error reporting. However, on a live/production environment:
In your
inc/header.inc.phpor yourphp.inifile, set:And in
php.ini:Then restart PHP-FPM to apply the changes:
How to get logs and post here for debugging:
Go to UNA logs folder and list files:
if you have multiple logs, you can tail them:
Show last 50 lines of Nginx error log:
tail -n 50 /var/log/nginx/error.logShow last 50 lines of PHP-FPM log:
tail -n 50 /var/log/php8.2-fpm.logCopy the output and paste it here, so maybe we can help.
Make sure to delete username and your domain name from the logs before sharing.
Happy coding!