Login to download the latest version of Mint and your favorite Pepper, purchase additional licenses, or post in the Forum. Don't have an account? Create one!

In Partnership with Media Temple

Mint Forum

Location - Pepper Vers. 2.0 with Mint 2.0

Robert
Minted
Posted on Jan 31, '07 at 05:33 am

Location 2.0 with Mint2.0 doesn´t show anything at “most common”, although there is a lot of data at “most recent”. Anyone with the same problem? And since the Update to 2.0 (both, Mint and Location) Location shows no new visitors. Is it necessary to update the database again? (i´ve updated it after installing the former version) thanks for any help, Robert

i’m having the same problem. it seems that the older version of the pepper worked halfway with the new mint but it wouldn’t show anything in the “most common” pane. so i uninstalled the old location pepper, deleted the folder on the server, uploaded the new location pepper and installed. now i get nothing. the only thing i didn’t update was the database. i’m guessing something new has to be done with the ip-to-country data but the update/upgrade notes only say “You should delete the /locations/ directory before you upload the new files” and there isn’t a readme with the zip file so not much help there.

i’m not much help, i just wanted to share your pain ;-)

chris

ok, i’m digging around a little in the pepper code and it looks like it’s querying the “country_code” field from the mint_visit table. trouble is the entire field is empty in my mint_visit table so it’s not coming back with anything to show. that would explain why i’m not getting any results, but i’m just guessing.

chris

Shaun Inman
Mint/Pepper Developer
Posted on Jan 31, '07 at 08:23 pm

Have you guys tried contacting the Pepper developer?

Robert
Minted
Posted on Feb 01, '07 at 02:48 am

Shaun: i couldn´t find a way to contact him, there is no mail-adress or another contact-possibility avaliable. a vew days ago in this forum was a thread where he postet answers, but it´s gone now… i hope he looks at this thread sometime and give us a clue..

chris: thanks for sharing the pain ;)

greets, Robert

Till
Pepper Developer
Posted on Feb 01, '07 at 05:33 am

I’m quite busy atm and I’ll take a look at this in the next few days. Anyway, 200 is working for me.

  1. Uninstall the Pepper Locations.
  2. Delete the /tillkruess/locations/ directory.
  3. Upload the release from http://pepper.pralinenschachtel.de
  4. Install the Pepper.

If this doens’t work, please wait until I post again in the Forums.

JCFP
Minted
Posted on Feb 01, '07 at 07:28 am

till,

i can also confirm the problem with the new locations 2.00 version in mint 2 that had been upgraded from mint 1 where an older version of locations was previously installed.

the new pepper refuses to update location stats and the most common pane is empty

Robert
Minted
Posted on Feb 02, '07 at 01:50 am

Till: i´ve done as you recommendet, now location is not visible anymore, and the error-message

“MySQL Error: You have an error in your SQL syntax near ‘collate utf8_bin NOT NULL default ”’ at line 1. (1064) Query: ALTER TABLE mint_visit ADD country_code varchar(2) collate utf8_bin NOT NULL default ””

is on top of the page.

when i load the page the 2nd time, location is there but empty.

a.jaffe
Minted
Posted on Feb 02, '07 at 09:12 am

I see what I think is the same issue — the Pepper exists (although I did need to change permissions on all the files!) but no data actually shows up.

However, this is my first install of the pepper — I never had 1.x (although I did have geo mint, which worked).

A

Till
Pepper Developer
Posted on Feb 02, '07 at 11:24 am

Live Mint: http://pralinenschachtel.de/mint Tracked page: http://trucksims.pralinenschachtel.de

I’m on those bugs!

Till
Pepper Developer
Posted on Feb 02, '07 at 12:08 pm

Ok, I’m going to spam a little bit.

Either you get in touch with me by mail to get troubleshooting done by mail (my domain is pralinenschachtel.de and my name is Till. It’s exactly what you’d think it is…)

or you open up your mint with the query command: ?observe and search for “locations = array”.

Take a look at my site: http://pralinenschachtel.de/mint/?observe and see what in the locations array…

Please report whats stored in your locations array.

I think your web servers have problems with the new country database.

Robert
Minted
Posted on Feb 03, '07 at 01:40 am

in my locations array is nothing… (totally empty)

All my problems with Location 2.0 disappeared after I checked the permissions of all the .php and .dat files in the /tillkruess/locations/ folder. I set them all to 644 (they were 600 after upload) and it seems to be working properly now. This also resolved the problem I wrote about here.

JCFP
Minted
Posted on Feb 03, '07 at 02:58 pm

greatislander,

i tried out your suggestion. my files were already set at 644 and the subdirectory at 755, so there is nothing to change.

so i don’t think your solution will solve the problem for at least some of us (including myself); good try, though.

RimWeb
Minted
Posted on Feb 03, '07 at 07:07 pm

How to install this location pepper for the first time? I remember it was mentioned about some SSH for the older version…

Till
Pepper Developer
Posted on Feb 05, '07 at 02:40 am

JCFP, be sure to set 644 on the ip-to-country.dat.

RimWeb, just upload the files and install it via the mint preferences.

I’m still not completly sure why my ip2c code doesn’t work on every server. I’m quite busy at the moment, but it think I’ll release 201 before the week is out.

JCFP
Minted
Posted on Feb 05, '07 at 05:18 am

till,

the ip-to-country.dat is set to 644 already.

i am quite puzzled indeed why the new update does not work me. will wait for your 201 release

RimWeb
Minted
Posted on Feb 05, '07 at 06:20 am

Till: I have done the same as well.. i just thought may be we will be needing to do some SSH again… anyways, will wait for the 201.

Till
Pepper Developer
Posted on Feb 05, '07 at 07:36 am

RimWeb: I’ll never utilize SSH again, because too many user don’t have access to this.

JCFP: Me too. I’m absolutely puzzled why my code isn’t working for everyone.

I did some testing with Robert and a.jaffe and I located the problem (if the chmod is set correctly) to my ip2c class source. I’ll fix this this week.

Till
Pepper Developer
Posted on Feb 05, '07 at 08:26 am

I’m incredibly stupid. I used the in PHP5 introduced Constructor __construct.

If Locations 200 isn’t working for you, either set your PHP-Version to 5.x, wait for 201 or simply open: /mint/pepper/tillkruess/locations/includes/ip-to-country.php

Search for: function __construct() {

Replace by: function i2c() {

I hope thats it!

By the way, have I said that I’m incredibly stupid?

RimWeb
Minted
Posted on Feb 05, '07 at 08:03 pm

No, you are not stupid at all :P Its working fine for me now :) Thanks !

JCFP
Minted
Posted on Feb 07, '07 at 04:52 am

till,

i am trying out Version 2.1 of your pepper.

the most recent locations pane is now displaying properly. i guess you are indeed correct about the php 4 compatibility.

however, the most common pane is completely empty!

can this be the same issue?

also, i noticed that the country codes are stored all differently with the new version (two-letter vs. three-letter abbreviations) in the SQL database. this is a problem because the cumulative table no longer works as it will not collorate the visit data recorded by the old pepper.

JCFP
Minted
Posted on Feb 07, '07 at 04:58 am

till,

just wondering also if you have a method to convert the 3-letter to 2-letter country cod so that all my old visit data can be saved?

Till
Pepper Developer
Posted on Feb 07, '07 at 05:24 am

you said it all : )

I’m working on a web (no ssh) update script, but this isn’t for the previous recored data.

You must be logged in to reply. Login above or create an account