Stats Duplicate Entry

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.

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.

Posted: Wed Sep 02, 2009 10:56 pm

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

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...

Posted: Fri Sep 04, 2009 8:15 am

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

Posted: Fri Sep 04, 2009 10:03 am

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)?

Posted: Fri Sep 04, 2009 6:42 pm

phpBB3 will not be in 2.4