There was an error trying to fetch latest speedtest results.

[siutung]

Hello,all.

I was installed speedtest on ubuntu 20.04 lts(Apache/2.4.41 + PHP 7.4.3 + mysql 8.0.33,installed them by apt.)

follow:https://fdossena.com/?p=speedtest/quickstart_v5_ubuntu.frag
step by step.

But when I vist http://myip/results/stats.php,
entered the password(logined successfully).The page says that:There was an error trying to fetch latest speedtest results. under the "Search test results".there haven't any test results.

But the speedtest frontpage is normal.

The apache2's access.log:
10.167.46.90 - - [14/Aug/2023:01:35:36 +0000] "GET /results/stats.php?op=id&id= HTTP/1.1" 200 1158 "http://10.167.45.154/results/stats.php?op=id&id=" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36 Edg/115.0.1901.203"
10.167.46.90 - - [14/Aug/2023:01:35:38 +0000] "GET /results/stats.php?op=id&id= HTTP/1.1" 200 1157 "http://10.167.45.154/results/stats.php?op=id&id=" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36 Edg/115.0.1901.203"
10.167.46.90 - - [14/Aug/2023:01:35:38 +0000] "GET /results/stats.php?op=id&id= HTTP/1.1" 200 1157 "http://10.167.45.154/results/stats.php?op=id&id=" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36 Edg/115.0.1901.203"
10.167.46.90 - - [14/Aug/2023:01:35:38 +0000] "GET /results/stats.php?op=id&id= HTTP/1.1" 200 1157 "http://10.167.45.154/results/stats.php?op=id&id=" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36 Edg/115.0.1901.203"
10.167.46.90 - - [14/Aug/2023:01:35:39 +0000] "GET /results/stats.php?op=id&id= HTTP/1.1" 200 1157 "http://10.167.45.154/results/stats.php?op=id&id=" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36 Edg/115.0.1901.203"
10.167.46.90 - - [14/Aug/2023:01:35:39 +0000] "GET /results/stats.php?op=id&id= HTTP/1.1" 200 1157 "http://10.167.45.154/results/stats.php?op=id&id=" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36 Edg/115.0.1901.203"
10.167.46.90 - - [14/Aug/2023:01:35:39 +0000] "GET /results/stats.php?op=id&id= HTTP/1.1" 200 1157 "http://10.167.45.154/results/stats.php?op=id&id=" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36 Edg/115.0.1901.203"
10.167.46.90 - - [14/Aug/2023:01:35:39 +0000] "GET /results/stats.php?op=id&id= HTTP/1.1" 200 1157 "http://10.167.45.154/results/stats.php?op=id&id=" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36 Edg/115.0.1901.203"
10.167.46.90 - - [14/Aug/2023:01:35:40 +0000] "GET /results/stats.php?op=id&id= HTTP/1.1" 200 1157 "http://10.167.45.154/results/stats.php?op=id&id=" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36 Edg/115.0.1901.203"
10.167.46.90 - - [14/Aug/2023:01:35:40 +0000] "GET /results/stats.php?op=id&id= HTTP/1.1" 200 1157 "http://10.167.45.154/results/stats.php?op=id&id=" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36 Edg/115.0.1901.203"
10.167.46.90 - - [14/Aug/2023:01:35:40 +0000] "GET /results/stats.php?op=logout HTTP/1.1" 200 978 "http://10.167.45.154/results/stats.php?op=id&id=" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36 Edg/115.0.1901.203"
10.167.46.90 - - [14/Aug/2023:01:35:40 +0000] "GET /results/stats.php HTTP/1.1" 200 1022 "http://10.167.45.154/results/stats.php?op=logout" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36 Edg/115.0.1901.203"
10.167.46.90 - - [14/Aug/2023:01:35:43 +0000] "POST /results/stats.php?op=login HTTP/1.1" 200 978 "http://10.167.45.154/results/stats.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36 Edg/115.0.1901.203"
10.167.46.90 - - [14/Aug/2023:01:35:43 +0000] "GET /results/stats.php HTTP/1.1" 200 1157 "http://10.167.45.154/results/stats.php?op=login" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36 Edg/115.0.1901.203"

The apache2's error.log:
[Mon Aug 14 01:19:38.940877 2023] [mpm_prefork:notice] [pid 9438] AH00163: Apache/2.4.41 (Ubuntu) configured -- resuming normal operations
[Mon Aug 14 01:19:38.951400 2023] [core:notice] [pid 9438] AH00094: Command line: '/usr/sbin/apache2'
[Mon Aug 14 01:33:04.046813 2023] [mpm_prefork:notice] [pid 9438] AH00169: caught SIGTERM, shutting down
[Mon Aug 14 01:33:28.687801 2023] [mpm_prefork:notice] [pid 710] AH00163: Apache/2.4.41 (Ubuntu) configured -- resuming normal operations
[Mon Aug 14 01:33:28.695237 2023] [core:notice] [pid 710] AH00094: Command line: '/usr/sbin/apache2'

What is my mistake,any idea?
Thanks.

[lill-peter]

I have th same problem.

[SX86]

Same for me. Created the speedtest_users table in my librespeed database, but it looks like it is not getting populated by results.

[g93920079]

Same for me. Does anyone know how to solve this? I try both mysql and postgres,the result is the same.