Recent Posts - Page 10

Bug Reports / Re: Re: Load time achievement

Last post by Hj Ahmad Rasyid Hj Ismail - August 03, 2026, 04:19:44 pm

It was a jail / chroot issue. Not jailing / chrooting it allows direct connection to localhost, so that issue alone was fixed.

However, there is no improvement whatsoever, so my guess about it was totally wrong. I got nothing to do with either 127.0.0.1 or localhost connection. Learning on how Elkarte 2.0 Beta 1 php is processing database may be is what I need to find out more.

By the way, converting either from or to 127.0.0.1 to or from localhost, need to be done in database as well as settings file, as the leftovers might render an Elkarte forum inaccessible do to the change of path whether just /web for chrooted site using 127.0.0.1 or /full/path/to/web in localhost setup.

It might be easier to setup a new site for testing, unless you want to have some fun too, which I did.

Bug Reports / Re: Attachment Insert Problem

Last post by ScottJB - August 03, 2026, 12:35:40 pm

Quote from: Spuds – August 03, 2026, 12:22:25 pmmaybe, or some odd cache issue since I've been making the site fixes.

This was on my site, not here.
However, seems like it's working now, so maybe something with my phone at the time.

Bug Reports / Re: Attachment Insert Problem

Last post by Spuds - August 03, 2026, 12:22:25 pm

maybe, or some odd cache issue since I've been making the site fixes.

Addons / Re: [ADDON] SimplePortal

Last post by Spuds - August 03, 2026, 12:21:15 pm

Its probably $news['board']['name']

Bug Reports / Re: Re: Load time achievement

Last post by Spuds - August 03, 2026, 12:18:54 pm

Did you check the hostname lookup setting (just want to be sure its a DB issue and not something else) is off?

The error message appears to be it was not finding the mysqld.sock socket, what setting did you have to change to fix the issue?

Bug Reports / Re: Re: Load time achievement

Last post by Hj Ahmad Rasyid Hj Ismail - August 03, 2026, 11:54:34 am

I have figure out what's forbidding me from using localhost, so that part is resolved now, I can use it just fine now. Old caches are all cleared. new have been built.

The queries delays are still the same though. It is still around 3 seconds ++ while 1.1 is around 0.02-0.03.

2.0 less queries but longer time.

1.1 more queries but lesser time.

Addons / Re: [ADDON] SimplePortal

Last post by ScottJB - August 03, 2026, 11:05:24 am

Thanks, @Spuds !

Is there a way to just have board name and not a link?
I found this line, and tried to edit, but would not work:

Code: (Line) [Copy]

<span class="floatright">', $txt['incat'], ': ', $news['board']['link'], '</span>

Code: (Tried) [Copy]

<span class="floatright">', $txt['incat'], ': ', $news['board'], '</span>

Yes, I made and edited the text call....

Bug Reports / Re: Attachment Insert Problem

Last post by ScottJB - August 03, 2026, 10:43:47 am

Quote from: Spuds – August 03, 2026, 10:37:27 amReply -> Select attachment -> Insert ... seemed to work for me?

Strange... Now it works on my site/phone.
Earlier, I could not, so wonder if intermittent issue, maybe?

Bug Reports / Re: Attachment Insert Problem

Last post by Spuds - August 03, 2026, 10:37:27 am

2026-08-0309.36.411326277252299853920.jpg

from my phone

Reply -> Select attachment -> Insert ... seemed to work for me?

100

Bug Reports / Re: Re: Load time achievement

Last post by Hj Ahmad Rasyid Hj Ismail - August 03, 2026, 10:37:08 am

Code: [Copy]

[code]2026/08/03 22:32:18 [error] 1944#1944: *18202 FastCGI sent in stderr: "PHP message: PHP Warning:  mysqli::real_connect(): (HY000/2002): No such file or directory in /web/sources/ElkArte/Database/Mysqli/Connection.php on line 43; PHP message: PHP Fatal error:  Uncaught Error: mysqli object is not fully initialized in /web/sources/ElkArte/Database/Mysqli/Query.php:165
Stack trace:
#0 /web/sources/ElkArte/Database/Mysqli/Query.php(165): mysqli_query()
#1 /web/sources/ElkArte/Database/AbstractQuery.php(539): ElkArte\Database\Mysqli\Query->executeQuery()
#2 /web/sources/ElkArte/Database/Mysqli/Connection.php(54): ElkArte\Database\AbstractQuery->query()
#3 /web/sources/database/Database.subs.php(73): ElkArte\Database\Mysqli\Connection::initiate()
#4 /web/sources/Load.php(1261): database()
#5 /web/bootstrap.php(358): loadDatabase()
#6 /web/bootstrap.php(90): Bootstrap->bringUp()
#7 /web/bootstrap.php(66): Bootstrap->bringUpBasics()
#8 /web/index.php(41): Bootstrap->__construct()
#9 {main}
  thrown in /web/sources/ElkArte/Database/Mysqli/Query.php on line 165" while reading response header from upstream, client: xxx.xxx.xxx.xxx, server: elkarte2.sch.my, request: "GET /index.php HTTP/2.0", upstream: "fastcgi://unix:/var/lib/php8.4-fpm/webYY.sock:", host: "elkarte2.sch.my", referrer: "https://elkarte2.sch.my/index.php?action=admin;area=logs;sa=errorlog;desc"
2026/08/03 22:32:21 [error] 1944#1944: *18202 FastCGI sent in stderr: "PHP message: PHP Warning:  mysqli::real_connect(): (HY000/2002): No such file or directory in /web/sources/ElkArte/Database/Mysqli/Connection.php on line 43; PHP message: PHP Fatal error:  Uncaught Error: mysqli object is not fully initialized in /web/sources/ElkArte/Database/Mysqli/Query.php:165
Stack trace:
#0 /web/sources/ElkArte/Database/Mysqli/Query.php(165): mysqli_query()
#1 /web/sources/ElkArte/Database/AbstractQuery.php(539): ElkArte\Database\Mysqli\Query->executeQuery()
#2 /web/sources/ElkArte/Database/Mysqli/Connection.php(54): ElkArte\Database\AbstractQuery->query()
#3 /web/sources/database/Database.subs.php(73): ElkArte\Database\Mysqli\Connection::initiate()
#4 /web/sources/Load.php(1261): database()
#5 /web/bootstrap.php(358): loadDatabase()
#6 /web/bootstrap.php(90): Bootstrap->bringUp()
#7 /web/bootstrap.php(66): Bootstrap->bringUpBasics()
#8 /web/index.php(41): Bootstrap->__construct()
#9 {main}
  thrown in /web/sources/ElkArte/Database/Mysqli/Query.php on line 165" while reading response header from upstream, client: xxx.xxx.xxx.xxx, server: elkarte2.sch.my, request: "GET /index.php?action=profile;area=forumprofile;u=1 HTTP/2.0", upstream: "fastcgi://unix:/var/lib/php8.4-fpm/webYY.sock:", host: "elkarte2.sch.my", referrer: "https://elkarte2.sch.my/index.php?action=profile;area=account;u=1"
2026/08/03 22:32:23 [error] 1944#1944: *18202 FastCGI sent in stderr: "PHP message: PHP Warning:  mysqli::real_connect(): (HY000/2002): No such file or directory in /web/sources/ElkArte/Database/Mysqli/Connection.php on line 43; PHP message: PHP Fatal error:  Uncaught Error: mysqli object is not fully initialized in /web/sources/ElkArte/Database/Mysqli/Query.php:165
Stack trace:
#0 /web/sources/ElkArte/Database/Mysqli/Query.php(165): mysqli_query()
#1 /web/sources/ElkArte/Database/AbstractQuery.php(539): ElkArte\Database\Mysqli\Query->executeQuery()
#2 /web/sources/ElkArte/Database/Mysqli/Connection.php(54): ElkArte\Database\AbstractQuery->query()
#3 /web/sources/database/Database.subs.php(73): ElkArte\Database\Mysqli\Connection::initiate()
#4 /web/sources/Load.php(1261): database()
#5 /web/bootstrap.php(358): loadDatabase()
#6 /web/bootstrap.php(90): Bootstrap->bringUp()
#7 /web/bootstrap.php(66): Bootstrap->bringUpBasics()
#8 /web/index.php(41): Bootstrap->__construct()
#9 {main}
  thrown in /web/sources/ElkArte/Database/Mysqli/Query.php on line 165" while reading response header from upstream, client: xxx.xxx.xxx.xxx, server: elkarte2.sch.my, request: "GET /index.php?action=mentions;sa=fetch;api=json;lastsentmention=0;lastsentpm=0 HTTP/2.0", upstream: "fastcgi://unix:/var/lib/php8.4-fpm/webYY.sock:", host: "elkarte2.sch.my", referrer: "https://elkarte2.sch.my/index.php?action=admin;area=permissions;sa=modify;group=0"
2026/08/03 22:32:25 [error] 1944#1944: *18202 FastCGI sent in stderr: "PHP message: PHP Warning:  mysqli::real_connect(): (HY000/2002): No such file or directory in /web/sources/ElkArte/Database/Mysqli/Connection.php on line 43; PHP message: PHP Fatal error:  Uncaught Error: mysqli object is not fully initialized in /web/sources/ElkArte/Database/Mysqli/Query.php:165
Stack trace:
#0 /web/sources/ElkArte/Database/Mysqli/Query.php(165): mysqli_query()
#1 /web/sources/ElkArte/Database/AbstractQuery.php(539): ElkArte\Database\Mysqli\Query->executeQuery()
#2 /web/sources/ElkArte/Database/Mysqli/Connection.php(54): ElkArte\Database\AbstractQuery->query()
#3 /web/sources/database/Database.subs.php(73): ElkArte\Database\Mysqli\Connection::initiate()
#4 /web/sources/Load.php(1261): database()
#5 /web/bootstrap.php(358): loadDatabase()
#6 /web/bootstrap.php(90): Bootstrap->bringUp()
#7 /web/bootstrap.php(66): Bootstrap->bringUpBasics()
#8 /web/index.php(41): Bootstrap->__construct()
#9 {main}
  thrown in /web/sources/ElkArte/Database/Mysqli/Query.php on line 165" while reading response header from upstream, client: xxx.xxx.xxx.xxx, server: elkarte2.sch.my, request: "GET /index.php HTTP/2.0", upstream: "fastcgi://unix:/var/lib/php8.4-fpm/webYY.sock:", host: "elkarte2.sch.my", referrer: "https://elkarte2.sch.my/index.php?action=admin;area=permissions;sa=modify;group=0"
2026/08/03 22:32:29 [error] 1944#1944: *18202 FastCGI sent in stderr: "PHP message: PHP Warning:  mysqli::real_connect(): (HY000/2002): No such file or directory in /web/sources/ElkArte/Database/Mysqli/Connection.php on line 43; PHP message: PHP Fatal error:  Uncaught Error: mysqli object is not fully initialized in /web/sources/ElkArte/Database/Mysqli/Query.php:165
Stack trace:
#0 /web/sources/ElkArte/Database/Mysqli/Query.php(165): mysqli_query()
#1 /web/sources/ElkArte/Database/AbstractQuery.php(539): ElkArte\Database\Mysqli\Query->executeQuery()
#2 /web/sources/ElkArte/Database/Mysqli/Connection.php(54): ElkArte\Database\AbstractQuery->query()
#3 /web/sources/database/Database.subs.php(73): ElkArte\Database\Mysqli\Connection::initiate()
#4 /web/sources/Load.php(1261): database()
#5 /web/bootstrap.php(358): loadDatabase()
#6 /web/bootstrap.php(90): Bootstrap->bringUp()
#7 /web/bootstrap.php(66): Bootstrap->bringUpBasics()
#8 /web/index.php(41): Bootstrap->__construct()
#9 {main}
  thrown in /web/sources/ElkArte/Database/Mysqli/Query.php on line 165" while reading response header from upstream, client: xxx.xxx.xxx.xxx, server: elkarte2.sch.my, request: "GET /index.php?action=admin;area=logs;sa=errorlog;desc HTTP/2.0", upstream: "fastcgi://unix:/var/lib/php8.4-fpm/webYY.sock:", host: "elkarte2.sch.my", referrer: "https://elkarte2.sch.my/index.php?action=admin;area=logs;sa=errorlog;desc"

The same just repeating if I changed to "localhost", nothing much other than that.
[/code]
The same just repeating if I changed to "localhost", nothing much other than that.