Column count not matching the amount of columns in database
posted 6 years ago
I am having a problem with the above error being produced from my code
In the query variable I have
In the SQL code my schema is set up like this
My problem is that two of my columns are set automatically (userID, userLocked). So I thought all I need to set is the userName and password. But whenever I run this code I get the error Column count doesn't match value count at row 1. So how do I represent these columns without setting them in the code? Thanks in advance for any advice.