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!
Ok, if you want to try out the maybe finished update script:
Grab the zipped update.php here: http://pepper.pralinenschachtel.de/files/update-php.zip
Backup both of your MINT database tables (maybe using the Backup/Restore Pepper).
Upload the update.php to mint/pepper/tillkruess/locations/
Run the script: yourdomain.com/mint/pepper/tillkruess/locations/update.php
thanks, till, for the update.
i am not sure how to activate the update script. i am trying out version 202, but there is no option to do any update from the preferences. is there a URL i am supposed to go to?
I wrote that:
Run the script: yourdomain.com/mint/pepper/tillkruess/locations/update.php
Oh, I didn’t put the update script in 202. I’ve fixed that. Just download it again if the file doesn’t exists.
hi, till,
i tried out the update script. no php error, yeah!
after the update, my total country stat did increase. however, when i looked at my SQL database table, the data column “country_code” still have 3-letter code entry as compared with the new 2-letter code you use. so, did it just do a partial but not complete conversion of the country code?
just puzzled.
I wrote to uninstall Locations 1.x (that meas that the outdated country_code field and its data will be dropped). This was a ugly solution, I know! Won’t happen again…
hi, till,
i am not sure i understand what you mean. i upgraded from v200 not v1.x. are you saying the outdated 3-letter country_code codes currently in my data table (after running the update.php) were all from v1.x? if so, these 3-letter codes were still there so nothing was dropped. if these 3-letter codes were left from 2.x, should they have been converted to the 2-letter code already?
till,
i am running into great difficulty with the v202.
1) when i try to run the update, i gave me a php error saying the url exceeded the length limit; it appeared that the parameter after the ? was repeated many times during the update leading to the error.
PHP Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /[homedir]/mint/pepper/tillkruess/locations/update.php on line 75
when i ran the update the second time, it just said there was no need to update. very strange…
2) the “most common” pane no longer works correctly. again, none of the past records showed up in the total count (both 3-letter old code and new 2-letter old code). it is broken somehow.
good try though, i like the new feature; looking forward to the fix.
Till, I just wanted to tell you one error that keeps popping up in my Apache error_log file. The script is running fine and the stats are also showing, but I am wondering if this error shown has any effect and can be fixed ?
[Sat Feb 10 13:20:23 2007] [error] PHP Notice: Uninitialized string offset: 1 in /home/*****/public_html/stat/pepper/tillkruess/locations/includes/ip-to-country.php on line 107
I am running PHP 4.4.4 and MySQL 5.0.27-standard
k, I’ll fix that next week.
AFAIK, this error-notice appears if a IP-Address can’t be resolved.
I have about a dozen Pepper installed and all are working now with 2.02. I installed Locations 2.11 yesterday and it didn’t work. Installed without any error messages, but nothing showed up in the pane except the titles. After reading through posts here, I uninstalled it, then downloaded it directly from Till’s site. But I got the same result after reinstalling.
I noticed Till added an “Update your records…” script link in Locations. But the instructions are minimal. What does that script do? Yeah, yeah, I know it says it updates empty database records, but why and when do I need to do that? What does it mean when it asks “how many records do I want to update per request”? The default is 750. Another “why?”
Inquiring minds want to know…
fork, Locations v2 starts tracking from the time of install.
If you’d like to update the total hits run the script linked in the peppers preferences.
The “records per request”-number should be adjusted to the amount of available resources of your webserver.
I’m using 3000, but 750 works fine and just takes a few minutes longer.
Each time I installed Locations, I assumed it would take some time to start tracking so I left it alone for five minutes, then ten minutes, half an hour, an hour. My site receives over 1000 unique visits per hour. The Locations never updated. That’s what I mean when I say it’s not working.
I’m still not clear WHY the extra script in Locations preferences updates “empty” records. I know very little about databases or SQL . I apologize if my questions sound stupid.
I do not know what you mean when you write “amount of available resources of your webserver”. Do you mean memory? Processor speed? Hard disk space?
I have a dedicated Dual Intel Xeon 2.66 GHz server with 1GB memory and a 200gb hard disk that is about 10% full. It’s LinuxOS running apache.
If these are the resources you mean, how do they correlate to the number of records per request in the update script? If you mean something else by “webserver resources”, please tell me what it is.
I left the number of records in the script at 750 and ran it to see what would happen. After clicking the start button on the script, Firefox informed me that it was “loading” and this continued for 35+ minutes. At some point I’m going to have to stop the script. Will this script do anything bad to my database if it’s stopped?
Your thinking too much : )
The update.php is for those who wants to update records that have been made before the installation of Locations.
Either contact me by mail or post the link to your mint installation.
You must be logged in to reply. Login above or create an account