Unsolved QSqlQuery::prepare: database not open
-
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 -
Hi,
Are you possibly missing a call to setPort() ?
Example:
db.setPort(3306);
-
@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?
-
@mawh1960 I didn't know you had to set port... where to you know the port ? is 3306 the default one ?
-
@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
-
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.
-
@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.
-
Then check that you are correctly using the same user name, password as you are using in PHPMyAdmin.
-
@SGaist It is the correct one i checked that before asking it here...
-
What exact error message do you get from your QSqlDatabase object ?
-
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...
-
@Taz742 QSqlError("2003", "QMYSQL: Unable to connect", "Can't connect to MySQL server on 'adress.here' (10060)")
Is the error... -
Did you check that the user you are using to connect to the database can be used for remote connections ?
-
@SGaist It can.... What is the "2003" and 10060 meaning ? is 2003 the port ?
-
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
-
@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
-
@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.
-
@Taz742
It's not a "title", just an qt internal error number. Same with the other code that is a mysql internal error code -
To add to @the_ : the error state that
mysql.hostinger.fr
is an unknown host. Looks like you are giving the wrong address. -
@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 ?