Make sure your user has the correct access rights. You should be able to
create and alter tables. And to read write the database.
If you create the database with:
create database <name>;
you have to use <name> as database name in QMS. QMS will take care of creating
the tables and stuff on it's own. Best to start QMS with
qmapshack -d
as it will print all errors to the debug output.
HTH
Oliver
Am Tuesday 05 January 2016, 19:23:56 schrieb Emanuel Hudl:
> 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
>
> ----------------------------------------------------------------------------
> --
>
>
>
>
> ----------------------------------------------------------------------------
> -- _______________________________________________
> Qlandkartegt-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/qlandkartegt-users
------------------------------------------------------------------------------
_______________________________________________
Qlandkartegt-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/qlandkartegt-users
