My MySQL database kills host's cpu

[fightlinker]

Okay, sorry to keep bugging about this ... one last question : If the query in question is only getting pulled when a person visits the profile page of a user, would I be able to stop it by simply deleting the file in pligg that displays that info? I need a quick fix to this issue, my site has been down for 4 days now!

[kbeeveer46]

Try removing the code in user_center.tpl under the profile section. It will be something along the lines of "last viewers"

[johntheentrepreneur]

delete a whole bunch of pageviews entries....that the problem will be gone....

i've run into this problem a few times........it's the sql statement they send you that is causing the problem....

each time I just delete a whole bunch of pageview entries in the database

[AshDigg]

If anyone is still having this problem, a fix will be in the next release, or you can update your copy using the changes listed here. Then run upgrade.php. There will then be a 'PageViews' section in the admin config area.

[nothingman]

Thanks Ashdigg. I went to the sourceforge repository and here's what I understood. Hope I'm not wrong.

Step1: Download the sourceforge files and replace the templates/yget/user_center.tpl and /user.php files
Step2: Execute the upgrade_config_table.sql on my database
Step3: finally, run upgrade.php?

Hope I got that right? :-/

[AshDigg]

You don't need step 2. That file is for new installs. Other than that you're correct.

[realest]

Hi all.
the same problem happened today with my site

the hosting provider suspended account because of page views load in database.
i am using d-nature template i think 9.0 version
the pageviews table was 15mib big so i delete almost 13 mib and removed lines in user_center.tpl from 280-283 :

{#PLIGG_Visual_User_Profile_Last_5_Title#}<br>
{section name=customer loop=$last_viewers_names}
<img src="{$last_viewers_avatar[customer]}" alt="Avatar" align="absmiddle"> <a href = "{$last_viewers_profile[customer]}">{$last_viewers_names[customer]}</a>
{/section}

Im asking is there anything else i can do so that the problems dont happen again.
thanks

[nothingman]

realest, I have done the following and well, i think it has worked.
Go to the the sourceforge repository that ashdigg talked about. Once there, do the following:

Step1: Download the sourceforge files and replace your current templates/yget/user_center.tpl, and <siteroot>/user.php files.
Step2: Also replace the /install/upgrade.php, under your install folder (i.e. assuming it is stil there.
Step3: Execute /install/upgrade.php

That worked for me and it'd help if the pligg masters confirmed it :)

[realest]

ow thanks.... i hope it will help because i got suspended again :\ now im waiting for access to ftp again.
and yeah the template is digitalnature and i see that here user_center.tpl file is from yget template, does that matter ?

[nothingman]

Sorry realist, I have no idea. It shouldn't matter, but please don't take my guess work. As a suggestion, why don't you first create a back up of the user_center.tpl file and test it out? :)