QPSQL: Unable to create query

Mikeeeeee

Hi!
I I get error: QPSQL: "42601", "QPSQL: Unable to create query".
How do I fix this?

void DataBase::openDB()
{
    dataBase = QSqlDatabase::addDatabase("QPSQL");
    dataBase.setDatabaseName("db_taxi_vik_park");
    //ResumeDB.setDatabaseName("1");
    dataBase.setUserName("postgres");
    dataBase.setPassword("1qaz");
    //ResumeDB.setHostName("127.0.0.1");
    dataBase.setPort(5433);//*/
    if (dataBase.open()) {
        qDebug()<<"db is opened \r\n";}
    else {
        qDebug()<<"db not opened \r\n";}
}

QVector<QMap<QString, QString> > DataBase::getAllAccauntWithoutPhoto()
{
    QVector<QMap<QString, QString> > resultVector;
    QMap<QString, QString> valueMap;
    QSqlQuery query;
    query.prepare("SELECT "
                  "id, "
                  "name, "
                  "email, "
                  "login, "
                  "password, "
                  "date_create, "
                  "date_block, "
                  "id_key_device, "
                  "number_of_downloaded_games, "
                  "blocked_bool, "
                  "comment "
                  " FROM public.account "
                  " ;");

    if (!query.exec()) {qDebug()<<"not get data from db \r\n"<<query.lastError()<<"\r\n";}
    else {
        qDebug()<<"get data from db \r\n";
        query.first();

        valueMap["id"] = query.value(0).toString();
        valueMap["name"] = query.value(1).toString();
        valueMap["email"] = query.value(2).toString();
        valueMap["login"] = query.value(3).toString();
        valueMap["password"] = query.value(4).toString();
        valueMap["date_create"] = query.value(5).toString();
        valueMap["date_block"] = query.value(6).toString();
        valueMap["id_key_device"] = query.value(7).toString();
        valueMap["number_of_downloaded_games"] = query.value(8).toString();
        valueMap["blocked_bool"] = query.value(9).toString();
        valueMap["comment"] = query.value(10).toString();

        resultVector.append(valueMap);

        while (query.next()) {
            valueMap["id"] = query.value(0).toString();
            valueMap["name"] = query.value(1).toString();
            valueMap["email"] = query.value(2).toString();
            valueMap["login"] = query.value(3).toString();
            valueMap["password"] = query.value(4).toString();
            valueMap["date_create"] = query.value(5).toString();
            valueMap["date_block"] = query.value(6).toString();
            valueMap["id_key_device"] = query.value(7).toString();
            valueMap["number_of_downloaded_games"] = query.value(8).toString();
            valueMap["blocked_bool"] = query.value(9).toString();
            valueMap["comment"] = query.value(10).toString();
            resultVector.append(valueMap);
        }
    }
    return resultVector;
}

Christian Ehrlicher

By looking what this error means: https://www.postgresql.org/docs/10/errcodes-appendix.html

Try to run your query directly with psql to see where exactly the error is.
Also there is no need to use prepare() here since you don't bind any values.

Mikeeeeee

@Christian-Ehrlicher I tried making a query in psql and the query works.
I also tried to make this request

    QSqlQuery query("select * from public.account");
    QSqlError error = query.lastError();
    if (error.type() == QSqlError::NoError) {
        while(query.next())
        {
            qDebug() << query.value(0).toString();
        }
    }
    else {
        qDebug() << error.text();
    }

But I got the error of not having a table, whereas the table is exactly there.

Christian Ehrlicher

The table is 'account', the schema public - try without schema

Mikeeeeee

@Christian-Ehrlicher Can there be a problem with a bad driver?

Mikeeeeee

@Christian-Ehrlicher it is too not work:

QSqlQuery query("SELECT *  FROM account ", dataBase);


    if (!query.exec()) {
        qDebug()<<"not get data from db \r\n"<<query.lastError()<<"\r\n";
    qDebug()<<query.lastQuery();
    }
    else {
        qDebug()<<"get data from db \r\n";
        query.first();



    }
    return resultVector;

Mikeeeeee

I use psql 12 in the windows 7 64

Christian Ehrlicher

So where do you get the error? during query.exec()? And what error? The same as in the first post?

Mikeeeeee

@Christian-Ehrlicher said in QPSQL: Unable to create query:

query.exec()

Yes, in query.exec(). The same error. Looks like it's the driver. How do I find out which version of the driver is designed for?

Mikeeeeee

Do you connect PSQL to the project and it works normally?

Christian Ehrlicher

@Mikeeeeee I'm using psql since ages with Qt. Imo it's a problem with your psql installation. Simply test it with a sqlite database. Also you should take a look what others did to solve the psql 42601 error but that's not Qt related

Mikeeeeee

Before the update, I had PSQL working, after the update, new drivers were added and it stopped working.

Christian Ehrlicher

Thenswitch back to the old PostgreSQL - or do you really need some new features in PostgreSQL 12 (btw: psql 12 is supported since Qt5.14 and works fine here)

Mikeeeeee

Sorry, I'm in a connection indicated is not the base, my stupid mistake.