Location Mod

[djalecc]

Make sure that you don't have the javascript file cached from before you installed the mod and also make sure that if you are using a custom theme that the javascript gets added to the javascript file for that theme.

Not sure what you mean there, but I dont use FireFox... only just quickly checked it today (as I sometimes check my sites with firefox). All I can say is... this is the first time I've ever tried to load the Map page with FireFox and it don't work! 

Just trying to please the 3 people in the world that seem to use it!!!!!!!! LOL

[stargazer_1017]

I use firefox as well. . .the only thing that's a bit off is where the pins show up after you save it. I put my pin on Hawaii, and I have to put it a bit lower from Hawaii in order for it to be saved on the actual island chain.

-Shayna

[rotor]

Hey Jerry,
Because of the way the database stores the pins I couldn't include Alaska and Hawaii without also including Canada and most of the North Pacific Ocean.

Basically how I did it this time is that there is one big "global" map that is really big. All of these other maps are just crops of that original big map. I store the upper left x/y co-ordinates for each of these crops and then do the pin placement based on that. Its sorta complicated but allows for zoomed in maps that still show the pins regardless of what map you used when placing it.

As for the pin placement not working in Firefox that is because the javascript file is cached. Once you refresh it it will work again.

Gobalopper,

I want to make up maps for the states of Australia ....

In the mod we only have the one which incorporates most of the region - Auss and everywhere around it. What I need to make up is a separate map for all of the states and New Zealand. When I work with the "Global Map" I can't zoom in very far before it becomes out of wack and blurred etc - any chance of getting a copy of your big "Global Map" - the one you used to make your maps, might just make life a little easier ....


rotor

[CLICKBANKS.NET]

how can I move User Listing to under Place Your Pin ? Thanks

[Astaroth27]

I've this problem.
What do I have to do?
If somebody could it in German, it would be great, but English is good as well. Thanks a lot in advance:

Unknown column 'p.country' in 'on clause'
File: /homepages/16/d153720143/htdocs/forum/Sources/MemberMap.php
Line: 101

 

[OncleBen31]

I've this problem.
What do I have to do?
If somebody could it in German, it would be great, but English is good as well. Thanks a lot in advance:

Unknown column 'p.country' in 'on clause'
File: /homepages/16/d153720143/htdocs/forum/Sources/MemberMap.php
Line: 101

 

I've the same problem Anyboy could help us ?
Thank

EDIT :
I've found some information that may help to resolve the problem. In Profil_Info / Track_User :

Code Select Expand

195.6.25.114    8: Undefined index: mm_mm
Fichier: /homepages/15/d148587084/htdocs/Forum/Themes/default/Memberlist.template.php (eval?)
Ligne: 533
?action=mlist Today at 14:48:19
195.6.25.114 8: Undefined index: mm_mm
Fichier: /homepages/15/d148587084/htdocs/Forum/Themes/default/PersonalMessage.template.php (eval?)
Ligne: 533
?action=pm Today at 14:48:15
195.6.25.114 8: Undefined index: mm_mm
Fichier: /homepages/15/d148587084/htdocs/Forum/Themes/default/languages/Who.french.php (eval?)
Ligne: 533
?action=profile Today at 14:48:13
195.6.25.114 8: Undefined index: mm_mm
Fichier: /homepages/15/d148587084/htdocs/Forum/Themes/default/Admin.template.php (eval?)
Ligne: 533
?action=admin Today at 14:48:12
195.6.25.114 8: Undefined index: mm_mm
Fichier: /homepages/15/d148587084/htdocs/Forum/Sources/Subs.php
Ligne: 2750
?action=admin Today at 14:48:12
195.6.25.114 8: Undefined index: mm_mm
Fichier: /homepages/15/d148587084/htdocs/Forum/Themes/default/Search.template.php (eval?)
Ligne: 533
?action=search Today at 14:48:11
195.6.25.114 8: Undefined index: mm_mm
Fichier: /homepages/15/d148587084/htdocs/Forum/Themes/default/languages/Manual.french.php (eval?)
Ligne: 533
?action=help Today at 14:48:09
195.6.25.114 8: Undefined index: mm_mm
Fichier: /homepages/15/d148587084/htdocs/Forum/Themes/default/BoardIndex.template.php (eval?)
Ligne: 533
Today at 14:48:07
195.6.25.114 8: Undefined index: mm_mm
Fichier: /homepages/15/d148587084/htdocs/Forum/Themes/default/Packages.template.php (eval?)
Ligne: 533
?action=packages;sa=browse Today at 14:47:55
195.6.25.114 8: Undefined index: mm_mm
Fichier: /homepages/15/d148587084/htdocs/Forum/Sources/Subs.php
Ligne: 2750
?action=packages;sa=browse Today at 14:47:55
195.6.25.114 8: Undefined index: mm_mm
Fichier: /homepages/15/d148587084/htdocs/Forum/Themes/default/Packages.template.php (eval?)
Ligne: 533
?action=packages;sa=browse Today at 14:47:50
195.6.25.114 8: Undefined index: mm_mm
Fichier: /homepages/15/d148587084/htdocs/Forum/Sources/Subs.php
Ligne: 2750
?action=packages;sa=browse Today at 14:47:50
195.6.25.114 512: parseModification(): The filename 'index.php' is not a full path!
Fichier: /homepages/15/d148587084/htdocs/Forum/Sources/Subs-Package.php
Ligne: 1329
?action=packages;sa=install2;package=gobalopper.locationmod.zip Today at 14:47:25
195.6.25.114 512: parseModification(): The filename 'index.php' is not a full path!
Fichier: /homepages/15/d148587084/htdocs/Forum/Sources/Subs-Package.php
Ligne: 1329
?action=packages;sa=install;package=gobalopper.locationmod.zip Today at 14:47:21

My default language is French. I switch to English and I 've got no more log mm_mm error

[Gobalopper]

It looks to me like the mod didn't install correctly because it is not finding a column from a table that is created when you install the mod. Can you see if you have the tables mm_pins, mm_maps, location_country?

And the mod only supports English right now so other languages will give you that error.

[OncleBen31]

I've tried to re-install SFM 1.1 RC2 (English version with Mysql 5.0 table). Then I Install Location Mod and I've still the same error.

I check the table and I see mm_pins (0 enr) , mm_maps(1 enr) , location_country(239 enr).

Due to the Track below, there were error during the mod installation :

Code Select Expand

195.6.25.114    admin    Database Error: Unknown column 'p.country' in 'on clause'
File: /homepages/15/d148587084/htdocs/Tests/Forum_test/Sources/MemberMap.php
Line: 101
?action=mm Today at 09:19:07 AM

195.6.25.114 admin 512: parseModification(): The filename 'index.php' is not a full path!
File: /homepages/15/d148587084/htdocs/Tests/Forum_test/Sources/Subs-Package.php
Line: 1329
?action=packages;sa=install2;package=gobalopper.locationmod.zip Today at 09:17:42 AM

195.6.25.114 admin 512: parseModification(): The filename 'index.php' is not a full path!
File: /homepages/15/d148587084/htdocs/Tests/Forum_test/Sources/Subs-Package.php
Line: 1329
?action=packages;sa=install;package=gobalopper.locationmod.zip Today at 09:17:37 AM

May be this help you.

[eriktm]

Code Select Expand

Unknown column 'p.country' in 'on clause'
File: C:\xxx\xxx\xxx\xxx\xxx\Sources\MemberMap.php
Line: 101

What a **** is that?

[Bigguy]

Look back on page 55 There might be an answer there.

[eriktm]

Didn`t find it

[Bigguy]

Sorry, I thought I seen the same error as that back there. Sorry to waste your time.

[eriktm]

Thanks for trying to help

[Gobalopper]

Was there any errors on installation?

[eriktm]

No, after, when try opening ?action=mm from mainmenu on top

[cotdagoo]

getting the same errors on a upgraded 1.1b3 -> 1.1rc2 - had no problems testing the mod on a spanking new 1.1rc2 install, but not after upgrading

[Gobalopper]

Can you do a DESCRIBE smf_mm_pins in your MySQL query browser. I want to see if that column is actually there.

[cotdagoo]

yup, the column appears to be there

      Edit       Delete      ID_MEMBER     mediumint( unsigned     NO     PRI     0     
   Edit    Delete    ID_MAP    smallint(5) unsigned    NO    MUL    0    
   Edit    Delete    xPin    smallint(5) unsigned    NO         0    
   Edit    Delete    yPin    smallint(5) unsigned    NO         0    
   Edit    Delete    country    char(2)    NO    MUL         
   Edit    Delete    city    varchar(50)    YES              

is what it gave me in phpmyadmin

[Gobalopper]

What version of MySQL are you running?

[ipoco]

Not unique table/alias: 'pin'
File: /home/ipococo/public_html/xforums/Sources/Load.php
Line: 477

I'm suddenly getting the above error after installing the location mod, additional maps and flags. 

I can add a post but the error shows up when I go to read a post.

Any ideas appreciated

Thanks

C