Why shows error message when generating application release

ChrisW67

QSqlDatabase::open() returns true?

lincoln

Yes, the connection returns true, when I test it in Qt Creator everything is fine, but when I test it on another pc, the data is not shown.

SGaist

Did you properly deploy all dependencies ? Including the ones for the SQL driver you are using ?

lincoln

This post is deleted!

lincoln

@SGaist
Of course, as you can see in the previous image that I publish, there are all the dependencies, those of the database and others that the application needs, which automatically adds windeployqt, and those that I add, manually such as:

libpq.dll
libcrypto-1_1-x64.dll
libiconv-2.dll
libintl-8.dll
libssl-1_1-x64.dll.

I am using PostgreSQL version 13.3 and Qt 5.15.2. Both 64-bit

These libraries correspond to PostgreSQL, as I did my tests in Qt Creator, they work fine there, but when I create the exe and run from there, nothing happens.

Even so, the data is not shown; And it doesn't occur to me what else it could be.

Here run from the Qt Creator, the data is shown without problems, which does not happen when I deploy the application.

jsulm

@lincoln said in Why shows error message when generating application release:

And it doesn't occur to me what else it could be

Set QT_DEBUG_PLUGINS to 1 before starting you app from terminal and put the output here.
https://doc.qt.io/qt-5/debug.html

lincoln

@jsulm Thanks for your answer, but I don't really know how to do what you tell me, thank you anyway.

JonB

@lincoln
Use the forum Search for QT_DEBUG_PLUGINS. We don't want to answer the same question from many users over and over. It's also in the docs at Environment Variables Recognized by Qt. You need to read and act on these.

SGaist

@lincoln said in Why shows error message when generating application release:

Here run from the Qt Creator, the data is shown without problems, which does not happen when I deploy the application.

Do you run that deployed version on your machine or on a different machine ?

lincoln

@SGaist First I tried it on my machine, and then I took it to a different one, where the Qt was not installed, and the same result.

lincoln

@JonB ok, thanks

SGaist

Then the next step is to start your application from the command line with QT_DEBUG_PLUGINS set to 1 to see what is going on.

lincoln

This post is deleted!

lincoln

@SGaist ok thanks, i'll find out how to do that.

lincoln

THIS IS A MESSAGE THAT IS DISPLAYED AFTER STARTING THE APP WITH QT_DEBUG_PLUGINS

QFactoryLoader::QFactoryLoader() checking directory path "C:/Qt/6.1.2/mingw81_64/plugins/sqldrivers" ...
QFactoryLoader::QFactoryLoader() looking at "C:/Qt/6.1.2/mingw81_64/plugins/sqldrivers/qsqlite.dll"
Found metadata in lib C:/Qt/6.1.2/mingw81_64/plugins/sqldrivers/qsqlite.dll, metadata=
{
"IID": "org.qt-project.Qt.QSqlDriverFactoryInterface",
"MetaData": {
"Keys": [
"QSQLITE"
]
},
"archreq": 0,
"className": "QSQLiteDriverPlugin",
"debug": false,
"version": 393472
}

Got keys from plugin meta data QList("QSQLITE")
QFactoryLoader::QFactoryLoader() looking at "C:/Qt/6.1.2/mingw81_64/plugins/sqldrivers/qsqlodbc.dll"
Found metadata in lib C:/Qt/6.1.2/mingw81_64/plugins/sqldrivers/qsqlodbc.dll, metadata=
{
"IID": "org.qt-project.Qt.QSqlDriverFactoryInterface",
"MetaData": {
"Keys": [
"QODBC"
]
},
"archreq": 0,
"className": "QODBCDriverPlugin",
"debug": false,
"version": 393472
}

Got keys from plugin meta data QList("QODBC")
QFactoryLoader::QFactoryLoader() looking at "C:/Qt/6.1.2/mingw81_64/plugins/sqldrivers/qsqlpsql.dll"
Found metadata in lib C:/Qt/6.1.2/mingw81_64/plugins/sqldrivers/qsqlpsql.dll, metadata=
{
"IID": "org.qt-project.Qt.QSqlDriverFactoryInterface",
"MetaData": {
"Keys": [
"QPSQL"
]
},
"archreq": 0,
"className": "QPSQLDriverPlugin",
"debug": false,
"version": 393472
}

Got keys from plugin meta data QList("QPSQL")
loaded library "C:/Qt/6.1.2/mingw81_64/plugins/sqldrivers/qsqlpsql.dll"
QFactoryLoader::QFactoryLoader() checking directory path "C:/Qt/6.1.2/mingw81_64/plugins/platforms" ...
QFactoryLoader::QFactoryLoader() looking at "C:/Qt/6.1.2/mingw81_64/plugins/platforms/qdirect2d.dll"
Found metadata in lib C:/Qt/6.1.2/mingw81_64/plugins/platforms/qdirect2d.dll, metadata=
{
"IID": "org.qt-project.Qt.QPA.QPlatformIntegrationFactoryInterface.5.3",
"MetaData": {
"Keys": [
"direct2d"
]
},
"archreq": 0,
"className": "QWindowsDirect2DIntegrationPlugin",
"debug": false,
"version": 393472
}

Got keys from plugin meta data QList("direct2d")
QFactoryLoader::QFactoryLoader() looking at "C:/Qt/6.1.2/mingw81_64/plugins/platforms/qminimal.dll"
Found metadata in lib C:/Qt/6.1.2/mingw81_64/plugins/platforms/qminimal.dll, metadata=
{
"IID": "org.qt-project.Qt.QPA.QPlatformIntegrationFactoryInterface.5.3",
"MetaData": {
"Keys": [
"minimal"
]
},
"archreq": 0,
"className": "QMinimalIntegrationPlugin",
"debug": false,
"version": 393472
}

Got keys from plugin meta data QList("minimal")
QFactoryLoader::QFactoryLoader() looking at "C:/Qt/6.1.2/mingw81_64/plugins/platforms/qoffscreen.dll"
Found metadata in lib C:/Qt/6.1.2/mingw81_64/plugins/platforms/qoffscreen.dll, metadata=
{
"IID": "org.qt-project.Qt.QPA.QPlatformIntegrationFactoryInterface.5.3",
"MetaData": {
"Keys": [
"offscreen"
]
},
"archreq": 0,
"className": "QOffscreenIntegrationPlugin",
"debug": false,
"version": 393472
}

Got keys from plugin meta data QList("offscreen")
QFactoryLoader::QFactoryLoader() looking at "C:/Qt/6.1.2/mingw81_64/plugins/platforms/qwindows.dll"
Found metadata in lib C:/Qt/6.1.2/mingw81_64/plugins/platforms/qwindows.dll, metadata=
{
"IID": "org.qt-project.Qt.QPA.QPlatformIntegrationFactoryInterface.5.3",
"MetaData": {
"Keys": [
"windows"
]
},
"archreq": 0,
"className": "QWindowsIntegrationPlugin",
"debug": false,
"version": 393472
}

Got keys from plugin meta data QList("windows")
QFactoryLoader::QFactoryLoader() checking directory path "C:/Users/USER/Downloads/build-monitoreo_xertek-Desktop_Qt_6_1_2_MinGW_64_bit-Release/release/platforms" ...
loaded library "C:/Qt/6.1.2/mingw81_64/plugins/platforms/qwindows.dll"
QFactoryLoader::QFactoryLoader() checking directory path "C:/Qt/6.1.2/mingw81_64/plugins/platformthemes" ...
QFactoryLoader::QFactoryLoader() checking directory path "C:/Users/USER/Downloads/build-monitoreo_xertek-Desktop_Qt_6_1_2_MinGW_64_bit-Release/release/platformthemes" ...
QFactoryLoader::QFactoryLoader() checking directory path "C:/Qt/6.1.2/mingw81_64/plugins/styles" ...
QFactoryLoader::QFactoryLoader() looking at "C:/Qt/6.1.2/mingw81_64/plugins/styles/qwindowsvistastyle.dll"
Found metadata in lib C:/Qt/6.1.2/mingw81_64/plugins/styles/qwindowsvistastyle.dll, metadata=
{
"IID": "org.qt-project.Qt.QStyleFactoryInterface",
"MetaData": {
"Keys": [
"windowsvista"
]
},
"archreq": 0,
"className": "QWindowsVistaStylePlugin",
"debug": false,
"version": 393472
}

Got keys from plugin meta data QList("windowsvista")
QFactoryLoader::QFactoryLoader() checking directory path "C:/Users/USER/Downloads/build-monitoreo_xertek-Desktop_Qt_6_1_2_MinGW_64_bit-Release/release/styles" ...
loaded library "C:/Qt/6.1.2/mingw81_64/plugins/styles/qwindowsvistastyle.dll"
QSqlDatabasePrivate::removeDatabase: connection 'qt_sql_default_connection' is still in use, all queries will cease to work.
QSqlDatabasePrivate::addDatabase: duplicate connection name 'qt_sql_default_connection', old connection removed.
QFactoryLoader::QFactoryLoader() checking directory path "C:/Qt/6.1.2/mingw81_64/plugins/iconengines" ...
QFactoryLoader::QFactoryLoader() looking at "C:/Qt/6.1.2/mingw81_64/plugins/iconengines/qsvgicon.dll"
Found metadata in lib C:/Qt/6.1.2/mingw81_64/plugins/iconengines/qsvgicon.dll, metadata=
{
"IID": "org.qt-project.Qt.QIconEngineFactoryInterface",
"MetaData": {
"Keys": [
"svg",
"svgz",
"svg.gz"
]
},
"archreq": 0,
"className": "QSvgIconPlugin",
"debug": false,
"version": 393472
}

Got keys from plugin meta data QList("svg", "svgz", "svg.gz")
QFactoryLoader::QFactoryLoader() checking directory path "C:/Users/USER/Downloads/build-monitoreo_xertek-Desktop_Qt_6_1_2_MinGW_64_bit-Release/release/iconengines" ...
QFactoryLoader::QFactoryLoader() checking directory path "C:/Qt/6.1.2/mingw81_64/plugins/imageformats" ...
QFactoryLoader::QFactoryLoader() looking at "C:/Qt/6.1.2/mingw81_64/plugins/imageformats/qgif.dll"
Found metadata in lib C:/Qt/6.1.2/mingw81_64/plugins/imageformats/qgif.dll, metadata=
{
"IID": "org.qt-project.Qt.QImageIOHandlerFactoryInterface",
"MetaData": {
"Keys": [
"gif"
],
"MimeTypes": [
"image/gif"
]
},
"archreq": 0,
"className": "QGifPlugin",
"debug": false,
"version": 393472
}

Got keys from plugin meta data QList("gif")
QFactoryLoader::QFactoryLoader() looking at "C:/Qt/6.1.2/mingw81_64/plugins/imageformats/qico.dll"
Found metadata in lib C:/Qt/6.1.2/mingw81_64/plugins/imageformats/qico.dll, metadata=
{
"IID": "org.qt-project.Qt.QImageIOHandlerFactoryInterface",
"MetaData": {
"Keys": [
"ico",
"cur"
],
"MimeTypes": [
"image/vnd.microsoft.icon",
"image/vnd.microsoft.icon"
]
},
"archreq": 0,
"className": "QICOPlugin",
"debug": false,
"version": 393472
}

Got keys from plugin meta data QList("ico", "cur")
QFactoryLoader::QFactoryLoader() looking at "C:/Qt/6.1.2/mingw81_64/plugins/imageformats/qjpeg.dll"
Found metadata in lib C:/Qt/6.1.2/mingw81_64/plugins/imageformats/qjpeg.dll, metadata=
{
"IID": "org.qt-project.Qt.QImageIOHandlerFactoryInterface",
"MetaData": {
"Keys": [
"jpg",
"jpeg"
],
"MimeTypes": [
"image/jpeg",
"image/jpeg"
]
},
"archreq": 0,
"className": "QJpegPlugin",
"debug": false,
"version": 393472
}

Got keys from plugin meta data QList("jpg", "jpeg")
QFactoryLoader::QFactoryLoader() looking at "C:/Qt/6.1.2/mingw81_64/plugins/imageformats/qsvg.dll"
Found metadata in lib C:/Qt/6.1.2/mingw81_64/plugins/imageformats/qsvg.dll, metadata=
{
"IID": "org.qt-project.Qt.QImageIOHandlerFactoryInterface",
"MetaData": {
"Keys": [
"svg",
"svgz"
],
"MimeTypes": [
"image/svg+xml",
"image/svg+xml-compressed"
]
},
"archreq": 0,
"className": "QSvgPlugin",
"debug": false,
"version": 393472
}

Got keys from plugin meta data QList("svg", "svgz")
QFactoryLoader::QFactoryLoader() checking directory path "C:/Users/USER/Downloads/build-monitoreo_xertek-Desktop_Qt_6_1_2_MinGW_64_bit-Release/release/imageformats" ...
loaded library "C:/Qt/6.1.2/mingw81_64/plugins/imageformats/qgif.dll"
loaded library "C:/Qt/6.1.2/mingw81_64/plugins/imageformats/qico.dll"
loaded library "C:/Qt/6.1.2/mingw81_64/plugins/imageformats/qjpeg.dll"
loaded library "C:/Qt/6.1.2/mingw81_64/plugins/imageformats/qsvg.dll"
QFactoryLoader::QFactoryLoader() checking directory path "C:/Qt/6.1.2/mingw81_64/plugins/accessible" ...
QFactoryLoader::QFactoryLoader() checking directory path "C:/Users/USER/Downloads/build-monitoreo_xertek-Desktop_Qt_6_1_2_MinGW_64_bit-Release/release/accessible" ...
QSqlDatabasePrivate::addDatabase: duplicate connection name 'qt_sql_default_connection', old connection removed.
La carpeta ya existe
QFactoryLoader::QFactoryLoader() checking directory path "C:/Qt/6.1.2/mingw81_64/plugins/accessiblebridge" ...
QFactoryLoader::QFactoryLoader() checking directory path "C:/Users/USER/Downloads/build-monitoreo_xertek-Desktop_Qt_6_1_2_MinGW_64_bit-Release/release/accessiblebridge" ...

SGaist

@lincoln said in Why shows error message when generating application release:

QSqlDatabasePrivate::addDatabase: duplicate connection name 'qt_sql_default_connection', old connection removed.

You are still creating multiple QSqlDatabase objects using the default connection. One might be wrong.

lincoln

@SGaist I changed the code in this way, but now it does not connect to the database, I think it is worse.

DbConection class

#ifndef DBCONECTION_H
#define DBCONECTION_H
#include <QSqlDatabase>
#include <QSqlError>

class DbConection
{
public:
  DbConection();
  bool connect(const QString &dbName);
  QString errorMessage(){return _errorMessage;}
  QSqlDatabase getDataBase();
//  void removeDb();


private:
  QString _errorMessage;
  QString mdbName;

};

#endif // DBCONECTION_H

#include "dbconection.h"


DbConection::DbConection(){

}

bool DbConection::connect(const QString &dbName)
{
  mdbName=dbName;
  auto db=QSqlDatabase::addDatabase("QPSQL",dbName);
  if(!db.isDriverAvailable("QPSQL")){
      _errorMessage=db.lastError().driverText();
      return false;
    }
  db.setDatabaseName("monitoreo_db");
  db.setPort(5432);
  db.setHostName("127.0.0.1");
  db.setUserName("postgres");
  db.setPassword("2311046");

  if(!db.open()){
      _errorMessage=db.lastError().databaseText();
      return false;
    }

  return true;

}

QSqlDatabase DbConection::getDataBase()
{

  return QSqlDatabase::database(mdbName);

}

BussinesLayer class:

#ifndef BUSSINESLAYER_H
#define BUSSINESLAYER_H

#include <QSqlQuery>
#include <QSqlError>
#include "dbconection.h"

class BussinesLayer : public QObject
{

public:
  BussinesLayer();  
  QVariantList selectData(QVariant id);
  
private:
  QString _errorMessage;
  QString _errorCode;  
  DbConection db;
  
};

#endif // BUSSINESLAYER_H


#include "bussineslayer.h"

BussinesLayer::BussinesLayer()
{

  db.connect("monitoreo");

}

QVariantList BussinesLayer::selectData(QVariant id)
{
  QVariantList dataList;
  QSqlQuery qry(db.getDataBase());
  qry.prepare("SELECT * FROM grupo_minero WHERE id=?");
  qry.addBindValue(id);
  if(!qry.exec()){
    _errorMessage=qry.lastError().text();
    return dataList;
}        
  return dataList;

}

now this message comes out

😟😠

jsulm

@lincoln said in Why shows error message when generating application release:

DbConection::connect(const QString &dbName)

^Where do you call it now in your code? You need to call it once before using the database connection.

JonB

@jsulm
He calls it in the BussinesLayer::BussinesLayer() constructor: db.connect("monitoreo");.

@lincoln
In DbConection::connect() you check for db.isDriverAvailable("QPSQL") after you have called QSqlDatabase::addDatabase(). I suggest you want to call it before.

On error you set _errorMessage and return false, yet you don't check for that nor show the error message.

Your console output still shows "duplicate connection", which implies you are still calling DbConection::connect() more than once. Since you call it from BussinesLayer constructor, maybe your outside world code creates a BussinesLayer more than once.

Can you please put in your own qDebug() messages to see what is getting executed in your own code, and for your error messages. This is a standard part of programming. For example, put one in at the start of DbConection::connect(). If that gets printed out more than once, you are in trouble....

lincoln

@JonB a business layer, I call it from several forms, in the private part of the .h file of each form, I declare a variable of type bussineslayer class, in that class I have all the code I need to be able to do the DB tasks.

here for example in "mainwindow.h"

and so on all the forms you need from the bussineslayer class.

Use a QMessageBox, to display the message and this is what it displays

I don't understand, when I don't pass the name of the connection in QSqlDatabase :: addDatabase ("QPSQL", dbName);
data is displayed normally.