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>

[DjPorkchop]

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.

[DjPorkchop]

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.

[.QUACK.Major.Pain]

I must be missing it. I don't see ip tracking anywhere.
I can click on the online users ip and see their info.

[DjPorkchop]

I suspect that it is the all languages version only then. I have the english only version and it does NOT have IP Tracking in the ACP anywhere at all.

[Dioncecht]

I'm getting this error as well. I know part fo it is that it is missing the table in the databases. I can't try the fix because I can't see any snippets of code posted on this site anymore.

I get this:

[djcasper]

I have fixed the problem with this tracker.
You can download the missing file + file edits and sql code from the link below.

Your tracker will then log your actions. To test it login to admin and goto your tracker and you will see your login data.

Regards
DJ Casper

[.QUACK.Major.Pain]

djcasper that edit didn't work here.

Causes this error on portal page:

Warning: main() [function.main]: Unable to access ./includes/functions_ip_track.php in /home4/stuffupf/public_html/bindepot/forum/includes/page_header.php on line 1416

Warning: main(./includes/functions_ip_track.php) [function.main]: failed to open stream: No such file or directory in /home4/stuffupf/public_html/bindepot/forum/includes/page_header.php on line 1416

Warning: main() [function.include]: Failed opening './includes/functions_ip_track.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home4/stuffupf/public_html/bindepot/forum/includes/page_header.php on line 1416


I just did a new install and the file doesn't exist.
I downloaded integramod files again and checked, but the file functions_ip_track.php doesn't exist in the download.

[.QUACK.Major.Pain]

Nevermind. LOL

Just got out of bed and still half asleep.

Found the file in your download and everything working great now.

Great job.

Thanks

[dungeon]

Hai


I have this error

Configuration = Oke


Ip: Admin Hits error =

Error Getting IP Count.

DEBUG MODE

SQL Error : 1146 Table 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx.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

Ip: Logs error =

Error Getting IP Count.

DEBUG MODE

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

SELECT COUNT(ip) AS total FROM phpbb_ip_tracking GROUP BY username

Line : 470
File : admin_ip_tracking.php

Ip: Multi Users error =

Error Getting IP Count.

DEBUG MODE

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

SELECT COUNT(ip) AS total FROM phpbb_ip_tracking GROUP BY ip

Line : 798
File : admin_ip_tracking.php

Ip: Search = oke


When i do the querry from this topic from JWI

Than i have this

[img=left:2geqc4jq]http://www.spuwjegalonline.nl/test/database.jpg[/img]


Greetz Dungeon

[Okki]

Maybe you can try the solution from djcasper.

I suppose this solution can go in the package, maybe also as an update package for the current version!!??

[dungeon]

I have don that but a can do this in Query

Code: Select all

SQL FIX  CREATE TABLE phpbb_ip_tracking_config (    max INT(15) NOT NULL DEFAULT '0'    );                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,    username varchar(50) NOT NULL DEFAULT ''    );    INSERT INTO phpbb_ip_tracking_config VALUES (25000);  

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE phpbb_ip_tracking ( ip varchar(15) NOT NULL default '', tim' at line 5






Dungeon

[.QUACK.Major.Pain]

You must be doing something wrong.
I just created a test database and did the above, and all was successful.

First, you mention query. You don't do query, you use the "SQL" tab and enter this in the box:

Code: Select all

CREATE TABLE phpbb_ip_tracking_config (    max INT(15) NOT NULL DEFAULT '0'    );                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,    username varchar(50) NOT NULL DEFAULT ''    );    INSERT INTO phpbb_ip_tracking_config VALUES (25000);

Then click "GO"

You should get the following when done]Your SQL query has been executed successfully[/code]

[code=sql]SQL query]

[code=sql]Run SQL query/queries ON DATABASE aaquac5_test]

[Helter]

mysql5 / mysqli

Code: Select all

 CREATE TABLE IF NOT EXISTS `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=latin1;    CREATE TABLE IF NOT EXISTS `phpbb_ip_tracking_config` (   `max` varchar(15) NOT NULL DEFAULT '0') ENGINE=MyISAM DEFAULT CHARSET=latin1;  INSERT INTO `phpbb_ip_tracking_config` (`max`) VALUES('25000');  

mysql4

Code: Select all

 CREATE TABLE IF NOT EXISTS `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 '') TYPE=MyISAM;    CREATE TABLE IF NOT EXISTS `phpbb_ip_tracking_config` (   `max` varchar(15) NOT NULL DEFAULT '0') TYPE=MyISAM;  INSERT INTO `phpbb_ip_tracking_config` (`max`) VALUES('25000');  

[dungeon]

I whas in the rong box lol now i have don this and it works

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;    

[dungeon]

i have fix the error but Tracking is not tracking anything


Dungeon

[Moander]

The djcasper fix worked perfectly, no errors, no issues, and I got tracking.

Thank you djcasper.

[Moander]

Only issue remaining, as I spoke too early <img>

I get no guest IP tracking. When I look at the Config screen, I can delete the registered member logs, but the Guest log shows 0 entries all the time.....

Ideas?