Posted by
bugzilla_noreply on
May 25, 2017; 6:52pm
URL: http://digikam.185.s1.nabble.com/digikam-Bug-374302-New-All-Images-with-Geoinfo-seem-to-be-at-0-0-tp4692118p4696551.html
https://bugs.kde.org/show_bug.cgi?id=374302--- Comment #22 from Lukas Winkler <
[hidden email]> ---
I just checked it: I am using MariaDB 10.1.23 on Debian Stretch.
MariaDB [digikamtest]> SELECT * FROM ImagePositions;
+---------+-----------------+--------------------+-----------------+--------------------+----------+-------------+------+------+----------+-------------+
| imageid | latitude | latitudeNumber | longitude |
longitudeNumber | altitude | orientation | tilt | roll | accuracy |
description |
+---------+-----------------+--------------------+-----------------+--------------------+----------+-------------+------+------+----------+-------------+
| 1 | 48,25.23788333N | 48.420631388888886 | 15,37.13064167E |
15.618844027777778 | 249 | NULL | NULL | NULL | NULL | NULL
|
+---------+-----------------+--------------------+-----------------+--------------------+----------+-------------+------+------+----------+-------------+
1 row in set (0.00 sec)
MariaDB [digikamtest]> describe ImagePositions;
+-----------------+----------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+----------+------+-----+---------+-------+
| imageid | int(11) | NO | PRI | NULL | |
| latitude | longtext | YES | | NULL | |
| latitudeNumber | double | YES | | NULL | |
| longitude | longtext | YES | | NULL | |
| longitudeNumber | double | YES | | NULL | |
| altitude | double | YES | | NULL | |
| orientation | double | YES | | NULL | |
| tilt | double | YES | | NULL | |
| roll | double | YES | | NULL | |
| accuracy | double | YES | | NULL | |
| description | longtext | YES | | NULL | |
+-----------------+----------+------+-----+---------+-------+
11 rows in set (0.00 sec)
--
You are receiving this mail because:
You are the assignee for the bug.