A few weeks earlier we discussed the problem to update /upgrade to version 3.2.08 .
One website, the smaller one, is still running perfectly, displaying statistics and history, the bigger one, about 700 pages, did run perfectly until 3 days ago and now the only thing I see is the continously running load symbol.

As for 5 minutes ago I replaced again the file "cache_creator.php", from the zipfile to the server, makes no difference. The program is run into a loop and keeps running, while the browser shows "ready".

On the smaller website I have not seen a message, holding a new update version 3.0.11 as I see now on the forum.
Is that version holding a solution, or is this error new to you.

Please your advise. 8-)

at first try the new Version...it wouldn't do any harm.

If this doesn't work, I have another thought.

in adminpanel create the cache new - if it works than fine.
If not, have a look at your cache_visitors.php in your log folder - especially at the end of this file.
The we will go on...

Zitat:

cache_visitors.php in your log folder

it's grown up to 4 Mb , can I replace it by a 0bytes file without loosing my data ?

kind regards,
:-/

Hi Dutchguru,

you are talking about the File size of the cache_visitors.php or the logdb_backup.dta?

Have your Server a File size limit? Maybe 4MB .....?  :-/

Husky

Husky schrieb am 02.04.08 um 19:05:42:

Have your Server a File size limit? Maybe 4MB .....?  :-/

probably "Strato"  ;D

So, es hat mir geschmeckt. One has to eat from time to time.

Hi Husky, hi Rumbelstilzchen,

first of all, I didn't make the software, it's rather funny, to see a php file is growing, but if another file or the same file is reproducing itself - it has a 777 chmod - I'm not responsible for that. My business is difficult enough, so I have no enthousiasm to study on the system of web-statistik.

I will point it out ( as the information of the ftp program tells me ):
cache_visitors.php    3.893 Kb  PHP file
directory LOG.

Also in the former item, some weeks ago, I mentioned, the continous running "load" symbol. Possible of course, a loop without risk, also possible a loop with risk of reproducing.

Because of the size, I did not download the php file to see if the end of the file would hold the message "lucky guy: your server is full now". ;D

Logically there is something not working well, only if a certain file or number has increased a maximum , because the other website runs until now without errors. Same version, same files . The same file on that site has a size of 316 Kb, the site holds about 50 pages ( the other one about 700 pages) keeping the string $visitor=array();

Before you guys are too worried about my server ( I appreciate it ) , it 's "made" in Germany......... not Strato ! (I'm familiar with that company ) and has a diskspace of 500 Gigabyte. Price about 2,5 times the banner above is showing  :D  You should know!

Serious again : how do we solve this.
The content of this file in the zip version
<?php ?>
so it 's gonna be filled during install and use..
The saved file of version 3.122, saved before install of version 3.2 has a size of 10.915 Kb.

The need of a statistical program is obvious, in a range of 3 years, this is the third one for me. Probably the number of pages is to high, the number of unique visitors each day about 1500-1700, and for good understanding it's only one domain. My other 20 domains has only Google analytics. So please, give me some hint.

Rumbelstilzchen schrieb am 02.04.08 um 17:35:08:

If not, have a look at your cache_visitors.php in your log folder - especially at the end of this file.

Do you check that?

Parse error: syntax error, unexpected $end, expecting ')' in ..................../getit/log/cache_visitors.php on line 59879


Look at the end of the file - it must be something like this:
[code]"29" => "1" ,
"24" => "2" ,
"32" => "2" ,
"43" => "1"

);


?>[/code]

Husky
P.s: For the next couple of hours i am out with my dogs .... und geschmeckt hat es auch!  ;D ;D ;D

Hello Husky,

Well, if you have that kind of dogs, I wouldn't be supprised if it will be some hours indeed. If you are use them in the way they are usualy used for, it's more a "giddy up go" than running after the dogs, see some trees , waiting until they have  read there news on the ground and than back home again.

No and yes, the first time Rumbelstilzchen asked to look at the end of the file, with all respect, I had the idea, if that should be the problem, than it's a programmers fault and it will repeated the next try. So I did not.

Asking it twice, I cannot refuse to download the file, check the whole 4 Mb until the end of the file in my php-editor, wich alerts already on the first line that the end of the file would be incorrect. So it was.

If I take your example :
"32" => "2" ,
"43" => "1"
);
?>

the result of the file was after the comma, behind "2",  : end of file.

So I deleted the comma, additional placed the "); ?>"  and uploaded the file to the server.

Last date of the file was 31-3-2008, so starting up the statistics and there we go again, loading round and round and round .... and so on.
Content of the file is all between $visitors_hour until searchwords-archive array.

It didn't supprised me because somewhere has to be a programming problem, the most simple one is overwrite the ); ?> and forget the last item because of the fact : the comma is the last character.

Looking for that kind of source, will take days to search all the files plus some days more to understand how the structure is made. Too difficult for a simple programmer. I'm able to program in php for simple tools I need for my business, certainly not a professional.

So here we are, in the middle of nowhere. In particular,  at the end of the day Middle European Time, 12:00 pm, I'm not going to walk with my dogs, I'm gathering some presents from the sandman.  ;D

schrieb am 03.04.08 um 00:02:56:

Well, if you have that kind of dogs, I wouldn't be supprised if it will be some hours indeed. If you are use them in the way they are usualy used for, it's more a "giddy up go" than running after the dogs, see some trees , waiting until they have  read there news on the ground and than back home again.

That's absolute right!!!! How do you know that?  ;D ;D ;D

Ok - back to your problem! I'm not sure .... I guess that can be a Server restriction  :-/

If you like then can we test your logs on one of my servers. I can make the test with your current version and with the newest version of the PHP WebStat.

I'm tomorrow back to European Sandman time  ;D

Husky

Zitat:

I guess that can be a Server restriction

Don't think so , Husky, 2 different domains, but 1 server.

Same file on the smaller site ends like this:
"64" => "22" ,
"66" => "1" ,
"68" => "1" ,
"69" => "1"
);
?>

regarding to the entry_site array,

the bigger one is cutting of, during the searchwords, is the one before entry_site. Therefor I think it's a maximum / capacity problem.

best regards :)

is this the ending of the file after recreating the cache? It doesn't seem so.

Hi  Rumbelstilzchen,

What you are reading above is the same file of the little website, different domain, same server.

On your advise I used the button Stat Reset, a few days earlier.

Yesterday I repaired the file, described above,
5 minutes earlier I've download the file and these are the last 3 of 48.241 rows, part of $referrer array, cut off after the comma as you can see.


"http://www.google.nl/search?q=delfts blauw bekleding" => "1" ,
"http://www.google.nl/search?q=zeyko keukens" => "1" ,
"http://www.google.nl/search?q=veranda verosol" => "1" ,

Of course I can hit the buttons "Delete Archive Cache" and / or "Delete Cache", but if a file is cut-off like this, it will be repeated in my point of view.

As I wrote before, the same error I have seen in the former version 3.200. Current version 3.208

sysinfo :
cache_visitors.php      3119 KB      48241      666      
all files on green color.
???

@Husky,

don't want to hurry you up, but I have sent the file on april the third, now I'm a little bit anxious if it's arrived.  8-)

schrieb am 06.04.08 um 12:06:39:

.... want to hurry you up....

Hihi - maybe you can try it, but ... ;D

Until now no file arrived! If you like you can give me optional a download link ...

regards
Husky

Uuuuuuuuuups - sorry - my fault!!!!  :'(

Your Mail arrived but it was catch by the Spamfilter.

Now I will have a look ....  ::)

Husky

No problem, Husky, perhaps it's a good filter because it has found some error in it  :)

Hi Dutchguru,
bad news!  :(

Your cache_visitors.php is absolut defect - and I doesn't know why!
After $referer is everythink missing! That is not just a comma!
Missing parts are:
$country,
$searchengines_archive,
$searchwords_archive,
$entrysite,

Sorry, I can't see the reason :-( but that explain why it doesn't run! And I have no Idea how we can fix it!

Your files are growing up to very big files ..... maybe .... ?!???

Husky

@R&H
Any Idea?

My fears become true - I need the cache_visitors.php, the problem could be relatet with ' and " , some times ago I sent a fix but it was ignored >:(

Rumbelstilzchen schrieb am 06.04.08 um 22:21:30:

I need the cache_visitors.php

Which address?  ;)

Husky

@dutchguru
Rumbelstilzchen inspect your cache_visitors.php.

Be hopeful!  ;)

Husky

it doesn't look like I've expected it, but the error is definitely in your pattern_referer.dta .
And as it isn't the same error I had, I need a copy of your file to provide you a simple fix.
The address I PM you

@Husky,

Zitat:

Be hopeful!

Of course I am, it's better than a visit at the dentist   ;D  

@Rumbelstilzchen,
At 08:51 this morning (m.e.t.)  the carrier-pigeon has left my pc flying in the direction of Germany, I'm living at about 15 miles west of the border on the level of  Oldenburg, so in a couple of seconds it should arrive........ if your post-office will accept a package of about 2 Mb    8-)

To be honest I don't exactly know what the error causes - it's different from the ones I had.

The only thing I'm wondering about is in line 144454 a blank.
And as your cache_vistors.php shows the error has to be somewhere around line 144453

so what I would do is:

• again download the patter_referrer.dta
  
• change line 144454 from
  Code (]http://www.google.nl/search?q=Brunotti |10717[/code):
  

  to [code]http://www.google.nl/search?q=Brunotti|10717

  
  
• and upload it again.
  

Be sure to make a backup before. Do those steps while you expect less visitors and do it quickly. If you are able to edit the file directly on the server, do it that way.

@Rumbelstilzchen,
As I said before,I'm not a profi in php, but.... if I see it with my dumby eyes :

1. I have not a remote php editor, I should have a remote hexa-editor to change only one byte ;

2. not earlier, but now I 've got a look at the content of that file,
cache_visitors.php is storing data in an array.
It was not ready when it stopped working, so it ends with a comma.

last used item was a search on "veranda verosol", found at 14 44 53 in the file pattern_referer.dta, wich seems to be a normal csv file, delimited with a pipe.

because both lines, 53 and 54 holds no scilly characters,


Zitat:

Brunotti |10717

holds only a hex 20 is a normal space character, wouldn't harm a string as far as I can see.

so far, not good  :'(

If I should remove that particular space character in a "text-database-file"  it would be only and shortly waiting untill the next "explosion", because we did nothing with the source of the problem.

Looking at these dta's, all the same pipe delimited's, :
logdb.dta,
logdb-counter.dta
are all ending on a hex 0A followed by a null byte.

pattern_referer.dta ends with a null byte, without a hex 0A.

A.
Could it therefore be possible, the source script is looking behind the EOF,  ends unproperly without displaying an error because of passing 30 seconds php script working time ? ( before asking : I cannot change that time) or passing beause of surpressing errors ?

B.
Wich script is handling this , so I can look at it ?

C.
wich script is handling the ( omitted) 0A ....null byte sequence

Perhaps then we will find the source of the ..  remember, I had this error also in the former versions.

But if I'm the only one with this kind of huge files, it's the wrong trail and is Web-statistik only usable with smaller websites or it needs a longer php working time than 30 seconds. :-/

OK you're right it shouldn't be the blank as it occurs earlier in that file too.

It also shouldn't be the execution time.

Hi Rumbelstilzchen,


Zitat:

as it occurs earlier in that file too.

for instance :
115 http://www.google.nl/search?q=inkomen starters |114
179 http://www.google.nl/search?q=slq019 seiko |178
76726  http://www.google.nl/search?q=oorsprong brunotti |23362   (?)

I'm working regularly with csv and pipe,semicolon,tab and so on.
To handle you can work with regex or (most common) get it into an array.

Looking for the existing space and pipe wasn't that difficult, now that other part.

wich script is handling what, because I don't know the structure, it's a tremendous hell of a job to look for this part, so if you can tell me wich script is the case, that would be helpfull.

---------
additional :
the admin part has 3 buttons, cannot find the exact meaning :
1.delete cache
2. delete archive cache
3. stat reset.
Can you tell, what each button does, and the difference ? :)

for investigating, have a close look at cache_creator.php

1. deletes your cahce_visitors.php and creates a new one out of those *.dta files (this one is used for displaying the stat)
2. you can save special periods of time, those are called archive and can be deleted there
3. deletes all your logged data (those *.dta files) - for starting with a clean stat.

Zitat:

1. deletes your cahce_visitors.php and creates a new one out of those *.dta files (this one is used for displaying the stat) 2. you can save special periods of time, those are called archive and can be deleted there 3. deletes all your logged data (those *.dta files) - for starting with a clean stat.

Not working software, so how much could I loose?
So I hit these buttons from right to the left, checked the info with my ftp program>>>>> no result whatsoever, started the normal page and guess what, cache is build up again,  it runs. Somebody who understands this ?

Nope!  ;D ;D ;D