Location Mod

[An_Old_Girl]

I *thought* that it did... I have tried replacing the load.php with the backed up one load.php~ - no help there... The Uninstall apparently did not go as it should have...

Should I simply try to re-upgrade? I don't want to make things worse than they are, but I gotta do sumthin'...

[Gobalopper]

Well I would suggest making sure all your source and template files are from RC2. You can check that in the admin center and the easiest way to replace them is just overwrite them all with the RC2 versions. Then run the RC2 upgrade.php again.

[An_Old_Girl]

Thanks, Jesse! I went back to the original load.php as you suggested and it helped enough for me to read the forum now. I will do as you suggested later on today. Hopefully, it will go well and then I'll be back to get some help trying to reinstall the Location Mod again.

Thanks again! 

[1948Pal]

Hi. I just re-installed this great mod on RC2, it installed without any errors, and installed complete, BUT the error log now shows this

Code Select Expand

8: Use of undefined constant mm_mm - assumed 'mm_mm'
File: /public_html/test/Themes/default/Errors.template.php (eval?)
Line: 533

[edit]
The same error goes for Boardindex.template.php, login.templote.php and Admin.template.php
What went wrong??

[An_Old_Girl]

The reupdate went fine and so far, so good. 

Since I had the same errors as 1948Pal, I will wait to see how that situation resolves before I try to reinstall this wonderful mod! My users have been clamoring for a member map for a long time and I hope I can get this one installed for them soon!

Thanks so much for your hard work! 

[Gobalopper]

I've updated the gobalopper.locationmod.zip file and it should fix that problem 1948Pal. Please let me know if it doesn't.

[1948Pal]

Thank you, yeah that seems to have fixed that. Now though, if I try to access the who's online, I get this

Code Select Expand

Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
File: ../public_html/test/Sources/Load.php
Line: 781
{EDIT} Also the same error on membermap.php when the member map button is clicked.

[Gobalopper]

Hmm I think there are some problems with MySQL STRICT and the queries. I will look into it.

[Mizery1]

Any chance of getting Uninstall instructions for this mod.
The option isn't available in SMF v1.0.5's package manager.

[Goosemoose]

I'm getting this error with the main mod file, I'm using a cvs version from 2 days ago, would that cause it? I didn't see a RC2 install file in the zip though.

The package you are trying to download or install is either corrupt or not compatible with this version of SMF.

[Gobalopper]

The RC2 version should work with the CVS releases. You would have to change the version numbers in the package-info.xml file to make it work though.

Mizery1 are you using the version I just posted? Or an older one? They should all have un-install instructions with them.

[Mizery1]

Mizery1 are you using the version I just posted? Or an older one? They should all have un-install instructions with them.

It was version 1.1.1  Its alright though, I'm working on a doing clean re-install of 1.0.5 anyway.

[1948Pal]

Hmm I think there are some problems with MySQL STRICT and the queries. I will look into it.

Hi Gobalopper, sorry to be the bringer of "not so happy news", but I am still getting those errors

Code Select Expand

Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='
File: /public_html/test/Sources/MemberMap.php
Line: 101 When the member map is clicked, and the same error, but on Load.php line 781 when the who's online is clicked.
Also found a couple of misplaced text but not a big deal;
in index.template.php

Code Select Expand

// The [member map]
echo ($current_action=='profile' || $context['browser']['is_ie4']) ? '<td class="maintab_active_' . $first . '">&nbsp;</td>' : '' , '
<td valign="top" class="maintab_' , $current_action=='mm' ? 'active_back' : 'back' , '">
<a href="', $scripturl, '?action=mm">' , $txt[79] , '</a>
</td>' , $current_action=='mm' ? '<td class="maintab_active_' . $last . '">&nbsp;</td>' : '';
should be

Code Select Expand

// The [member map]
echo ($current_action=='mm' || $context['browser']['is_ie4']) ? '<td class="maintab_active_' . $first . '">&nbsp;</td>' : '' , '
<td valign="top" class="maintab_' , $current_action=='mm' ? 'active_back' : 'back' , '">
<a href="', $scripturl, '?action=mm">' , $txt['mm_mm'] , '</a>
</td>' , $current_action=='mm' ? '<td class="maintab_active_' . $last . '">&nbsp;</td>' : '';
peace

[Gobalopper]

I thought the latest version had that index.template.php problem fixed. I will have to check that again.

Can you post the return values of these two queries for me?

show create table smf_mm_pins;
show create table smf_location_country;

[aussieholden]

Love this mod but one problem I am having the flags in the user's post's are not displaying all we get is the square with the red cross. ?

[Goosemoose]

Make sure the flags are uploaded to whatever theme  folder you are using.

[Kindred]

hmmmm...

the index.template.php is correct in the version that I downloaded in Dec 8.

[1948Pal]

I thought the latest version had that index.template.php problem fixed. I will have to check that again.

Can you post the return values of these two queries for me?

Code Select Expand

show create table smf_mm_pins;
#1146 - Table 'allabout_test.smf_mm_pins' doesn't exist

Code Select Expand

show create table smf_location_country;
#1146 - Table 'allabout_test.smf_location_country' doesn't exist

However, both tables do exist but without the smf part, i.e allabout_test_location_country, and allabout_test_mm_pins.

[edit]If I change it to "show create table mm_pins", I still get "allabout_test.mm_pins" doesn't exist, but it is there and is populated with data[/edit]

[Gobalopper]

Wait so there is a table mm_pins? So if you go "SELECT * FROM mm_pins LIMIT 1" you get results?

[1948Pal]

OK, duh, I am such a..., well you know .

Code Select Expand

CREATE TABLE `test_mm_pins` (\n  `ID_MEMBER` mediumint(8) unsigned NOT NULL default '0',\n  `ID_MAP` smallint(5) unsigned NOT NULL default '0',\n  `xPin` smallint(5) unsigned NOT NULL default '0',\n  `yPin` smallint(5) unsigned NOT NULL default '0',\n  `country` char(2) collate latin1_general_ci default '',\n  `city` varchar(50) collate latin1_general_ci default '',\n  UNIQUE KEY `ID_MEMBER` (`ID_MEMBER`),\n  KEY `country` (`country`),\n  KEY `ID_MAP` (`ID_MAP`)\n) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci

and

Code Select Expand

CREATE TABLE `test_location_country` (\n  `c2code` char(2) NOT NULL default '',\n  `name` varchar(42) NOT NULL default '',\n  `ID_MAP` smallint(5) unsigned NOT NULL default '0',\n  PRIMARY KEY  (`c2code`)\n) ENGINE=MyISAM DEFAULT CHARSET=latin1[code][/code]