WARNING PHP

Report bugs of current version 2.2.5 here!

Moderators: Moderator Team, Development Team

WARNING PHP

Postby purasorte on Sun Nov 16, 2003 8:36 pm

What does it means:
x
I've many warnings like this.
Thank you
Last edited by purasorte on Wed Oct 04, 2006 7:14 pm, edited 2 times in total.
purasorte
 
Posts: 12
Joined: Sat Nov 15, 2003 3:03 am

code

Postby purasorte on Sun Nov 16, 2003 8:45 pm

I forgot the code in "[color=darkblue][i]xx
Last edited by purasorte on Wed Oct 04, 2006 7:15 pm, edited 3 times in total.
purasorte
 
Posts: 12
Joined: Sat Nov 15, 2003 3:03 am

Postby sdjl on Mon Nov 17, 2003 11:11 am

What page were you on when this error occured?

David
User avatar
sdjl
Moderator
 
Posts: 1282
Joined: Mon Nov 17, 2003 1:13 am
Location: London, UK

Postby purasorte on Mon Nov 17, 2003 6:23 pm

sdjl wrote:What page were you on when this error occured?

I"ve about 300 pages using phplogger 2.5.
The main page is http://www.xxxxxxx.com/
This pages have 30.000 pageviews/day
May be this is the problem
Last edited by purasorte on Wed Oct 04, 2006 7:11 pm, edited 1 time in total.
purasorte
 
Posts: 12
Joined: Sat Nov 15, 2003 3:03 am

Postby sdjl on Mon Nov 17, 2003 11:23 pm

Ah right, so it actually appears when you try and display the logger output.
Is 30,000 unique hits? If so, it could be that.

Becuase the DB is being written to so often it might not be getting enough time to work out the num_rows.

David
User avatar
sdjl
Moderator
 
Posts: 1282
Joined: Mon Nov 17, 2003 1:13 am
Location: London, UK

Postby purasorte on Mon Nov 17, 2003 11:40 pm

Thank you David
It's only 30.000 pageviews/day
I'll try upload all files again

Another question:
The data base is growing and growing. How to set PPhlogger to avoid this.
Sorry bad English

Luiz
purasorte
 
Posts: 12
Joined: Sat Nov 15, 2003 3:03 am

Postby sdjl on Tue Nov 18, 2003 12:33 am

I would imagine your site has too many hits for the logger to handle. I think it was said that over 10,000 hits per day would start to cause performance issues.

I find that removing keywords and multi-pages every once in a while helps stop the database growing in size.

David
User avatar
sdjl
Moderator
 
Posts: 1282
Joined: Mon Nov 17, 2003 1:13 am
Location: London, UK

2 warnings

Postby purasorte on Fri Nov 21, 2003 2:07 am

Thank you David

After re-upload the files I get not 1 but 2 warnings each time :oops: :

I really would like to use phplogger but it don't like me :-)

Luiz
Last edited by purasorte on Wed Oct 04, 2006 7:12 pm, edited 1 time in total.
purasorte
 
Posts: 12
Joined: Sat Nov 15, 2003 3:03 am

Postby sdjl on Fri Nov 21, 2003 2:20 am

When i visit that URL you provided, i can see no errors?
Have you got it fixed?

David
User avatar
sdjl
Moderator
 
Posts: 1282
Joined: Mon Nov 17, 2003 1:13 am
Location: London, UK

error

Postby purasorte on Fri Nov 21, 2003 3:41 am

There are no errors, thereare warnings in the serverlog's

During a day the warnings appears about 100 times to about 30000 pageviews.

x
Last edited by purasorte on Wed Oct 04, 2006 7:12 pm, edited 1 time in total.
purasorte
 
Posts: 12
Joined: Sat Nov 15, 2003 3:03 am

Postby sdjl on Sat Nov 22, 2003 12:48 am

Oh right!!
I understand what you mean now!
Should have mentioned "serverlog" from the beginning!

I also get these errors in my server logs, ill have a look into it and see what the issue could be and post any resolve that i find :)

David
User avatar
sdjl
Moderator
 
Posts: 1282
Joined: Mon Nov 17, 2003 1:13 am
Location: London, UK

Postby sdjl on Sat Nov 22, 2003 1:04 am

Ok, i think i've found the problem.
I'm just going to do some checks to verify that this is the problem.

I'll post again with an update shortly.

David
User avatar
sdjl
Moderator
 
Posts: 1282
Joined: Mon Nov 17, 2003 1:13 am
Location: London, UK

Postby sdjl on Sat Nov 22, 2003 1:19 am

Ok, here's what i think has happened:

When the pphlogger.php file tries to insert keywords into the relevant users _mpdl database table it doesn't pass the table name over to the function correctly.
This means that because it has a blank table name, when it tries to execute the SQL it fails and returns the errors logged in your server logs.

I'm not entirely sure if this a successful edit or not, only time will tell really!
I have tested it though and it doesn't appear to cause any issues/errors to the current setup.

Here's what you need to do:

1) Locate the following code in pphlogger.php (Line: 190ish)
Code: Select all
insert_keyw($keywrd[3]);


2) Replace the above code with the following:
Code: Select all
insert_keyw($keywrd[3], $tbl_mpdl);


The new code basically defines the table to be used when inserting keywords.

Give it a day or two and see if your server log file cuts down in size.

Keep me posted!

David
User avatar
sdjl
Moderator
 
Posts: 1282
Joined: Mon Nov 17, 2003 1:13 am
Location: London, UK

Postby purasorte on Sat Nov 22, 2003 3:47 am

sdjl wrote:Oh right!!
I understand what you mean now!
Should have mentioned "serverlog" from the beginning!

Sorry

Hello David,
I made the changes posted here.
I'll tell you soom about the results.
Thank You very much

Luiz
purasorte
 
Posts: 12
Joined: Sat Nov 15, 2003 3:03 am

Mr. Google

Postby purasorte on Tue Dec 02, 2003 12:12 am

The warnings continues:
x

but something of new appeared: I analyzed acesslog of the server and discovered that all the warnings are being generated for visits comings of the Google. He looks at the examples below:
x
another example:
x
Some idea ?

x
Last edited by purasorte on Wed Oct 04, 2006 7:13 pm, edited 1 time in total.
purasorte
 
Posts: 12
Joined: Sat Nov 15, 2003 3:03 am

Next

Return to PPhlogger bug reports

Who is online

Users browsing this forum: No registered users and 1 guest

cron