User cannot send private message
User cannot send private message
|
|
Hello, on my forum, private messages have stopped working. When I want to send someone a private message, and I click the "Send message" button, the page keeps loading, and after 100 seconds a message from Cloudflare appears with the error "A timeout occuredd - error code 524"
Please help
2024-11-21, 04:10 PM
(This post was last modified: 2024-11-21, 04:36 PM by Mostafa.Shiraali. Edited 1 time in total.)
enable mybb debug log and send error from log here, because 524 error is mean cloudflare do not get response from your server , and this is for a error , you must find that error with debug settings.
Go to Admin CP -> Server and Optimization Options change setting Error Logging Medium to "log errors" change Error Type Medium setting to "Warnings and Errors" save then you can see warning and errors in page and "./error.log" that is default value in Error Logging Location setting (2024-11-21, 04:10 PM)Mostafa.Shiraali Wrote: enable mybb debug log and send error from log here, because 524 error is mean cloudflare do not get response from your server , and this is for a error , you must find that error with debug settings. Okay, I've changed these options, how do I get to these logs? I don't quite understand.
logs when i try send private message to member "Krzys16"
<error> <dateline>1732223904</dateline> <script></script> <line>0</line> <type>20</type> <friendly_type>MyBB SQL Error</friendly_type> <message>SQL Error: 2006 - MySQL server has gone away Query: SELECT * FROM mybb_users WHERE username IN('Krzys16')</message> <back_trace>#0 errorHandler->error() called at [/inc/db_mysqli.php:601] #1 DB_MySQLi->error() called at [/inc/db_mysqli.php:337] #2 DB_MySQLi->query() called at [/inc/db_mysqli.php:793] #3 DB_MySQLi->simple_select() called at [/inc/datahandlers/pm.php:201] #4 PMDataHandler->verify_recipient() called at [/inc/datahandlers/pm.php:481] #5 PMDataHandler->validate_pm() called at [/private.php:663] </back_trace> </error>
if you have VPS or dedicated server , check your mysql connection and also increase your max_allowed_packet ,otherwise you must send a ticket for your server provider.
remember if you have VPS or dedicated server you must change max_allowed_packet in my.cnf file and after that restart your mysql service with command,then you can test again.
I rent hosting for my website, I have already sent the ticket. What value will be good? and Are you sure this will help?
2024-11-21, 10:45 PM
(This post was last modified: 2024-11-21, 10:54 PM by Mostafa.Shiraali. Edited 2 times in total.)
(2024-11-21, 10:00 PM)Adex Wrote: I rent hosting for my website, I have already sent the ticket. What value will be good? and Are you sure this will help? when your website is up and you only have problem for one query or a few , usually this mean not enough free packet space in your server to mysql be able run that query , usually is enough , remember if your db size are less than 600M and you got this error , This shows that your hosting quality is very low , so if your website is growing , I suggest get better hosting provider or get a good VPS (Growing means that the forum is not only for a limited number of people) Because I usually shared host providers do not change this value , because they must share harware resource between clients fairly
You can view that variable, maybe if permissions granted by host, by logging in to
cPanel / phpMyAdmin / choose the Variables tab and scroll to max_allowed_packet to view allotment.
@HLFadmin, i have value "268,435,456" in this tab max_allowed_packet in phpMyAdmin
I got a response from the hosting, they said there is no 1M, and I have 256M
Your 256M setting is the same as on my server.
Although max_allowed_packet is set high enough (or so I'd think), the problem may be elsewhere. This stackoverflow question shows other factors may be involved. https://stackoverflow.com/questions/7942...-gone-away One comment replied that checking the mysql server log will show the reason the server went away. I do not know if you have access to that log if you are on a shared server. You'll have to check with your host. You can recreate the condition that generates the error, note the timestamp when it occurred, then ask for help reviewing the log at that particular moment to see if a clue can be found. Looking at current version code, it might be an important detail. Your error starts at line 201 which invokes a simple select query. I observe that current code shows the query is initiated in line 211. What version myBB software are you running? It may not matter. But you say PMs stopped working which implies they did at one time. So another important question is "what changed?" New plugin or something else? And if you didn't change anything, but server resources did, that's what you'll need to investigate with the host provider. Good luck. |
|
« Next Oldest | Next Newest »
|
