Location Mod

[Gobalopper]

Had you installed this mod before? Or accidently installed it twice maybe? Were there errors on install?

[eriktm]

Unknown column 'p.country' in 'on clause'
File: C:\Program Files\xampp\htdocs\erik\forum\Sources\MemberMap.php
Line: 101

Hwo to fix this??
Anyone willing to help me?

[beemer]

Unknown column 'p.country' in 'on clause'
File: C:\Program Files\xampp\htdocs\erik\forum\Sources\MemberMap.php
Line: 101

Hwo to fix this??
Anyone willing to help me?

Install the additional maps, then set a default map in adminCP

[eriktm]

Done, don`t work, same message...

[skyshroud]

dudes.

I must be a moron. Forum had been working well, used pkg mgr to install mod, site error occurred, removed the 'arcade' mod, which magically allowed users to begin viewing threads again..so, I assume there must be some sort of conflict there, as well. Just to mention it.

Now, here's where the problem comes from. I have NO IDEA what I am doing, what I need to modify, where I need to place the button, how to link to it, etc..... at this point, the package is installed, but has no functionality, since I have done nothing but 'apply mod' from manager.

The instructions in the text file merely give a shout to the creator. No info I could find on what to do after application of the mod. I have searched pretty much all of the 59 pages in this thread, but can find no specifics. Am I correct in that 3 files need to be modified? I have my google ID, and once again, no idea how to add it to the code....lol...or even which code file I need to add it to. I think I need the grand 'ole click here, type this on this line, etc.

Any use in me trying to forge ahead, or should I just uninstall, cause I am not knowledgeable enough to get past this hump?

[Gobalopper]

skyshroud I think you have the wrong thread, this isn't the Google member map.

Erik same question for you, what version of MySQL are you running?

[beemer]

Done, don`t work, same message...

Was this a new install or was it on a forum you upgraded?

I had exactly the same error on a forum I upgraded

I think I deleted all location mods from within package manager and reinstalled, and it fixed it

[eriktm]

Using a totaly clean rc2, installed, not upgraded...

[eriktm]

I think I deleted all location mods from within package manager and reinstalled, and it fixed it

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND )
AND (p.yPin BETWEEN AND )
AND p.ID_MEMBER = mem.ID_MEMBER
ORDER B' at line 4
Fil: C:\Program Files\xampp\htdocs\erik\forum\Sources\MemberMap.php
Linje: 101

[beemer]

I think I deleted all location mods from within package manager and reinstalled, and it fixed it

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND )
AND (p.yPin BETWEEN AND )
AND p.ID_MEMBER = mem.ID_MEMBER
ORDER B' at line 4
Fil: C:\Program Files\xampp\htdocs\erik\forum\Sources\MemberMap.php
Linje: 101

Yep that one sounds familiar too

As I recall something was clashing I didnt have all the options available in pacman to uninstall, apply etc for the 3 location mods and deleting one (sorry cant remember which one) let me apply the mod again.

Are you just using the default theme?
Have you checked to see if pacman applied the updates to the theme files are the maps and flags present in there folders?

[eriktm]

Using default theme, but now I deleted whole forum (just a local test-forum)...

Gonna reinstall...

[skyshroud]

thanks, Global....directed my comment to the proper thread....

see my earlier Moron comment...

lol

[ipoco]

um - okay - not sure if this is the right place to post this but I think it is.

I'm using smf 1.0.6, and TP.  I had some problems getting the location mod to work in TP but seem to have resolved them.  I did install and uninstall Location Mod several times which seemed to add multiple requests to several files like load.php

like the below example:

$select_columns = "
         IFNULL(lo.logTime, 0) AS isOnline, IFNULL(a.ID_ATTACH, 0) AS ID_ATTACH, a.filename, mem.signature,
         mem.personalText, mem.location, mem.gender, mem.avatar, mem.ID [nofollow]_MEMBER, mem.memberName, mem.realName,
         mem.emailAddress, mem.hideEmail, mem.dateRegistered, mem.websiteTitle, mem.websiteUrl, mem.birthdate,
         mem.memberIP, mem.location, mem.ICQ, mem.AIM, mem.YIM, mem.MSN, mem.posts, mem.lastLogin, mem.karmaGood,
         mem.ID [nofollow]_POST_GROUP, mem.karmaBad, mem.lngfile, mem.ID [nofollow]_GROUP, mem.timeOffset, mem.showOnline, pin.country [nofollow], c.name [nofollow], pin.country [nofollow], c.name [nofollow], pin.country [nofollow], c.name [nofollow], pin.country [nofollow], c.name [nofollow], pin.country [nofollow], c.name [nofollow],
         mg.onlineColor AS member_group_color, IFNULL(mg.groupName, '') AS member_group,
         pg.onlineColor AS post_group_color, IFNULL(pg.groupName, '') AS post_group,
         IF((mem.ID_GROUP = 0 OR mg.stars = '')$moderator_fix[pg], pg.stars, mg.stars) AS stars" . (!empty($modSettings['titlesEnable']) ? ',
         mem.usertitle' : '');
      $select_tables = "
         LEFT JOIN {$db_prefix}mm_pins AS pin ON (pin.ID_MEMBER = mem.ID [nofollow]_MEMBER)
         LEFT JOIN {$db_prefix}location_country AS c ON (pin.country = c.c2code)
         LEFT JOIN {$db_prefix}mm_pins AS pin ON (pin.ID_MEMBER = mem.ID [nofollow]_MEMBER)
         LEFT JOIN {$db_prefix}location_country AS c ON (pin.country = c.c2code)
         LEFT JOIN {$db_prefix}mm_pins AS pin ON (pin.ID_MEMBER = mem.ID [nofollow]_MEMBER)
         LEFT JOIN {$db_prefix}location_country AS c ON (pin.country = c.c2code)
         LEFT JOIN {$db_prefix}mm_pins AS pin ON (pin.ID_MEMBER = mem.ID [nofollow]_MEMBER)
         LEFT JOIN {$db_prefix}location_country AS c ON (pin.country = c.c2code)
         LEFT JOIN {$db_prefix}mm_pins AS pin ON (pin.ID_MEMBER = mem.ID [nofollow]_MEMBER)
         LEFT JOIN {$db_prefix}location_country AS c ON (pin.country = c.c2code)
         LEFT JOIN {$db_prefix}log_online AS lo ON (lo.ID_MEMBER = mem.ID [nofollow]_MEMBER)
         LEFT JOIN {$db_prefix}attachments AS a ON (a.ID_MEMBER = mem.ID [nofollow]_MEMBER)
         LEFT JOIN {$db_prefix}membergroups AS pg ON (pg.ID_GROUP = mem.ID [nofollow]_POST_GROUP)
         LEFT JOIN {$db_prefix}membergroups AS mg ON (mg.ID_GROUP = $moderator_fix[mg])";

but I've cleaned all that up and it seems to be working fine except for one annoying issue that I can't seem to find.

Here are the clues:

A users country flag shows up 4 times in all posts and the flag associated with the country ip he or she is coming in from appears twice in the who's online jazz.

When using the TP theme I added the munu item and button for membermap and it shows once along the top as it should, however, if one uses the default SMF theme the menu item for member map shows 4 times.

At first I thought there might be multiple items in the DB itself that was causing mm to output multiple iterations of a single users flag - but I can't seem to find anything wrong in the DB.

I've looked thru all the code modified by MM (Location mode) and can't seem to find anything out of place.

What am I missing here?

Thanks

C

www.ipoco.com [nofollow]

[beemer]

the four flags must be the code in (your theme)display.template

Code Select Expand

if (!empty($message['member']['flag']['country']))
echo '
<img src="', $settings['default_images_url'], '/flags/', $message['member']['flag']['country'], '.png" alt="', $message['member']['flag']['name'], '" title="', $message['member']['flag']['name'], '" /><br />';

[ipoco]

it only seems to be there once . . .

Code Select Expand

if (!empty($message['member']['flag']['country']))
echo '
<img src="', $settings['default_images_url'], '/flags/', $message['member']['flag']['country'], '.png" alt="', $message['member']['flag']['name'], '" title="', $message['member']['flag']['name'], '" /><br />';

[beemer]

it shows up 5 times if you view source

Try comparing your display template with the original you can use winmerge for comparing files

http://winmerge.sourceforge.net/

[OncleBen31]

Erik same question for you, what version of MySQL are you running?

I've made some test. The mod generate the error message when using a MySQL 5.0 and work correctly with MySQL 4.0

I hope this may help you to solve the problem

[Gobalopper]

Thanks OncleBen, thats what I was starting to think. I will look into a fix.

[ipoco]

fixed - winmerge was a great help

[Bigguy]

so is PHP Designer