Need help with SQLite data input

[donmerch]

My code checks if an account number exists and if so just prints a statement saying so, else if not then it asks for a name and then stores the new account number and name.

I have defined the data type for the fields both as TEXT. My program works if I only enter a single digit but if I enter a number of 2 or more digits then I get an error. But what is confusing to me is that I can enter a name for customer name with many characters and it stores fine even though both fields are defined as TEXT. I also tried defining the account number field as INTEGER and REAL and I get the same result.

Here's my code:

import sqlite3

conn = sqlite3.connect('example.db')
c = conn.cursor()

def create_table():
    c.execute('CREATE TABLE IF NOT EXISTS customers_main(acctnum TEXT, custname TEXT)')
    
def manual_input():
    account = input("Enter account number: ")
    
    c.execute("SELECT acctnum from customers_main WHERE acctnum=?", (account))

    result = c.fetchone()

    if result:
        print('Customer in database!')
    else:
        customername = input('Enter customer name: ')
        c.execute("INSERT INTO customers_main VALUES (?, ?)", (account, customername))
        conn.commit()

create_table() 
manual_input()

c.close()
conn.close()

And here's the error:

Error:
=================== RESTART: /home/pi/Documents/forum1.py ===================
Enter account number: 1
Enter customer name: Don
>>> 
=================== RESTART: /home/pi/Documents/forum1.py ===================
Enter account number: 1
Customer in database!
>>> 
=================== RESTART: /home/pi/Documents/forum1.py ===================
Enter account number: 1234
Traceback (most recent call last):
  File "/home/pi/Documents/forum1.py", line 24, in <module>
    manual_input()
  File "/home/pi/Documents/forum1.py", line 12, in manual_input
    c.execute("SELECT acctnum from customers_main WHERE acctnum=?", (account))
sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 1, and there are 4 supplied.

What am I doing wrong?

[Larz60+]

You never put anything in the database,
the table was created properly
using the command line interface, here's a snapshot of your database:

Output:
λ sqlite3 example.db
SQLite version 3.21.0 2017-10-24 18:55:49
Enter ".help" for usage hints.
sqlite> .schema
CREATE TABLE customers_main(acctnum TEXT, custname TEXT);
sqlite> select * from customers_main;
sqlite> select count(*) from customers_main;
0
sqlite> .quit

[donmerch]

Actually I did store something in the database. If you look at the error message you can see that I entered 1 then my name and it was stored. I then ran it again and entered 1 and it printed my message indicating that it exists. I then ran it a 3rd time and entered 1234 and that's when I got the error.

[Larz60+]

But that's not done until after you run:

c.execute("SELECT acctnum from customers_main WHERE acctnum=?", (account))

which creates the error because at this point, the table is empty

[donmerch]

Perhaps I need to ask the question in a different way- why will it let me store a row (record) using a single digit or letter in first column but not multiple digits or letters? It will store multiple letters in second column which in my mind is defined the same as first column.