(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 \'\ufeff\nselect t.品类,t.`厂商`,\nsum(case when 渠道类型 = "线上线下" then\' at line 1')
Traceback (most recent call last):
File "C:\Program Files (x86)\ShadowBot\shadowbot-5.6.26\python\lib\runpy.py", line 193, in _run_module_as_main
"__main__", mod_spec)
File "C:\Program Files (x86)\ShadowBot\shadowbot-5.6.26\python\lib\runpy.py", line 85, in _run_code
exec(code, run_globals)
File "C:\Program Files (x86)\ShadowBot\shadowbot-5.6.26\python\lib\site-packages\xbot_interpreter.py", line 67, in <module>
main()
File "C:\Program Files (x86)\ShadowBot\shadowbot-5.6.26\python\lib\site-packages\xbot_interpreter.py", line 45, in main
try:
File "C:\Users\Administrator\AppData\Local\ShadowBot\users\675e04a7-91f0-413b-a0a4-1e869e9720de\apps\6591523c-5af9-4359-b46b-554120827965\xbot_robot\process1.py", line 33, in main
], _block=("子流程1", 10, "执行 SQL 语句"))
File "<string>", line 79, in wrapper
File "<string>", line 74, in wrapper
File "<string>", line 82, in run
File "C:\Users\Administrator\AppData\Local\ShadowBot\users\675e04a7-91f0-413b-a0a4-1e869e9720de\apps\6591523c-5af9-4359-b46b-554120827965\xbot_extensions\activity_759a3f99\process1.py", line 56, in main
}, _block=("执行 SQL 语句", 20, "调用模块"))
File "<string>", line 79, in wrapper
File "<string>", line 74, in wrapper
File "<string>", line 79, in wrapper
File "<string>", line 74, in wrapper
File "<string>", line 37, in invoke_module
File "C:\Users\Administrator\AppData\Local\ShadowBot\users\675e04a7-91f0-413b-a0a4-1e869e9720de\apps\6591523c-5af9-4359-b46b-554120827965\xbot_extensions\activity_759a3f99\utils.py", line 64, in execute_sql
query_result = MySQL_functions.execute_an_sql(host, port, username, password, database_name, sql_sentence, charset)
File "C:\Users\Administrator\AppData\Local\ShadowBot\users\675e04a7-91f0-413b-a0a4-1e869e9720de\apps\6591523c-5af9-4359-b46b-554120827965\xbot_extensions\activity_759a3f99\MySQL_functions.py", line 101, in execute_an_sql
raise ValueError(error)
ValueError: (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 \'\ufeff\nselect t.品类,t.`厂商`,\nsum(case when 渠道类型 = "线上线下" then\' at line 1')