>> Site Map >> Forums >> General 6x
Forum module - topics in forum:
General 6x - Discussions reagarding any other PHP-Nuke Problems.
Detailed stats not working
I posted this as a tag on to another post, but recieved no responce, so figured I put it in it's own.....
I'm running nuke 6.9 and the detailed stats appear to be blank. Take a look- www.audifans.net
Not worked since I migrated hosts, wondered if I'd missed something in the migration. Everything else appears to be working fine........
Last time I had it working, we were doing 12k page views/ day- wondered where we were at now, but can't tell......
| Quote: : |
Audifans.net Access Statistics We received 4773041 page views since 30 January 2003 Today is: 21/04/2005 Busiest Month: 0 0 (0 Hits) Busiest Day: 0 0 0 (0 Hits) Busiest Hour: 00:00 - 00:59 on 0 0, 0 (0 Hits) [ Return to Basic Statistics ] Yearly Stats Year Page Views Montly Stats for 2005 Month Page Views Daily Stats for April, 2005 Date Page Views Hourly Stats for April 21, 2005 |
Spot the blanks!
Any help suggestions etc. appreciated.
Cheers.
Andy
Looks like all your nuke_stats tables are missing to me.
The first page is controlled by nuke_counter, second page by 4 stats tables.
| Code: : |
-- -- Table structure for table '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' ) TYPE=MyISAM; -- -- Dumping data for table 'nuke_stats_date' -- -- -- Table structure for 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' ) TYPE=MyISAM; -- -- Dumping data for table 'nuke_stats_hour' -- -- -- Table structure for table 'nuke_stats_month' -- CREATE TABLE nuke_stats_month ( year smallint(6) NOT NULL default '0', month tinyint(4) NOT NULL default '0', hits bigint(20) NOT NULL default '0' ) TYPE=MyISAM; -- -- Dumping data for table 'nuke_stats_month' -- -- -- Table structure for table 'nuke_stats_year' -- CREATE TABLE nuke_stats_year ( year smallint(6) NOT NULL default '0', hits bigint(20) NOT NULL default '0' ) TYPE=MyISAM; -- -- Dumping data for table 'nuke_stats_year' -- |
Thats from the nuke.sql file for 6.9
Think he needs more than that D.
He needs the data too.
All I can think is they didn't go on when he moved his site.
at least with the blank tables in place tho it will start collecting the stats....
| Dirk Wrote: : |
| at least with the blank tables in place tho it will start collecting the stats.... |
But then he'll get a mismatch between counter and stats table.
He really needs to use a 5 tables from a backup if he has one.
I *really* shouldn't read emails/ follow links when I have had a drink or a bottle.....!
Both of you know what you are talking about, both are right. (Trust me, in this state, I know)- but WHICH do I need to do?
Would the bits from my "includes" help?
Maybe?
Please be gentle, my head will *really* hurt in the morning when you read this
| Quote: : |
| Would the bits from my "includes" help? |
I'm sure you know what you mean but I don't
Read thru the post again tomorow when your head is clear.
OK,
I meant my includes.php and "others"
I understand regarding "check back tomorrow"... only will be sober.... (yay!) and driving (yay!) so may need to wait temporarily...... until I get back to the PC (sober????)
LOL
Thankyou. Another donation needs to make it's way......
Andy.
PS. I'm tiddly, so what? I still understand the importance of the work these guys do - unpaid- to try to help idiots like me....!
Nothing to do with your includes I think..... unless you happily added anything in there stopping your stats being recorded....
| dar63 Wrote: : | ||
But then he'll get a mismatch between counter and stats table. He really needs to use a 5 tables from a backup if he has one. |
I should still have the back up from when I moved hosts....... (I remember it being a real beyatch- sql file was too big to upload.... and had to be inserted into the database on the new host manually, in bits, so I could have quite easily have missed it.)
I didn't know if it would have been related to the Sentinel installation as well- I know you need to amend/ replace some files....
Oh, cheers guys- my head isn't hurting.... yet
LOL
If you still have the sql file - grab the 5 tables needed into your DB - Nuke_counter and all the nuke_stats ones (4 of em)
cheers. I'll look for them Sunday when I get back- I'll also do an sql dump to see if there are any listed before I try to insert them..........
OK,
I'm sober (yaay! took me this long
)The tables were missing, so I've inserted them.
And uploaded the data.
Only, I now have another problem, and it's easier of you go look at my stats (detailed):
There's 62 instances of the 9th of May!!!!
The whole lot's goosed, so I've gone a tad wrong somewhere.....
Ideas, please? (before I get back from the fridge with a cold one
)Ok, update:
I've emtpied the contents of the tables, but managed to keep the table structures.
It will now start recording again "live"- but how do I add the extra data without creating additional sections in the database?
