零散 bug 记录

本文记录日常工作、学习、生活中遇到的 BUG！

Linux 相关

deepin 搜狗输入法顿号输入 BUG，解决详见：https://bbs.deepin.org/forum.php?mod=viewthread&tid=36369
git push 到 GitHub 警告
1
Warning: Permanently added the RSA host key for IP address
解决详见：https://stackoverflow.com/questions/18711794/warning-permanently-added-the-rsa-host-key-for-ip-address

deepin 下 Lantern 启动错误

Running installation script...
/usr/lib/lantern/lantern-binary: 成功
/home/gbin/.lantern/bin/lantern: error while loading shared libraries: libappindicator3.so.1:
open shared object file: No such file or directory

Install the libappindicator3,see issue

step 1

1 2	$ apt-cache search libappindicator3 gir1.2-appindicator3-0.1 - Typelib fi gir1.2-appindicator3-0.1 - Typelib files for libappindicator3-1

step 2

1	$ sudo apt-get install -y libappindicator3-1

done!

Nginx 报错：
1
Nginx: nginx: [warn] load balancing method redefined
You can mix keepalive and least_conn, but you should define least_conn before keepalive

https://ma.ttias.be/nginx-nginx-warn-load-balancing-method-redefined/

MySQL 相关

column xx in field list is ambiguous，一般在 join 的时候出现字段模糊，字段前添加表名即可。

如下报错：

SELECT product_id,
       presentation
FROM Variant
INNER JOIN productCategory ON product_id = product_id
LIMIT 10;

改为：

SELECT
   Variant.product_id, 
   presentation
FROM Variant 
INNER JOIN productCategory 
ON productCategory.product_id = Variant.product_id 
LIMIT 10;