Hello,
i followed your instructions:
mysql> create database Touren;
Query OK, 1 row affected (0.01 sec)
mysql>
Then i add the DB, console says this:
2016-01-06 9:38:00.381 [warning] Execution of SQL-Statement ` "SELECT
t1.child, t2.type FROM folder2folder AS t1, folders AS t2 WHERE t1.parent
= :id AND t2.id = t1.child ORDER BY t2.id" ` failed:
2016-01-06 9:38:00.381 [warning] QSqlError("1146", "QMYSQL: Die Abfrage
konnte nicht ausgeführt werden", "Table 'Touren.folder2folder' doesn't
exist")
2016-01-06 9:38:00.381 [warning] Execution of SQL-Statement ` "SELECT id
FROM items AS t1 WHERE NOT EXISTS(SELECT * FROM folder2item WHERE
child=t1.id) ORDER BY t1.type, t1.name" ` failed:
2016-01-06 9:38:00.381 [warning] QSqlError("1146", "QMYSQL: Die Abfrage
konnte nicht ausgeführt werden", "Table 'Touren.items' doesn't exist")
Emi
Am Tue, 05 Jan 2016 22:23:42 +0100 schrieb Oliver Eichler:
> 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
>> 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
