找回密码
 立即注册

扫一扫,访问微社区

QQ登录

只需一步,快速开始

查看: 2155|回复: 1

[求助] 爬虫连接数据库出现的错误,谁能帮助解决下

1

主题

1

帖子

1

积分

贫民

积分
1
wx_QQFP2Ph6 发表于 2018-9-18 18:58:51 | 显示全部楼层 |阅读模式
Traceback (most recent call last):
  File "C:/Users/19837/PycharmProjects/test_mysql/zl_test.py", line 223, in <module>
    get_page(page)
  File "C:/Users/19837/PycharmProjects/test_mysql/zl_test.py", line 119, in get_page
    read_contents()
  File "C:/Users/19837/PycharmProjects/test_mysql/zl_test.py", line 212, in read_contents
    priority,internationalApplication,internationalPublication,entryDate,patentTypeNumber)
  File "C:/Users/19837/PycharmProjects/test_mysql/zl_test.py", line 100, in inserttable
    priority,internationalApplication,internationalPublication,entryDate,patentTypeNumber))
  File "C:\Users\19837\PycharmProjects\test_mysql\venv\lib\site-packages\pymysql\cursors.py", line 168, in execute
    query = self.mogrify(query, args)
  File "C:\Users\19837\PycharmProjects\test_mysql\venv\lib\site-packages\pymysql\cursors.py", line 147, in mogrify
    query = query % self._escape_args(args, conn)
  File "C:\Users\19837\PycharmProjects\test_mysql\venv\lib\site-packages\pymysql\cursors.py", line 122, in _escape_args
    return tuple(conn.literal(arg) for arg in args)
  File "C:\Users\19837\PycharmProjects\test_mysql\venv\lib\site-packages\pymysql\cursors.py", line 122, in <genexpr>
    return tuple(conn.literal(arg) for arg in args)
  File "C:\Users\19837\PycharmProjects\test_mysql\venv\lib\site-packages\pymysql\connecti**.py", line 469, in literal
    return self.escape(obj, self.encoders)
  File "C:\Users\19837\PycharmProjects\test_mysql\venv\lib\site-packages\pymysql\connecti**.py", line 462, in escape
    return converters.escape_item(obj, self.charset, mapping=mapping)
  File "C:\Users\19837\PycharmProjects\test_mysql\venv\lib\site-packages\pymysql\converters.py", line 27, in escape_item
    val = encoder(val, mapping)
  File "C:\Users\19837\PycharmProjects\test_mysql\venv\lib\site-packages\pymysql\converters.py", line 118, in escape_unicode
    return u"'%s'" % _escape_unicode(value)
  File "C:\Users\19837\PycharmProjects\test_mysql\venv\lib\site-packages\pymysql\converters.py", line 73, in _escape_unicode
    return value.translate(_escape_table)
AttributeError: 'builtin_function_or_method' object has no attribute 'translate'
回复

使用道具 举报

0

主题

956

帖子

956

积分

圣骑士

积分
956
sheeboard 发表于 2018-9-19 14:21:25 | 显示全部楼层
最好相关代码也贴出来
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

快速回复 返回顶部 返回列表