• Welcome to the Chevereto user community!

    Here users from all over the world gather around to learn the latest about Chevereto and contribute with ideas to improve the software.

    Please keep in mind:

    • 😌 This community is user driven. Be polite with other users.
    • 👉 Is required to purchase a Chevereto license to participate in this community (doesn't apply to Pre-sales).
    • 💸 Purchase a Pro Subscription to get access to active software support and faster ticket response times.
  • Chevereto Support CLST

    Support response

    Support checklist

    • ⚠️ Got a Something went wrong message? Read this guide and provide the actual error. Do not skip this.
    • ✅ Confirm that the server meets the System Requirements
    • 🔥 Check for any available Hotfix - your issue could be already reported/fixed
    • 📚 Read documentation - It will be required to Debug and understand Errors for a faster support response

site loading too slow

Status
Not open for further replies.
S

siddharth

💖 Chevereto Fan
Even though we are on a more powerful server, the site is loading too slow. We have also tested the same by changing the DB from MySQL to MariaDB but still no result.

We have also reinstalled all the apps like php, nginx and all the stuffs, still there is no result. Where as our server admin says there is no issue with server and there is issue with the script.

This is the error we have found in error logs

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}()


[Mon Nov 18 15:39:53.758714 2019] [php7:notice] [pid 2846] [client 127.0.0.1:42866] 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\nStack trace:\n#0
/home/public_html/app/lib/classes/class.user.php(619): CHV\\User::delete(Array)\n#1
/home/public_html/app/loader.php(422): CHV\\User::cleanUnconfirmed(5)\n#2 [internal function]: CHV\\
{closure}()\n#3 {main}, referer: https://epbestdriveraward.com/DriverNoTrafficRegister

And also admin says, this url is taking a lot of time to execute and also causing the website to go down

https://xxx.com/?queue&r=dde8bad80d5a3e4c0ab2300d1df7cf4f
 
Sort by date Sort by votes
siddharthramakrishnan said:

XXX Sex - Free Porn Videos at XXX.com

XXX Sex Videos - Free Porn Movies at XXX.com
xxx.com xxx.com
Click to expand...
This pixel image is used to handle queue jobs in Chevereto, which are triggered asap and sneaked in any applicable HTML response. The queue jobs in this case are external storage deletions (local uploads gets removed without queues).

If that thing takes forever to load is because is taking forever to complete any pending queue jobs. This could happen for various reasons, most notable when the external storage server is unreachable or something worse goes on. The system is designed to stop trying removing content if after many failed attempts is unable to remove the content, so is stuck in a very long process.

You should check the queue table, that will give you a better idea on what the system is trying to delete. It could be that is trying to delete stuff that doesn't exists, servers unable to be reached, etc. I ignore the status of your installation.

siddharthramakrishnan said:
[Mon Nov 18 15:39:53.758714 2019] [php7:notice] [pid 2846] [client 127.0.0.1:42866] 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\nStack trace:\n#0
/home/public_html/app/lib/classes/class.user.php(619): CHV\\User::delete(Array)\n#1
/home/public_html/app/loader.php(422): CHV\\User::cleanUnconfirmed(5)\n#2 [internal function]: CHV\\
{closure}()\n#3 {main}, referer: https://epbestdriveraward.com/DriverNoTrafficRegister
Click to expand...

Most likely there was a DB issue that corrupted your installation. I'm afraid that I will have to check your database, send access to REDACTED

Don't forger to include:
  • Server access
  • Admin account to your website (must be a new account)
  • A link to this topic
 
Upvote 0 Downvote
Unfortunately, this ticket has more than seven days without a reply or feedback from the original poster. We will now consider this ticket abandoned and its now closed.

Don't hesitate to create a new ticket if this matter is still causing you issues.

Ticket closed.
 
Upvote 0 Downvote
Status
Not open for further replies.
Back
Top