Vassilis Posted December 14, 2010 Share Posted December 14, 2010 I installed v3.7, working ok, but i have the same issue more or less with plutomon: flags, country, city aren't shown and googlemap on the bottom of the page doesn't show any location (only when i click on the visitor's ip address, then i can see country, city and location on googlemap in the ipinfodb.com pop up window that comes up. Any help? :-) Quote Link to comment Share on other sites More sharing options...
Guest Posted December 20, 2010 Share Posted December 20, 2010 I installed v3.7, working ok, but i have the same issue more or less with plutomon: flags, country, city aren't shown and googlemap on the bottom of the page doesn't show any location (only when i click on the visitor's ip address, then i can see country, city and location on googlemap in the ipinfodb.com pop up window that comes up. Any help? :-) me too.. :( any help? :-) Quote Link to comment Share on other sites More sharing options...
fer_fer Posted December 20, 2010 Share Posted December 20, 2010 I addes the 3.7 changes as well. Everything works except the flags do not appear on the map. Any help? Quote Link to comment Share on other sites More sharing options...
SimoNtpf Posted February 20, 2011 Share Posted February 20, 2011 After installing 3.7 (there was v1.11 intalled before) when I try to open Admin/Tools/Who's online i am gettin this error Parse error: syntax error, unexpected T_CLASS in /stor1/minotaur/html/sfaf/catalog/mynewadmin/includes/classes/ipinfodb.class.php on line 2 Any idea how to solve this? Quote Link to comment Share on other sites More sharing options...
johanv Posted March 7, 2011 Share Posted March 7, 2011 Hi everyone, I'm using Who's Online 3.6.6 and I've noticed an intermittent problem that has popped up every few weeks or so over the past 4 months. lines 35-49 of includes/functions/whos_online.php: function wo_get_host_from_addr($ip_address) { //Get hostname from IP address if (strstr($ip_address, ',')) { //if multiple responses, use first one $ips = explode(',', $ip_address); $ip_address = $ips[0]; } if ($ip_address == 'unknown') { $hostname = $ip_address; } else { $hostname = gethostbyaddr($ip_address); } return $hostname; } Is this some coding error or could it be some problem with my hosting service? I'm using a shared server for a few more weeks. Thanks Has this been resolved as I am having the same issue. Johan Quote Link to comment Share on other sites More sharing options...
Guest Posted April 21, 2011 Share Posted April 21, 2011 What did you do to adjust it? Can you give me some information about those tweaks please? Thank you in advance nobody find solution? help please.. :) Quote Link to comment Share on other sites More sharing options...
Eric B Posted April 28, 2011 Share Posted April 28, 2011 Hello everyone, I read a lot on this forum without founding my problem. I have install whosonlineturbov1.1 a long time ago but now I like to change it with Who's Online Enhancement cause I heart only good things about this contribution. SQL downloaded for whosonlineturbov1.1: ALTER TABLE whos_online ADD http_referer VARCHAR(255) NOT NULL; ALTER TABLE whos_online ADD user_agent VARCHAR(255) NOT NULL; ////// At the start, I have to download the SQL file but I get an error: Erreur requête SQL: ALTER TABLE whos_online ADD http_referer VARCHAR( 255 ) NOT NULL ; MySQL a répondu:Documentation #1060 - Duplicate column name 'http_referer' //////// I have push up and finish to install all the files. My admin side is working normaly and I can see whos_online but my website is down with an error: 1054 - Unknown column 'hostname' in 'field list' insert into whos_online (customer_id, full_name, session_id, ip_address, hostname, time_entry, time_last_click, last_page_url, http_referer, user_agent) values ('0', 'Guest', 'd33a478148c4e95a2b3cxxxxxxxxxx', '101.231.216.249', '101.231.216.249', '1303000657', '1303000657', '/catalog/index.php', '', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.2.16) Gecko/20110319 Firefox/3.6.16 ( .NET CLR 3.5.30729; .NET4.0E)') [TEP STOP] I have change a few numbers..., cause I don't know if it is safe to show them! Someone as an idea please? Thanks Quote osCommerce Online Merchant v2.2 RC1 W3C Valid FR avec : colissimo_v1.9 // CGV // GoogleXML_sitemap - Update -> googlexml_sitemap_seo_v_1.5 // Ultimate SEO URLs 2.1d - Update -> v22d_12 // AntiRobotRegistrationValidation-3.1 // TinyMCE WYSIWYG HTML EDITOR // HEader Tag SEO 3.1.4 // PDF Invoice 1.5 // Specials_enhanced_v1_3_1 // quick_stock_update_v3.5_FRENCH // xmembers_v2.2 // contact_us_form_in_db_with_amin_v1.1 // photo_display_1 // previous_next_with_details // infoBox Admin v.2.25 // whosonlineturbov1.1fr // customer_discount_v1.3 // flash_bannersv2 // Horizontal_menu_V3 // Loginbox_Best_1 // CCGV // XSell_v2_7_2 // Printable Catalog XSS Flaw Fixed // all_specials_slideshow // Birthdays_v1.4 // Search_price_range_pulldown_menu_1.1 // contrib-categories // Reviews_in_Product_Display_v2.3 // Easy Graphical Borders // Simple Multiple Images (Unlimited) with Fancy Popups V1.3.5 // Guestbook V3.0 // Blacklist_IP_v.3 // Quicker Product Edit v2.1 // Chronopost_2010 // Easy Center // Size Shop with Layers // Safari-Chrome_fix // Protection to Configuration v1.3a // Page_Cache_v1.6... Thanks to everyone! Link to comment Share on other sites More sharing options...
Eric B Posted April 28, 2011 Share Posted April 28, 2011 Hello everyone, I read a lot on this forum without founding my problem. I have install whosonlineturbov1.1 a long time ago but now I like to change it with Who's Online Enhancement cause I heart only good things about this contribution. SQL downloaded for whosonlineturbov1.1: ALTER TABLE whos_online ADD http_referer VARCHAR(255) NOT NULL; ALTER TABLE whos_online ADD user_agent VARCHAR(255) NOT NULL; ////// At the start, I have to download the SQL file but I get an error: Erreur requête SQL: ALTER TABLE whos_online ADD http_referer VARCHAR( 255 ) NOT NULL ; MySQL a répondu:Documentation #1060 - Duplicate column name 'http_referer' //////// I have push up and finish to install all the files. My admin side is working normaly and I can see whos_online but my website is down with an error: 1054 - Unknown column 'hostname' in 'field list' insert into whos_online (customer_id, full_name, session_id, ip_address, hostname, time_entry, time_last_click, last_page_url, http_referer, user_agent) values ('0', 'Guest', 'd33a478148c4e95a2b3cxxxxxxxxxx', '101.231.216.249', '101.231.216.249', '1303000657', '1303000657', '/catalog/index.php', '', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.2.16) Gecko/20110319 Firefox/3.6.16 ( .NET CLR 3.5.30729; .NET4.0E)') [TEP STOP] I have change a few numbers..., cause I don't know if it is safe to show them! Someone as an idea please? Thanks Last minute... if I keep the original file whos_online.php (from whosonlineturbov1.1) in catalog/includes/fonctions/whos_online.php it seems working fine in ADMIN and Website! But it still don't know if is it ok and I can use it the same way for my main website! Someone knows? Thanks Quote osCommerce Online Merchant v2.2 RC1 W3C Valid FR avec : colissimo_v1.9 // CGV // GoogleXML_sitemap - Update -> googlexml_sitemap_seo_v_1.5 // Ultimate SEO URLs 2.1d - Update -> v22d_12 // AntiRobotRegistrationValidation-3.1 // TinyMCE WYSIWYG HTML EDITOR // HEader Tag SEO 3.1.4 // PDF Invoice 1.5 // Specials_enhanced_v1_3_1 // quick_stock_update_v3.5_FRENCH // xmembers_v2.2 // contact_us_form_in_db_with_amin_v1.1 // photo_display_1 // previous_next_with_details // infoBox Admin v.2.25 // whosonlineturbov1.1fr // customer_discount_v1.3 // flash_bannersv2 // Horizontal_menu_V3 // Loginbox_Best_1 // CCGV // XSell_v2_7_2 // Printable Catalog XSS Flaw Fixed // all_specials_slideshow // Birthdays_v1.4 // Search_price_range_pulldown_menu_1.1 // contrib-categories // Reviews_in_Product_Display_v2.3 // Easy Graphical Borders // Simple Multiple Images (Unlimited) with Fancy Popups V1.3.5 // Guestbook V3.0 // Blacklist_IP_v.3 // Quicker Product Edit v2.1 // Chronopost_2010 // Easy Center // Size Shop with Layers // Safari-Chrome_fix // Protection to Configuration v1.3a // Page_Cache_v1.6... Thanks to everyone! Link to comment Share on other sites More sharing options...
Eric B Posted April 28, 2011 Share Posted April 28, 2011 (edited) Last minute... if I keep the original file whos_online.php (from whosonlineturbov1.1) in catalog/includes/fonctions/whos_online.php it seems working fine in ADMIN and Website! But it still don't know if is it ok and I can use it the same way for my main website! Someone knows? Thanks I forgot... The only thing who is not working is step 5 (even if I use all good files from Who's Online Enhancement). (5. In the Admin area, go to Configuration -> Store -> Google Maps Key and enter the key from the previous step) I have no Google Maps Key option in my ADMIN. Means I can show the Google Map! An idea? Thanks Edited April 28, 2011 by Eric B Quote osCommerce Online Merchant v2.2 RC1 W3C Valid FR avec : colissimo_v1.9 // CGV // GoogleXML_sitemap - Update -> googlexml_sitemap_seo_v_1.5 // Ultimate SEO URLs 2.1d - Update -> v22d_12 // AntiRobotRegistrationValidation-3.1 // TinyMCE WYSIWYG HTML EDITOR // HEader Tag SEO 3.1.4 // PDF Invoice 1.5 // Specials_enhanced_v1_3_1 // quick_stock_update_v3.5_FRENCH // xmembers_v2.2 // contact_us_form_in_db_with_amin_v1.1 // photo_display_1 // previous_next_with_details // infoBox Admin v.2.25 // whosonlineturbov1.1fr // customer_discount_v1.3 // flash_bannersv2 // Horizontal_menu_V3 // Loginbox_Best_1 // CCGV // XSell_v2_7_2 // Printable Catalog XSS Flaw Fixed // all_specials_slideshow // Birthdays_v1.4 // Search_price_range_pulldown_menu_1.1 // contrib-categories // Reviews_in_Product_Display_v2.3 // Easy Graphical Borders // Simple Multiple Images (Unlimited) with Fancy Popups V1.3.5 // Guestbook V3.0 // Blacklist_IP_v.3 // Quicker Product Edit v2.1 // Chronopost_2010 // Easy Center // Size Shop with Layers // Safari-Chrome_fix // Protection to Configuration v1.3a // Page_Cache_v1.6... Thanks to everyone! Link to comment Share on other sites More sharing options...
Eric B Posted April 28, 2011 Share Posted April 28, 2011 I forgot... The only thing who is not working is step 5 (even if I use all good files from Who's Online Enhancement). (5. In the Admin area, go to Configuration -> Store -> Google Maps Key and enter the key from the previous step) I have no Google Maps Key option in my ADMIN. Means I can show the Google Map! An idea? Thanks Found a way for that and it is working: http://www.oscommerce.com/forums/topic/124853-whos-online-enhancement-14/page__st__1640__p__1502838#entry1502838 Quote osCommerce Online Merchant v2.2 RC1 W3C Valid FR avec : colissimo_v1.9 // CGV // GoogleXML_sitemap - Update -> googlexml_sitemap_seo_v_1.5 // Ultimate SEO URLs 2.1d - Update -> v22d_12 // AntiRobotRegistrationValidation-3.1 // TinyMCE WYSIWYG HTML EDITOR // HEader Tag SEO 3.1.4 // PDF Invoice 1.5 // Specials_enhanced_v1_3_1 // quick_stock_update_v3.5_FRENCH // xmembers_v2.2 // contact_us_form_in_db_with_amin_v1.1 // photo_display_1 // previous_next_with_details // infoBox Admin v.2.25 // whosonlineturbov1.1fr // customer_discount_v1.3 // flash_bannersv2 // Horizontal_menu_V3 // Loginbox_Best_1 // CCGV // XSell_v2_7_2 // Printable Catalog XSS Flaw Fixed // all_specials_slideshow // Birthdays_v1.4 // Search_price_range_pulldown_menu_1.1 // contrib-categories // Reviews_in_Product_Display_v2.3 // Easy Graphical Borders // Simple Multiple Images (Unlimited) with Fancy Popups V1.3.5 // Guestbook V3.0 // Blacklist_IP_v.3 // Quicker Product Edit v2.1 // Chronopost_2010 // Easy Center // Size Shop with Layers // Safari-Chrome_fix // Protection to Configuration v1.3a // Page_Cache_v1.6... Thanks to everyone! Link to comment Share on other sites More sharing options...
GwilliamP Posted May 1, 2011 Share Posted May 1, 2011 Since neither dnstuff or showmyip work, is there sn alternative? I am also using 3.5.4 and showmyip has recently stopped working. I searched a few sites until I found an acceptable one that 1) worked with a URL that included the IP address in it 2) provided a decent page of information To implement this I only had to make one minor change to admin/whos_online.php at line 540 in my file. Find echo '<a href="http://www.showmyip.com/?ip=' . $whos_online['ip_address'] . '&get=nmap" target="_blank">'; replace with echo '<a href="http://www.ipchecking.com/?ip=' . $whos_online['ip_address'] . '&check=Lookup" target="_blank">'; I hope this helps (even though it is 2 years later LOL!). Quote Link to comment Share on other sites More sharing options...
Guest Posted May 16, 2011 Share Posted May 16, 2011 hi, trying to use the whosonline feature and i am getting the following error message on 2 oscommerce sites. Fatal error: Uncaught exception 'Exception' with message 'String could not be parsed as XML' in /home/xxxxxx/public_html/xxxxxx/whos_online.php:184 Stack trace: #0 /home/xxxxxx/public_html/xxxxxx/whos_online.php(184): SimpleXMLElement->__construct('') #1 /home/xxxxxx/public_html/xxxxxx/whos_online.php(221): updateIps() #2 /home/xxxxxx/public_html/xxxxxx/whos_online.php(379): add_geolocation() #3 {main} thrown in /home/xxxxxx/public_html/xxxxxx/whos_online.php on line 184 any ideas please ? regrads Quote Link to comment Share on other sites More sharing options...
Antena Posted May 16, 2011 Share Posted May 16, 2011 hi, trying to use the whosonline feature and i am getting the following error message on 2 oscommerce sites. Fatal error: Uncaught exception 'Exception' with message 'String could not be parsed as XML' in /home/xxxxxx/public_html/xxxxxx/whos_online.php:184 Stack trace: #0 /home/xxxxxx/public_html/xxxxxx/whos_online.php(184): SimpleXMLElement->__construct('') #1 /home/xxxxxx/public_html/xxxxxx/whos_online.php(221): updateIps() #2 /home/xxxxxx/public_html/xxxxxx/whos_online.php(379): add_geolocation() #3 {main} thrown in /home/xxxxxx/public_html/xxxxxx/whos_online.php on line 184 any ideas please ? regrads Same problem to me. Quote Link to comment Share on other sites More sharing options...
RobC1962 Posted May 16, 2011 Share Posted May 16, 2011 This error is due to the IP lookup database site being offline at present. Antena 1 Quote Link to comment Share on other sites More sharing options...
Guest Posted May 16, 2011 Share Posted May 16, 2011 This error is due to the IP lookup database site being offline at present. hi thanks for the reply, i guess that puts this one to bed :thumbsup: Quote Link to comment Share on other sites More sharing options...
Antena Posted May 16, 2011 Share Posted May 16, 2011 This error is due to the IP lookup database site being offline at present. Thank's. Quote Link to comment Share on other sites More sharing options...
Cheepnis Posted May 16, 2011 Share Posted May 16, 2011 How can I easily disable the IP lookup feature and make Who's Online work again? I rarely use it anyway. Quote Link to comment Share on other sites More sharing options...
RobC1962 Posted May 16, 2011 Share Posted May 16, 2011 The quickest way would be to backup and copy to local folder your 'enhanced whois online' whois_online.php file and then simply replace it with the standard copy from your osCommerce source files. The problem with ipinfodb should only be temporary and they have posted on Twitter and FaceBook the following: "Sorry everyone for the inconvenience. Our data center is having some technical issues at the moment and they are working as fast as they can to get our servers up again. In the meantime, please be patient and we will update everyone again as soon as there is any progress." Quote Link to comment Share on other sites More sharing options...
Cheepnis Posted May 16, 2011 Share Posted May 16, 2011 Ok, worked out the fix. To disable the IP Lookup feature (but not disable the link to the lookup) Comment out the following lines in admin/whos_online.php: Around line 106 add "//" to this line (as shown): // require('includes/classes/ipinfodb.class.php'); Around line 161, add: /* BEFORE this line: //Function to get IP address geolocation data from IPInfoDB and update whos_online table and around line 214, add: */ BEFORE this line: // Determines status and cart of visitor and displays appropriate icon. Around 372, add "//" to this line (as shown): // add_geolocation(); That's it! Hopefully it doesn't break anything else, but at least it gets Who's Online working again until ipinfodb.com is running again. Quote Link to comment Share on other sites More sharing options...
SambaMambo Posted May 16, 2011 Share Posted May 16, 2011 (edited) well, you just need to change the ip locator api edit /admin/whos_online.php and change to this (line 160): //Function to get IP address geolocation data from IPInfoDB and update whos_online table function updateIps($ips){ //Old,incesure method //$d = file_get_contents("http://ipinfodb.com/ip_query2.php?ip=$ips"); //Initialize the Curl session $ch = curl_init(); $URL = ("http://api.hostip.info/?ip=$ips"); //Set curl to return the data instead of printing it to the browser. curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); //Set the URL, then execute, then close curl_setopt($ch, CURLOPT_URL, $URL); $d = curl_exec($ch); curl_close($ch); //Use backup server if cannot make a connection if (!$d){ //$backup = file_get_contents("http://backup.ipinfodb.com/ip_query2.php?ip=$ips"); $ch = curl_init(); $URL = ("http://api.hostip.info/?ip=$ips"); Edited May 16, 2011 by SambaMambo Quote Link to comment Share on other sites More sharing options...
Cheepnis Posted May 16, 2011 Share Posted May 16, 2011 well, you just need to change the ip locator api edit /admin/whos_online.php and change to this (line 160): Make sure you add another end tag: } to the section, just before: //Add IP address geolocation to whos_online table Quote Link to comment Share on other sites More sharing options...
Cheepnis Posted May 16, 2011 Share Posted May 16, 2011 BTW, not having the IP Lookup enabled REALLY speeds up Who's Online - a lot! I may never put it back (especially since the links should still work once the database is running again). Quote Link to comment Share on other sites More sharing options...
RobC1962 Posted May 16, 2011 Share Posted May 16, 2011 The ipinfo database is back online - enhanced whois all functioning fine now :) Quote Link to comment Share on other sites More sharing options...
Cheepnis Posted May 17, 2011 Share Posted May 17, 2011 Should a completely ancillary function from a third-party website really be allowed to break the entire application when their server has a hiccup, however rare? The next version of this really should have a test for the presence of a working lookup site and should also allow the user to disable that function as part of it's settings (especially considering the speed improvements). I'm not a good enough programmer to make those changes, but I think it would be a welcome addition if anybody wants to do it. Quote Link to comment Share on other sites More sharing options...
rfwoolf Posted June 27, 2011 Share Posted June 27, 2011 I am posting a solution to a problem with the pins on the map - my map had no pins :S First make sure you have uploaded visitors_georss.php to your catalog directory. Then in admin/whos_online.php find the line: geoXml = new GGeoXml("<?php echo HTTP_CATALOG_SERVER . "/visitors_georss.php";?>"); or geoXml = new GGeoXml("<?php echo HTTP_CATALOG_SERVER . DIR_WS_CATALOG . "visitors_georss.php";?>"); Basically the problem was with this line. I had both these lines but the first one was commented out -- but that was the correct line for me! You can take the php part in the line, e.g. <?php echo HTTP_CATALOG_SERVER . DIR_WS_CATALOG . "visitors_georss.php";?> and paste it somewhere on your website to see the URL it generates, for example it may say: www.yoursite.com//visitors_georss.php or something else Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.