I'm trying to upload the id of the users onto the database using sqllite however whenever i run the code and execute the command it shows this error
discord.ext.commands.errors.CommandInvokeError: Command raised an exception: NameError: name 'main' is not defined
async def add(self, ctx, user:discord.User):
if ctx.message.author.guild_permissions.manage_messages:
db = sqlite3.connect('main.sqlite')
cursor = main.cursor()
cursor.execute(f"SELECT Players FROM main")
result = cursor.fetchall()
if result != user.id:
sql = ("INSERT INTO main(Players) VALUES(?)")
val = (user.id)
await ctx.send(f"<@!{user.id}> has been added")
else:
await ctx.send(f"<@{user.id}> is already in teh database")
cursor.execute(sql,val)
db.commit()
cursor.close()
db.close()
question from:
https://stackoverflow.com/questions/66053284/discord-ext-commands-errors-commandinvokeerror-command-raised-an-exception-nam 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…