Ip Tracking in ACP

[a_lunatic]

All thses are getting this error in

IP Tracking Admin: Admin Page Hits
Ip: Admin Hits
Ip: Logs
Ip: Multi Users

Error Getting IP Count.

DEBUG MODE

SQL Error : 1146 Table 'xxxxxxxxxx.phpbb_ip_tracking' doesn't exist

SELECT COUNT(*) AS total FROM phpbb_ip_tracking WHERE located LIKE '%admin%' GROUP BY time

Line : 679
File : admin_ip_tracking.php

[meijin]

Yeah, I get the same thing...just have not gotten around to trying address it.

[Fallen]

Exactly the same here with my site.

[tmotley]

What are you doing to get these errors exactly?

[Helter]

see if this helps

Code: Select all

DROP TABLE IF EXISTS phpbb_ip_tracking_config;
DROP TABLE IF EXISTS phpbb_ip_tracking;
CREATE TABLE `phpbb_ip_tracking_config` ( `max` varchar(15) NOT NULL DEFAULT '' ) TYPE=MyISAM;
INSERT INTO `phpbb_ip_tracking_config` VALUES ('25000');
CREATE TABLE `phpbb_ip_tracking` ( `ip` varchar(15) NOT NULL DEFAULT '', `time` int(11) NOT NULL DEFAULT '0', `located` varchar(255) NOT NULL DEFAULT '', `username` varchar(50) NOT NULL DEFAULT '') TYPE=MyISAM;

[a_lunatic]

Fixed it but had to do it in server control panel as on phpbbmyadmin had ctracker warning

[meijin]

I hate to show my newbie-ness yet again, but I have to.

What, exactly, should I be doing with that code snippet above to get the IP Tracking feature to work?

Thanks (AGAIN) for the help!

[Helter]

open your database in phpmyadmin, click the querry button and paste that code in the box that appears, click submit. That will add the ip_tracking_config table to your database

[Neva]

I had the same error and ran the fix, I no longer have the error but Ip Tracking is not tracking anything.

Any Ideas?

[melamkish]

Same problem here. Updated the db, fixed the error, but no tracking.

Started to dig into the code and in the admin_ip_logger.php file I found the following line

include($phpbb_root_path . "includes/functions_ip_logger.php");

If I'm not mistaken, this line calls the functions for the logger. I have searched all over the software and have not found this file. Even downloaded the earlier versions of IM as well as looked at the core phpbb2 software.

Nowhere.

It would appear that this mod is incomplete. <img>

[star]

Same problem here. Updated the db, fixed the error, but no tracking.

Started to dig into the code and in the admin_ip_logger.php file I found the following line

include($phpbb_root_path . "includes/functions_ip_logger.php");

If I'm not mistaken, this line calls the functions for the logger. I have searched all over the software and have not found this file. Even downloaded the earlier versions of IM as well as looked at the core phpbb2 software.

Nowhere.

It would appear that this mod is incomplete. <img>

whats missing are the sql commands and 2 file edits
edit one

Code: Select all

 OPEN Root/includes/page_header.php
FIND
 ?>
 BEFORE ADD
 include_once($phpbb_root_path . 'includes/functions_ip_track.'.$phpEx);

edit 2

Code: Select all

 OPEN Root/admin/index.php
FIND
include_once($phpbb_root_path . 'includes/lite.'.$phpEx);
ADD AFTER
include_once($phpbb_root_path . 'includes/functions_ip_track.'.$phpEx);


and then run the following 2 sql commands

Code: Select all

CREATE TABLE `phpbb_ip_tracking` ( `ip` varchar(15) NOT NULL default '', `time` int(11) NOT NULL default '0', `located` varchar(255) NOT NULL default '', `referer` varchar(255) NOT NULL default '', `username` varchar(50) NOT NULL default '') ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `phpbb_ip_tracking_config` ( `max` int(15) NOT NULL default '0') ENGINE=MyISAM DEFAULT CHARSET=utf8;

[Neva]

Thanks for the suggestion star but I still don't have any IPs being tracked in Ip Tracking. <img>

[MWE_001]

my girlfriends website has the same problem as well as another that Im helping work on as well as 2 other installs I did. Seems we need to mark this one as BUG and get it fixed in the new version eh?

[.QUACK.Major.Pain]

After reading, still not sure where you getting this error.

[MWE_001]

The error is there when you click on IP Tracking in the ACP. My girfriends website had it as well.

I did run the sql on my girlfriends website and it did absolutely nothing for her BUT to get rid of the error. Everything is there but not a 1 ip gets logged.