json列使phpmyadmin崩溃

rslzwgfq  于 2021-06-20  发布在  Mysql
关注(0)|答案(0)|浏览(290)

我用的是MySQL5.5。但是我想在表中插入json列。由于从MySQL5.7开始就支持json，所以我升级到了5.7.22（按照在线建议，先升级到5.6，然后再升级到5.7）。升级后，我的数据库在5.7.22上运行正常。
现在我尝试使用phpmyadmin添加一个json列。但是我有phpMyAdmin4.0.10，它不支持json。所以我安装了最新版本phpMyAdmin4.8.0.1。现在我可以将json列添加到表中。添加json列时，执行查询，我可以看到结构：

但是，当我单击browse时，出现以下错误消息：

知道这是从哪里来的吗？当表中有一个json列时，我通常如何访问browse选项卡？
编辑：以下是apache2和mysql的日志：
apache2的error.log：

[Wed May 30 17:49:00.681304 2018] [core:notice] [pid 14677] AH00051: child pid 16591 exit signal Segmentation fault (11), possible coredump in /etc/apache2
[Wed May 30 17:49:00.681348 2018] [core:notice] [pid 14677] AH00051: child pid 17013 exit signal Segmentation fault (11), possible coredump in /etc/apache2
[Wed May 30 17:49:05.687043 2018] [core:notice] [pid 14677] AH00051: child pid 17015 exit signal Segmentation fault (11), possible coredump in /etc/apache2

mysql的error.log：

2018-05-30T15:49:00.082385Z 303017 [Note] Aborted connection 303017 to db: 'pointageversus' user: 'root' host: 'localhost' (Got an error reading communication packets)
2018-05-30T15:49:00.082385Z 303018 [Note] Aborted connection 303018 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2018-05-30T15:49:00.444586Z 303019 [Note] Aborted connection 303019 to db: 'pointageversus' user: 'root' host: 'localhost' (Got an error reading communication packets)
2018-05-30T15:49:00.444586Z 303020 [Note] Aborted connection 303020 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2018-05-30T15:49:05.661929Z 303010 [Note] Aborted connection 303010 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2018-05-30T15:49:05.661958Z 303009 [Note] Aborted connection 303009 to db: 'pointageversus' user: 'root' host: 'localhost' (Got an error reading communication packets)

apache2的access.log：

XX.XX.XX.XX - - [30/May/2018:17:48:37 +0200] "POST /tbl_structure.php HTTP/1.1" 200 1202 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.181 Safari/537.36"
XX.XX.XX.XX - - [30/May/2018:17:48:37 +0200] "POST /tbl_create.php HTTP/1.1" 200 2684 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.181 Safari/537.36"
XX.XX.XX.XX - - [30/May/2018:17:48:37 +0200] "GET /db_structure.php?server=1&db=pointageversus&table=&ajax_request=true&ajax_page_request=true&_nocache=1527695086610245467&token=%3F0%5BgrDzF%2F_%2Bs%22%5B(D HTTP/1.1" 200 19908 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.181 Safari/537.36"
XX.XX.XX.XX - - [30/May/2018:17:48:37 +0200] "POST /navigation.php?ajax_request=1 HTTP/1.1" 200 6226 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.181 Safari/537.36"
XX.XX.XX.XX - - [30/May/2018:17:48:37 +0200] "GET /tbl_structure.php?server=1&db=pointageversus&token=?0[grDzF/_+s%22[(D&goto=db_structure.php&table=contact2&ajax_request=true&ajax_page_request=true&_nocache=1527695086624542685&token=%3F0%5BgrDzF%2F_%2Bs%22%5B(D HTTP/1.1" 200 7873 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.181 Safari/537.36"
XX.XX.XX.XX - - [30/May/2018:17:48:38 +0200] "GET /themes/pmahomme/img/b_tblimport.png HTTP/1.1" 200 839 "http://phpmyadmin.versus-alternative.ch/phpmyadmin.css.php?nocache=6102843922ltr&server=1" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.181 Safari/537.36"
XX.XX.XX.XX - - [30/May/2018:17:48:38 +0200] "GET /themes/pmahomme/img/b_tblexport.png HTTP/1.1" 200 797 "http://phpmyadmin.versus-alternative.ch/phpmyadmin.css.php?nocache=6102843922ltr&server=1" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.181 Safari/537.36"
XX.XX.XX.XX - - [30/May/2018:17:48:38 +0200] "GET /themes/pmahomme/img/s_tbl.png HTTP/1.1" 200 928 "http://phpmyadmin.versus-alternative.ch/phpmyadmin.css.php?nocache=6102843922ltr&server=1" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.181 Safari/537.36"
XX.XX.XX.XX - - [30/May/2018:17:48:38 +0200] "GET /themes/pmahomme/img/b_move.png HTTP/1.1" 200 664 "http://phpmyadmin.versus-alternative.ch/phpmyadmin.css.php?nocache=6102843922ltr&server=1" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.181 Safari/537.36"
XX.XX.XX.XX - - [30/May/2018:17:48:38 +0200] "GET /themes/pmahomme/img/normalize.png HTTP/1.1" 200 788 "http://phpmyadmin.versus-alternative.ch/phpmyadmin.css.php?nocache=6102843922ltr&server=1" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.181 Safari/537.36"
XX.XX.XX.XX - - [30/May/2018:17:48:38 +0200] "GET /themes/pmahomme/img/b_edit.png HTTP/1.1" 200 660 "http://phpmyadmin.versus-alternative.ch/phpmyadmin.css.php?nocache=6102843922ltr&server=1" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.181 Safari/537.36"
XX.XX.XX.XX - - [30/May/2018:17:48:38 +0200] "GET /themes/pmahomme/img/b_primary.png HTTP/1.1" 200 820 "http://phpmyadmin.versus-alternative.ch/phpmyadmin.css.php?nocache=6102843922ltr&server=1" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.181 Safari/537.36"
XX.XX.XX.XX - - [30/May/2018:17:48:38 +0200] "GET /themes/pmahomme/img/b_unique.png HTTP/1.1" 200 866 "http://phpmyadmin.versus-alternative.ch/phpmyadmin.css.php?nocache=6102843922ltr&server=1" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.181 Safari/537.36"
XX.XX.XX.XX - - [30/May/2018:17:48:38 +0200] "GET /themes/pmahomme/img/b_index.png HTTP/1.1" 200 927 "http://phpmyadmin.versus-alternative.ch/phpmyadmin.css.php?nocache=6102843922ltr&server=1" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.181 Safari/537.36"
XX.XX.XX.XX - - [30/May/2018:17:48:38 +0200] "GET /themes/pmahomme/img/b_ftext.png HTTP/1.1" 200 833 "http://phpmyadmin.versus-alternative.ch/phpmyadmin.css.php?nocache=6102843922ltr&server=1" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.181 Safari/537.36"
XX.XX.XX.XX - - [30/May/2018:17:48:38 +0200] "GET /js/tbl_structure.js?v=4.8.0.1 HTTP/1.1" 200 5116 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.181 Safari/537.36"
XX.XX.XX.XX - - [30/May/2018:17:48:38 +0200] "GET /navigation.php?ajax_request=1&aPath=cm9vdA%3D%3D.cG9pbnRhZ2V2ZXJzdXM%3D.dmlld3M%3D&vPath=cm9vdA%3D%3D.cG9pbnRhZ2V2ZXJzdXM%3D.Vmlld3M%3D&pos=0&pos2_name=views&pos2_value=0&searchClause=&searchClause2=&_nocache=1527695087786998417&token=%3F0%5BgrDzF%2F_%2Bs%22%5B(D HTTP/1.1" 200 2776 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.181 Safari/537.36"
XX.XX.XX.XX - - [30/May/2018:17:48:53 +0200] "GET /db_structure.php?server=1&db=pointageversus&ajax_request=true&ajax_page_request=true&_nocache=1527695102868657800&token=%3F0%5BgrDzF%2F_%2Bs%22%5B(D HTTP/1.1" 200 19928 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.181 Safari/537.36"
XX.XX.XX.XX - - [30/May/2018:17:48:57 +0200] "GET /tbl_structure.php?db=pointageversus&table=contact2&ajax_request=true&ajax_page_request=true&_nocache=1527695106985813658&token=%3F0%5BgrDzF%2F_%2Bs%22%5B(D HTTP/1.1" 200 7853 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.181 Safari/537.36"

命令的结果 php -r 'phpinfo();' :
https://ufile.io/68ad0

mysqlJSONphpmyadmin

暂无答案！

目前还没有任何答案，快来回答吧！

我来回答

相关问题

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新问答

    更多
    • 蜀ICP备2022004421号-2 NULL123 https://www.null123.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com