MySQL driver isn't installed

[jsulm]

@pierrbt said in MySQL driver isn't installed:

I configured the plugin as a SQLite one, and the users table exists because i tried the same command in the main MySQL shell and it was working

But did you create that table in your SQLite database?

[JonB]

@pierrbt

@JonB said in MySQL driver isn't installed:

there is a QSqlError QSqlQuery::lastError() const to call after the exec().

? What's the point of guessing if you have a call to use?

[pierrbt]

@jsulm I use a MySQL database and, yes i create it. And, it may seem like an obvious question but in the doc you send me, they said to execute a command, so i run that command on the Windows Command Prompt but it return an error :

C:\Qt\6.2.3\Src>configure.bat -sql-mysql -- -DMySQL_INCLUDE_DIR="C:\Program Files\MySQL\MySQL Connector C 6.1\include" -DMySQL_LIBRARY="C:\Program Files\MySQL \MySQL Connector C 6.1\lib\libmysql.lib
+qtbase cd
+ C:\Qt\6.2.3\Src\qtbase\configure.bat -top-level -sql-mysql -- -DMySQL_INCLUDE_DIR="C:\Program Files\MySQL\MySQL Connector C 6.1\include" -DMySQL_LIBRARY=" C:\Program Files\MySQL\MySQL Connector C 6.1\lib\libmysql.lib
-top-level -sql-mysql -- -DMySQL_INCLUDE_DIR="C:\Program Files\MySQL\MySQL Connector C 6.1\include" -DMySQL_LIBRARY="C:\Program Files\MySQL\MySQL Connector C 6.1\lib\libmysql. lib>config.opt.in
'cmake' is not recognized as an internal command
or external, an executable program or a batch file.
'cmake' is not recognized as an internal command
or external, an executable program or a batch file.

And btw, here is the MySQL table config :

[jsulm]

@pierrbt said in MySQL driver isn't installed:

'cmake' is not recognized as an internal command

You need cmake to build Qt6.

And I was refering to:
"I configured the plugin as a SQLite one, and the users table exists because i tried the same command in the main MySQL shell and it was working".
SQLite != MySQL
SQLite stores the database in a file, it has absolutelly nothing to do with MySQL.

[pierrbt]

I've already installed CMake :

but it don't appear in the build options, have i need to build from a command prompt ?

And yes i know that MySQL != SQLite but i was just trying to test ...

[jsulm]

@pierrbt Make sure folder containing cmake executable is in path.
On Windows you also should execute batch script which prepares the build environment (it should be in the Qt start menu entry and in Qt installation folder). Which one depends on your compiler: either the one for MinGW or MSVC.

[pierrbt]

@jsulm I maybe found : i was coding my app in a "Empty qmake Project", it's maybe the reason why it wasn't working. I'm actually trying to copy the old scripts to the new Project.

EDIT : And by the way, which compiler should i use, MSVC, MinGW or WebAssembly @jsulm ?

[jsulm]

@pierrbt said in MySQL driver isn't installed:

And by the way, which compiler should i use, MSVC, MinGW or WebAssembly @jsulm ?

That's up to you.
WebAssembly is for applications running in a browser.

[pierrbt]

@jsulm Ok, i've finally installed CMake and the project is working, the MySQL plugin still doesn't work but it will be easier to repair it ( i hope ).

Here is my project :

[pierrbt]

@jsulm I finally fix my problem, I replaced lots of DLLs of the MySQL and MinGW folders using that repository and it finally work ! The MySQL Driver is detected by the compiler and I can perfectly use it. I tried to made that command :

INSERT INTO users (pseudo, mail, birthdate, passwd) 
VALUES ("pierrbt",
        "haha@gmail.com",
        "2000-01-01", 
        "testPassword");

and it's working. Thanks for helping me to fix that problem.