World map not installing.

World Map modules tries to add submenu to "Search" main menu.

It looks like "Search" top menu doesn't exist on your site, this is non standard situation, this menu item should be deactivated at least, but not deleted from database.

To force World Map module to install I suggest you to comment out the following lines in /modules/boonex/world_map/install/sql/install.sql file, so it will look like this:

-- top menu
-- SET @iCatOrder := (SELECT MAX(`Order`)+1 FROM `sys_menu_top` WHERE `Parent` = 138 ORDER BY `Order` DESC LIMIT 1);
-- 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, ''); 

Thanks a lot !

yepp had the same problem before, had changed the SQL command to (change @iCatOrder to just 19)

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', 19, 'non,memb', '', '', '', 1, 1, 1, 'custom', '', '', 0, '');

It maybe a little more deeper Alex, I have the search record in my table and I am still getting the error. I don’t want to comment out the line, so I will do some research as to why it is happening. If you have any ideas please let me hear them.

Ok, this is what I have found. Makenoiz found the problem and a fix for it some time back, but it does not explain why it is happening. He changed the order to except NULL values. For some reason @iCatOrder is not passing a small int and that is causing the problem. 

http://www.boonex.com/forums/topic/Unable-to-install-Profiles-Map-module-Error.htm

The really questions are, should order be something other then a small int or is iCatOrder really passing a NULL value?

There is a SQL query above the one that tryes to insert the item. That is what sets the iCatOrder variable.

Try running this query in phpMyAdmin

SELECT MAX(`Order`)+1 FROM `sys_menu_top` WHERE `Parent` = 138 ORDER BY `Order` DESC LIMIT 1

That should return a number.

 Yes, I guess that is the problem. Some reason it is pass the charters not the numeric value. Take a look at the screen shot. 

 Sorry, this is the query not allowing NULL. 

Here is a shot after trying to run the select statement in MySQL. I notice that ID 138, the search record, has an order number of 0. Any change that this is what is causing the problem? Even if it has a value of 0 the number being passed should be 1, but something is happening to it. Not sure what!

 
Not likely. But there is a problem. The query is not looking the the order of the parent which is id 138, it's grabbing the order of the siblings whos parent is 138. And it's running into a problem getting the order there.

Next query try this.

SELECT * FROM `sys_menu_top` WHERE `Parent` = 138 ORDER BY `Order` DESC LIMIT 1

This will list the siblings. What is the order field in those?

Your query shows 0 :( I ran this (SELECT * FROM `sys_menu_top` WHERE `Name` LIKE "%search%") and got 22 hits none of which had 138 as the parent. Now that sounds more like what the problem is. My guess is that I should have some records with 138 as the parent, correct? 

 
Correct. I believe there is suppose to be at least one. But i will have to do a little research to find out what one and what normally puts it in. But yea, i am guessing that's the reason.

Yes it is the problem, i put it in on ID 138 to test it and it ran fine. If you could tell me when you find out about which one that would be great. Thank you for all your help on this issue and I hope this will help others that may have the same problem :) 

Deano,

I just want to say this, there is still a problem with the way the select statement is functioning I would think. Even if there are no records it should be passing (@iCatOrder)+1 = 1 not (@CatOrder)+1 = NULL. I am not sure as I am a newbie to dolphin and I am a little rusty on my SQL statements, but i would say there is a little problem with the logic on the select statement. 

I did a fresh install of version 7.0.9 on another domain and there were 3 records with the parent = 138, (Keyword Search, order 3), (People Search, order 1) and (Search Home, order 0). I am not sure why these values changed, but they did. Anyway, Thanks again for the help.   

Ok, something is going on here! I had an extra world map button in my menu builder so I wanted to make sure everything we nice and clean. I uninstalled world maps again and when I did all 3 search records, “People Search, Keyword Search, and Search Home”, with the parent ID of 138 had the parent ID removed as well as the order causing the reinstall to crash again. This is telling me that the remove script is touching these records for some reason.

 This worked perfectly for me.

My map was also not updating events, etc.  I had the same error as cgiannelli when I attempted to uninstall and install the boonex world map module.  I used AlexT's solution to force install the module which worked.  Cleared cache.

However, now NO events, profiles, etc. are showing up on the world map.  

Any ideas on how I can make the events, profiles, etc. show up on my Boonex World Map?

After World Maps module reinstallation all saved geocoded positions are cleared, to manually geocode all available positions, click on "Update Locations" from World Map admin page.

be prepared to wait if you have a lot of profiles :)