Hey Michael,
I'm sorry about that! It seems that the sql query that creates the KML table is wrong. I've fixed this now in the dev. release
compojoom.com/downloads/developer-releas...y-stuff/dev-hotspots
. You can download it and try to see if it works. Or just go ahead -> delete the kml table and change its structure to this:
CREATE TABLE IF NOT EXISTS `#__hotspots_kmls` (
`hotspots_kml_id` bigint(20) NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL,
`catid` int(11) NOT NULL COMMENT 'FK to #__hotspots_categorie',
`description` text NOT NULL,
`original_filename` varchar(1024) NOT NULL,
`mangled_filename` varchar(1024) NOT NULL,
`mime_type` varchar(255) NOT NULL DEFAULT 'application/octet-stream',
`created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`created_by` bigint(20) NOT NULL DEFAULT '0',
`state` tinyint(4) NOT NULL DEFAULT '1',
PRIMARY KEY (`hotspots_kml_id`)
);
replace #__ with your table prefix.
Kind regards,
Daniel
P.S. The dev release will be able to update your table structure only if you are updating from 3.0 and not from another dev release.
