Hi Axel,

no, you need access to the server. Either via network, or you install
the server on your laptop and access it as localhost.

In the meantime I wrote a few lines in the Wiki. Including a short
discussion of the pro and cons using the one or the other database:

"You can choose between a SQLite database or a MySQL database. For a
single user or an installation on a laptop with no permanent access to a
network, SQLite is the better choice. If you want multiple users to
access the data via network, MySQL is the option to go."

https://bitbucket.org/maproom/qmapshack/wiki/DocGisDatabaseAddRemove

Oliver


Am 08.01.2016 um 17:07 schrieb apschwimmer:
> Hello,
>
>
> as mentioned before I created a mysql Database. It's usable with
> serveral clients now.
>
> It seems that I can use this database only if the server is online. 
> Is there a way to use the db offline ?
>
>
> Kind regards
>
> Axel
>
>
>
>
> On Do, 2016-01-07 at 09:07 +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: Solved: QMS with SQL Database (Oliver Eichler)
>>
>>
>> -------------------------------------------------------------------
>> ---
>>
>> Message: 1
>> Date: Thu, 7 Jan 2016 10:07:31 +0100
>> From: Oliver Eichler <oliver.eich...@gmx.de>
>> Subject: Re: [Qlandkartegt-users] Solved: QMS with SQL Database
>> To: qlandkartegt-users@lists.sourceforge.net
>> Message-ID: <568e2ad3.9000...@gmx.de>
>> Content-Type: text/plain; charset=utf-8
>>
>> 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/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. 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/Ro
>>>>>>>> utin
>>>>>>>> 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/qlandk
>>>>>>>>>>> arte
>>>>>>>>>>> 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/qlan
>>>>>>>>>>>> dkar
>>>>>>>>>>>> tegt
>>>>>>>>>>>> -use
>>>>>>>>>>>> rs
>>>>>>>>> -----------------------------------------------------
>>>>>>>>> ----
>>>>>>>>> ----
>>>>>>>>> ----
>>>>>>>>> -----------
>>>>>>>>> -- _______________________________________________
>>>>>>>>> Qlandkartegt-users mailing list
>>>>>>>>> Qlandkartegt-users@lists.sourceforge.net
>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/qlandkarte
>>>>>>>>> gt-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-u
>>>>>>> sers
>>>>>> ------------------------------
>>>>>>
>>>>>> 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/Ro
>>>>>>>> utin
>>>>>>>> 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/qlandk
>>>>>>>>>>> arte
>>>>>>>>>>> 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/qlan
>>>>>>>>>>>> dkar
>>>>>>>>>>>> tegt
>>>>>>>>>>>> -use
>>>>>>>>>>>> rs
>>>>>>>>> -----------------------------------------------------
>>>>>>>>> ----
>>>>>>>>> ----
>>>>>>>>> ----
>>>>>>>>> -----------
>>>>>>>>> -- _______________________________________________
>>>>>>>>> Qlandkartegt-users mailing list
>>>>>>>>> Qlandkartegt-users@lists.sourceforge.net
>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/qlandkarte
>>>>>>>>> gt-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-u
>>>>>>> sers
>>>>>> ------------------------------
>>>>>>
>>>>>> -----------------------------------------------------------
>>>>>> ----
>>>>>> ----
>>>>>> -----------
>>>>>>
>>>>>>
>>>>>> ------------------------------
>>>>>>
>>>>>> _______________________________________________
>>>>>> 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 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
>>
>>
>> End of Qlandkartegt-users Digest, Vol 85, Issue 9
>> *************************************************
> ------------------------------------------------------------------------------
> _______________________________________________
> 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

Reply via email to