pligg_pageviews too big

[ditto]

Originally Posted by Yankidank

All you have to do is change the "Show last visit" option to false from /admin_config.php?page=Story. This is something we should probably have switched off by default.

I have disabled this an anything else related to page views, and still my pligg_pageviews table keep grow bigger and bigger for every day.

This question has been asked many times before in this forum, and it would be nice to get some more information about it. Can we empty pligg_pageviews table without problems? Also please give us some more information about what else this table does and how it works.

[gen3ric]

I've had show last visit disabled since I installed but my pageviews table was still filling up at the rate of nearly 3MB a day so I disabled the stats plugin just dropped the table and haven't had any problems as a result.

[ditto]

Originally Posted by gen3ric

just dropped the table and haven't had any problems as a result.

Thank you for sharing! To be absolute sure about it: Does "dropped" mean that you deleted the table entirely?

[maiti]

Hello i think i fix it :smile: my pligg_pageviews table is not getting bigger anymore

If i fix it.... here is the way how i did it

(it worked for me on Pligg 9.8)

first copy your user.php, user_center.tpl and pageview.php files somewhere.

root/user.php delete

1. lines from 54 to 56
2. line 64
3. lines from 66 to 93

root/templates/yget/user_center.tpl delete

lines from 399 to 406

root/libs/pageview.php delete

lines from 16 to 23

:pfew: i hope i helped

[xiesi]

it don't work for 9.9.0

[peppolone]

for 9.9 remove $pageview->insert(); from story.php

[davemackey]

I think we can actually remove more code than that. I commented out the following:
// log the pageview
// $pageview = new Pageview;
// $pageview->type='story';
// $pageview->page_id=$link->id;
// $pageview->user_id=$current_user->user_id;
require_once(mnminclude.'check_behind_proxy.php');
// $pageview->user_ip=check_ip_behind_proxy();

// find the last pageview
// $last_visit = $pageview->last_visit();
// if($last_visit != 0){$last_visit = txt_time_diff($pageview->last_visit(), time());}
// $main_smarty->assign('last_visit', $last_visit);
// $pageview->insert();
Just to note: I like removing/commenting out unnecessary code as possible. There is no need to have processes running which will consume CPU cycles if we just want to disable the functionality anyways.
David.

[kbeeveer46]

There are three types of page views

• One when you view a story on story.php
• One when you click the story title to view the external link
• And one when you view a profile

You have to remove/disable the code for all three of these situations for your pageviews table to stop growing. It has been suggested above to turn off several features. That will not actually stop the table from getting larger. The table will continue to get larger even though you don't use it. Remove the table and the code completely to fix your problem.

[netfreak]

I think you can have a look on this you might like this one.. >>

http://forums.pligg.com/core-develop...mizing-db.html

[micxuy]

I just comments out all the functions in user.php, out.php, user.php and libs/pageview.php

Then delete database, it works cool