广告

10 手机使用支付宝完成支付后提示"系统出现错误、请联系管理员或到shopxo社区查阅~"

如题,使用手机下单,用支付宝支付出现错误,但到个人中心查看订单,又显示已经支付了;然后使用电脑下单选支付宝一切是正常的,如下图:

attachments-2021-01-csgLmLKU601518817bfeb.png

attachments-2021-01-RDjHDqPH601518a4b88b1.png


查看论坛,发现说可查下日志,我把日志发出来,请大大们帮忙分析一下,谢谢!


---------------------------------------------------------------

[ 2021-01-30T16:32:29+08:00 ] 183.57.248.162 GET www.tehuide.com/

[ sql ] [ DB ] CONNECT:[ UseTime:0.002156s ] mysql:host=127.0.0.1;port=3306;dbname=shopxo_com;charset=utf8

[ sql ] [ SQL ] SHOW COLUMNS FROM `s_quick_nav` [ RunTime:0.010170s ]

[ sql ] [ SQL ] SELECT `id`,`name`,`images_url`,`event_value`,`event_type`,`bg_color` FROM `s_quick_nav` WHERE  `platform` = 'pc'  AND `is_enable` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000108s ]

[ sql ] [ SQL ] SHOW COLUMNS FROM `s_goods_category` [ RunTime:0.000341s ]

[ sql ] [ SQL ] SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `s_goods_category` WHERE  `pid` = 0  AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000093s ]

[ sql ] [ SQL ] SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `s_goods_category` WHERE  `pid` = 1  AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000089s ]

[ sql ] [ SQL ] SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `s_goods_category` WHERE  `pid` IN (58,59,60,61,62,63,64,65,66,67,102)  AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000177s ]

[ sql ] [ SQL ] SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `s_goods_category` WHERE  `pid` = 2  AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000124s ]

[ sql ] [ SQL ] SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `s_goods_category` WHERE  `pid` IN (304,305,306,307,308,309,310,311,188,189,190,191,192)  AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000222s ]

[ sql ] [ SQL ] SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `s_goods_category` WHERE  `pid` = 3  AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000102s ]

[ sql ] [ SQL ] SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `s_goods_category` WHERE  `pid` IN (236,237,238,239,240,241,242,243,244,245)  AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000124s ]

[ sql ] [ SQL ] SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `s_goods_category` WHERE  `pid` = 7  AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000082s ]

[ sql ] [ SQL ] SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `s_goods_category` WHERE  `pid` IN (452,453,454,455,456,457,458)  AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000118s ]

[ sql ] [ SQL ] SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `s_goods_category` WHERE  `pid` = 52  AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000086s ]

[ sql ] [ SQL ] SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `s_goods_category` WHERE  `pid` IN (512,513,514,515,516,517,518,519,520,511)  AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000119s ]

[ sql ] [ SQL ] SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `s_goods_category` WHERE  `pid` = 53  AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000086s ]

[ sql ] [ SQL ] SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `s_goods_category` WHERE  `pid` IN (572,573,574,575,576,577,578,579)  AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000122s ]

[ sql ] [ SQL ] SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `s_goods_category` WHERE  `pid` = 54  AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000084s ]

[ sql ] [ SQL ] SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `s_goods_category` WHERE  `pid` IN (639,640,641,642,643,644,645,646)  AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000173s ]

[ sql ] [ SQL ] SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `s_goods_category` WHERE  `pid` = 55  AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000090s ]

[ sql ] [ SQL ] SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `s_goods_category` WHERE  `pid` IN (736,737,738,739,740,741,742,743,744,745,746,747)  AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000121s ]

[ sql ] [ SQL ] SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `s_goods_category` WHERE  `pid` = 56  AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000086s ]

[ sql ] [ SQL ] SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `s_goods_category` WHERE  `pid` IN (798,799,800,801,802,803,804,805)  AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000132s ]

[ sql ] [ SQL ] SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `s_goods_category` WHERE  `pid` = 57  AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000080s ]

[ sql ] [ SQL ] SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `s_goods_category` WHERE  `pid` IN (872,873,874,875,876)  AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000090s ]

[ sql ] [ SQL ] SHOW COLUMNS FROM `s_link` [ RunTime:0.000370s ]

[ sql ] [ SQL ] SELECT * FROM `s_link` WHERE  `is_enable` = 1 ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000078s ]

[ sql ] [ SQL ] SHOW COLUMNS FROM `s_cart` [ RunTime:0.000319s ]

[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_cart` WHERE  `user_id` = 1 LIMIT 1 [ RunTime:0.000068s ]

[ sql ] [ SQL ] SHOW COLUMNS FROM `s_message` [ RunTime:0.000310s ]

[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_message` WHERE  `is_delete_time` = 0  AND `user_id` = 1  AND `is_read` = 0 LIMIT 1 [ RunTime:0.000068s ]

[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_cart` WHERE  `user_id` = 1 LIMIT 1 [ RunTime:0.000119s ]

[ sql ] [ SQL ] SHOW COLUMNS FROM `s_slide` [ RunTime:0.000320s ]

[ sql ] [ SQL ] SELECT `name`,`images_url`,`event_value`,`event_type`,`bg_color` FROM `s_slide` WHERE  `platform` = 'pc'  AND `is_enable` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000073s ]

[ sql ] [ SQL ] SHOW COLUMNS FROM `s_app_home_nav` [ RunTime:0.000313s ]

[ sql ] [ SQL ] SELECT `id`,`name`,`images_url`,`event_value`,`event_type`,`bg_color`,`is_need_login` FROM `s_app_home_nav` WHERE  `platform` = 'pc'  AND `is_enable` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000069s ]

[ sql ] [ SQL ] SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `s_goods_category` WHERE  `pid` = 0  AND `is_home_recommended` = 1  AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000085s ]

[ sql ] [ SQL ] SELECT `id` FROM `s_goods_category` WHERE  `pid` IN (1)  AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000075s ]

[ sql ] [ SQL ] SELECT `id` FROM `s_goods_category` WHERE  `pid` IN (58,67,66,65,64,63,62,61,60,59,102)  AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000099s ]

[ sql ] [ SQL ] SELECT `id` FROM `s_goods_category` WHERE  `pid` IN (141,157,158,159,160,161,162,163,164,165,166,167,168,156,155,154,142,143,144,145,146,147,148,149,150,151,152,153,169,170,171,187,90,91,92,93,94,95,96,97,98,99,100,186,185,184,172,173,174,175,176,177,178,179,180,181,182,183,101,140,68,84,85,86,87,88,89,103,104,105,106,107,108,83,82,81,69,70,71,72,73,74,75,76,77,78,79,80,109,110,111,127,128,129,130,131,132,133,134,135,136,137,138,126,125,124,112,113,114,115,116,117,118,119,120,121,122,123,139)  AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000225s ]

[ sql ] [ SQL ] SHOW COLUMNS FROM `s_goods` [ RunTime:0.000467s ]

[ sql ] [ SQL ] SELECT `g`.`id` FROM `s_goods` `g` INNER JOIN `s_goods_category_join` `gci` ON `g`.`id`=`gci`.`goods_id` WHERE  `gci`.`category_id` IN ('1','58','67','66','65','64','63','62','61','60','59','102','141','157','158','159','160','161','162','163','164','165','166','167','168','156','155','154','142','143','144','145','146','147','148','149','150','151','152','153','169','170','171','187','90','91','92','93','94','95','96','97','98','99','100','186','185','184','172','173','174','175','176','177','178','179','180','181','182','183','101','140','68','84','85','86','87','88','89','103','104','105','106','107','108','83','82','81','69','70','71','72','73','74','75','76','77','78','79','80','109','110','111','127','128','129','130','131','132','133','134','135','136','137','138','126','125','124','112','113','114','115','116','117','118','119','120','121','122','123','139')  AND `g`.`is_shelves` = '1' GROUP BY `g`.`id` ORDER BY `g`.`id` DESC LIMIT 8 [ RunTime:0.000212s ]

[ sql ] [ SQL ] SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `s_goods_category` WHERE  `id` IN (58,59,60,61,62,63)  AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000090s ]

[ sql ] [ SQL ] SELECT `id` FROM `s_goods_category` WHERE  `pid` IN (2)  AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000077s ]

[ sql ] [ SQL ] SELECT `id` FROM `s_goods_category` WHERE  `pid` IN (188,310,309,308,307,306,305,304,192,191,190,189,311)  AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000107s ]

[ sql ] [ SQL ] SELECT `id` FROM `s_goods_category` WHERE  `pid` IN (405,393,392,391,390,389,388,387,386,385,394,395,404,403,402,401,400,399,398,397,396,384,383,382,370,369,368,367,366,365,364,363,362,371,372,381,380,379,378,377,376,375,374,373,361,406,451,439,438,437,436,435,434,433,432,431,440,441,450,449,448,447,446,445,444,443,442,430,429,428,416,415,414,413,412,411,410,409,408,417,418,427,426,425,424,423,422,421,420,419,407,360,313,225,224,223,222,221,220,219,218,217,226,227,312,235,234,233,232,231,230,229,228,216,215,214,202,201,200,199,198,197,196,195,194,203,204,213,212,211,210,209,208,207,206,205,193,314,359,347,346,345,344,343,342,341,340,339,348,349,358,357,356,355,354,353,352,351,350,338,337,336,324,323,322,321,320,319,318,317,316,325,326,335,334,333,332,331,330,329,328,327,315)  AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000275s ]

[ sql ] [ SQL ] SELECT `g`.`id` FROM `s_goods` `g` INNER JOIN `s_goods_category_join` `gci` ON `g`.`id`=`gci`.`goods_id` WHERE  `gci`.`category_id` IN ('2','188','310','309','308','307','306','305','304','192','191','190','189','311','405','393','392','391','390','389','388','387','386','385','394','395','404','403','402','401','400','399','398','397','396','384','383','382','370','369','368','367','366','365','364','363','362','371','372','381','380','379','378','377','376','375','374','373','361','406','451','439','438','437','436','435','434','433','432','431','440','441','450','449','448','447','446','445','444','443','442','430','429','428','416','415','414','413','412','411','410','409','408','417','418','427','426','425','424','423','422','421','420','419','407','360','313','225','224','223','222','221','220','219','218','217','226','227','312','235','234','233','232','231','230','229','228','216','215','214','202','201','200','199','198','197','196','195','194','203','204','213','212','211','210','209','208','207','206','205','193','314','359','347','346','345','344','343','342','341','340','339','348','349','358','357','356','355','354','353','352','351','350','338','337','336','324','323','322','321','320','319','318','317','316','325','326','335','334','333','332','331','330','329','328','327','315')  AND `g`.`is_shelves` = '1' GROUP BY `g`.`id` ORDER BY `g`.`id` DESC LIMIT 8 [ RunTime:0.000291s ]

[ sql ] [ SQL ] SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `s_goods_category` WHERE  `id` IN (304,305,306,307,308,309)  AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000097s ]

[ sql ] [ SQL ] SELECT * FROM `s_goods` WHERE  `id` IN (8,7,6,5,4,3,2,1,11,10,9)  AND `is_shelves` = 1 ORDER BY `id` DESC [ RunTime:0.000150s ]

[ sql ] [ SQL ] SHOW COLUMNS FROM `s_brand` [ RunTime:0.000332s ]

[ sql ] [ SQL ] SELECT `name` FROM `s_brand` WHERE  `id` = 3 LIMIT 1 [ RunTime:0.000060s ]

[ sql ] [ SQL ] SELECT `name` FROM `s_brand` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000070s ]

[ sql ] [ SQL ] SELECT `name` FROM `s_brand` WHERE  `id` = 1 LIMIT 1 [ RunTime:0.000092s ]

[ sql ] [ SQL ] SELECT `name` FROM `s_brand` WHERE  `id` = 1 LIMIT 1 [ RunTime:0.000061s ]

[ sql ] [ SQL ] SELECT `name` FROM `s_brand` WHERE  `id` = 1 LIMIT 1 [ RunTime:0.000057s ]

[ sql ] [ SQL ] SELECT `name` FROM `s_brand` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000059s ]

[ sql ] [ SQL ] SELECT `name` FROM `s_brand` WHERE  `id` = 1 LIMIT 1 [ RunTime:0.000056s ]

[ sql ] [ SQL ] SELECT `name` FROM `s_brand` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000057s ]

[ sql ] [ SQL ] SELECT `name` FROM `s_brand` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000055s ]

[ sql ] [ SQL ] SELECT `name` FROM `s_brand` WHERE  `id` = 1 LIMIT 1 [ RunTime:0.000055s ]

[ sql ] [ SQL ] SHOW COLUMNS FROM `s_article` [ RunTime:0.000880s ]

[ sql ] [ SQL ] SELECT `id`,`title`,`title_color`,`article_category_id` FROM `s_article` WHERE  `is_enable` = 1  AND `is_home_recommended` = 1 ORDER BY `id` DESC LIMIT 0,9 [ RunTime:0.000089s ]

[ sql ] [ SQL ] SHOW COLUMNS FROM `s_article_category` [ RunTime:0.000283s ]

[ sql ] [ SQL ] SELECT `id`,`name` FROM `s_article_category` WHERE  `id` IN (24,18,17) [ RunTime:0.000066s ]

[ sql ] [ SQL ] SHOW COLUMNS FROM `s_order` [ RunTime:0.009480s ]

[ sql ] [ SQL ] SELECT COUNT(DISTINCT id) AS count, status FROM `s_order` WHERE  `is_delete_time` = 0  AND `user_is_delete_time` = 0  AND `user_id` = 1 GROUP BY `status` [ RunTime:0.000116s ]

[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_order` WHERE  `is_delete_time` = 0  AND `user_is_delete_time` = 0  AND `user_id` = 1  AND `user_is_comments` = 0  AND `status` = 4 LIMIT 1 [ RunTime:0.000100s ]

---------------------------------------------------------------

[ 2021-01-30T16:32:31+08:00 ] 183.57.248.162 GET www.tehuide.com/index.php?s=/index/ueditor/index/path_type/user-1.html&action=config&&noCache=1611995512764

[ sql ] [ DB ] CONNECT:[ UseTime:0.000352s ] mysql:host=127.0.0.1;port=3306;dbname=shopxo_com;charset=utf8

[ sql ] [ SQL ] SHOW COLUMNS FROM `s_link` [ RunTime:0.000520s ]

[ sql ] [ SQL ] SELECT * FROM `s_link` WHERE  `is_enable` = 1 ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000105s ]

[ sql ] [ SQL ] SHOW COLUMNS FROM `s_cart` [ RunTime:0.000324s ]

[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_cart` WHERE  `user_id` = 1 LIMIT 1 [ RunTime:0.000067s ]

[ sql ] [ SQL ] SHOW COLUMNS FROM `s_message` [ RunTime:0.000305s ]

[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_message` WHERE  `is_delete_time` = 0  AND `user_id` = 1  AND `is_read` = 0 LIMIT 1 [ RunTime:0.000077s ]

[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `s_cart` WHERE  `user_id` = 1 LIMIT 1 [ RunTime:0.000071s ]



请先 登录 后评论

最佳答案 2021-01-30 23:12

应用商店下载最新支付宝支付插件安装即可解决问题

请先 登录 后评论

其它 1 个回答

13712344353

感谢,原来是这样真的可以解决了,建议版本更新这个bug,或者把这个原有的删除也可以,让别人知道重新安装就可以了。对于刚刚入手的人来说,测试遇到问题,影响心情,严重的以为是bug,用不了,放弃。

请先 登录 后评论