Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Get Qt Extensions
  • Unsolved
Collapse
Brand Logo
  1. Home
  2. Qt Development
  3. Installation and Deployment
  4. Can't working MYSQL database in qt (QSqlDatabase: available drivers: QSQLITE QODBC QPSQL)
Forum Updated to NodeBB v4.3 + New Features

Can't working MYSQL database in qt (QSqlDatabase: available drivers: QSQLITE QODBC QPSQL)

Scheduled Pinned Locked Moved Unsolved Installation and Deployment
33 Posts 6 Posters 4.8k Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • J jsulm
    23 Feb 2022, 09:13

    @Lestev OK, then we need to debug now.
    Do this on console:

    • Go to the build folder of your application
    • Do: export QT_DEBUG_PLUGINS=1
    • Run your app from the terminal
    • Copy paste the output from terminal to here

    You can also set QT_DEBUG_PLUGINS in Run settings of your project in QtCreator.
    https://doc.qt.io/qt-5/debug.html

    L Offline
    L Offline
    Lestev
    wrote on 23 Feb 2022, 09:52 last edited by Lestev
    #20

    @jsulm Thanks, i get it, but how i can use run in terminal project?, i wrote:

    migellestev@Migels-MacBook-Pro forBeginner % c++ main.cpp
    main.cpp:1:10: fatal error: 'QGuiApplication' file not found
    #include <QGuiApplication>
    ^~~~~~~~~~~~~~~~~
    1 error generated.

    J 2 Replies Last reply 23 Feb 2022, 09:55
    0
    • L Lestev
      23 Feb 2022, 09:52

      @jsulm Thanks, i get it, but how i can use run in terminal project?, i wrote:

      migellestev@Migels-MacBook-Pro forBeginner % c++ main.cpp
      main.cpp:1:10: fatal error: 'QGuiApplication' file not found
      #include <QGuiApplication>
      ^~~~~~~~~~~~~~~~~
      1 error generated.

      J Offline
      J Offline
      jsulm
      Lifetime Qt Champion
      wrote on 23 Feb 2022, 09:55 last edited by
      #21
      This post is deleted!
      1 Reply Last reply
      0
      • L Lestev
        23 Feb 2022, 09:52

        @jsulm Thanks, i get it, but how i can use run in terminal project?, i wrote:

        migellestev@Migels-MacBook-Pro forBeginner % c++ main.cpp
        main.cpp:1:10: fatal error: 'QGuiApplication' file not found
        #include <QGuiApplication>
        ^~~~~~~~~~~~~~~~~
        1 error generated.

        J Offline
        J Offline
        jsulm
        Lifetime Qt Champion
        wrote on 23 Feb 2022, 09:57 last edited by
        #22

        @Lestev I did not ask you to build your app in the terminal, that you can still do in QtCreator.
        What I asked you to do is to run the executable of your application.

        L 1 Reply Last reply 23 Feb 2022, 15:14
        0
        • J jsulm
          23 Feb 2022, 09:57

          @Lestev I did not ask you to build your app in the terminal, that you can still do in QtCreator.
          What I asked you to do is to run the executable of your application.

          L Offline
          L Offline
          Lestev
          wrote on 23 Feb 2022, 15:14 last edited by
          #23

          @jsulm hey, the terminal doesn't output anything, it only launches the application

          migellestev@Migels-MacBook-Pro build-forBeginner-Clone_of_Qt_6_2_2_for_macOS-Debug % export QT_DEBUG_PLUGINS=1
          migellestev@Migels-MacBook-Pro build-forBeginner-Clone_of_Qt_6_2_2_for_macOS-Debug % open forBeginner.app
          migellestev@Migels-MacBook-Pro build-forBeginner-Clone_of_Qt_6_2_2_for_macOS-Debug %

          Everything works, but inside qt error is keeping

          1 Reply Last reply
          0
          • S Offline
            S Offline
            SGaist
            Lifetime Qt Champion
            wrote on 23 Feb 2022, 20:40 last edited by
            #24

            Don't call open, use the full path to the executable in the bundle.

            Interested in AI ? www.idiap.ch
            Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct

            L 1 Reply Last reply 24 Feb 2022, 18:25
            0
            • S SGaist
              23 Feb 2022, 20:40

              Don't call open, use the full path to the executable in the bundle.

              L Offline
              L Offline
              Lestev
              wrote on 24 Feb 2022, 18:25 last edited by
              #25

              @SGaist hi, I think my directory is not properly defined because it should be /Users/migellestev/Qt/6.2.3/macos/plugins/sqldrivers
              but directory is:
              /Users/migellestev/Qt/QtDesignStudio/qt6_design_studio_reduced_version/plugins/sqldrivers

              if it helps:
              Screenshot 2022-02-24 at 21.23.40.png
              Screenshot 2022-02-24 at 21.24.05.png

              1 Reply Last reply
              0
              • C Online
                C Online
                Christian Ehrlicher
                Lifetime Qt Champion
                wrote on 24 Feb 2022, 18:28 last edited by
                #26

                Looks like you're mixing up Qt versions which is not possible. Make sure QtDesignStudio is not picked up, only your Qt6.2.2 where you also (hopefully) build your Qt mysql plugin for. Currently it looks like you created (or had by default - don't know) the plugin inside QtDesignStudio.

                Qt Online Installer direct download: https://download.qt.io/official_releases/online_installers/
                Visit the Qt Academy at https://academy.qt.io/catalog

                L 1 Reply Last reply 28 Feb 2022, 04:07
                0
                • C Christian Ehrlicher
                  24 Feb 2022, 18:28

                  Looks like you're mixing up Qt versions which is not possible. Make sure QtDesignStudio is not picked up, only your Qt6.2.2 where you also (hopefully) build your Qt mysql plugin for. Currently it looks like you created (or had by default - don't know) the plugin inside QtDesignStudio.

                  L Offline
                  L Offline
                  Lestev
                  wrote on 28 Feb 2022, 04:07 last edited by
                  #27

                  @Christian-Ehrlicher
                  Thanks for your response very much,
                  But i verify my path and got that this path used by default, but why?

                  Screenshot 2022-02-28 at 07.03.14.png

                  I reinstalled qt and got the same

                  1 Reply Last reply
                  0
                  • C Online
                    C Online
                    Christian Ehrlicher
                    Lifetime Qt Champion
                    wrote on 28 Feb 2022, 16:16 last edited by
                    #28

                    Don't know MacOS but on linux this means you have the other somewhere in your LD_LIBRARY_PATH or ld.so.conf. Remove it /make sure the correct path comes first.

                    Qt Online Installer direct download: https://download.qt.io/official_releases/online_installers/
                    Visit the Qt Academy at https://academy.qt.io/catalog

                    1 Reply Last reply
                    0
                    • I Offline
                      I Offline
                      Ilya Pro
                      wrote on 5 Mar 2022, 16:37 last edited by Ilya Pro 3 May 2022, 16:37
                      #29

                      Hello!
                      Error
                      /Users/ilaproskurnev/Qt/6.2.3/macos/bin/qt-cmake: line 17: exec: cmake: not found
                      If export PATH="/Users/ilaproskurnev/Qt/6.2.3/macos/bin:$PATH"
                      qt-cmake -G Ninja /Users/ilaproskurnev/Qt/6.2.3/Src/qtbase/src/plugins/sqldrivers -DCMAKE_INSTALL_PREFIX=/Users/ilaproskurnev/Qt/6.2.3/macos -DMySQL_INCLUDE_DIR="/usr/local/mysql/include" -DMySQL_LIBRARY="/usr/local/mysql/lib/libmysqlclient.dylib"
                      line 17: exec: cmake: not found

                      1 Reply Last reply
                      0
                      • C Online
                        C Online
                        Christian Ehrlicher
                        Lifetime Qt Champion
                        wrote on 5 Mar 2022, 16:51 last edited by
                        #30

                        Then make sure that cmake is installed and in your PATH...

                        Qt Online Installer direct download: https://download.qt.io/official_releases/online_installers/
                        Visit the Qt Academy at https://academy.qt.io/catalog

                        I 1 Reply Last reply 5 Mar 2022, 17:08
                        0
                        • C Christian Ehrlicher
                          5 Mar 2022, 16:51

                          Then make sure that cmake is installed and in your PATH...

                          I Offline
                          I Offline
                          Ilya Pro
                          wrote on 5 Mar 2022, 17:08 last edited by Ilya Pro 3 May 2022, 17:11
                          #31

                          @Christian-Ehrlicher
                          Please tell me how to check it?
                          exec "$cmake_path" -DCMAKE_TOOLCHAIN_FILE="$toolchain_path" "$@"

                          C 1 Reply Last reply 5 Mar 2022, 17:12
                          0
                          • I Ilya Pro
                            5 Mar 2022, 17:08

                            @Christian-Ehrlicher
                            Please tell me how to check it?
                            exec "$cmake_path" -DCMAKE_TOOLCHAIN_FILE="$toolchain_path" "$@"

                            C Online
                            C Online
                            Christian Ehrlicher
                            Lifetime Qt Champion
                            wrote on 5 Mar 2022, 17:12 last edited by
                            #32

                            @Ilya-Pro said in Can't working MYSQL database in qt (QSqlDatabase: available drivers: QSQLITE QODBC QPSQL):

                            Please tell me how to check it?

                            I don't understand. If you want to build Qt or one of it's plugins you have to install cmake and make sure it's found in your PATH.

                            Qt Online Installer direct download: https://download.qt.io/official_releases/online_installers/
                            Visit the Qt Academy at https://academy.qt.io/catalog

                            I 1 Reply Last reply 5 Mar 2022, 17:20
                            0
                            • C Christian Ehrlicher
                              5 Mar 2022, 17:12

                              @Ilya-Pro said in Can't working MYSQL database in qt (QSqlDatabase: available drivers: QSQLITE QODBC QPSQL):

                              Please tell me how to check it?

                              I don't understand. If you want to build Qt or one of it's plugins you have to install cmake and make sure it's found in your PATH.

                              I Offline
                              I Offline
                              Ilya Pro
                              wrote on 5 Mar 2022, 17:20 last edited by Ilya Pro 3 May 2022, 17:32
                              #33

                              @Christian-Ehrlicher
                              QtToolchainHelpers.cmake
                              toolchain_path="$script_dir_path/../lib/cmake/Qt6/qt.toolchain.cmake"
                              screenshot

                              1 Reply Last reply
                              0

                              29/33

                              5 Mar 2022, 16:37

                              • Login

                              • Login or register to search.
                              29 out of 33
                              • First post
                                29/33
                                Last post
                              0
                              • Categories
                              • Recent
                              • Tags
                              • Popular
                              • Users
                              • Groups
                              • Search
                              • Get Qt Extensions
                              • Unsolved