PHPee.com PHP development forum
Prob with dspStats.php

 
Post new topic   Reply to topic    phpee.com Forum Index -> PPhlogger Support
View previous topic :: View next topic  
Author Message
Michi



Joined: 04 Jun 2004
Posts: 3

PostPosted: Fri Jun 04, 2004 6:43 pm    Post subject: Prob with dspStats.php Reply with quote
Hello,

i have an problem with this file.

Sometime´s i get the correctly list with searchengines, ref´s etc.
and sometime´s i get only the "actually visitors" without the rest.

Since 4 day´s i get only the "acutally visitors" - and nothing more !?

I have pphlooger include in all of my domains, and the prob is only on one page !?

Did you have an idea ?

thx for your answers.
Back to top
View user's profile Send private message
sdjl
Moderator


Joined: 17 Nov 2003
Posts: 791
Location: London, UK

PostPosted: Fri Jun 04, 2004 7:53 pm    Post subject: Reply with quote
So the hits are being logged, but the details about each page aren't being stored?

I've moved this post to Support as it's not technically a bug yet.

David
_________________
-----
Free Logger Accounts | PPHlogger Manual | PM Me
Back to top
View user's profile Send private message Visit poster's website
Michi



Joined: 04 Jun 2004
Posts: 3

PostPosted: Fri Jun 04, 2004 7:58 pm    Post subject: Reply with quote
sure - hits are logged and stored, if the part is runnig, i see all the correct data´s (i hope Wink )
but since 4 day´s, i didn´t see it...
Back to top
View user's profile Send private message
sdjl
Moderator


Joined: 17 Nov 2003
Posts: 791
Location: London, UK

PostPosted: Sat Jun 05, 2004 10:18 am    Post subject: Reply with quote
Do you have a URL and login for an account so i can see this problem for myself?

Thanks,

David
_________________
-----
Free Logger Accounts | PPHlogger Manual | PM Me
Back to top
View user's profile Send private message Visit poster's website
sdjl
Moderator


Joined: 17 Nov 2003
Posts: 791
Location: London, UK

PostPosted: Sun Jun 06, 2004 8:11 pm    Post subject: Reply with quote
Ok, the dspstats.php page won't load for me.
I'm guessing that you have far too many hits/keywords to show for PHP to handle.
This is one thing i have noticed about the current script setup. It keeps building up data about keywords and the links and never removes any of the old stuff.

When the amount of data has built up sufficiently, PHP will have trouble outputtng such a vast amount of data, hence why the page freezes.

You will need to manually remove keywords and/or page hits to get the page working again.

You need to remove the relevant information from the pphl_USERID_mpdl table in MySQL where the type is kw (for keywords) or mp (for page hits).

The only other thing asides from the above that it could be, is a corrupt database table. It might be worth you running the repair option on the table to fix it Smile

Hope this helps.

David
_________________
-----
Free Logger Accounts | PPHlogger Manual | PM Me
Back to top
View user's profile Send private message Visit poster's website
Michi



Joined: 04 Jun 2004
Posts: 3

PostPosted: Sun Jun 06, 2004 8:36 pm    Post subject: Reply with quote
Hello,

at first, thx for your help.

correct Sad

but i haved only 1 MB Data´s and the shop is running since 2 month´s !?
how can i fixed this problem in the future ?

all 1-2 month clean this DB manual is not very funny.
Back to top
View user's profile Send private message
sdjl
Moderator


Joined: 17 Nov 2003
Posts: 791
Location: London, UK

PostPosted: Sun Jun 06, 2004 11:19 pm    Post subject: Reply with quote
Make sure you run the Optimize User table and Optimize Admin Tables in the Admin side of the script.
Its also worth keeping an eye on how many keywords and stats you have logged.

You can edit/delete them from the script itself if there isnt too many for the program to read.

David
_________________
-----
Free Logger Accounts | PPHlogger Manual | PM Me
Back to top
View user's profile Send private message Visit poster's website
Post new topic   Reply to topic    phpee.com Forum Index -> PPhlogger Support All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB 2.0.8
Theme design based on Team 101 Designs, modified by Philip Iezzi