Hi, I am trying to populate a QSqlTableModel() using a table in my Postgresql database and display it in a QTableView. Here is the first part of the code: QSqlDatabase db = QSqlDatabase::addDatabase("QPSQL"); db.setHostName("localhost"); db.setPort(5432); db.setDatabaseName("test_db"); db.setUserName("test_user"); db.setPassword("test_pass"); bool ok = db.open(); QSqlTableModel *model = new QSqlTableModel(nullptr, db); if (ok){ model->setTable("my_table_name_here"); model->select(); } On Windows, this works perfectly and QTableView is populated. However, when testing on Ubuntu 16.04 LTS the QTableView is empty. I checked the output of model->rowCount(); and it returns '0'. A few things to note: Both Operating Systems are accessing the same database using the same credentials. On Ubuntu, using a standard QSqlQuery works perfectly in accessing data from the very same database in the same application. There are no errors in opening the database or anything else related. This really has me stumped. Why is it not working on Ubuntu ? Thanks.

Upgrading to Qt Version 5.15+ solved the issue.

check the return value of model->select(); and if it returns false use model->lastError() to diagnose what's going wrong

Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

QSqlTableModel() empty on Ubuntu but works on Windows ?

Solved General and Desktop

41 Posts 4 Posters 8.4k Views

R Offline
R Offline
R-P-H

wrote on 7 Oct 2020, 14:21 last edited by

#41

Upgrading to Qt Version 5.15+ solved the issue.
1 Reply Last reply

1

41/41

7 Oct 2020, 14:21