Shop is broken when self hosting about bobdotbot

[BobDotCom]

Well for starters none of the code isn't really meant to be hosted in any bot besides the main one. Anyways this is probably happening because you didn't pass correct arguments to the command.

[CutieRei]

well first of all it seems that the number you are providing on the f string is None and the query is attempting to add another column which already exists

[CutieRei]

Well for starters none of the code isn't really meant to be hosted in any bot besides the main one. Anyways this is probably happening because you didn't pass correct arguments to the command.

actually the argument is filled but the database result is null which explains why the column name is itemNone and it seems they are hosting on the bot itself they just mean selfhost which means hosting locally

So, I am passing in the wrong arguments?

[CutieRei]

So, I am passing in the wrong arguments?

no you did not but the database query returned None in rows[-1][0] thats the issue

the rows itself is not empty but the index [-1][0] returned None

That means rows[-1][0] doesn't exist. But how is that possible?

[CutieRei]

That means rows[-1][0] doesn't exist. But how is that possible?

its possible because the column value can be null

Right, so in aiosqlite when you do rows = await cursor.fetchall() isn't the first index (i.e. [-1]) the last from the right. Which is the latest. In that the first index would be the ID of the item. Is this a bug with aiosqlite? Or are the indexes wrong?

[CutieRei]

Right, so in aiosqlite when you do rows = await cursor.fetchall() isn't the first index (i.e. [-1]) the last from the right. Which is the latest. In that the first index would be the ID of the item. Is this a bug with aiosqlite? Or are the indexes wrong?

as i said the column value is null try and print rows before indexing them

rows = await cursor.fetchall()
print(rows)
numbers = rows[-1][0]

k I fixed this, thanks @ReyterYT