Parameter count mismatch on SELECT statement - SQLITE using Bindvalues

cxam

Hi, I'm currently facing an error where I get "Parameter count mismatch" from query.lastError, my bindvalues are correct (i've tested them).

My query is:

QSqlQuery query(DBT);
    query.prepare("SELECT Foto, Nombre, Apellido1, Apellido2, Curso, Grupo, FotoHuella FROM usuarios WHERE Nombre=:nombre1 OR Apellido1=:apellido1 OR Apellido2=:apellido2 OR Curso=:curso1 OR Grupo=:grupo1");
        query.bindValue(":nombre1", nombre);
        query.bindValue(":apellido1", apellido1);
        query.bindValue(":apellido2", apellido2);
        query.bindValue(":curso1", curso);
        query.bindValue(":grupo1", grupo);
    query.exec();

In case you where wondering here is where I set up the database:

QSqlDatabase DBT=QSqlDatabase::addDatabase("QSQLITE");
    DBT.setDatabaseName("/home/pi/FoodCircleDBT.db");
    DBT.open();

Thanks in advance.

cxam

Allright, I finally figured it out, the problem was the database was corrupt, and i had to create another one manually because if I created the DB with some program it gets corrupted

VRonin

normally this error is due to a typo in the field names. check the "column" names

cxam

Allright, I finally figured it out, the problem was the database was corrupt, and i had to create another one manually because if I created the DB with some program it gets corrupted