Stats Duplicate Entry

khaled_dxb · Regular Joined: Jan 15, 2007 Posts: 66

Hi Guys,

Doing an upgrade to 2.3.02 and during the file compare, i came across the following in a log file (rnlogs/dblog)

Code:

August 30, 2009, 12:03 am 1062 : Duplicate entry '2009-8-30-20' for key 1
SQL was: INSERT INTO nuke_stats_hour VALUES ('2009','08','30','20','0')
remote addr: 67.218.116.132
August 30, 2009, 12:03 am 1062 : Duplicate entry '2009-8-30-18' for key 1
SQL was: INSERT INTO nuke_stats_hour VALUES ('2009','08','30','18','0')
remote addr: 67.218.116.162
August 30, 2009, 12:03 am 1062 : Duplicate entry '2009-8-30-21' for key 1
SQL was: INSERT INTO nuke_stats_hour VALUES ('2009','08','30','21','0')
remote addr: 67.218.116.132
August 30, 2009, 12:03 am 1062 : Duplicate entry '2009-8-30-19' for key 1
SQL was: INSERT INTO nuke_stats_hour VALUES ('2009','08','30','19','0')
remote addr: 67.218.116.162
August 30, 2009, 12:03 am 1062 : Duplicate entry '2009-8-30-22' for key 1
SQL was: INSERT INTO nuke_stats_hour VALUES ('2009','08','30','22','0')
remote addr: 67.218.116.132

Any ideas why the script is trying to enter duplicates?
It is only from those two IPs that you see there - strange??
I've got lines and lines of that stuff going back almost a year, but only from certain IPs, i'm guessing if it was every user that visited i would've prob consumed gigs of disk space!

Thanks in advance for any replies.

wHiTeHaT · Posted: Wed Sep 02, 2009 3:22 pm

Could you post the table itself so we can maby detect the problem.
Simply make a backup of the stats tables without the data.

khaled_dxb · Regular Joined: Jan 15, 2007 Posts: 66

Is this the info you're looking for?

Code:

/*Column Information For - raven.nuke_stats_hour*/
----------------------------------------------------------

Field Type Collation Null Key Default Extra Privileges Comment
------ ----------- --------- ------ ------ ------- ------ ------------------------------- -------
year smallint(6) (NULL) NO PRI 0 select,insert,update,references
month tinyint(4) (NULL) NO PRI 0 select,insert,update,references
date tinyint(4) (NULL) NO PRI 0 select,insert,update,references
hour tinyint(4) (NULL) NO PRI 0 select,insert,update,references
hits int(11) (NULL) NO 0 select,insert,update,references

/*Index Information For - raven.nuke_stats_hour*/
---------------------------------------------------------

Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment
--------------- ---------- -------- ------------ ----------- --------- ----------- -------- ------ ------ ---------- -------
nuke_stats_hour 0 PRIMARY 1 year A (NULL) (NULL) (NULL) BTREE
nuke_stats_hour 0 PRIMARY 2 month A (NULL) (NULL) (NULL) BTREE
nuke_stats_hour 0 PRIMARY 3 date A (NULL) (NULL) (NULL) BTREE
nuke_stats_hour 0 PRIMARY 4 hour A 50115 (NULL) (NULL) BTREE

/*DDL Information For - raven.nuke_stats_hour*/
-------------------------------------------------------

Table Create Table
--------------- -----------------------------------------------
nuke_stats_hour CREATE TABLE `nuke_stats_hour` (
`year` smallint(6) NOT NULL default '0',
`month` tinyint(4) NOT NULL default '0',
`date` tinyint(4) NOT NULL default '0',
`hour` tinyint(4) NOT NULL default '0',
`hits` int(11) NOT NULL default '0',
PRIMARY KEY (`year`,`month`,`date`,`hour`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

montego · Posted: Fri Sep 04, 2009 6:43 am

khaled_dxb, clear your log and track it go forward. Pretty sure we fixed that, just cannot recall if it was 2.3 or 2.4 (soon to be released). It was a PHP-Nuke bug... many such bugs...

khaled_dxb · Regular Joined: Jan 15, 2007 Posts: 66

Ok, will do - looking forward to 2.4 - Thanks!

khaled_dxb · Regular Joined: Jan 15, 2007 Posts: 66

By any chance will it have the phpbb3 integration built in (to save me a whole bunch of time) or is that for 2.5+ (if at all)?

evaders99 · Posted: Fri Sep 04, 2009 6:42 pm

phpBB3 will not be in 2.4