[Qt4.1]program segfault after upgrading from 4.0.1 to 4.1

[jacek]

Did you upgrade MySQL libs recently?

[patcito]

yes I did, I used to use 4.1 before so /usr/lib/libmysqlclient.so.14.0.0 now I use /usr/lib/libmysqlclient.so.15.0.0, you think that might be the problem?

[jacek]

yes I did, I used to use 4.1 before so /usr/lib/libmysqlclient.so.14.0.0 now I use /usr/lib/libmysqlclient.so.15.0.0, you think that might be the problem?

It crashes when the execution flow enters libmysqlclient, so if you did upgrade that library, it might be the cause.

But first write a small program that connects to the database and fetches some data, if it doesn't crash the problem is in your code for 100%, if it crashes it is more likely that the problem in lack of binary compatibility between two versions of libmysqlclient.

If you are using plugins, you can try to recompile QMYSQL driver, otherwise you will have to recompile whole Qt.

[patcito]

I did a basic program and it segfaults too, I'll report it to the kubuntu guys thanx.

Pat

Update: here is the test program: http://p80.free.fr/basicmysql.tar.bz2 could you confirm it doesn't crash for you please? it displays mysql users in a qtableview, you can modify connection.h to change the user password

[jacek]

here is the test program: http://p80.free.fr/basicmysql.tar.bz2 could you confirm it doesn't crash for you please? it displays mysql users in a qtableview, you can modify connection.h to change the user password

My idea of a small program is:

#include <QtDebug>
#include <QApplication>
#include <QVariant>
 
#include "connection.h"
 
int main(int argc, char *argv[])
{
   QApplication app(argc, argv);
 
   createConnection();
 
   QSqlQuery q( "SELECT * FROM user" );
   qDebug() << q.lastError();
   while( q.next() ) {
      qDebug() << q.value( 0 ) << q.value( 1 );
   }
}

#include <QtDebug>
#include <QApplication>
#include <QVariant>

#include "connection.h"

int main(int argc, char *argv[])
{
   QApplication app(argc, argv);

   createConnection();

   QSqlQuery q( "SELECT * FROM user" );
   qDebug() << q.lastError();
   while( q.next() ) {
      qDebug() << q.value( 0 ) << q.value( 1 );
   }
}

To copy to clipboard, switch view to plain text mode 

Anyway, it seems that there is a bug in Qt 4.1.0. If I change CutePOS::initialize() to:

QSqlQueryModel *model = new QSqlQueryModel;
model->setQuery( "select * from user" );
ui.articlestableView->setModel(model);

QSqlQueryModel *model = new QSqlQueryModel;
model->setQuery( "select * from user" );
ui.articlestableView->setModel(model);

To copy to clipboard, switch view to plain text mode 

it works.

[patcito]

Thanx a lot for your help. I compiled a snapshot of Qt4.1.1 and it does run now!