I did the migration with mysqldump then I edited the dump file. Then I have the resulting file into sqlite and saved it as database. The date columns are now stored in sqlite as TEXT fields. All done on a linux machine. Thank you VRonin for your suggestion. That sounds like a great idea. Can I do this in pyQt5 or do I need to go to C++? I think QSQLiteDriver is a plugin i.e. a shared library. That means I have to do this in C++. Is that right? I wanted to avoid C++ so that my application is more portable. But anyway this solution sounds great. Thanks for you answers guys.

@Giggon said in SQLite database creation: Thread to be closed Please go and mark the post as solved. Thanks

No it's not, you can see that with its constructors that take a QSqlDatabase parameter. No clear is not called, the destructor is. There's no need to create QSqlQuery objects on the heap.

@projectbavaria Ging es nicht darum die gelesenen Daten in eine Datei reinzuschreiben? Wenn nicht, dann sollte auch nicht von einer Datei die Rede sein, da es sonst nur verwirrt. Also, was ist das: "haben wir versucht mit QFile aber es funktioniert nicht, Qt gibt meldung raus das es keine file gibt bzw. empty"? Wo wird in dem Code irgendwas mit QFile gemacht? Wie groß ist outByteArray und was ist drin?

No, you have to use the same compiler that was used to build Qt. You can't mix and match C++ librairies built with MinGW and MSVC.

@Bardfast said in Trouble building the QMYSQL Plugin on Unix (Mint 19.2): $QTDIR/$QTVERSION/gcc_64/bin/qmake -- MYSQL_PREFIX=/usr/include/mysql Thank you for your reply. Unfortunately the log doesn't tell me much. The log <./Src/qtbase/src/plugins/sqldrivers/config.log> reads as follows ... Command line: MYSQL_PREFIX=/usr/include/mysql Global lib dirs: [/home/qt/openssl-1.1.1b/lib] [/usr/lib/gcc/x86_64-linux-gnu/7 /usr/lib/x86_64-linux-gnu /usr/lib /lib/x86_64-linux-gnu /lib] Global inc dirs: [/home/qt/openssl-1.1.1b/include] [/usr/include/c++/7 /usr/include/x86_64-linux-gnu/c++/7 /usr/include/c++/7/backward /usr/lib/gcc/x86_64-linux-gnu/7/include /usr/local/include /usr/lib/gcc/x86_64-linux-gnu/7/include-fixed /usr/include/x86_64-linux-gnu /usr/include] loaded result for library config.sqldrivers.libraries.db2 test config.sqldrivers.libraries.db2 succeeded loaded result for library config.sqldrivers.libraries.ibase test config.sqldrivers.libraries.ibase succeeded loaded result for library config.sqldrivers.libraries.mysql test config.sqldrivers.libraries.mysql FAILED loaded result for library config.sqldrivers.libraries.oci test config.sqldrivers.libraries.oci succeeded loaded result for library config.sqldrivers.libraries.odbc test config.sqldrivers.libraries.odbc FAILED loaded result for library config.sqldrivers.libraries.psql test config.sqldrivers.libraries.psql FAILED loaded result for library config.sqldrivers.libraries.sqlite2 test config.sqldrivers.libraries.sqlite2 succeeded loaded result for library config.sqldrivers.libraries.tds test config.sqldrivers.libraries.tds FAILED Is this the 'test' log that you were referring to?

Seems to be a bug reported here QTBUG-50244 Nobody tried to integrate MySQL for a Raspberry Pi project already ?! no workaround?! Seems strange :(

Are you trying to move things around in the folder where you are currently doing the application deployment ?

what is your suggestion about server app design ? People usually refer to "server app" as "middleware" or "web application". There are tons of web frameworks and ORMs for various languages including Java and C# on "enterprise" side and scripting languages (pphp, python, perl, ruby, node.js). C++ is not really convenient language here. As for protocol, if you are not pursuing real-time data processing with lowest possible latency, it makes sense to use REST API on top of HTTP, so that on server side you have the most typical "web app" with ORM inside and REST outside, and on client side you can easily add web client if needed, and even if not, you get some additional convenience as compared to e.g. RPC over plain TCP

@SnuggleKat said in Cannot access MySQL running on another machine: Looks like skip-networking solved the problem Could you describe what this skip-networking concept is? for the sake of completeness and benefit of documenting the case for other future users having the same issue. And if your issue is solved, please don't forget to mark your post as such. Thanks

@raven-worx Thanks a lot. Now, I got a perspective on how I can proceed further. I will try the solution with the QWebSocket and see how that goes. Cheers!

@SGaist I have OpenSSL recently installed, but I am stating explicitly "no" for SSL connection option in MySql workbench. The connection give a warning, but this relates to the workbench version which seem to be higher than the actual MySql install at the web domain. No mention of SSL at all there. Since I have not really used OpenSSL I am lost on those parameters as used above. They are from the Qt document example and potentially completely wrong

Hi, There’s also no need to allocate the query on the heap as the QSqlQueryModel::setQuery method parameter suggests.

@SGaist , thanks

No, bad design. The child should never even know who its parent is. The correct process is to push information downstream. The child should have setters for all the data it need. The manwindow calls those setters.

I may have misunderstood the case that doesn’t work. Can you maybe do a small picture with the setup ?

I have add C:\mysql\mysql-5.7.21-winx64\lib into path variable. but don't work!

As it is now, double is used. Depending on how your DECIMAL filed is configured, it might be enough. If not, then you can modify the plugin to read the field as described here.

Dear Allerknapper I have same problem and stacked long time at here . Now I have use the QT5.10.1 maybe can get succeed. I have no time on it, but i will try it from July. If you have any new progress could you update on this topic? Best regards, jeff

Zapewne już jakoś sobie poradziłeś ale gdyby nie to musisz na systemie z Win7 sprawdzić czego brakuje. Jest kilka aplikacji, które posiadają funkcjonalność Linuksowego ldd. Popatrz też na stronę: https://wiki.qt.io/Show_library_dependencies

Good afternoon. The topic is old, but still relevant to this day. I decided to try to connect MYSQL for Android. Article: https://wiki.qt.io/Build_Qt_5_MySQL_Plugin_for_Android Ct 5.10.1 I write under android Faced with difficulties.

Hi, Are you aware of the implications of moving from MySQL to SQLite ? One of which is: you are using a relative path for your SQLite database which won't work if your users install your application in e.g. Program Files as it's a read-only location.

hi, @LuAria , wat ws the value coming in Numtwo ?. Nways ur got solution. Happy coding. Thanks,

@jsulm Thanks a lot! Sorry for my miss on the link. I will try it.

@jsulm woooow! i add the spaces and the error disappear! REALLY REALLY thanks!!!!

@SGaist @SGaist said in MySQL + Qt 5.7 integration on Ubuntu 16.04: Indeed, however I did misread, the calls seem to have been done. But something looks wrong since the .so files can't be found. Interesting to see what ldd on libqsqlmysql.so displays now, after creating the link: guilherme@k45a:~/Programs/Qt/5.7/gcc_64/plugins/sqldrivers$ ldd libqsqlmysql.so linux-vdso.so.1 => (0x00007ffe33d5f000) libmysqlclient.so.20 => /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20 (0x00007f8c1fcb1000) libQt5Sql.so.5 => /home/guilherme/Programs/Qt/5.7/gcc_64/plugins/sqldrivers/./../../lib/libQt5Sql.so.5 (0x00007f8c1fa6c000) libQt5Core.so.5 => /home/guilherme/Programs/Qt/5.7/gcc_64/plugins/sqldrivers/./../../lib/libQt5Core.so.5 (0x00007f8c1f34d000) libstdc++.so.6 => /usr/lib/x86_64-linux-gnu/libstdc++.so.6 (0x00007f8c1efcb000) libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007f8c1ec02000) libz.so.1 => /lib/x86_64-linux-gnu/libz.so.1 (0x00007f8c1e9e7000) libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007f8c1e7e3000) libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007f8c1e5c6000) libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007f8c1e2bc000) libgcc_s.so.1 => /lib/x86_64-linux-gnu/libgcc_s.so.1 (0x00007f8c1e0a6000) libicui18n.so.56 => /home/guilherme/Programs/Qt/5.7/gcc_64/plugins/sqldrivers/./../../lib/libicui18n.so.56 (0x00007f8c1dc0b000) libicuuc.so.56 => /home/guilherme/Programs/Qt/5.7/gcc_64/plugins/sqldrivers/./../../lib/libicuuc.so.56 (0x00007f8c1d853000) libicudata.so.56 => /home/guilherme/Programs/Qt/5.7/gcc_64/plugins/sqldrivers/./../../lib/libicudata.so.56 (0x00007f8c1be70000) libgthread-2.0.so.0 => /usr/lib/x86_64-linux-gnu/libgthread-2.0.so.0 (0x00007f8c1bc6d000) librt.so.1 => /lib/x86_64-linux-gnu/librt.so.1 (0x00007f8c1ba65000) libglib-2.0.so.0 => /lib/x86_64-linux-gnu/libglib-2.0.so.0 (0x00007f8c1b754000) /lib64/ld-linux-x86-64.so.2 (0x000055a9c6cac000) libpcre.so.3 => /lib/x86_64-linux-gnu/libpcre.so.3 (0x00007f8c1b4e3000) Seems like it changed the entire dependency table.

@koahnig Well the "MySQL server has gone away" msg also seems slightly "wooden" so it fits perfectly :)

@SGaist is VS express not excotic enough ? ;)

Thank you dear friend . You're right . the drivers names were wrong . it works now

Hi and welcome to devnet, Please search the forum a bit, I've already provided the solution several times for OS X/macOS.

@MrErfan Did you not check you earlier deleted post ? It had a few answers. @MrErfan To add to @neda's answer you can convert the image to base64 and set this as value to Image's source property. Something like: imageObj->setProperty("source", "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADwAAAA8CAYAAAA6/NlyAAAQvUlEQVRo3t2beYxd1X3Hv79zzr33LTNv3iwez+aNDOCw2WAMKSIgpTZJaUA0SkkrNWnTVhBFolG6pJIb2ihFFk3/aEBJF0VVk0pJS5eoCYVCYwjEwhTbY4PBi7A9tpkZ27O/W

Hi and welcome to devnet, You have to go to the mysql plugin folder.

can i export this script to windows and use it there?

hi I like this one https://sourceforge.net/projects/qtrpt/

I'm just realizing that what I was trying to do was maybe nonsense : I was trying to pass on to the mysql server a value for the client on which my Qt program is running i.e. I was trying to "deceive" the server. And I could understand then that there would be no such method in QSqlDatabase (and that you couldn't understand my question initially). Could you confirm my reasoning please?