25 reputation
3
bio website
location
age
visits member for 2 years
seen Aug 27 at 16:09

Dec
28
awarded  Supporter
Dec
28
accepted QGIS crashes when adding vector layer from mysql or testing connection to mysql
Dec
28
comment QGIS crashes when adding vector layer from mysql or testing connection to mysql
thanks a lot, great input. Will try it out!
Dec
25
comment QGIS crashes when adding vector layer from mysql or testing connection to mysql
O.k.: I deleted the three problematic tables and left the one with the shorter names. This seems to work. I really don't know what is happening and feeling bad about this project, afraid that it can break any moment. But right now it seems to work. Thanks for helping and I would still be very glad to know the reasons behind this behaviour
Dec
25
comment QGIS crashes when adding vector layer from mysql or testing connection to mysql
More information: When I leave the three tables in the database but delete all data from them I can connect to the database. But when trying to open one of these tables QGIS crashes
Dec
25
comment QGIS crashes when adding vector layer from mysql or testing connection to mysql
Hi. I finally got to working on it again. No table has multiple geometry columns anymore. I have two tables having one a point and the other a polygon column. They dont seem to create a problem. I have three other tables: One with a point column, one with a line column and one with a polygon column. I use them to create either points, lines or polygons for a certain table. I have isolated the problem so far: If these three tables are in the database QGIS crashes when connecting. When I remove them, QGIS works. I am very baffled as I can tell absolutely no problem in these tables
Dec
21
asked QGIS crashes when adding vector layer from mysql or testing connection to mysql
Dec
21
awarded  Scholar
Dec
21
accepted Why can't I edit polygons once they have been saved to MySQL?
Dec
21
comment Why can't I edit polygons once they have been saved to MySQL?
I created the tables in on my Webserver on mySql, then added them as vectorlayer. What I have learned: the table needs a Primary Key and Auto Incrementing. AND: It only works with one (the first) geometry field - more are ignored and when I present them with a view editing does not work.
Dec
21
awarded  Student
Dec
21
comment Why can't I edit polygons once they have been saved to MySQL?
That was it! It was Primary Key but not Auto Incrementing. I had no idea this was required. Thanks a whole lot, elrobis! How can I mark your answer as the accepted?
Dec
20
asked Why can't I edit polygons once they have been saved to MySQL?