===进行全国PING测试结束===
警告：SQL语句有误
错误代码：1064；
错误信息：You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Hosted by Cox - Wichita (Wichita, KS) [43.14 km]: 45.922 ms' Testing download sp' at line 1

python修改成python3解决了CentOS8不能使用
#带宽测试
bdtest()
{
if [ "$os" == 'centos' ]; then
yum -y install python3
else
apt-get update
apt-get -y install python3
fi
echo "===开始测试带宽===" | tee -a $logfilename
wget --no-check-certificate https://raw.githubusercontent.com/sivel/speedtest-cli/master/speedtest.py 1>/dev/null 2>&1
python3 speedtest_cli.py --share | tee -a $logfilename
echo -e "===带宽测试结束==\n\n" | tee -a $logfilename
rm -rf speedtest_cli.py
}

Provider:

CPU model : Intel(R) Xeon(R) CPU E3-1270 v3 @ 3.50GHz
Number of cores : 1
CPU frequency : 3500.014 MHz
Total amount of Mem : 981 MB
Total amount of Swap : 1023 MB
System uptime : 0days, 12:44:35
IPaddr : 卢森堡 卢森堡 buyvm.net
OS : Ubuntu 20.04.1 LTS x86_64 5.4.0-29-generic

Ookla collects certain data through Speedtest that may be considered
personally identifiable, such as your IP address, unique device
identifiers or location. Ookla believes it has a legitimate interest
to share this data with internet providers, hardware manufacturers and
industry regulators to help them understand and create a better and
faster internet. For further information including how the data may be
shared, where the data may be transferred and Ookla's contact details,
please see our Privacy Policy at:

   http://www.speedtest.net/privacy

==============================================================================

To accept the message please run speedtest interactively or use the following:

speedtest --accept-gdpr

Node Name Upload Speed Download Speed Latency

Node Name IPv4 address Download Speed
CacheFly 205.234.175.175 72.6MB/s
Linode, Tokyo, JP 139.162.65.37 5.04MB/s
Linode, London, UK 176.58.107.39 36.7MB/s
Linode, Fremont, CA 50.116.14.9 8.11MB/s
Softlayer, Seattle, WA 67.228.112.250 8.86MB/s
Softlayer, Singapore, SG 119.81.28.170 3.88MB/s
Softlayer, HongKong, CN 119.81.130.170 1.92MB/s

It should be an ipv4 address but shows an ipv6 address

警告：SQL语句有误<br />错误代码：<font color='red'>1366</font>；<br /> 错误信息：<font color='red'>Incorrect string value: '旦°㬮.' for column 'c' at row 1</font>

可以將 Debian/Ubuntu apt安裝的 mtr 改成 mtr-tiny ，因為服務器並不需要GUI套件，裝mtr-tiny即可。

脚本运行到开始进行群过ping测试，之后不显示结果。如下：

===开始进行全国PING测试===
线路            节点数目        最快节点                                延迟            最慢节点                                延迟                                    平均延迟
                                                                                                                                        
===进行全国PING测试结束===
测试已经结束，测试结果已经生成在同目录下的91yuntest.log,可以使用cat 91yuntest.log查看。

是不是多了一列，对比ipip站点最后列表，发觉并没有平均延长这一栏，请确实http://www.ipip.net/ping.php?a=send&host=$1&area%5B%5D=china 地址仍然有效，谢谢。

Debian/Ubuntu用apt裝mtr會多裝一堆沒意義的套件 那是GUI環境才需要的
用mtr-tiny只會有mtr本體 可以少占用一堆空間

如题