QMYSQL Driver (undefined symbol: mysql_server_init)

[miroslavgojic]

I have this errors:

/home/miroslav/dekis/Dekis/main.cpp:3: In file included from main.cpp:3:
/home/miroslav/dekis/Dekis/connector.h:3: error: QSqlDatabase: No such file or directory
/home/miroslav/dekis/Dekis/main.cpp:3: In file included from main.cpp:3:
/home/miroslav/dekis/Dekis/connector.h:9: error: ‘QSqlDatabase’ has not been declared
/home/miroslav/dekis/Dekis/connector.h:11: error: ‘QSqlDatabase’ was not declared in this scope
/home/miroslav/dekis/Dekis/connector.h:11: error: expected ‘;’ before ‘db’
/home/miroslav/dekis/Dekis/connector.h:12: error: ‘db’ was not declared in this scope
/home/miroslav/dekis/Dekis/main.cpp:12: error: expected ‘;’ before ‘w’
/home/miroslav/dekis/Dekis/main.cpp:13: error: ‘w’ was not declared in this scope
/home/miroslav/dekis/Dekis/main.cpp:12: error: ‘MainWindow’ was not declared in this scope
/home/miroslav/dekis/Dekis/main.cpp:12: error: expected ‘;’ before ‘w’

/home/miroslav/dekis/Dekis/main.cpp:3: In file included from main.cpp:3:
/home/miroslav/dekis/Dekis/connector.h:3: error: QSqlDatabase: No such file or directory
/home/miroslav/dekis/Dekis/main.cpp:3: In file included from main.cpp:3:
/home/miroslav/dekis/Dekis/connector.h:9: error: ‘QSqlDatabase’ has not been declared
/home/miroslav/dekis/Dekis/connector.h:11: error: ‘QSqlDatabase’ was not declared in this scope
/home/miroslav/dekis/Dekis/connector.h:11: error: expected ‘;’ before ‘db’
/home/miroslav/dekis/Dekis/connector.h:12: error: ‘db’ was not declared in this scope
/home/miroslav/dekis/Dekis/main.cpp:12: error: expected ‘;’ before ‘w’
/home/miroslav/dekis/Dekis/main.cpp:13: error: ‘w’ was not declared in this scope
/home/miroslav/dekis/Dekis/main.cpp:12: error: ‘MainWindow’ was not declared in this scope
/home/miroslav/dekis/Dekis/main.cpp:12: error: expected ‘;’ before ‘w’

To copy to clipboard, switch view to plain text mode 

[saa7_go]

Can you post/attach your mainwindow.h and project file (*.pro)?

It looks like you don't add sql module in your project file.

[miroslavgojic]

mainwindow.h

/****************************************************************************
** Form interface generated from reading ui file 'mainwindow.ui'
**
** Created: Sat Jul 24 19:27:05 2010
**
** WARNING! All changes made in this file will be lost!
****************************************************************************/

/****************************************************************************
** Form interface generated from reading ui file 'mainwindow.ui'
**
** Created: Sat Jul 24 19:27:05 2010
**
** WARNING! All changes made in this file will be lost!
****************************************************************************/

To copy to clipboard, switch view to plain text mode 

Dekis.pro

######################################################################
# Automatically generated by qmake (2.01a) Tue Jul 20 19:42:45 2010
######################################################################
 
TEMPLATE = app
TARGET = 
DEPENDPATH += .
INCLUDEPATH += .
 
# Input
HEADERS += connector.h mainwindow.h
FORMS += mainwindow.ui
SOURCES += main.cpp mainwindow.cpp

######################################################################
# Automatically generated by qmake (2.01a) Tue Jul 20 19:42:45 2010
######################################################################

TEMPLATE = app
TARGET = 
DEPENDPATH += .
INCLUDEPATH += .

# Input
HEADERS += connector.h mainwindow.h
FORMS += mainwindow.ui
SOURCES += main.cpp mainwindow.cpp

To copy to clipboard, switch view to plain text mode 

[saa7_go]

mainwindow.h

/****************************************************************************
** Form interface generated from reading ui file 'mainwindow.ui'
**
** Created: Sat Jul 24 19:27:05 2010
**
** WARNING! All changes made in this file will be lost!
****************************************************************************/

/****************************************************************************
** Form interface generated from reading ui file 'mainwindow.ui'
**
** Created: Sat Jul 24 19:27:05 2010
**
** WARNING! All changes made in this file will be lost!
****************************************************************************/

To copy to clipboard, switch view to plain text mode 

Where is your MainWindow class declaration?

Dekis.pro

######################################################################
# Automatically generated by qmake (2.01a) Tue Jul 20 19:42:45 2010
######################################################################
 
TEMPLATE = app
TARGET = 
DEPENDPATH += .
INCLUDEPATH += .
 
# Input
HEADERS += connector.h mainwindow.h
FORMS += mainwindow.ui
SOURCES += main.cpp mainwindow.cpp

######################################################################
# Automatically generated by qmake (2.01a) Tue Jul 20 19:42:45 2010
######################################################################

TEMPLATE = app
TARGET = 
DEPENDPATH += .
INCLUDEPATH += .

# Input
HEADERS += connector.h mainwindow.h
FORMS += mainwindow.ui
SOURCES += main.cpp mainwindow.cpp

To copy to clipboard, switch view to plain text mode 

Add the the following line in Dekis.pro

QT += sql

QT += sql

To copy to clipboard, switch view to plain text mode 

[miroslavgojic]

I was not make changes in MainWindow class declaration.

[miroslavgojic]

after I add

QT += sql

QT += sql

To copy to clipboard, switch view to plain text mode 

to Dekis.pro

I have next errors (it is less then before)

/home/miroslav/dekis/Dekis/main.cpp:3: In file included from main.cpp:3:
/home/miroslav/dekis/Dekis/connector.h:11: error: expected primary-expression before ‘.’ token
/home/miroslav/dekis/Dekis/main.cpp:12: error: ‘MainWindow’ was not declared in this scope
/home/miroslav/dekis/Dekis/main.cpp:12: error: expected ‘;’ before ‘w’
/home/miroslav/dekis/Dekis/main.cpp:13: error: ‘w’ was not declared in this scope

/home/miroslav/dekis/Dekis/main.cpp:3: In file included from main.cpp:3:
/home/miroslav/dekis/Dekis/connector.h:11: error: expected primary-expression before ‘.’ token
/home/miroslav/dekis/Dekis/main.cpp:12: error: ‘MainWindow’ was not declared in this scope
/home/miroslav/dekis/Dekis/main.cpp:12: error: expected ‘;’ before ‘w’
/home/miroslav/dekis/Dekis/main.cpp:13: error: ‘w’ was not declared in this scope

To copy to clipboard, switch view to plain text mode 

[saa7_go]

I was not make changes in MainWindow class declaration.

Stay to the same question, where is the MainWindow class declaration?

after I add

QT += sql

QT += sql

To copy to clipboard, switch view to plain text mode 

to Dekis.pro

I have next errors (it is less then before)

/home/miroslav/dekis/Dekis/main.cpp:3: In file included from main.cpp:3:
/home/miroslav/dekis/Dekis/connector.h:11: error: expected primary-expression before ‘.’ token
/home/miroslav/dekis/Dekis/main.cpp:12: error: ‘MainWindow’ was not declared in this scope
/home/miroslav/dekis/Dekis/main.cpp:12: error: expected ‘;’ before ‘w’
/home/miroslav/dekis/Dekis/main.cpp:13: error: ‘w’ was not declared in this scope

/home/miroslav/dekis/Dekis/main.cpp:3: In file included from main.cpp:3:
/home/miroslav/dekis/Dekis/connector.h:11: error: expected primary-expression before ‘.’ token
/home/miroslav/dekis/Dekis/main.cpp:12: error: ‘MainWindow’ was not declared in this scope
/home/miroslav/dekis/Dekis/main.cpp:12: error: expected ‘;’ before ‘w’
/home/miroslav/dekis/Dekis/main.cpp:13: error: ‘w’ was not declared in this scope

To copy to clipboard, switch view to plain text mode 

Just try to create new project based on your old project. Your mainwindow.h is empty (except the comments).

[miroslavgojic]

After creating new project everything now work

Thanks,

This code working :

connector.h

#ifndef CONNECTOR_H
#define CONNECTOR_H
#include <QSqlDatabase>
#include <QMessageBox>
 
 
bool createConnection()
{
    if (QSqlDatabase::isDriverAvailable("QMYSQL"))
    {
        QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
        db.setHostName("localhost");
        db.setDatabaseName("test");
        db.setUserName("test");
        db.setPassword("test");
 
            if (!db.open())
            {
                QMessageBox m;
                m.setText("error I");
                m.exec();
                return false;
            }
        else
            {
                return true;
            }
    }
    else
    {
        QMessageBox m;
        m.setText("error II");
        m.exec();
        return false;
    }
 
}
 
#endif // CONNECTOR_H

#ifndef CONNECTOR_H
#define CONNECTOR_H
#include <QSqlDatabase>
#include <QMessageBox>


bool createConnection()
{
    if (QSqlDatabase::isDriverAvailable("QMYSQL"))
    {
        QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
        db.setHostName("localhost");
        db.setDatabaseName("test");
        db.setUserName("test");
        db.setPassword("test");

            if (!db.open())
            {
                QMessageBox m;
                m.setText("error I");
                m.exec();
                return false;
            }
        else
            {
                return true;
            }
    }
    else
    {
        QMessageBox m;
        m.setText("error II");
        m.exec();
        return false;
    }

}

#endif // CONNECTOR_H

To copy to clipboard, switch view to plain text mode 

main.cpp

#include <QtGui/QApplication>
#include "mainwindow.h"
#include "connector.h"
 
int main(int argc, char *argv[])
{
    QApplication a(argc, argv);
    if (!createConnection())
        return 1;
    MainWindow w;
    w.show();
    return a.exec();
}

#include <QtGui/QApplication>
#include "mainwindow.h"
#include "connector.h"

int main(int argc, char *argv[])
{
    QApplication a(argc, argv);
    if (!createConnection())
        return 1;
    MainWindow w;
    w.show();
    return a.exec();
}

To copy to clipboard, switch view to plain text mode 

mainwindow.cpp

#include "mainwindow.h"
#include "ui_mainwindow.h"
 
MainWindow::MainWindow(QWidget *parent) :
    QMainWindow(parent),
    ui(new Ui::MainWindow)
{
    ui->setupUi(this);
}
 
MainWindow::~MainWindow()
{
    delete ui;
}
 
void MainWindow::changeEvent(QEvent *e)
{
    QMainWindow::changeEvent(e);
    switch (e->type()) {
    case QEvent::LanguageChange:
        ui->retranslateUi(this);
        break;
    default:
        break;
    }
}

#include "mainwindow.h"
#include "ui_mainwindow.h"

MainWindow::MainWindow(QWidget *parent) :
    QMainWindow(parent),
    ui(new Ui::MainWindow)
{
    ui->setupUi(this);
}

MainWindow::~MainWindow()
{
    delete ui;
}

void MainWindow::changeEvent(QEvent *e)
{
    QMainWindow::changeEvent(e);
    switch (e->type()) {
    case QEvent::LanguageChange:
        ui->retranslateUi(this);
        break;
    default:
        break;
    }
}

To copy to clipboard, switch view to plain text mode 

baza.pro

# -------------------------------------------------
# Project created by QtCreator 2010-07-26T09:33:19
# -------------------------------------------------
QT += network \
    opengl \
    sql \
    script \
    scripttools \
    svg \
    webkit \
    testlib \
    dbus
TARGET = baza
TEMPLATE = app
SOURCES += main.cpp \
    mainwindow.cpp
HEADERS += mainwindow.h \
    connector.h
FORMS += mainwindow.ui

# -------------------------------------------------
# Project created by QtCreator 2010-07-26T09:33:19
# -------------------------------------------------
QT += network \
    opengl \
    sql \
    script \
    scripttools \
    svg \
    webkit \
    testlib \
    dbus
TARGET = baza
TEMPLATE = app
SOURCES += main.cpp \
    mainwindow.cpp
HEADERS += mainwindow.h \
    connector.h
FORMS += mainwindow.ui

To copy to clipboard, switch view to plain text mode 

[miroslavgojic]

Now, how to create query

what is procedure?

Is new *.h file for sql or I can use existing files in project ...

I have created database ... I need to manipulate with data in database ...