problem with Site Info v2.2.2

Involved Joined: Apr 22, 2006 Posts: 356

For some reason the new hits today and new hits yesterday are staying at 0. the total hists seems to be adding ok.

When I view the stats page, it only shows daily stats upto march 22nd on the detailed view. That is the day, that I did a fresh install and dumped info from my old db into this one. However under that it shows todays stats by the hour like normal.

Posted: Thu Mar 29, 2007 9:18 am

Use phpmyadmin to have a look at your tables. The nuke_user table or your stats tables might be "in use". If it is, then run a repair on those tables.
I've similar issues when importing old data into a new table.

Posted: Thu Mar 29, 2007 4:28 pm

not sure, but I used the "check" option in it and everything showed "ok". Is that what you were talking about? I did an export of the stats_date table and it stops on the 22nd, nothing after, that is the day I did the install and dump.

I guess it could be a problem with the stats in general.

Posted: Thu Mar 29, 2007 4:39 pm

Sorry if I lacked clarity.

In phpmyadmin get to the view with all the tables (click the db name in the left-side frame). You can see if your tables are "in use" from this view. If any of them are, then scroll down to below the tables and click the "check all" link. All your tables will be selected, then, with all selected, use the pull down to select repair db tables.

I don't know why tables get stuck, but they do and when they do data doesn't get added to the table.

Of course, it may be something else entirely....
Are you sure you uploaded all the files required in the Statistics directory?

Posted: Thu Mar 29, 2007 5:03 pm

I selected the db in phpmyadmin, it shows all the tables on the left, then on the right it shows all of them along with action, record, type, etc. I see nothing saying "in use" I did do a repair of the db earlier and it did not change anything.

Posted: Thu Mar 29, 2007 7:09 pm

Perhaps the stats dir files became corrupted when you ftp'd them?

Posted: Thu Mar 29, 2007 7:22 pm

i deleted and re-uploaded the stats dir. the info block as well. no luck

registered · Posted: Fri Mar 30, 2007 6:01 am

kevinkap, I cannot recall if you had downgraded from a previous nuke version? The reason I ask, is that I just checked from yesterday to today on my site and it appears that the stats are accumulating properly. So, I just wonder if there is a different in the database somewhere. However, just so you know, I am guessing here as I am not aware of what FB has done, if anything, to stats in later releases. But, might be worth a check if you had downgraded.

Posted: Fri Mar 30, 2007 9:29 am

I had this same problem when I upgraded from 6.9 to 2.02 ... I'm still trying to remember how I fixed it but I'm pretty sure it was something to do with the database. Did you copy old sessions table data into your new database? Perhaps clearing any data in that table would help.

Posted: Fri Mar 30, 2007 12:49 pm

montego wrote:

kevinkap, I cannot recall if you had downgraded from a previous nuke version? The reason I ask, is that I just checked from yesterday to today on my site and it appears that the stats are accumulating properly. So, I just wonder if there is a different in the database somewhere. However, just so you know, I am guessing here as I am not aware of what FB has done, if anything, to stats in later releases. But, might be worth a check if you had downgraded.

Actually, I put my old site, 2.02.02 in a folder, uploaded 2.10 and did a fresh install. Then I ran the upgrade script against my original db, then imported such things as, news, topics, stats. I installed the league module and imported that information from my old db as well. I did not upgrade because there were several old mods and such that I did not want to install on the site now.

I did not import the users or sessions or any of that.
I have ran the "check"db and "repair" db from within cpanel mysql.

Posted: Fri Mar 30, 2007 1:32 pm

The stats_date table is the only one that is not updating.

Posted: Sat Mar 31, 2007 8:44 am

I don't get it... makes not sense. I don't see that table as having changed in a long time. Maybe try re-creating it using the below SQL:

Code:




DROP TABLE IF EXISTS nuke_stats_date;


CREATE TABLE nuke_stats_date (


  `year` smallint(6) NOT NULL default '0',


  `month` tinyint(4) NOT NULL default '0',


  `date` tinyint(4) NOT NULL default '0',


  hits bigint(20) NOT NULL default '0'


) ENGINE=MyISAM;

Also, one other thing, make sure includes/counter.php isn't corrupt. Try replacing it from the 2.10.00 distro. You might want to try that before you rebuild the table.

Posted: Sat Mar 31, 2007 12:10 pm

I have tried both of your suggestions montego, did not solve the problem. I tried using diff. themes as well. Thought my theme may be the issue some how.

Posted: Sun Apr 01, 2007 7:37 am

If you imported data from your old DB you may wish to just double check the site url in preferences to make sure ts correct.

Posted: Sun Apr 01, 2007 8:36 pm

Checked it, it is correct. Still no daily stats.

Posted: Sun Apr 01, 2007 11:35 pm

So to re-cap;
You have deleted and re-created the stats table, deleted and uploaded a fresh counter.php file and Stats module.
I'll try at look at this on Tuesday night as thats my first bit of free time if no one else has any other sugestions.

Posted: Mon Apr 02, 2007 5:16 am

Yes, that is correct. The only other thing I can think of that I have done is upgraded sentinel. It may be just as easy to start over from scratch I guess.

Thanks for everyones help.

Posted: Mon Apr 02, 2007 5:55 am

kevinkap, I am just befuddled myself. Had you already tried to turn $display_errors to TRUE in config.php and then checked your Apache error logs and any errors on the screen?

How did you know that the issue was only in the nuke_stats_date table and not also in the others?

Posted: Mon Apr 02, 2007 2:18 pm

When I turn it to true, all I get are notices about my theme and the sommaire block.

I did not know it was only that table, that is just the only thing that does not work. I had ran a check on the complete db and tried a repair of the complete db.

Posted: Mon Apr 02, 2007 5:57 pm

Kevin, Is this the same mysql version your using?

In other words, did you change host or did your host upgrade/downgrade?

This is looking as if the issue is based on information Not getting inserted into the tables, and if someone could send me a link to the stats block?
I personally wouldnt mind looking at the code itself and seeing if its not compatible with my setup which is pretty standard with a few exceptions.

Posted: Mon Apr 02, 2007 8:54 pm

No, it is the same server, same everything. Nothing has been upgraded. The site is maysvillesports.com. I appreciate you looking at it. If I do not get it resolved I am just going to delete it and do another install this weekend when I have time to mess with it. I have only installed 3 modules and it should not be to bad I hope. Rolling Eyes

Posted: Tue Apr 03, 2007 6:05 am

kevinkap wrote:

montego wrote:

kevinkap, I cannot recall if you had downgraded from a previous nuke version? The reason I ask, is that I just checked from yesterday to today on my site and it appears that the stats are accumulating properly. So, I just wonder if there is a different in the database somewhere. However, just so you know, I am guessing here as I am not aware of what FB has done, if anything, to stats in later releases. But, might be worth a check if you had downgraded.

Actually, I put my old site, 2.02.02 in a folder, uploaded 2.10 and did a fresh install. Then I ran the upgrade script against my original db, then imported such things as, news, topics, stats. I installed the league module and imported that information from my old db as well. I did not upgrade because there were several old mods and such that I did not want to install on the site now.

I did not import the users or sessions or any of that.
I have ran the "check"db and "repair" db from within cpanel mysql.

The above process still concerns me. I would rather see you take a complete copy of your current 2.02.02 site (replicate it) and then follow the "Upgrade" instructions in the HowToInstall manual.

I still think something has gotten "honked up" in the process you described above.

Darklord, you may just want to keep this in mind as you are helping him.

Posted: Thu Apr 05, 2007 8:37 pm

Well, I almost did as you suggested montego. I pointed my fresh install to my old db that I had already ran the upgrade on. Now my stats work again. I decided to add the newsletter tables and such and remove the un-needed tables from my old db and go that way. Everything seems to be working now.

Posted: Sat Apr 07, 2007 9:16 am

Very strange, but glad its all working.