[Interest] SQLite: mystic bug: No query Unable to fetch row error
Scott Bloom
scott at towel42.com
Thu Jan 14 17:06:54 CET 2021
Did the prepare fail?
Do you check to see that the "m_db" database is valid, open, and connected?
Scott
-----Original Message-----
From: Interest [mailto:interest-bounces at qt-project.org] On Behalf Of Alexander Dyagilev
Sent: Thursday, January 14, 2021 07:19
To: interest at qt-project.org
Subject: [Interest] SQLite: mystic bug: No query Unable to fetch row error
Hello,
Each instance of our app is supposed to have an unique id (UUID).
At every start, it check if it has assigned one, and if not - generates it and saves it to the SQLite database.
We've found, that 4% of ours users has empty UUIDs.
We've added some diagnostic reporting info and found, that this is caused by SQLite database not being able to write generated UUID to it.
QSqlQuery::exec returns false and its last error returns this error "No query Unable to fetch row error".
How can this be? I could not find any problems working with the database in our code.
We do it so:
1. Make sure the table exists:
"CREATE TABLE IF NOT EXISTS miscData (Name TEXT, Value BLOB, PRIMARY KEY (Name))"
2. Write value to the table:
QSqlQuery query(m_db);
query.prepare("REPLACE INTO miscData (Name, Value) VALUES (:Name, :Value)"); query.bindValue(":Name", "UUID"); query.bindValue(":Value", UuidByteArray);
if (!query.exec())
{
// here we're getting this error....
}
What are the possible reasons of this error?
_______________________________________________
Interest mailing list
Interest at qt-project.org
https://lists.qt-project.org/listinfo/interest
More information about the Interest
mailing list