Hello,
After upgrading to Dolphin 7.1, I could not get the World Maps module installed. It gave me this error:
-- -- There are errors in the following MySQL queries:
-- -- Error:
INSERT INTO `sys_menu_top` (`Parent`, `Name`, `Caption`, `Link`, `Order`, `Visible`, `Target`, `Onclick`, `Check`, `Editable`, `Deletable`, `Active`, `Type`, `Picture`, `Icon`, `BQuickLink`, `Statistics`) VALUES(138, 'World Map', '_bx_wmap_search_submenu', 'modules/?r=wmap/home', @iCatOrder, 'non,memb', '', '', '', 1, 1, 1, 'custom', '', '', 0, '');
After researching it, I commented out the above line where it inserts into the top menu, and it installed.
However, even after entering a Google Map API key, when I try to update locations (because the maps do not display) I get the following error -- this I have no idea how to fix. PLEASE HELP! :)
Database error in The Black Vault
Query:
SELECT 'events_sponsor' AS `part`, `p`.`id` AS `id`, `p`.`country` AS `country`, `p`.`city` AS `city`, `p`.`title` AS `title`, `p`.`uri` AS `uri` , `p`.`zip` AS `zip` , `p`.`address1` AS `address` , `p`.`state` AS `state` , `p`.`allow_view_to` AS `privacy` FROM `bx_events_sponsor_main` AS `p` LEFT JOIN `bx_wmap_locations` AS `m` ON (`m`.`id` = `p`.`id` AND `m`.`part` = 'events_sponsor') WHERE ISNULL(`m`.`id`) AND `p`.`status` = 'approved' LIMIT 4
Mysql error: Unknown column 'p.country' in 'field list'
Found error in the file '/home/theblack/public_html/modules/boonex/world_map/classes/BxWmapDb.php' at line 74.
Called 'getAll' function with erroneous argument #0.
