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/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. Using mysql in QMS (AP)
> > > > 2. Re: Using mysql in QMS (Oliver Eichler)
> > > > 3. Compiling QMS for Windows (was: QMapShack/Routino
> > > > 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/qlandkartegt-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/qlandkartegt
> > > > > > > > -use
> > > > > > > > rs
> > > > >
> > > > > -------------------------------------------------------------
> > > > > ----
> > > > > -----------
> > > > > -- _______________________________________________
> > > > > Qlandkartegt-users mailing list
> > > > > Qlandkartegt-users@lists.sourceforge.net
> > > > > https://lists.sourceforge.net/lists/listinfo/qlandkartegt-users
> > > >
> > > > ------------------------------
> > > >
> > > > 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-users
> > > >
> > > >
> > > > 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/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. Using mysql in QMS (AP)
> > > > 2. Re: Using mysql in QMS (Oliver Eichler)
> > > > 3. Compiling QMS for Windows (was: QMapShack/Routino
> > > > 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/qlandkartegt-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/qlandkartegt
> > > > > > > > -use
> > > > > > > > rs
> > > > >
> > > > > -------------------------------------------------------------
> > > > > ----
> > > > > -----------
> > > > > -- _______________________________________________
> > > > > Qlandkartegt-users mailing list
> > > > > Qlandkartegt-users@lists.sourceforge.net
> > > > > https://lists.sourceforge.net/lists/listinfo/qlandkartegt-users
> > > >
> > > > ------------------------------
> > > >
> > > > 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-users
> > > >
> > > >
> > > > 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
