sofos Posted November 15, 2023 Posted November 15, 2023 (edited) Hi guys, for a few days now, after writing a post and clicking 'Submit Reply' it takes 10 to thirty seconds to save the post. This does not happen on the post editing function and happens even without advertising and with all plugins disabled. Do you have any advice for me? Edited November 15, 2023 by sofos
teraßyte Posted November 15, 2023 Posted November 15, 2023 Does the topic you're replying to have a lot of followers? Or does it happen also for topics with few or zero followers? sofos 1
sofos Posted November 15, 2023 Author Posted November 15, 2023 hi @teraßyte it also happens for topics with zero followers but it seems that the delay is greater in discussions with many participants (those who follow the discussions are few, three or four for each discussion). I can do some tests if you think it helps.
teraßyte Posted November 15, 2023 Posted November 15, 2023 I think that notifications might be delaying the submission process. What Email method are you using to send out notifications? PHP mail, SMTP, Sendgrid?
sofos Posted November 15, 2023 Author Posted November 15, 2023 I did some tests, the delay seems independent of the number of posts and followers @teraßyte I am using a SMTP by ovh.net
teraßyte Posted November 15, 2023 Posted November 15, 2023 (edited) Instead of the number of followers, it might just be the SMTP server being slow in its starting reply. Switch temporarily to PHP mail and try again to post something. Does the delay disappear? Edited November 15, 2023 by teraßyte sofos 1
Marc Posted November 15, 2023 Posted November 15, 2023 1 hour ago, sofos said: I did some tests, the delay seems independent of the number of posts and followers @teraßyte I am using a SMTP by ovh.net If there are a lower number of followers then it would attempt to send them immediately. So if the SMTP is slow, then indeed it would be what is causing the delay there sofos 1
loccom Posted November 15, 2023 Posted November 15, 2023 We use sendgrid and it's great. Much more reliable than phpmail or smtp. most notificatons arrive using sendgrid.
sofos Posted November 15, 2023 Author Posted November 15, 2023 @teraßyte @Marc Stridgen switching to PHP mail doesn't seem to have any effect
Jim M Posted November 15, 2023 Posted November 15, 2023 7 minutes ago, sofos said: @teraßyte @Marc Stridgen switching to PHP mail doesn't seem to have any effect If PHP mail runs on the same SMTP server, you would indeed have the same issue. That would be a question for your hosting provider.
sofos Posted November 15, 2023 Author Posted November 15, 2023 @Jim M switching to sendgrid doesn't seem to have any effect Reoccurring system log entry (169 times) OutOfRangeException: (0) #0 /var/www/vhosts/ myforum.com/httpdocs/system/Theme/Theme.php(401): IPS\Patterns\_ActiveRecord::load() #1 /var/www/vhosts/ myforum.com/httpdocs/system/Dispatcher/Standard.php(54): IPS\_Theme::i() #2 /var/www/vhosts/ myforum.com/httpdocs/system/Dispatcher/Front.php(760): IPS\Dispatcher\_Standard::baseCss() #3 /var/www/vhosts/ myforum.com/httpdocs/system/Dispatcher/Front.php(76): IPS\Dispatcher\_Front::baseCss() #4 /var/www/vhosts/ myforum.com/httpdocs/system/Dispatcher/Dispatcher.php(110): IPS\Dispatcher\_Front->init() #5 /var/www/vhosts/ myforum.com/httpdocs/index.php(13): IPS\_Dispatcher::i() #6 {main}
Jim M Posted November 15, 2023 Posted November 15, 2023 16 minutes ago, sofos said: @Jim M switching to sendgrid doesn't seem to have any effect Reoccurring system log entry (169 times) OutOfRangeException: (0) #0 /var/www/vhosts/ myforum.com/httpdocs/system/Theme/Theme.php(401): IPS\Patterns\_ActiveRecord::load() #1 /var/www/vhosts/ myforum.com/httpdocs/system/Dispatcher/Standard.php(54): IPS\_Theme::i() #2 /var/www/vhosts/ myforum.com/httpdocs/system/Dispatcher/Front.php(760): IPS\Dispatcher\_Standard::baseCss() #3 /var/www/vhosts/ myforum.com/httpdocs/system/Dispatcher/Front.php(76): IPS\Dispatcher\_Front::baseCss() #4 /var/www/vhosts/ myforum.com/httpdocs/system/Dispatcher/Dispatcher.php(110): IPS\Dispatcher\_Front->init() #5 /var/www/vhosts/ myforum.com/httpdocs/index.php(13): IPS\_Dispatcher::i() #6 {main} You may wish to investigate what is happening with your community. Attempting to sign in from the ACP, I keep getting redirected around. If you have any custom redirects on the server imposing HTTP to HTTPS or otherwise. I would remove those. sofos 1
sofos Posted November 20, 2023 Author Posted November 20, 2023 No results so far. 😔 I've noticed that sometimes posts are duplicated, does this tell you anything?
Marc Posted November 20, 2023 Posted November 20, 2023 Usually that there are issues with the site saving data at times. sofos 1
sofos Posted November 20, 2023 Author Posted November 20, 2023 hi @Marc Stridgen, issue on server side? Do you have anything you recommend checking out?
Marc Posted November 20, 2023 Posted November 20, 2023 Usually, performance issues with your mysql instance and/or mailing.
sofos Posted November 20, 2023 Author Posted November 20, 2023 @Marc Stridgen there are two queries thrown continuously: Quote /*forum::forum::IPS\Content\Search\Mysql\_Index::index:306*/ INSERT INTO `core_search_index` Quote /*forum::forum::IPS\Session\Store\_Database::updateSession:381*/ INSERT INTO `core_sessions` ( `id`, `member_name`, `seo_name`, `member_id`, `ip_address`, `browser`, `running_time`, `login_type`, `member_group`, `current_appcomponent`, `current_module`, `current_controller`, `current_id`, `uagent_key`, `uagent_version`, `uagent_type`, `search_thread_id`, `search_thread_time`, `data`, `location_url`, `location_lang`, `location_data`, `location_permissions`, `theme_id`, `in_editor` ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) ON DUPLICATE KEY UPDATE `id`=VALUES(`id`), `member_name`=VALUES(`member_name`), `seo_name`=VALUES(`seo_name`), `member_id`=VALUES(`member_id`), `ip_address`=VALUES(`ip_address`), `browser`=VALUES(`browser`), `running_time`=VALUES(`running_time`), `login_type`=VALUES(`login_type`), `member_group`=VALUES(`member_group`), `current_appcomponent`=VALUES(`current_appcomponent`), `current_module`=VALUES(`current_module`), `current_controller`=VALUES(`current_controller`), `current_id`=VALUES(`current_id`), `uagent_key`=VALUES(`uagent_key`), `uagent_version`=VALUES(`uagent_version`), `uagent_type`=VALUES(`uagent_type`), `search_thread_id`=VALUES(`search_thread_id`), `search_thread_time`=VALUES(`search_thread_time`), `data`=VALUES(`data`), `location_url`=VALUES(`location_url`), `location_lang`=VALUES(`location_lang`), `location_data`=VALUES(`location_data`), `location_permissions`=VALUES(`location_permissions`), `theme_id`=VALUES(`theme_id`), `in_editor`=VALUES(`in_editor`)
Marc Posted November 20, 2023 Posted November 20, 2023 These are things you would need to take up with your host. These really are simple queries that should be running efficiently
sofos Posted November 26, 2023 Author Posted November 26, 2023 SOLVED! Data Storage Method FROM MySQL Database TO File System
Recommended Posts