File "D:\program\python\Python39\lib\site-packages\pymysql\connections.py", line 358, in __init__ self.connect()
时间: 2023-12-07 12:40:02 浏览: 40
根据提供的引用内容,可以看出这是在使用Python中的pymysql库连接数据库时出现的错误。具体来说,这个错误是由于端口号传递的不是数字类型导致的。解决这个问题的方法是将端口号转换为整数类型。可以使用int()函数将端口号转换为整数类型,例如:
```python
port = '3306'
conn = pymysql.connect(host='localhost', port=int(port), user='root', password='123456', db='test')
```
另外,还可以检查一下端口号是否正确,以及是否有其他错误导致端口号无法正确传递。
相关问题
Exception in Tkinter callback Traceback (most recent call last): File "D:\python\lib\tkinter\__init__.py", line 1892, in __call__ return self.func(*args) File "D:\桌面\mx_B\March\高景报料界面.py", line 46, in auto_insert1 cursor.execute("INSERT INTO (name, age, email) bool (?, ?, ?)") File "D:\python\lib\site-packages\pymysql\cursors.py", line 148, in execute result = self._query(query) File "D:\python\lib\site-packages\pymysql\cursors.py", line 310, in _query conn.query(q) File "D:\python\lib\site-packages\pymysql\connections.py", line 548, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "D:\python\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result result.read() File "D:\python\lib\site-packages\pymysql\connections.py", line 1156, in read first_packet = self.connection._read_packet() File "D:\python\lib\site-packages\pymysql\connections.py", line 725, in _read_packet packet.raise_for_error() File "D:\python\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "D:\python\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.ProgrammingError: (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 '(name, age, email) bool (?, ?, ?)' at line 1")
这是一个 Python 中使用 PyMySQL 操作 MySQL 数据库时出现的错误。错误信息显示 SQL 语句存在语法错误,检查一下 SQL 语句的语法是否正确。根据错误信息,可能是 INSERT INTO 语句中字段名的格式不正确,或者是 VALUES 关键字缺失等问题导致的。建议将 SQL 语句拆分成多行,逐行检查语法是否正确。
File "d:\python 3.8\lib\site-packages\SCons\Script\Main.py", line 965, in _main
这个错误出现在SCons的Main.py文件的第965行。根据引用中的解决方法,你可以通过编辑TensorflowPlugin.py文件来解决这个错误。具体步骤为:在文件路径/home/wangsp/anaconda3/lib/python3.6/site-packages/nuitka/plugins/standard/TensorflowPlugin.py中找到第90行,将elements = module_name.split(".")修改为elements = module_name.getBasename()。
另外,你还可以尝试安装scons-4.0.0来解决这个问题。根据引用中的方法,你可以在终端输入以下命令来安装scons-4.0.0:
tar -xvf scons-4.0.0.tar.gz && cd SCons-4.0.0
sudo python3 setup.py install
注意,如果你的python版本不是3.8,那么应该相应地修改安装命令中的python版本号。
此外,根据引用中提供的信息,你还可以检查python模块的路径是否包含了/usr/local/lib/python3.8/dist-packages和/usr/lib/python3/dist-packages。
总结一下,要解决File "d:\python 3.8\lib\site-packages\SCons\Script\Main.py", line 965, in _main的错误,你可以尝试以下几个方法:
1. 编辑TensorflowPlugin.py文件,修改对应代码行。
2. 安装scons-4.0.0。
3. 检查python模块的路径是否正确。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* *3* [Nuitka-Python 打包](https://blog.csdn.net/wsp_1138886114/article/details/114115316)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"]
- *2* [【问题解决】SCons version 2.4.1 does not run under Python version 3.8.0.](https://blog.csdn.net/p1279030826/article/details/111464816)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]