Good to read, @Emanuel: does this solve your problems, too?
Am 06.01.2016 um 22:17 schrieb apschwimmer: > Dear Oliver, > > I give my user all rights for mysql and it works ! > Thank you for your patience ! > > > Kind regards > > Axel > > > > On Mi, 2016-01-06 at 20:04 +0000, qlandkartegt-users- > requ...@lists.sourceforge.net wrote: >> Send Qlandkartegt-users mailing list submissions to >> qlandkartegt-users@lists.sourceforge.net >> >> To subscribe or unsubscribe via the World Wide Web, visit >> https://lists.sourceforge.net/lists/listinfo/qlandkartegt-users >> or, via email, send a message with subject or body 'help' to >> qlandkartegt-users-requ...@lists.sourceforge.net >> >> You can reach the person managing the list at >> qlandkartegt-users-ow...@lists.sourceforge.net >> >> When replying, please edit your Subject line so it is more specific >> than "Re: Contents of Qlandkartegt-users digest..." >> >> >> Today's Topics: >> >> 1. Re: Qlandkartegt-users Digest, Vol 85, Issue 5 (Oliver Eichler) >> >> >> ------------------------------------------------------------------- >> --- >> >> Message: 1 >> Date: Wed, 06 Jan 2016 21:04:27 +0100 >> From: Oliver Eichler <oliver.eich...@gmx.de> >> Subject: Re: [Qlandkartegt-users] Qlandkartegt-users Digest, Vol 85, >> Issue 5 >> To: qlandkartegt-users@lists.sourceforge.net >> Message-ID: <16151651.r93bKL7QSz@linux-12kj> >> Content-Type: text/plain; charset="us-ascii" >> >> Am Wednesday 06 January 2016, 20:56:58 schrieb apschwimmer: >>> Hello Oliver, >>> >>> here's the output from debug: >>> >>> >>> 2016-01-06 20:51:15.260 [warning] Execution of SQL-Statement ` >>> "CREATE >>> TRIGGER items_insert_last_user BEFORE INSERT ON items FOR EACH ROW >>> SET >>> NEW.last_user = USER();" ` failed: >>> 2016-01-06 20:51:15.260 [warning] QSqlError("1419", "QMYSQL: Unable >>> to >>> execute query", "You do not have the SUPER privilege and binary >>> logging >>> is enabled (you *might* want to use the less safe >> Right. This clearly states that your user does not have the needed >> access >> rights. For my test I granted my user all rights possible. >> >> >>> log_bin_trust_function_creators variable)") >>> 2016-01-06 20:51:15.261 [warning] QSqlQuery::value: not positioned >>> on a >>> valid record >>> 2016-01-06 20:51:15.261 [warning] QSqlQuery::value: not positioned >>> on a >>> valid record >>> 2016-01-06 20:51:15.261 [warning] QSqlQuery::value: not positioned >>> on a >>> valid record >>> 2016-01-06 20:51:15.261 [warning] Execution of SQL-Statement ` >>> "SELECT >>> COUNT(*) FROM folder2folder WHERE parent=:id" ` failed: >>> 2016-01-06 20:51:15.261 [warning] QSqlError("1146", "QMYSQL: Unable >>> to >>> execute query", "Table 'Touren.folder2folder' doesn't exist") >>> >>> I think you're right it's something with mysql user rights, I'll >>> check >>> it . >>> >>> >>> Kind regards >>> >>> Axel >>> >>> >>> >>> >>> >>> >>> On Mi, 2016-01-06 at 19:35 +0000, qlandkartegt-users- >>> >>> requ...@lists.sourceforge.net wrote: >>>> Send Qlandkartegt-users mailing list submissions to >>>> >>>> qlandkartegt-users@lists.sourceforge.net >>>> >>>> To subscribe or unsubscribe via the World Wide Web, visit >>>> >>>> https://lists.sourceforge.net/lists/listinfo/qlandkartegt-users >>>> >>>> or, via email, send a message with subject or body 'help' to >>>> >>>> qlandkartegt-users-requ...@lists.sourceforge.net >>>> >>>> You can reach the person managing the list at >>>> >>>> qlandkartegt-users-ow...@lists.sourceforge.net >>>> >>>> When replying, please edit your Subject line so it is more >>>> specific >>>> than "Re: Contents of Qlandkartegt-users digest..." >>>> >>>> >>>> Today's Topics: >>>> >>>> 1. Re: Using mysql in QMS (Oliver Eichler) >>>> 2. Re: Using mysql in QMS (Oliver Eichler) >>>> >>>> >>>> --------------------------------------------------------------- >>>> ---- >>>> --- >>>> >>>> Message: 1 >>>> Date: Wed, 06 Jan 2016 20:31:27 +0100 >>>> From: Oliver Eichler <oliver.eich...@gmx.de> >>>> Subject: Re: [Qlandkartegt-users] Using mysql in QMS >>>> To: qlandkartegt-users@lists.sourceforge.net >>>> Message-ID: <5221779.x6YmYSiXz1@linux-12kj> >>>> Content-Type: text/plain; charset="us-ascii" >>>> >>>> Hi >>>> >>>> I think this is the same problem as Emanuel reports. So let's >>>> keep >>>> the >>>> discussion together. >>>> >>>>> From the error logs I can see that the database has not been >>>>> initialized >>>> properly. (your's and the one of Emanuel) >>>> >>>> 1) Remove it from QMapShack >>>> 2) Remove it from the mysql server (drop database <myname>;) >>>> 3) Make sure your mysql user has the rights to create tables, >>>> triggers, etc.. >>>> 4) Add the database on the server (create database <myname>;) >>>> 5) Add the database in QMapShack. Watch out for the debug output! >>>> >>>> >>>> HTH >>>> >>>> Oliver >>>> >>>> Am Wednesday 06 January 2016, 18:16:32 schrieb apschwimmer: >>>>> Hello Oliver, >>>>> >>>>> >>>>> I recompiled QMS using >>>>> >>>>> hg pull >>>>> hg update >>>>> >>>>> make >>>>> make install >>>>> >>>>> >>>>> but I have the same problem, I can't see any folders in mysql >>>>> db >>>>> myname >>>>> in QMS appliction. >>>>> >>>>> >>>>> Further I start QMS with option -d and received: >>>>> >>>>> QSqlError("1146", "QMYSQL: Unable to execute query", >>>>> 'myname.folder2folder' doesn't exist") >>>>> >>>>> >>>>> >>>>> Here's the complete log until error message >>>>> >>>>> qmapshack -d >>>>> 2016-01-06 17:54:19.956 [debug] "GDAL_DATA directory set to " >>>>> 2016-01-06 17:54:19.956 [debug] "PROJ_LIB directory set to " >>>>> 2016-01-06 17:54:20.007 [debug] Application ID: 1909280421 >>>>> 2016-01-06 17:54:20.016 [debug] "ROUTINO file is >>>>> /usr/share/routino/profiles.xml" >>>>> 2016-01-06 17:54:20.017 [debug] "ROUTINO file is >>>>> /usr/share/routino/translations.xml" >>>>> 2016-01-06 17:54:20.059 [debug] config >>>>> dir "/home/acki/.config/QLandkarte/WaypointIcons" >>>>> 2016-01-06 17:54:20.133 [debug] config >>>>> dir "/home/acki/.config/QLandkarte" >>>>> 2016-01-06 17:54:21.160 [debug] model: "" vendor: "" >>>>> 2016-01-06 17:54:21.166 [debug] model: "" vendor: "" >>>>> 2016-01-06 17:54:21.174 [debug] model: "" vendor: "" >>>>> 2016-01-06 17:54:21.189 [debug] model: "ST500LT012-1DG142" >>>>> vendor: >>>>> "" >>>>> 2016-01-06 17:54:26.082 [warning] Execution of SQL-Statement ` >>>>> "SELECT >>>>> COUNT(*) FROM folder2folder WHERE parent=:id" ` failed: >>>>> 2016-01-06 17:54:26.082 [warning] QSqlError("1146", "QMYSQL: >>>>> Unable >>>>> to >>>>> execute query", "Table 'myname.folder2folder' doesn't exist") >>>>> >>>>> I find out that I can switch to some other branches on https:// >>>>> bitb >>>>> ucke >>>>> t.org/maproom/qmapshack/src >>>>> >>>>> -default >>>>> -V1.x >>>>> -databases >>>>> - ... >>>>> >>>>> >>>>> To be honest I'm not sure if I did everything right. >>>>> >>>>> I only use "default" until now, is this ok ? >>>>> >>>>> How can I check, if I use the actual source, is there something >>>>> like a >>>>> source ident number ? QMS shows the version 1.6.0.pre. now. >>>>> >>>>> Perhaps I can find some further information how to work with >>>>> this >>>>> branch ? >>>>> >>>>> >>>>> >>>>> Kind regards >>>>> >>>>> Axel >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> On Di, 2016-01-05 at 19:25 +0000, qlandkartegt-users- >>>>> >>>>> requ...@lists.sourceforge.net wrote: >>>>>> Send Qlandkartegt-users mailing list submissions to >>>>>> >>>>>> qlandkartegt-users@lists.sourceforge.net >>>>>> >>>>>> To subscribe or unsubscribe via the World Wide Web, visit >>>>>> >>>>>> https://lists.sourceforge.net/lists/listinfo/qlandkarte >>>>>> gt-users >>>>>> >>>>>> or, via email, send a message with subject or body 'help' to >>>>>> >>>>>> qlandkartegt-users-requ...@lists.sourceforge.net >>>>>> >>>>>> You can reach the person managing the list at >>>>>> >>>>>> qlandkartegt-users-ow...@lists.sourceforge.net >>>>>> >>>>>> When replying, please edit your Subject line so it is more >>>>>> specific >>>>>> than "Re: Contents of Qlandkartegt-users digest..." >>>>>> >>>>>> >>>>>> Today's Topics: >>>>>> >>>>>> 1. Using mysql in QMS (AP) >>>>>> 2. Re: Using mysql in QMS (Oliver Eichler) >>>>>> 3. Compiling QMS for Windows (was: QMapShack/Routin >>>>>> o >>>>>> link >>>>>> error >>>>>> (Windows)) (WT) >>>>>> 4. Re: Database change - "mysql.jpg" yEnc (Emanuel Hudl) >>>>>> 5. Re: Database change (Emanuel Hudl) >>>>>> 6. Re: Database change - "qms.jpg" yEnc (Emanuel Hudl) >>>>>> >>>>>> >>>>>> ----------------------------------------------------------- >>>>>> ---- >>>>>> ---- >>>>>> --- >>>>>> >>>>>> Message: 1 >>>>>> Date: Fri, 1 Jan 2016 18:46:09 +0100 >>>>>> From: AP <apschwim...@apmland.de> >>>>>> Subject: [Qlandkartegt-users] Using mysql in QMS >>>>>> To: qlandkartegt-users@lists.sourceforge.net >>>>>> Message-ID: <5686bb61.9040...@apmland.de> >>>>>> Content-Type: text/plain; charset=windows-1252; format=flowed >>>>>> >>>>>> Dear All, >>>>>> >>>>>> >>>>>> meanwhile I compiled QMS 1.5.1 following the tutorial >>>>>> >>>>>> https://bitbucket.org/maproom/qmapshack/src >>>>>> >>>>>> As mentioned before I created a mysql db "myname". >>>>>> >>>>>> I created a db in QMS with the same name by using the menue >>>>>> with >>>>>> mysql >>>>>> instead sqlite. >>>>>> >>>>>> The db appears in QMS menue "data". >>>>>> >>>>>> But if I try to create a folder "Tours" , the folder do not >>>>>> appears >>>>>> in >>>>>> the db in QMS. >>>>>> >>>>>> Using phpmyadmin I can see the db myname and the folder >>>>>> "Tours". >>>>>> >>>>>> What's wrong ? >>>>>> >>>>>> Kind regards >>>>>> >>>>>> Axel >>>>>> >>>>>> >>>>>> >>>>>> ------------------------------ Message: 3 Date: Thu, 31 Dec >>>>>> 2015 >>>>>> 16:56:20 +0100 From: AP <apschwim...@apmland.de> Subject: >>>>>> Re: >>>>>> [Qlandkartegt-users] Qlandkartegt-users Digest, Vol 84, Issue >>>>>> 8 >>>>>> To: >>>>>> qlandkartegt-users@lists.sourceforge.net Message-ID: >>>>>> <56855024.2050...@apmland.de> Content-Type: text/plain; >>>>>> charset=windows-1252; format=flowed Hallo Oliver, I'm not >>>>>> very >>>>>> fimilar >>>>>> with mysql but would be glad to help a little bit. I created >>>>>> a db >>>>>> with >>>>>> the name "myname" and can access it as a user. But I don't >>>>>> know >>>>>> how >>>>>> to >>>>>> deal with it from QMS side. How can I use a mysql-db in QMS >>>>>> 5.5.1 >>>>>> in >>>>>> Arch Linux ? Kind regards Axel Am 22.12.2015 um 15:09 schrieb >>>>>> Oliver >>>>>> >>>>>> Eichler: >>>>>>>>> hi, >>>>>>>>> >>>>>>>>> there has been another change in the database that >>>>>>>>> needs >>>>>>>>> migration of >>>>>>>>> the database. Please backup your database and report >>>>>>>>> errors. >>>>>>>>> >>>>>>>>> As you might have noticed QMapShack is supporting MySql >>>>>>>>> now. To >>>>>>>>> use >>>>>>>>> MySql you need a database server and a user login to >>>>>>>>> that >>>>>>>>> server. On the >>>>>>>>> database sever you have to create a database by: >>>>>>>>> >>>>>>>>> create database myname; >>>>>>>>> >>>>>>>>> This will create the database with name "myname". In >>>>>>>>> QMapShack's >>>>>>>>> database setup dialog you have to use that name. >>>>>>>>> >>>>>>>>> The challenge with using a MySql server is having >>>>>>>>> multiple >>>>>>>>> instances of >>>>>>>>> QMapShack using the same database. This will create >>>>>>>>> conflicts >>>>>>>>> when >>>>>>>>> inserting/updating items from different instances. I >>>>>>>>> spent >>>>>>>>> quite some >>>>>>>>> efforts to catch all these conflicts. But you never >>>>>>>>> know. >>>>>>>>> Thus >>>>>>>>> if you >>>>>>>>> experience some peculiar behaviour please report. >>>>>>>>> >>>>>>>>> >>>>>>>>> The next step will be a mechanism to >>>>>>>>> manually/automatically >>>>>>>>> update the >>>>>>>>> database tree and the workspace. >>>>>>>>> >>>>>>>>> >>>>>>>>> It would be nice if enough users test and challenge >>>>>>>>> that >>>>>>>>> feature before >>>>>>>>> the next release. >>>>>>>>> >>>>>>>>> Oliver >>>>>>>>> >>>>>>>>> ----------------------------------------------------- >>>>>>>>> ---- >>>>>>>>> ---- >>>>>>>>> ----------------- >>>>>>>>> _______________________________________________ >>>>>>>>> Qlandkartegt-users mailing list >>>>>>>>> Qlandkartegt-users@lists.sourceforge.net >>>>>>>>> https://lists.sourceforge.net/lists/listinfo/qlandkarte >>>>>>>>> gt-u >>>>>>>>> sers >>>>>> ------------------------------ >>>>>> >>>>>> Message: 2 >>>>>> Date: Fri, 01 Jan 2016 19:12:45 +0100 >>>>>> From: Oliver Eichler <oliver.eich...@gmx.de> >>>>>> Subject: Re: [Qlandkartegt-users] Using mysql in QMS >>>>>> To: qlandkartegt-users@lists.sourceforge.net >>>>>> Message-ID: <16701937.S9x7W6culu@linux-12kj> >>>>>> Content-Type: text/plain; charset="us-ascii" >>>>>> >>>>>> That was fast. You found a bug. Please test with latest >>>>>> version >>>>>> in >>>>>> the >>>>>> repository. >>>>>> >>>>>> >>>>>> Thanks >>>>>> >>>>>> Oliver >>>>>> >>>>>> Am Friday 01 January 2016, 18:46:09 schrieb AP: >>>>>>> Dear All, >>>>>>> >>>>>>> >>>>>>> meanwhile I compiled QMS 1.5.1 following the tutorial >>>>>>> >>>>>>> https://bitbucket.org/maproom/qmapshack/src >>>>>>> >>>>>>> As mentioned before I created a mysql db "myname". >>>>>>> >>>>>>> I created a db in QMS with the same name by using the menue >>>>>>> with >>>>>>> mysql >>>>>>> instead sqlite. >>>>>>> >>>>>>> The db appears in QMS menue "data". >>>>>>> >>>>>>> But if I try to create a folder "Tours" , the folder do not >>>>>>> appears >>>>>>> in >>>>>>> the db in QMS. >>>>>>> >>>>>>> Using phpmyadmin I can see the db myname and the folder >>>>>>> "Tours". >>>>>>> >>>>>>> What's wrong ? >>>>>>> >>>>>>> Kind regards >>>>>>> >>>>>>> Axel >>>>>>> >>>>>>> >>>>>>> >>>>>>> ------------------------------ Message: 3 Date: Thu, 31 Dec >>>>>>> 2015 >>>>>>> 16:56:20 +0100 From: AP <apschwim...@apmland.de> Subject: >>>>>>> Re: >>>>>>> [Qlandkartegt-users] Qlandkartegt-users Digest, Vol 84, >>>>>>> Issue 8 >>>>>>> To: >>>>>>> qlandkartegt-users@lists.sourceforge.net Message-ID: >>>>>>> <56855024.2050...@apmland.de> Content-Type: text/plain; >>>>>>> charset=windows-1252; format=flowed Hallo Oliver, I'm not >>>>>>> very >>>>>>> fimilar >>>>>>> with mysql but would be glad to help a little bit. I >>>>>>> created a >>>>>>> db >>>>>>> with >>>>>>> the name "myname" and can access it as a user. But I don't >>>>>>> know >>>>>>> how >>>>>>> to >>>>>>> deal with it from QMS side. How can I use a mysql-db in QMS >>>>>>> 5.5.1 >>>>>>> in >>>>>>> Arch Linux ? Kind regards Axel Am 22.12.2015 um 15:09 >>>>>>> schrieb >>>>>>> Oliver >>>>>>> >>>>>>> Eichler: >>>>>>>>>> hi, >>>>>>>>>> >>>>>>>>>> there has been another change in the database that >>>>>>>>>> needs >>>>>>>>>> migration of >>>>>>>>>> the database. Please backup your database and report >>>>>>>>>> errors. >>>>>>>>>> >>>>>>>>>> As you might have noticed QMapShack is supporting >>>>>>>>>> MySql >>>>>>>>>> now. >>>>>>>>>> To use >>>>>>>>>> MySql you need a database server and a user login to >>>>>>>>>> that >>>>>>>>>> server. On the >>>>>>>>>> database sever you have to create a database by: >>>>>>>>>> >>>>>>>>>> create database myname; >>>>>>>>>> >>>>>>>>>> This will create the database with name "myname". In >>>>>>>>>> QMapShack's >>>>>>>>>> database setup dialog you have to use that name. >>>>>>>>>> >>>>>>>>>> The challenge with using a MySql server is having >>>>>>>>>> multiple >>>>>>>>>> instances of >>>>>>>>>> QMapShack using the same database. This will create >>>>>>>>>> conflicts >>>>>>>>>> when >>>>>>>>>> inserting/updating items from different instances. I >>>>>>>>>> spent >>>>>>>>>> quite some >>>>>>>>>> efforts to catch all these conflicts. But you never >>>>>>>>>> know. >>>>>>>>>> Thus if you >>>>>>>>>> experience some peculiar behaviour please report. >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> The next step will be a mechanism to >>>>>>>>>> manually/automatically >>>>>>>>>> update the >>>>>>>>>> database tree and the workspace. >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> It would be nice if enough users test and challenge >>>>>>>>>> that >>>>>>>>>> feature before >>>>>>>>>> the next release. >>>>>>>>>> >>>>>>>>>> Oliver >>>>>>>>>> >>>>>>>>>> --------------------------------------------------- >>>>>>>>>> ---- >>>>>>>>>> ---- >>>>>>>>>> ------------- >>>>>>>>>> ------ >>>>>>>>>> _______________________________________________ >>>>>>>>>> Qlandkartegt-users mailing list >>>>>>>>>> Qlandkartegt-users@lists.sourceforge.net >>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/qlandkar >>>>>>>>>> tegt >>>>>>>>>> -use >>>>>>>>>> rs >>>>>>> --------------------------------------------------------- >>>>>>> ---- >>>>>>> ---- >>>>>>> ----------- >>>>>>> -- _______________________________________________ >>>>>>> Qlandkartegt-users mailing list >>>>>>> Qlandkartegt-users@lists.sourceforge.net >>>>>>> https://lists.sourceforge.net/lists/listinfo/qlandkartegt-u >>>>>>> sers >>>>>> ------------------------------ >>>>>> >>>>>> Message: 3 >>>>>> Date: Sat, 2 Jan 2016 13:14:23 +0000 (UTC) >>>>>> From: WT <k-w.thaem...@vodafone.de> >>>>>> >>>>>> Subject: [Qlandkartegt-users] Compiling QMS for Windows (was: >>>>>> QMapShack/Routino link error (Windows)) >>>>>> >>>>>> To: qlandkartegt-users@lists.sourceforge.net >>>>>> Message-ID: <loom.20160102t135949-...@post.gmane.org> >>>>>> Content-Type: text/plain; charset=us-ascii >>>>>> >>>>>> The linker error problem was solved and all questions >>>>>> concerning >>>>>> this >>>>>> error >>>>>> found an answer with Helmut's help (thank you again!). I >>>>>> finally >>>>>> compiled >>>>>> the Windows version of QMapShack from source on a 64-bit >>>>>> machine >>>>>> with >>>>>> Windows 7 Professional, SP 1. I tested this QMS with some of >>>>>> my >>>>>> typical >>>>>> actions - everything looks good. >>>>>> >>>>>> Here are some remarks and comments about the used procedure >>>>>> and >>>>>> its >>>>>> possible >>>>>> bottlenecks: >>>>>> >>>>>> - In some steps BAT-files have to be executed. I did this in >>>>>> a >>>>>> normal >>>>>> command line window started from cmd.exe. >>>>>> >>>>>> - Be sure to have the correct 64-bit development packages >>>>>> installed >>>>>> as >>>>>> indicated in Helmut's description. >>>>>> >>>>>> - QMS for windows is now supported as 64-bit program. Thus in >>>>>> all >>>>>> steps >>>>>> described in Helmut's document be sure to have the proper 64- >>>>>> bit >>>>>> development >>>>>> environment selected. The compiler packages normally support >>>>>> 32- >>>>>> as >>>>>> well as >>>>>> 64-bit projects on 32- and 64-bit machines! Check this in the >>>>>> cmake- >>>>>> gui with >>>>>> "Grouped" and "Advanced" both checked and in Visual studio >>>>>> properties >>>>>> and >>>>>> solution platform and look for 32- or 64-bit entries. >>>>>> >>>>>> - On my machine MinGW (without 64!) was already installed >>>>>> before >>>>>> trying to >>>>>> compile QMS. Comments on the MinGW homepage are ambiguous in >>>>>> what >>>>>> concerns >>>>>> the possibility of using it for 64-bit compilations too. This >>>>>> was >>>>>> my >>>>>> failure >>>>>> and the reason for the linker error! After switching to >>>>>> MinGW64 >>>>>> as >>>>>> proposed >>>>>> all the compilation steps could be carried out without >>>>>> problems. >>>>>> >>>>>> - During the compilation of almost any package compiler >>>>>> warnings >>>>>> appear. I >>>>>> simply ignored these warnings (under which circumstances is >>>>>> it >>>>>> recommended >>>>>> to pay attention to these warnings?). >>>>>> >>>>>> - There might be some trouble when using '"' to deliminate >>>>>> required >>>>>> path >>>>>> settings in configuration scripts. Don't use this >>>>>> deliminator. >>>>>> Use >>>>>> only >>>>>> directory names without spaces (and propably non-ASCII >>>>>> characters). >>>>>> >>>>>> - Visual studio creates some irritating program menu entries. >>>>>> Use >>>>>> "Visual >>>>>> studio 2013" and not "Microsoft Visual studio ..."! >>>>>> >>>>>> - cmake-gui: call help to find what to do as first steps. >>>>>> Don't >>>>>> forget to >>>>>> select correct development environment (lower part of the >>>>>> window) >>>>>> and >>>>>> set >>>>>> correct paths in upper 2 edit fields. >>>>>> >>>>>> - Select the proper build type ("Release") in cmake-gui >>>>>> and/or >>>>>> Visual >>>>>> studio. >>>>>> >>>>>> - QMS\nsi\copyfiles.bat: >>>>>> - copy %QMSI_QT_PATH%\bin\icudt53.dll and similar commands >>>>>> had >>>>>> to >>>>>> be >>>>>> replaced with copy %QMSI_QT_PATH%\bin\icudt54.dll (use of >>>>>> Qt5.5 - >>>>>> in >>>>>> my 5.5 >>>>>> installation there are no *53.dll files!) >>>>>> >>>>>> - I used Visual Studio Community 2013 - the installation >>>>>> procedure >>>>>> downloads >>>>>> more than 2 GB! >>>>>> >>>>>> - msys/MinGW64: >>>>>> - Install msys before installing MinGW64 >>>>>> - Installation of MinGW64 with win-builds-1.5.0: >>>>>> - after some automatic steps running in a cmd-window the >>>>>> "Win- >>>>>> builds >>>>>> installation" windows appears >>>>>> - choose "Cygwin or MSYS" >>>>>> - choose x86_64 >>>>>> - enter c:\msys as MSYS installation directory (if >>>>>> appropriate) >>>>>> - press Ok >>>>>> - in the next window click "Process" (upper right >>>>>> corner - >>>>>> difficult >>>>>> to identify!) - only now the necessary software will be >>>>>> downloaded >>>>>> and >>>>>> installed within the msys directory >>>>>> - close window at the end of the installation process >>>>>> (100% >>>>>> reached, >>>>>> click on x in upper right corner of window) >>>>>> - the \msys\opt directory is created by this installer. >>>>>> It >>>>>> contains >>>>>> MinGW64 >>>>>> >>>>>> - make.exe: use msys\bin\make.exe. In my case it was not in >>>>>> the >>>>>> PATH. >>>>>> I >>>>>> therefore modified the following nsi\build_routino.bat part >>>>>> >>>>>> rem add mingw64 toolchain to PATH >>>>>> set >>>>>> PATH=c:\msys\bin\;c:\msys\opt\windows_64\bin\;%PATH% >>>>>> rem set PATH=C:\msys\opt\windows_64\bin;%PATH% >>>>>> >>>>>> Regards >>>>>> >>>>>> Wolfgang >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> ------------------------------ >>>>>> >>>>>> Message: 4 >>>>>> Date: Tue, 5 Jan 2016 19:23:56 +0000 (UTC) >>>>>> From: Emanuel Hudl <emie1...@gmail.com> >>>>>> Subject: Re: [Qlandkartegt-users] Database change - >>>>>> "mysql.jpg" yEnc >>>>>> To: qlandkartegt-users@lists.sourceforge.net >>>>>> Message-ID: <n6h58c$eld$2...@ger.gmane.org> >>>>>> Content-Type: text/plain; charset=UTF-8 >>>>>> >>>>>> =ybegin part=1 line=128 size=292343 name=mysql.jpg >>>>>> =ypart begin=0 end=5 >>>>>> ))=J* >>>>>> =yend size=5 part=1 pcrc32=0f4066e6 >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> ------------------------------ >>>>>> >>>>>> Message: 5 >>>>>> Date: Tue, 5 Jan 2016 19:23:56 +0000 (UTC) >>>>>> From: Emanuel Hudl <emie1...@gmail.com> >>>>>> Subject: Re: [Qlandkartegt-users] Database change >>>>>> To: qlandkartegt-users@lists.sourceforge.net >>>>>> Message-ID: <pan$4479d$2a84d1c8$3d1dabcb$14c91008$1...@gmail.com >>>>>> Content-Type: text/plain; charset=UTF-8 >>>>>> >>>>>> hello oliver, >>>>>> >>>>>> i need your help. as my provider offers only one mysql >>>>>> database >>>>>> (yes >>>>>> i >>>>>> know that's poor) i want to test it on localhost. So seeting >>>>>> up >>>>>> the >>>>>> enviroment (apache2, php5 and mysql 5.5.46) is no problem (i >>>>>> tested >>>>>> with >>>>>> a local wordpress installation). >>>>>> >>>>>> My steps: >>>>>> Create database via phpmyadmin called "Touren" >>>>>> Creating a mysql Database named Touren >>>>>> when i try to add a folder, nothing happens, but when i look >>>>>> into >>>>>> the >>>>>> mysql database, there is written: >>>>>> >>>>>> Diese Tabelle enth?lt keine eindeutige ("unique") Spalte. >>>>>> Gitter- >>>>>> Bearbeitungsfunktion, Kontrollk?stchen, Bearbeiten, Kopieren >>>>>> und >>>>>> L?schen >>>>>> von Links sind nicht verf?gbar. >>>>>> >>>>>> SELECT * >>>>>> FROM `versioninfo` >>>>>> LIMIT 0 , 30 >>>>>> >>>>>> Version type >>>>>> 4 QMapShack >>>>>> >>>>>> Any hints? I read the post above "using mysql in QMS", put i >>>>>> stuck. >>>>>> I >>>>>> compiled lastet version, 1.6.0pre >>>>>> >>>>>> I added some screenshots and the localhost.sql >>>>>> Thanks! >>>>>> >>>>>> Am Tue, 22 Dec 2015 15:09:53 +0100 schrieb Oliver Eichler: >>>>>>> hi, >>>>>>> >>>>>>> there has been another change in the database that needs >>>>>>> migration >>>>>>> of >>>>>>> the database. Please backup your database and report >>>>>>> errors. >>>>>>> >>>>>>> As you might have noticed QMapShack is supporting MySql >>>>>>> now. To >>>>>>> use >>>>>>> MySql you need a database server and a user login to that >>>>>>> server. >>>>>>> On the >>>>>>> database sever you have to create a database by: >>>>>>> >>>>>>> create database myname; >>>>>>> >>>>>>> This will create the database with name "myname". In >>>>>>> QMapShack's >>>>>>> database setup dialog you have to use that name. >>>>>>> >>>>>>> The challenge with using a MySql server is having multiple >>>>>>> instances of >>>>>>> QMapShack using the same database. This will create >>>>>>> conflicts >>>>>>> when >>>>>>> inserting/updating items from different instances. I spent >>>>>>> quite >>>>>>> some >>>>>>> efforts to catch all these conflicts. But you never know. >>>>>>> Thus >>>>>>> if >>>>>>> you >>>>>>> experience some peculiar behaviour please report. >>>>>>> >>>>>>> >>>>>>> The next step will be a mechanism to manually/automatically >>>>>>> update >>>>>>> the >>>>>>> database tree and the workspace. >>>>>>> >>>>>>> >>>>>>> It would be nice if enough users test and challenge that >>>>>>> feature >>>>>>> before >>>>>>> the next release. >>>>>>> >>>>>>> Oliver >>>>>> ----------------------------------------------------------- >>>>>> ---- >>>>>> ---- >>>>>> ----------- >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> ------------------------------ >>>>>> >>>>>> Message: 6 >>>>>> Date: Tue, 5 Jan 2016 19:23:56 +0000 (UTC) >>>>>> From: Emanuel Hudl <emie1...@gmail.com> >>>>>> Subject: Re: [Qlandkartegt-users] Database change - >>>>>> "qms.jpg" yEnc >>>>>> To: qlandkartegt-users@lists.sourceforge.net >>>>>> Message-ID: <n6h58c$ngc$1...@ger.gmane.org> >>>>>> Content-Type: text/plain; charset=UTF-8 >>>>>> >>>>>> =ybegin part=1 line=128 size=19259 name=qms.jpg >>>>>> =ypart begin=0 end=5 >>>>>> ))=J* >>>>>> =yend size=5 part=1 pcrc32=0f4066e6 >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> ------------------------------ >>>>>> >>>>>> ----------------------------------------------------------- >>>>>> ---- >>>>>> ---- >>>>>> ----------- >>>>>> >>>>>> >>>>>> ------------------------------ >>>>>> >>>>>> _______________________________________________ >>>>>> Qlandkartegt-users mailing list >>>>>> Qlandkartegt-users@lists.sourceforge.net >>>>>> https://lists.sourceforge.net/lists/listinfo/qlandkartegt-use >>>>>> rs >>>>>> >>>>>> >>>>>> End of Qlandkartegt-users Digest, Vol 85, Issue 3 >>>>>> ************************************************* >>>>> ------------------------------------------------------------- >>>>> ---- >>>>> ----------- >>>>> -- _______________________________________________ >>>>> Qlandkartegt-users mailing list >>>>> Qlandkartegt-users@lists.sourceforge.net >>>>> https://lists.sourceforge.net/lists/listinfo/qlandkartegt-users >>>> ------------------------------ >>>> >>>> Message: 2 >>>> Date: Wed, 06 Jan 2016 20:35:26 +0100 >>>> From: Oliver Eichler <oliver.eich...@gmx.de> >>>> Subject: Re: [Qlandkartegt-users] Using mysql in QMS >>>> To: qlandkartegt-users@lists.sourceforge.net >>>> Message-ID: <11633960.qDLLYCSkTo@linux-12kj> >>>> Content-Type: text/plain; charset="us-ascii" >>>> >>>> Concerning "How can I check, if I use the actual source, is there >>>> something >>>> like a source ident number ? QMS shows the version 1.6.0.pre. >>>> now." >>>> >>>> I recommend to use TortoiseHg to handle all the repository stuff. >>>> This will >>>> show you a graph of all revisions. And handle all hg commands via >>>> GUI. >>>> >>>> Am Wednesday 06 January 2016, 18:16:32 schrieb apschwimmer: >>>>> Hello Oliver, >>>>> >>>>> >>>>> I recompiled QMS using >>>>> >>>>> hg pull >>>>> hg update >>>>> >>>>> make >>>>> make install >>>>> >>>>> >>>>> but I have the same problem, I can't see any folders in mysql >>>>> db >>>>> myname >>>>> in QMS appliction. >>>>> >>>>> >>>>> Further I start QMS with option -d and received: >>>>> >>>>> QSqlError("1146", "QMYSQL: Unable to execute query", >>>>> 'myname.folder2folder' doesn't exist") >>>>> >>>>> >>>>> >>>>> Here's the complete log until error message >>>>> >>>>> qmapshack -d >>>>> 2016-01-06 17:54:19.956 [debug] "GDAL_DATA directory set to " >>>>> 2016-01-06 17:54:19.956 [debug] "PROJ_LIB directory set to " >>>>> 2016-01-06 17:54:20.007 [debug] Application ID: 1909280421 >>>>> 2016-01-06 17:54:20.016 [debug] "ROUTINO file is >>>>> /usr/share/routino/profiles.xml" >>>>> 2016-01-06 17:54:20.017 [debug] "ROUTINO file is >>>>> /usr/share/routino/translations.xml" >>>>> 2016-01-06 17:54:20.059 [debug] config >>>>> dir "/home/acki/.config/QLandkarte/WaypointIcons" >>>>> 2016-01-06 17:54:20.133 [debug] config >>>>> dir "/home/acki/.config/QLandkarte" >>>>> 2016-01-06 17:54:21.160 [debug] model: "" vendor: "" >>>>> 2016-01-06 17:54:21.166 [debug] model: "" vendor: "" >>>>> 2016-01-06 17:54:21.174 [debug] model: "" vendor: "" >>>>> 2016-01-06 17:54:21.189 [debug] model: "ST500LT012-1DG142" >>>>> vendor: >>>>> "" >>>>> 2016-01-06 17:54:26.082 [warning] Execution of SQL-Statement ` >>>>> "SELECT >>>>> COUNT(*) FROM folder2folder WHERE parent=:id" ` failed: >>>>> 2016-01-06 17:54:26.082 [warning] QSqlError("1146", "QMYSQL: >>>>> Unable >>>>> to >>>>> execute query", "Table 'myname.folder2folder' doesn't exist") >>>>> >>>>> I find out that I can switch to some other branches on https:// >>>>> bitb >>>>> ucke >>>>> t.org/maproom/qmapshack/src >>>>> >>>>> -default >>>>> -V1.x >>>>> -databases >>>>> - ... >>>>> >>>>> >>>>> To be honest I'm not sure if I did everything right. >>>>> >>>>> I only use "default" until now, is this ok ? >>>>> >>>>> How can I check, if I use the actual source, is there something >>>>> like a >>>>> source ident number ? QMS shows the version 1.6.0.pre. now. >>>>> >>>>> Perhaps I can find some further information how to work with >>>>> this >>>>> branch ? >>>>> >>>>> >>>>> >>>>> Kind regards >>>>> >>>>> Axel >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> On Di, 2016-01-05 at 19:25 +0000, qlandkartegt-users- >>>>> >>>>> requ...@lists.sourceforge.net wrote: >>>>>> Send Qlandkartegt-users mailing list submissions to >>>>>> >>>>>> qlandkartegt-users@lists.sourceforge.net >>>>>> >>>>>> To subscribe or unsubscribe via the World Wide Web, visit >>>>>> >>>>>> https://lists.sourceforge.net/lists/listinfo/qlandkarte >>>>>> gt-users >>>>>> >>>>>> or, via email, send a message with subject or body 'help' to >>>>>> >>>>>> qlandkartegt-users-requ...@lists.sourceforge.net >>>>>> >>>>>> You can reach the person managing the list at >>>>>> >>>>>> qlandkartegt-users-ow...@lists.sourceforge.net >>>>>> >>>>>> When replying, please edit your Subject line so it is more >>>>>> specific >>>>>> than "Re: Contents of Qlandkartegt-users digest..." >>>>>> >>>>>> >>>>>> Today's Topics: >>>>>> >>>>>> 1. Using mysql in QMS (AP) >>>>>> 2. Re: Using mysql in QMS (Oliver Eichler) >>>>>> 3. Compiling QMS for Windows (was: QMapShack/Routin >>>>>> o >>>>>> link >>>>>> error >>>>>> (Windows)) (WT) >>>>>> 4. Re: Database change - "mysql.jpg" yEnc (Emanuel Hudl) >>>>>> 5. Re: Database change (Emanuel Hudl) >>>>>> 6. Re: Database change - "qms.jpg" yEnc (Emanuel Hudl) >>>>>> >>>>>> >>>>>> ----------------------------------------------------------- >>>>>> ---- >>>>>> ---- >>>>>> --- >>>>>> >>>>>> Message: 1 >>>>>> Date: Fri, 1 Jan 2016 18:46:09 +0100 >>>>>> From: AP <apschwim...@apmland.de> >>>>>> Subject: [Qlandkartegt-users] Using mysql in QMS >>>>>> To: qlandkartegt-users@lists.sourceforge.net >>>>>> Message-ID: <5686bb61.9040...@apmland.de> >>>>>> Content-Type: text/plain; charset=windows-1252; format=flowed >>>>>> >>>>>> Dear All, >>>>>> >>>>>> >>>>>> meanwhile I compiled QMS 1.5.1 following the tutorial >>>>>> >>>>>> https://bitbucket.org/maproom/qmapshack/src >>>>>> >>>>>> As mentioned before I created a mysql db "myname". >>>>>> >>>>>> I created a db in QMS with the same name by using the menue >>>>>> with >>>>>> mysql >>>>>> instead sqlite. >>>>>> >>>>>> The db appears in QMS menue "data". >>>>>> >>>>>> But if I try to create a folder "Tours" , the folder do not >>>>>> appears >>>>>> in >>>>>> the db in QMS. >>>>>> >>>>>> Using phpmyadmin I can see the db myname and the folder >>>>>> "Tours". >>>>>> >>>>>> What's wrong ? >>>>>> >>>>>> Kind regards >>>>>> >>>>>> Axel >>>>>> >>>>>> >>>>>> >>>>>> ------------------------------ Message: 3 Date: Thu, 31 Dec >>>>>> 2015 >>>>>> 16:56:20 +0100 From: AP <apschwim...@apmland.de> Subject: >>>>>> Re: >>>>>> [Qlandkartegt-users] Qlandkartegt-users Digest, Vol 84, Issue >>>>>> 8 >>>>>> To: >>>>>> qlandkartegt-users@lists.sourceforge.net Message-ID: >>>>>> <56855024.2050...@apmland.de> Content-Type: text/plain; >>>>>> charset=windows-1252; format=flowed Hallo Oliver, I'm not >>>>>> very >>>>>> fimilar >>>>>> with mysql but would be glad to help a little bit. I created >>>>>> a db >>>>>> with >>>>>> the name "myname" and can access it as a user. But I don't >>>>>> know >>>>>> how >>>>>> to >>>>>> deal with it from QMS side. How can I use a mysql-db in QMS >>>>>> 5.5.1 >>>>>> in >>>>>> Arch Linux ? Kind regards Axel Am 22.12.2015 um 15:09 schrieb >>>>>> Oliver >>>>>> >>>>>> Eichler: >>>>>>>>> hi, >>>>>>>>> >>>>>>>>> there has been another change in the database that >>>>>>>>> needs >>>>>>>>> migration of >>>>>>>>> the database. Please backup your database and report >>>>>>>>> errors. >>>>>>>>> >>>>>>>>> As you might have noticed QMapShack is supporting MySql >>>>>>>>> now. To >>>>>>>>> use >>>>>>>>> MySql you need a database server and a user login to >>>>>>>>> that >>>>>>>>> server. On the >>>>>>>>> database sever you have to create a database by: >>>>>>>>> >>>>>>>>> create database myname; >>>>>>>>> >>>>>>>>> This will create the database with name "myname". In >>>>>>>>> QMapShack's >>>>>>>>> database setup dialog you have to use that name. >>>>>>>>> >>>>>>>>> The challenge with using a MySql server is having >>>>>>>>> multiple >>>>>>>>> instances of >>>>>>>>> QMapShack using the same database. This will create >>>>>>>>> conflicts >>>>>>>>> when >>>>>>>>> inserting/updating items from different instances. I >>>>>>>>> spent >>>>>>>>> quite some >>>>>>>>> efforts to catch all these conflicts. But you never >>>>>>>>> know. >>>>>>>>> Thus >>>>>>>>> if you >>>>>>>>> experience some peculiar behaviour please report. >>>>>>>>> >>>>>>>>> >>>>>>>>> The next step will be a mechanism to >>>>>>>>> manually/automatically >>>>>>>>> update the >>>>>>>>> database tree and the workspace. >>>>>>>>> >>>>>>>>> >>>>>>>>> It would be nice if enough users test and challenge >>>>>>>>> that >>>>>>>>> feature before >>>>>>>>> the next release. >>>>>>>>> >>>>>>>>> Oliver >>>>>>>>> >>>>>>>>> ----------------------------------------------------- >>>>>>>>> ---- >>>>>>>>> ---- >>>>>>>>> ----------------- >>>>>>>>> _______________________________________________ >>>>>>>>> Qlandkartegt-users mailing list >>>>>>>>> Qlandkartegt-users@lists.sourceforge.net >>>>>>>>> https://lists.sourceforge.net/lists/listinfo/qlandkarte >>>>>>>>> gt-u >>>>>>>>> sers >>>>>> ------------------------------ >>>>>> >>>>>> Message: 2 >>>>>> Date: Fri, 01 Jan 2016 19:12:45 +0100 >>>>>> From: Oliver Eichler <oliver.eich...@gmx.de> >>>>>> Subject: Re: [Qlandkartegt-users] Using mysql in QMS >>>>>> To: qlandkartegt-users@lists.sourceforge.net >>>>>> Message-ID: <16701937.S9x7W6culu@linux-12kj> >>>>>> Content-Type: text/plain; charset="us-ascii" >>>>>> >>>>>> That was fast. You found a bug. Please test with latest >>>>>> version >>>>>> in >>>>>> the >>>>>> repository. >>>>>> >>>>>> >>>>>> Thanks >>>>>> >>>>>> Oliver >>>>>> >>>>>> Am Friday 01 January 2016, 18:46:09 schrieb AP: >>>>>>> Dear All, >>>>>>> >>>>>>> >>>>>>> meanwhile I compiled QMS 1.5.1 following the tutorial >>>>>>> >>>>>>> https://bitbucket.org/maproom/qmapshack/src >>>>>>> >>>>>>> As mentioned before I created a mysql db "myname". >>>>>>> >>>>>>> I created a db in QMS with the same name by using the menue >>>>>>> with >>>>>>> mysql >>>>>>> instead sqlite. >>>>>>> >>>>>>> The db appears in QMS menue "data". >>>>>>> >>>>>>> But if I try to create a folder "Tours" , the folder do not >>>>>>> appears >>>>>>> in >>>>>>> the db in QMS. >>>>>>> >>>>>>> Using phpmyadmin I can see the db myname and the folder >>>>>>> "Tours". >>>>>>> >>>>>>> What's wrong ? >>>>>>> >>>>>>> Kind regards >>>>>>> >>>>>>> Axel >>>>>>> >>>>>>> >>>>>>> >>>>>>> ------------------------------ Message: 3 Date: Thu, 31 Dec >>>>>>> 2015 >>>>>>> 16:56:20 +0100 From: AP <apschwim...@apmland.de> Subject: >>>>>>> Re: >>>>>>> [Qlandkartegt-users] Qlandkartegt-users Digest, Vol 84, >>>>>>> Issue 8 >>>>>>> To: >>>>>>> qlandkartegt-users@lists.sourceforge.net Message-ID: >>>>>>> <56855024.2050...@apmland.de> Content-Type: text/plain; >>>>>>> charset=windows-1252; format=flowed Hallo Oliver, I'm not >>>>>>> very >>>>>>> fimilar >>>>>>> with mysql but would be glad to help a little bit. I >>>>>>> created a >>>>>>> db >>>>>>> with >>>>>>> the name "myname" and can access it as a user. But I don't >>>>>>> know >>>>>>> how >>>>>>> to >>>>>>> deal with it from QMS side. How can I use a mysql-db in QMS >>>>>>> 5.5.1 >>>>>>> in >>>>>>> Arch Linux ? Kind regards Axel Am 22.12.2015 um 15:09 >>>>>>> schrieb >>>>>>> Oliver >>>>>>> >>>>>>> Eichler: >>>>>>>>>> hi, >>>>>>>>>> >>>>>>>>>> there has been another change in the database that >>>>>>>>>> needs >>>>>>>>>> migration of >>>>>>>>>> the database. Please backup your database and report >>>>>>>>>> errors. >>>>>>>>>> >>>>>>>>>> As you might have noticed QMapShack is supporting >>>>>>>>>> MySql >>>>>>>>>> now. >>>>>>>>>> To use >>>>>>>>>> MySql you need a database server and a user login to >>>>>>>>>> that >>>>>>>>>> server. On the >>>>>>>>>> database sever you have to create a database by: >>>>>>>>>> >>>>>>>>>> create database myname; >>>>>>>>>> >>>>>>>>>> This will create the database with name "myname". In >>>>>>>>>> QMapShack's >>>>>>>>>> database setup dialog you have to use that name. >>>>>>>>>> >>>>>>>>>> The challenge with using a MySql server is having >>>>>>>>>> multiple >>>>>>>>>> instances of >>>>>>>>>> QMapShack using the same database. This will create >>>>>>>>>> conflicts >>>>>>>>>> when >>>>>>>>>> inserting/updating items from different instances. I >>>>>>>>>> spent >>>>>>>>>> quite some >>>>>>>>>> efforts to catch all these conflicts. But you never >>>>>>>>>> know. >>>>>>>>>> Thus if you >>>>>>>>>> experience some peculiar behaviour please report. >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> The next step will be a mechanism to >>>>>>>>>> manually/automatically >>>>>>>>>> update the >>>>>>>>>> database tree and the workspace. >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> It would be nice if enough users test and challenge >>>>>>>>>> that >>>>>>>>>> feature before >>>>>>>>>> the next release. >>>>>>>>>> >>>>>>>>>> Oliver >>>>>>>>>> >>>>>>>>>> --------------------------------------------------- >>>>>>>>>> ---- >>>>>>>>>> ---- >>>>>>>>>> ------------- >>>>>>>>>> ------ >>>>>>>>>> _______________________________________________ >>>>>>>>>> Qlandkartegt-users mailing list >>>>>>>>>> Qlandkartegt-users@lists.sourceforge.net >>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/qlandkar >>>>>>>>>> tegt >>>>>>>>>> -use >>>>>>>>>> rs >>>>>>> --------------------------------------------------------- >>>>>>> ---- >>>>>>> ---- >>>>>>> ----------- >>>>>>> -- _______________________________________________ >>>>>>> Qlandkartegt-users mailing list >>>>>>> Qlandkartegt-users@lists.sourceforge.net >>>>>>> https://lists.sourceforge.net/lists/listinfo/qlandkartegt-u >>>>>>> sers >>>>>> ------------------------------ >>>>>> >>>>>> Message: 3 >>>>>> Date: Sat, 2 Jan 2016 13:14:23 +0000 (UTC) >>>>>> From: WT <k-w.thaem...@vodafone.de> >>>>>> >>>>>> Subject: [Qlandkartegt-users] Compiling QMS for Windows (was: >>>>>> QMapShack/Routino link error (Windows)) >>>>>> >>>>>> To: qlandkartegt-users@lists.sourceforge.net >>>>>> Message-ID: <loom.20160102t135949-...@post.gmane.org> >>>>>> Content-Type: text/plain; charset=us-ascii >>>>>> >>>>>> The linker error problem was solved and all questions >>>>>> concerning >>>>>> this >>>>>> error >>>>>> found an answer with Helmut's help (thank you again!). I >>>>>> finally >>>>>> compiled >>>>>> the Windows version of QMapShack from source on a 64-bit >>>>>> machine >>>>>> with >>>>>> Windows 7 Professional, SP 1. I tested this QMS with some of >>>>>> my >>>>>> typical >>>>>> actions - everything looks good. >>>>>> >>>>>> Here are some remarks and comments about the used procedure >>>>>> and >>>>>> its >>>>>> possible >>>>>> bottlenecks: >>>>>> >>>>>> - In some steps BAT-files have to be executed. I did this in >>>>>> a >>>>>> normal >>>>>> command line window started from cmd.exe. >>>>>> >>>>>> - Be sure to have the correct 64-bit development packages >>>>>> installed >>>>>> as >>>>>> indicated in Helmut's description. >>>>>> >>>>>> - QMS for windows is now supported as 64-bit program. Thus in >>>>>> all >>>>>> steps >>>>>> described in Helmut's document be sure to have the proper 64- >>>>>> bit >>>>>> development >>>>>> environment selected. The compiler packages normally support >>>>>> 32- >>>>>> as >>>>>> well as >>>>>> 64-bit projects on 32- and 64-bit machines! Check this in the >>>>>> cmake- >>>>>> gui with >>>>>> "Grouped" and "Advanced" both checked and in Visual studio >>>>>> properties >>>>>> and >>>>>> solution platform and look for 32- or 64-bit entries. >>>>>> >>>>>> - On my machine MinGW (without 64!) was already installed >>>>>> before >>>>>> trying to >>>>>> compile QMS. Comments on the MinGW homepage are ambiguous in >>>>>> what >>>>>> concerns >>>>>> the possibility of using it for 64-bit compilations too. This >>>>>> was >>>>>> my >>>>>> failure >>>>>> and the reason for the linker error! After switching to >>>>>> MinGW64 >>>>>> as >>>>>> proposed >>>>>> all the compilation steps could be carried out without >>>>>> problems. >>>>>> >>>>>> - During the compilation of almost any package compiler >>>>>> warnings >>>>>> appear. I >>>>>> simply ignored these warnings (under which circumstances is >>>>>> it >>>>>> recommended >>>>>> to pay attention to these warnings?). >>>>>> >>>>>> - There might be some trouble when using '"' to deliminate >>>>>> required >>>>>> path >>>>>> settings in configuration scripts. Don't use this >>>>>> deliminator. >>>>>> Use >>>>>> only >>>>>> directory names without spaces (and propably non-ASCII >>>>>> characters). >>>>>> >>>>>> - Visual studio creates some irritating program menu entries. >>>>>> Use >>>>>> "Visual >>>>>> studio 2013" and not "Microsoft Visual studio ..."! >>>>>> >>>>>> - cmake-gui: call help to find what to do as first steps. >>>>>> Don't >>>>>> forget to >>>>>> select correct development environment (lower part of the >>>>>> window) >>>>>> and >>>>>> set >>>>>> correct paths in upper 2 edit fields. >>>>>> >>>>>> - Select the proper build type ("Release") in cmake-gui >>>>>> and/or >>>>>> Visual >>>>>> studio. >>>>>> >>>>>> - QMS\nsi\copyfiles.bat: >>>>>> - copy %QMSI_QT_PATH%\bin\icudt53.dll and similar commands >>>>>> had >>>>>> to >>>>>> be >>>>>> replaced with copy %QMSI_QT_PATH%\bin\icudt54.dll (use of >>>>>> Qt5.5 - >>>>>> in >>>>>> my 5.5 >>>>>> installation there are no *53.dll files!) >>>>>> >>>>>> - I used Visual Studio Community 2013 - the installation >>>>>> procedure >>>>>> downloads >>>>>> more than 2 GB! >>>>>> >>>>>> - msys/MinGW64: >>>>>> - Install msys before installing MinGW64 >>>>>> - Installation of MinGW64 with win-builds-1.5.0: >>>>>> - after some automatic steps running in a cmd-window the >>>>>> "Win- >>>>>> builds >>>>>> installation" windows appears >>>>>> - choose "Cygwin or MSYS" >>>>>> - choose x86_64 >>>>>> - enter c:\msys as MSYS installation directory (if >>>>>> appropriate) >>>>>> - press Ok >>>>>> - in the next window click "Process" (upper right >>>>>> corner - >>>>>> difficult >>>>>> to identify!) - only now the necessary software will be >>>>>> downloaded >>>>>> and >>>>>> installed within the msys directory >>>>>> - close window at the end of the installation process >>>>>> (100% >>>>>> reached, >>>>>> click on x in upper right corner of window) >>>>>> - the \msys\opt directory is created by this installer. >>>>>> It >>>>>> contains >>>>>> MinGW64 >>>>>> >>>>>> - make.exe: use msys\bin\make.exe. In my case it was not in >>>>>> the >>>>>> PATH. >>>>>> I >>>>>> therefore modified the following nsi\build_routino.bat part >>>>>> >>>>>> rem add mingw64 toolchain to PATH >>>>>> set >>>>>> PATH=c:\msys\bin\;c:\msys\opt\windows_64\bin\;%PATH% >>>>>> rem set PATH=C:\msys\opt\windows_64\bin;%PATH% >>>>>> >>>>>> Regards >>>>>> >>>>>> Wolfgang >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> ------------------------------ >>>>>> >>>>>> Message: 4 >>>>>> Date: Tue, 5 Jan 2016 19:23:56 +0000 (UTC) >>>>>> From: Emanuel Hudl <emie1...@gmail.com> >>>>>> Subject: Re: [Qlandkartegt-users] Database change - >>>>>> "mysql.jpg" yEnc >>>>>> To: qlandkartegt-users@lists.sourceforge.net >>>>>> Message-ID: <n6h58c$eld$2...@ger.gmane.org> >>>>>> Content-Type: text/plain; charset=UTF-8 >>>>>> >>>>>> =ybegin part=1 line=128 size=292343 name=mysql.jpg >>>>>> =ypart begin=0 end=5 >>>>>> ))=J* >>>>>> =yend size=5 part=1 pcrc32=0f4066e6 >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> ------------------------------ >>>>>> >>>>>> Message: 5 >>>>>> Date: Tue, 5 Jan 2016 19:23:56 +0000 (UTC) >>>>>> From: Emanuel Hudl <emie1...@gmail.com> >>>>>> Subject: Re: [Qlandkartegt-users] Database change >>>>>> To: qlandkartegt-users@lists.sourceforge.net >>>>>> Message-ID: <pan$4479d$2a84d1c8$3d1dabcb$14c91008$1...@gmail.com >>>>>> Content-Type: text/plain; charset=UTF-8 >>>>>> >>>>>> hello oliver, >>>>>> >>>>>> i need your help. as my provider offers only one mysql >>>>>> database >>>>>> (yes >>>>>> i >>>>>> know that's poor) i want to test it on localhost. So seeting >>>>>> up >>>>>> the >>>>>> enviroment (apache2, php5 and mysql 5.5.46) is no problem (i >>>>>> tested >>>>>> with >>>>>> a local wordpress installation). >>>>>> >>>>>> My steps: >>>>>> Create database via phpmyadmin called "Touren" >>>>>> Creating a mysql Database named Touren >>>>>> when i try to add a folder, nothing happens, but when i look >>>>>> into >>>>>> the >>>>>> mysql database, there is written: >>>>>> >>>>>> Diese Tabelle enth?lt keine eindeutige ("unique") Spalte. >>>>>> Gitter- >>>>>> Bearbeitungsfunktion, Kontrollk?stchen, Bearbeiten, Kopieren >>>>>> und >>>>>> L?schen >>>>>> von Links sind nicht verf?gbar. >>>>>> >>>>>> SELECT * >>>>>> FROM `versioninfo` >>>>>> LIMIT 0 , 30 >>>>>> >>>>>> Version type >>>>>> 4 QMapShack >>>>>> >>>>>> Any hints? I read the post above "using mysql in QMS", put i >>>>>> stuck. >>>>>> I >>>>>> compiled lastet version, 1.6.0pre >>>>>> >>>>>> I added some screenshots and the localhost.sql >>>>>> Thanks! >>>>>> >>>>>> Am Tue, 22 Dec 2015 15:09:53 +0100 schrieb Oliver Eichler: >>>>>>> hi, >>>>>>> >>>>>>> there has been another change in the database that needs >>>>>>> migration >>>>>>> of >>>>>>> the database. Please backup your database and report >>>>>>> errors. >>>>>>> >>>>>>> As you might have noticed QMapShack is supporting MySql >>>>>>> now. To >>>>>>> use >>>>>>> MySql you need a database server and a user login to that >>>>>>> server. >>>>>>> On the >>>>>>> database sever you have to create a database by: >>>>>>> >>>>>>> create database myname; >>>>>>> >>>>>>> This will create the database with name "myname". In >>>>>>> QMapShack's >>>>>>> database setup dialog you have to use that name. >>>>>>> >>>>>>> The challenge with using a MySql server is having multiple >>>>>>> instances of >>>>>>> QMapShack using the same database. This will create >>>>>>> conflicts >>>>>>> when >>>>>>> inserting/updating items from different instances. I spent >>>>>>> quite >>>>>>> some >>>>>>> efforts to catch all these conflicts. But you never know. >>>>>>> Thus >>>>>>> if >>>>>>> you >>>>>>> experience some peculiar behaviour please report. >>>>>>> >>>>>>> >>>>>>> The next step will be a mechanism to manually/automatically >>>>>>> update >>>>>>> the >>>>>>> database tree and the workspace. >>>>>>> >>>>>>> >>>>>>> It would be nice if enough users test and challenge that >>>>>>> feature >>>>>>> before >>>>>>> the next release. >>>>>>> >>>>>>> Oliver >>>>>> ----------------------------------------------------------- >>>>>> ---- >>>>>> ---- >>>>>> ----------- >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> ------------------------------ >>>>>> >>>>>> Message: 6 >>>>>> Date: Tue, 5 Jan 2016 19:23:56 +0000 (UTC) >>>>>> From: Emanuel Hudl <emie1...@gmail.com> >>>>>> Subject: Re: [Qlandkartegt-users] Database change - >>>>>> "qms.jpg" yEnc >>>>>> To: qlandkartegt-users@lists.sourceforge.net >>>>>> Message-ID: <n6h58c$ngc$1...@ger.gmane.org> >>>>>> Content-Type: text/plain; charset=UTF-8 >>>>>> >>>>>> =ybegin part=1 line=128 size=19259 name=qms.jpg >>>>>> =ypart begin=0 end=5 >>>>>> ))=J* >>>>>> =yend size=5 part=1 pcrc32=0f4066e6 >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> ------------------------------ >>>>>> >>>>>> ----------------------------------------------------------- >>>>>> ---- >>>>>> ---- >>>>>> ----------- >>>>>> >>>>>> >>>>>> ------------------------------ >>>>>> >>>>>> _______________________________________________ >>>>>> Qlandkartegt-users mailing list >>>>>> Qlandkartegt-users@lists.sourceforge.net >>>>>> https://lists.sourceforge.net/lists/listinfo/qlandkartegt-use >>>>>> rs >>>>>> >>>>>> >>>>>> End of Qlandkartegt-users Digest, Vol 85, Issue 3 >>>>>> ************************************************* >>>>> ------------------------------------------------------------- >>>>> ---- >>>>> ----------- >>>>> -- _______________________________________________ >>>>> Qlandkartegt-users mailing list >>>>> Qlandkartegt-users@lists.sourceforge.net >>>>> https://lists.sourceforge.net/lists/listinfo/qlandkartegt-users >>>> ------------------------------ >>>> >>>> --------------------------------------------------------------- >>>> ---- >>>> ----------- >>>> >>>> >>>> ------------------------------ >>>> >>>> _______________________________________________ >>>> Qlandkartegt-users mailing list >>>> Qlandkartegt-users@lists.sourceforge.net >>>> https://lists.sourceforge.net/lists/listinfo/qlandkartegt-users >>>> >>>> >>>> End of Qlandkartegt-users Digest, Vol 85, Issue 5 >>>> ************************************************* >>> ----------------------------------------------------------------- >>> ----------- >>> -- _______________________________________________ >>> Qlandkartegt-users mailing list >>> Qlandkartegt-users@lists.sourceforge.net >>> https://lists.sourceforge.net/lists/listinfo/qlandkartegt-users >> >> >> >> ------------------------------ >> >> ------------------------------------------------------------------- >> ----------- >> >> >> ------------------------------ >> >> _______________________________________________ >> Qlandkartegt-users mailing list >> Qlandkartegt-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/qlandkartegt-users >> >> >> End of Qlandkartegt-users Digest, Vol 85, Issue 7 >> ************************************************* > ------------------------------------------------------------------------------ > _______________________________________________ > Qlandkartegt-users mailing list > Qlandkartegt-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/qlandkartegt-users ------------------------------------------------------------------------------ _______________________________________________ Qlandkartegt-users mailing list Qlandkartegt-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/qlandkartegt-users
