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://bitbucke
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-
[email protected] wrote:
> Send Qlandkartegt-users mailing list submissions to
> [email protected]
>
> 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
> [email protected]
>
> You can reach the person managing the list at
> [email protected]
>
> 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 <[email protected]>
> Subject: [Qlandkartegt-users] Using mysql in QMS
> To: [email protected]
> Message-ID: <[email protected]>
> 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 <[email protected]> Subject: Re:
> [Qlandkartegt-users] Qlandkartegt-users Digest, Vol 84, Issue 8 To:
> [email protected] Message-ID:
> <[email protected]> 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
> > > > [email protected]
> > > > https://lists.sourceforge.net/lists/listinfo/qlandkartegt-users
> > > >
> > >
> > >
>
>
>
>
> ------------------------------
>
> Message: 2
> Date: Fri, 01 Jan 2016 19:12:45 +0100
> From: Oliver Eichler <[email protected]>
> Subject: Re: [Qlandkartegt-users] Using mysql in QMS
> To: [email protected]
> 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 <[email protected]> Subject: Re:
> > [Qlandkartegt-users] Qlandkartegt-users Digest, Vol 84, Issue 8 To:
> > [email protected] Message-ID:
> > <[email protected]> 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
> > > > > [email protected]
> > > > > https://lists.sourceforge.net/lists/listinfo/qlandkartegt-use
> > > > > rs
> >
> > -----------------------------------------------------------------
> > -----------
> > -- _______________________________________________
> > Qlandkartegt-users mailing list
> > [email protected]
> > https://lists.sourceforge.net/lists/listinfo/qlandkartegt-users
>
>
>
>
> ------------------------------
>
> Message: 3
> Date: Sat, 2 Jan 2016 13:14:23 +0000 (UTC)
> From: WT <[email protected]>
> Subject: [Qlandkartegt-users] Compiling QMS for Windows (was:
> QMapShack/Routino link error (Windows))
> To: [email protected]
> Message-ID: <[email protected]>
> 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 <[email protected]>
> Subject: Re: [Qlandkartegt-users] Database change - "mysql.jpg" yEnc
> To: [email protected]
> Message-ID: <[email protected]>
> 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 <[email protected]>
> Subject: Re: [Qlandkartegt-users] Database change
> To: [email protected]
> Message-ID: <[email protected]>
> 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 <[email protected]>
> Subject: Re: [Qlandkartegt-users] Database change - "qms.jpg" yEnc
> To: [email protected]
> Message-ID: <[email protected]>
> 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
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/qlandkartegt-users
>
>
> End of Qlandkartegt-users Digest, Vol 85, Issue 3
> *************************************************
------------------------------------------------------------------------------
_______________________________________________
Qlandkartegt-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/qlandkartegt-users
