零散 bug 记录

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

Linux 相关

  1. deepin 搜狗输入法顿号输入 BUG,解决详见:https://bbs.deepin.org/forum.php?mod=viewthread&tid=36369

  2. 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

  3. deepin 下 Lantern 启动错误

    1
    2
    3
    4
    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!

  4. 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 相关

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

    如下报错:

    1
    2
    3
    4
    5
    SELECT product_id,
    presentation
    FROM Variant
    INNER JOIN productCategory ON product_id = product_id
    LIMIT 10;

    改为:

    1
    2
    3
    4
    5
    6
    7
    SELECT
    Variant.product_id,
    presentation
    FROM Variant
    INNER JOIN productCategory
    ON productCategory.product_id = Variant.product_id
    LIMIT 10;

本文标题:零散 bug 记录

文章作者:Syncher

发布时间:2017年11月10日 - 20:11

最后更新:2018年08月14日 - 21:08

原始链接:https://0x400.com/2017-11-10-linux-debug.html

许可协议: 署名-非商业性使用-禁止演绎 4.0 国际 转载请保留原文链接及作者。