Solved The SQLite exception "no such table: <table> Unable to execute statement" with QSqlDatabase
-
@Maarouf-Med-Mahdi
You said:(no such table: <table> Unable to execute statement).
So it's telling you there is no table named whatever it reports for
<table>
(really wish you'd give the actual text of the error message, then we'd know....)Your statement is:
insert into serveurs ...
so, assuming it reportsserveurs
as the table name, there is no such table asserveurs
in whatever is your current database....P.S.
Have you triedSELECT * FROM serveurs
in your Qt code for yourself, to decide whether it's really anINSERT
problem? -
@Maarouf-Med-Mahdi
Try:QSqlQuery query; query.prepare("insert into serveurs (field1, field2, field3) values (:value1, :value2, :value3)"); query.bindValue(":value1," MyValue1); query.bindValue(":value2", MyValue2); query.bindValue(":value3", MyValue3); if (query.exec()) { // } else { qDebug() << query.lastError().text(); }
-
@Taz742
https://sqlite.org/lang_insert.html is telling you that the list of column/field names is optional inINSERT INTO
, if that's what you're trying to tell the OP to correct to. -
@Maarouf-Med-Mahdi ,
Are you sure, your table name is correct? -
@Vinod-Kuntoji yes i m sure
-
@JNBarchan that is my dataBase file
-- Fichier généré par SQLiteStudio v3.1.1 sur mer. déc. 13 21:27:34 2017
-- Encodage texte utilisé : System
PRAGMA foreign_keys = off;
BEGIN TRANSACTION;-- Table : historiques
CREATE TABLE historiques(
IP varchar(20) ,
date_modification date,
anc_type_serveur varchar(10),
anc_croire int (10),
anc_rack int(10),
anc_chassis int (4),
anc_position int (10),
constraint FK_historiques foreign key (IP) references serveurs(IP)
);-- Table : serveurs
CREATE TABLE serveurs (
IP varchar(20) ,
type_serveur varchar(10),
croire int (10),
rack int(10),
chassis int (4),
position int (10),
date_creation date,
date_der_accee date,
constraint PK_serveurs primary key (IP)
);COMMIT TRANSACTION;
PRAGMA foreign_keys = on; -
@JNBarchan I give you the result of this query
select * from serveurs;
***the code:
mydb.setDatabaseName("D:\Applications\App Gestion Data CenterV2\GestionDataCenterV2\GestionDataCenter_BD.db");
if(mydb.open())
qDebug() << "connected";
else
qDebug() << "deconnected";QSqlQuery requette;
QString text_req = "select * from serveurs;";
if(requette.exec(text_req))
qDebug()<<"requette valide";
else
qDebug()<<"invalide requette"<<" --> "<<requette.lastError().text();
***the debug
connected
invalide requette --> "no such table: serveurs Unable to execute statement" -
@Taz742 this query shows me the same error
QString text_req = "insert into serveurs('IP','type_serveur','croire','rack','chassis','position','date_creation','date_der_accee') values('123.112.113','Physique',1,2,3,3,'01/01/1997','12/01/1997');";// I wish you saw my database I posted it
-
@Maarouf-Med-Mahdi
This message also prove that there is no such table in your database.
You can check which tables are available with this code:if(mydb.open()) qDebug() << "connected"; else qDebug() << "deconnected"; qDebug() << "Tables: " << mydb.tables();
Maybe there is a difference in some letter in other code page (UTF-8 vs ANSI).
-
Hi @Stoyan that show me (), i think you saw my db i posted it ,
all tables has been created but Qt can not find it -
@Stoyan previously I used the encoding "system", now I've changed to UTF-8 but the same error still see
-
@Maarouf-Med-Mahdi
It seems that you are not connected to the database.
Try to change your code for open database.
Instead:if(mydb.open()) qDebug() << "connected"; else qDebug() << "deconnected";
use this:
if(!mydb.open()) { qDebug() << mydb.lastError().text(); }
BTW, what is the result from query that you use to test database connection:
select * from sqlite_master where tbl_name = 'serveurs';
-
@Stoyan connected and that query works
select * from sqlite_master where tbl_name = 'serveurs'; -
@Maarouf-Med-Mahdi
OK, but what is the result? Empty set or 2-3 rows? -
In SQLite a database is a single file. And I think that, if database file don't exists it is created and practically the connection is made to new empty database.
You can search on your computer for file with the name "GestionDataCenter_BD.db". I guess that there will be another such file in other folder than original database. -
@Stoyan i understood what you said, but i m sure i connected to the real database from a real path
mydb.setDatabaseName("D:\Applications\App Gestion Data CenterV2\GestionDataCenterV2\GestionDataCenter_BD.db"); -
I think the answer is quite simple:
use double backslash!instead of
mydb.setDatabaseName("D:\Applications\App Gestion Data CenterV2\GestionDataCenterV2\GestionDataCenter_BD.db"); use mydb.setDatabaseName("D:\\Applications\\App Gestion Data CenterV2\\GestionDataCenterV2\\GestionDataCenter_BD.db");
regards
Karl-Heinz -
Hi @karlheinzreichel , i got that message
connected
invalide requette --> "file is encrypted or is not a database Unable to execute statement" -
@Maarouf-Med-Mahdi said in How insert data into sqlite database with Qt:
(no such table: <table> Unable to execute statement).
But before you get the error:
(no such table: <table> Unable to execute statement).now you get
file is encrypted or is not a database Unable to execute statementit's somehow different.
Have you tried to test the database with sqlite3 database application?
-
@karlheinzreichel
all queries it works well with SQLiteStudio and has the same database