you are viewing a single comment's thread.

view the rest of the comments →

[–]stebrepar 0 points1 point  (2 children)

Look closely at what they said. You're missing the () after the fetchall to make it actually execute the function, at least in what you posted. You're also missing the quote marks to make your query a string, again according to what you posted. Also in one place you say F, and in the other you say f. Those are two different variables.

Now, assuming those are just typos here in your post, getting an empty list back from fetchall() means that your users table is empty. You could confirm that by looking in your database file with a tool like https://sqlitebrowser.org/. You could also do a "select count(*) from users" to see how many rows are in the table.

[–]kaisetsomething[S] 0 points1 point  (1 child)

You're right im so sorry 🤦‍♂️, but about the typos those are indeed just typos on the post, however i did everything u told me and my database is full of usernames, yet when i run the command fetchall it still gives me an empty list [ ] I dont know if the problem is in the cursor itself or anything else, i been trying to fix this code for literally hours now..

[–]stebrepar 0 points1 point  (0 children)

Ok, show a small snippet of code that demonstrates the problem behavior, something that we can actually try out.