D707 world map is updating for long time

Hi,

I have upgraded my sites to 7.0.7 and had on one site no world map installed. Now by using the new zip module I had to install it. I got 1000 something members and its updating the profiles since over 2 hours. Isn't this a bit too long?

I'm not sure for how long I will let run before shuting it down :-)

it is still running :-)

LoL sorry :-) profile update has just been completed :-)

Take your time but best is to installed on every new Dolphin installation :-)

cities update gives me a database juery error.

I do a reinstall

same thing Database query error after reinstall

Hi Diddy! ;-)

Hmm i havent got a database error. It works fine. 

Let us know what for database juery error your got.
The first 20 lines are important... you dont must post the full code.

Best regards! ;-)

Please provide the exact DB error, usually it is send to bug report email of your site.

Also locations update script process one profile in 6 seconds (there is a limit to not abuse google servers), so for 2000 profiles it can take approx 2000 * 6 = 6000 sec = 100 min 

sorry, here we go:

Query:

SELECT `m`.`country`, `m`.`lat`, `m`.`lng`, COUNT(`p`.`ID`) AS `num`
            FROM `bx_map_countries` AS `m`
            INNER JOIN `Profiles` AS `p` ON (`p`.`Country` = `m`.`country` AND `p`.`Status` = 'Active')
            INNER JOIN `bx_map_profiles` AS `pm` ON (`pm`.`id` = `p`.`ID` AND `pm`.`failed` = 0 AND `pm`.`allow_view_location_to` = '3')
            WHERE `m`.`failed` = 0  AND `m`.`lat` < 79.9359182463 AND `m`.`lat` > -35.4606699515  AND `m`.`lng` < 180 AND `m`.`lng` > -180 
            GROUP BY `p`.`Country`
            LIMIT 250

Mysql error: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='

Found error in the file '/xxxx/xzxxxxx/public_html/modules/boonex/map_profiles/classes/BxMapDb.php' at line 126.
Called 'getAll' function with erroneous argument #0.

 phpmyadmin
bx_map_ countries
operations and change the collations..

It is set to utf8_general_ci

I just did a new install and try again

or should I set it to utf8_unicode_ci?

one will work so if one doesn't try the other one

cool thank you, I will try once my profile has been updated :-)

I had to change the collations at bx_map_cities & bx_map_countries to utf8_unicode_ci and now I hope it will work well :-)  

I will let you know in a little while

everything is is well now with the map :-)

Thanks :-)