QSqlQuery::prepare: database not open

RekTek249

Hey, I started SQL today and I was wondering why it says db isn't open. Note: I had trouble with another error saying the driver wasn't found or something and I added a bunch of files to system PATH. Here is my code.

void w::database(){
QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
    db.setHostName("Host");
    db.setDatabaseName("Name");         /* In my real code, I set the real
    db.setUserName("Username");               stuff here */
    db.setPassword("Password");

    if (db.open())                                             
    {                                                                        
        QMessageBox msgBox;                         
        msgBox.setText("DB OPENED");          
        msgBox.exec();

    }


    QSqlQuery query(db);
    query.prepare("INSERT INTO person (Username, Password, summ, Email) "  
                      "VALUES (:user, :pass, :summ, :mail)");
    query.bindValue(":user", Username);          // I do have variables set earlier
    query.bindValue(":pass", Password);
    query.bindValue(":summ", summ);
    query.bindValue(":mail", Email);
    query.exec();

}

For some reasons, when I press the button (which launch this method) if I have the db.open part, It "doesn't respond". Help anyone... I searched on internet but didn't find anything that solved my problem...
Thanks

mawh1960

Hi,

Are you possibly missing a call to setPort() ?

Example:

db.setPort(3306);

jsulm

@RekTek249 said in QSqlQuery::prepare: database not open:

"doesn't respond"

is the host reachable? Did you try to connect to the server using MySQL client?

RekTek249

@mawh1960 I didn't know you had to set port... where to you know the port ? is 3306 the default one ?

RekTek249

@jsulm It works with phpmyadmin... It doesn't respond for like 30sec and then if I wait it sends the "database not open"message in the output

SGaist

Hi,

Are you running phpmyadmin on the same machine as the MySQL server ?

Are you running your application on the same machine as the server ?

If no to the second question, then did you correctly configure your MySQL server to accept external connections ? And also don't forget to secure them.

RekTek249

@SGaist I'm hosting the sql server on a website. It's a hosting website so I guess it's a linux server ? I'm running phpmyadmin on my windows 10 computer.

SGaist

Then check that you are correctly using the same user name, password as you are using in PHPMyAdmin.

RekTek249

@SGaist It is the correct one i checked that before asking it here...

SGaist

What exact error message do you get from your QSqlDatabase object ?

Taz742

@RekTek249

    QSqlQuery query(db);
    query.prepare("INSERT INTO person (Username, Password, summ, Email) "  
                      "VALUES (:user, :pass, :summ, :mail)");
    query.bindValue(":user", Username);          // I do have variables set earlier
    query.bindValue(":pass", Password);
    query.bindValue(":summ", summ);
    query.bindValue(":mail", Email);
    query.exec();

The mistake is not giving you anything error?

please #include "QSqlError" and

 if (db.open())                                             
    {                                                                        
        QMessageBox msgBox;                         
        msgBox.setText("DB OPENED");          
        msgBox.exec();

    }
else{
       qDebug() << db.lastError()
 }

By doing so we can understand what the problem is about anyway...

RekTek249

@Taz742 QSqlError("2003", "QMYSQL: Unable to connect", "Can't connect to MySQL server on 'adress.here' (10060)")
Is the error...

SGaist

Did you check that the user you are using to connect to the database can be used for remote connections ?

RekTek249

@SGaist It can.... What is the "2003" and 10060 meaning ? is 2003 the port ?

RekTek249

I tried it on another server and it gives the following error..

QSqlError("2005", "QMYSQL: Unable to connect", "Unknown MySQL server host 'mysql.hostinger.fr' (0)")
QSqlQuery::prepare: database not open

the_

@RekTek249
Again: are you sure you are allowed to establish a remote connection to the database?

check user permission
check if port is correct
check if port is reachable from remote

Taz742

@RekTek249 said in QSqlQuery::prepare: database not open:

It can.... What is the "2003" and 10060 meaning ? is 2003 the port ?

2003 is not a port name, so let's say the title of the problem.

the_

@Taz742
It's not a "title", just an qt internal error number. Same with the other code that is a mysql internal error code

SGaist

To add to @the_ : the error state that mysql.hostinger.fr is an unknown host. Looks like you are giving the wrong address.

RekTek249

@SGaist When I go to the "remote mysql" part of the site, it gives an access host... do i gotta use this as the hostname ?