SQLITTE "unable to fetch row"

[giusepped]

I have two database connections (SQLITE).
The second one is created by:

bool MainWindow::createConnection(const QString &id)
{
	databasePanels = QCoreApplication::applicationDirPath()+"/panels.db";
 
	QSqlDatabase db =  QSqlDatabase::addDatabase("QSQLITE",id);
 
	db.setDatabaseName(databasePanels);
	db.open();
/ 
	if (db.isOpen())
		return true;
	else
 
		return false;
}

bool MainWindow::createConnection(const QString &id)
{
	databasePanels = QCoreApplication::applicationDirPath()+"/panels.db";
 
	QSqlDatabase db =  QSqlDatabase::addDatabase("QSQLITE",id);
	
	db.setDatabaseName(databasePanels);
	db.open();
/ 
	if (db.isOpen())
		return true;
	else
	
		return false;
}

To copy to clipboard, switch view to plain text mode 

void MainWindow::createTablePanel(const QString &type)
{
	QSqlDatabase db=QSqlDatabase::database(type);
	db.setDatabaseName(databasePanels);
	QSqlQuery q(db);
	q.prepare(" create table pannelli ( id INTEGER NOT NULL PRIMARY KEY,costruttore VARCHAR(50),modello VARCHAR(50),pnom  )");
	q.exec();
 
}

void MainWindow::createTablePanel(const QString &type)
{
	QSqlDatabase db=QSqlDatabase::database(type);
	db.setDatabaseName(databasePanels);
	QSqlQuery q(db);
	q.prepare(" create table pannelli ( id INTEGER NOT NULL PRIMARY KEY,costruttore VARCHAR(50),modello VARCHAR(50),pnom  )");
	q.exec();
 
}

To copy to clipboard, switch view to plain text mode 

but I get:

createTablePanel.: QSqlError(-1, "Unable to fetch row", "No query") "

why?

[spirit]

maybe this table already exist?

[nhs_0702]

maybe this table already exist?

void MainWindow::on_pushButton_clicked()
{
	QSqlDatabase db = QSqlDatabase::addDatabase( "QSQLITE" );
	db.setDatabaseName( "C:/Users/BotNetVN/Desktop/TuDien/Disa.s3db" );
	QSqlQuery qry;
	QString qstrExe = "INSERT INTO word (ID_Word,English) VALUES (3,'" + ui->textEdit->toPlainText() + "')";
	qry.prepare( qstrExe );
	if (!qry.exec()){
		ui->textEdit->setText(qry.lastError().text());
	}
	else{
		ui->textEdit->setText("Them CSDL thanh cong");
	}
	db.close();
}

void MainWindow::on_pushButton_clicked()
{
	QSqlDatabase db = QSqlDatabase::addDatabase( "QSQLITE" );
	db.setDatabaseName( "C:/Users/BotNetVN/Desktop/TuDien/Disa.s3db" );
	QSqlQuery qry;
	QString qstrExe = "INSERT INTO word (ID_Word,English) VALUES (3,'" + ui->textEdit->toPlainText() + "')";
	qry.prepare( qstrExe );
	if (!qry.exec()){
		ui->textEdit->setText(qry.lastError().text());
	}
	else{
		ui->textEdit->setText("Them CSDL thanh cong");
	}
	db.close();
}

To copy to clipboard, switch view to plain text mode 

why error No query Unable to fetch row

[ChrisW67]

Where are you opening the database in MainWindow::on_pushButton_clicked()?