🎯Description of the issue
1) In the admin panel, it is showing 0 whereas we have more than 100k images. And also I have applied the fix which has given before, but still, the site is getting 0 stats often.
FYI, our storage server which is FTP are getting down daily due to CP and we are mitigating it somehow. Whether this may be the problem for 0 stats? if so, the issue needs to be fixed permanently
2) Site is loading slow
We are using i9 processor and 64gigs of ram and 1gbps of bandwidth for main server, still when loading the images page and other settings pages, we are getting 504 error. And when checking the error log we saw this error
2019/11/17 13:57:58 [error] 3359#0: *302850 FastCGI sent in stderr: "PHP message: CHV\ImageException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'deleted_content_original_filename' at row 1 (LINE:473) in /home/public_html/app/lib/classes/class.image.php:1429
Stack trace:
#0 /home/public_html/app/loader.php(409): CHV\Image::deleteExpired(50)
#1 [internal function]: CHV\{closure}()
#2 {main}
PHP message: CHV\UserException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'deleted_content_original_filename' at row 1 (LINE:473) in /home/public_html/app/lib/classes/class.user.php:448
Stack trace:
#0 /home/public_html/app/lib/classes/class.user.php(619): CHV\User::delete(Array)
#1 /home/public_html/app/loader.php(422): CHV\User::cleanUnconfirmed(5)
#2 [internal function]: CHV\{closure}()
1) In the admin panel, it is showing 0 whereas we have more than 100k images. And also I have applied the fix which has given before, but still, the site is getting 0 stats often.
FYI, our storage server which is FTP are getting down daily due to CP and we are mitigating it somehow. Whether this may be the problem for 0 stats? if so, the issue needs to be fixed permanently
2) Site is loading slow
We are using i9 processor and 64gigs of ram and 1gbps of bandwidth for main server, still when loading the images page and other settings pages, we are getting 504 error. And when checking the error log we saw this error
2019/11/17 13:57:58 [error] 3359#0: *302850 FastCGI sent in stderr: "PHP message: CHV\ImageException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'deleted_content_original_filename' at row 1 (LINE:473) in /home/public_html/app/lib/classes/class.image.php:1429
Stack trace:
#0 /home/public_html/app/loader.php(409): CHV\Image::deleteExpired(50)
#1 [internal function]: CHV\{closure}()
#2 {main}
PHP message: CHV\UserException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'deleted_content_original_filename' at row 1 (LINE:473) in /home/public_html/app/lib/classes/class.user.php:448
Stack trace:
#0 /home/public_html/app/lib/classes/class.user.php(619): CHV\User::delete(Array)
#1 /home/public_html/app/loader.php(422): CHV\User::cleanUnconfirmed(5)
#2 [internal function]: CHV\{closure}()