主页 / user-621241

ITACHI's questions

Martin Hope
ITACHI
Asked: 2024-10-17 18:41:46 +0800 CST
  • 5

我正在尝试给自己发送一封电子邮件。所有 2 封电子邮件都是我的。我使用操作系统、电子邮件、smtplib 以及远程机器人。

代码：

@bot.message_handler(commands=['test'])
def test_message(messagep):
   message = "WORKED!"
   bot.send_message(messagep.chat.id, test(message=message))


def test(message):
   sender = "[email protected]"
   orders = "[email protected]"
   password = os.getenv("app_password_email")

   print(message)

   server = smtplib.SMTP("smtp.yandex.ru", 587)
   server.starttls()

   try:
       server.login(sender, password)
       server.sendmail(sender, orders, message)

       return "The message was sent successfully!"
   except Exception as _ex:
       return f"{_ex}\nCheck your login or password please!"

错误：

'NoneType' object has no attribute 'encode'
python
Martin Hope
ITACHI
Asked: 2024-10-13 00:11:59 +0800 CST
  • 4

我正在尝试将从用户收到的变量值插入到表中：

try:
    # create table
    with connection.cursor() as cursor:
        role = "user"
        version = 0
        dol = 0
        #insert_query = "INSERT INTO `DataBaseRegAndLog` ('user', 'pass', 'role', 'version', 'email', 'dol') VALUES (%s, %s, %s, %s, %s, %s);"
        cursor.execute("INSERT INTO `DataBaseRegAndLog` ('user', 'pass', 'role', 'version', 'email', 'dol') VALUES (%s, %s, %s, %s, %s, %s)", (loginUser, passUser, role, version, emailUser, dol))
        connection.commit()

finally:
    connection.close()

except Exception as ex:
    print("Connection refused...")
    print(ex)

但它给了我错误 1064：

C:\Users\Demon\PycharmProjects\tg_DemonDostavka\.venv\Scripts\python.exe C:\Users\Demon\PycharmProjects\tg_DemonDostavka\main.py 
successfully connected...
####################
Connection refused...
(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 ''user', 'pass', 'role', 'version', 'email', 'dol') VALUES ('/reg', '/reg', 'user' at line 1")

我首先尝试将sql命令注册在一个单独的变量中，但它给出了一个错误。现在我知道一行中有一条sql命令和变量。

python