1
Discussion & Troubleshooting / Re: hight CPU with 50 visit per day!!!
« on: January 02, 2012, 06:24:12 PM »
I too modified to be updated. Especially since earlier worked fine.
Show Posts
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
Pages: [1] 2
2
Discussion & Troubleshooting / hight CPU with 50 visit per day!!!
« on: January 02, 2012, 01:38:22 PM »
Version: 1.7.7
50 visit per day
I received ticket from hostgator:
50 visit per day
I received ticket from hostgator:
Quote
Hello,
I apologize, but I was forced to suspend the scripts within /home/artporta/public_html as it was causing a high load on the server, and due to it affecting all of the other accounts on the system, I forced to take immediate action for the health of the server.
Unfortunately I do not have any specific recommendations for this script, however, in general, adding some sort of caching mechanism, where the script does not need to generate a new page with every request, helps to lower the over load that a script will cause. Likely the original author or support group of the software that you are using will be able to help you to understand how to add something of this nature.
One of the primary causes of this issue is the length of time that these processes are running and requiring CPU usage. There may be additional steps required to assist your script in completing quicker, such as minimizing remotely included content.
If you reply back to this with your IP address (http://www.hostgator.com/ip.shtml) we will be more than happy to go ahead enable HTTP access for you, so that you can safely work on the script without it causing further issues.
Please let us know how you would like to proceed.
Running Processes:
artporta 9720 0.0 0.1 36044 14828 ? DN 03:21 0:00 /usr/bin/php /home/artporta/public_html/categories.php
artporta 9760 0.0 0.1 36044 14828 ? SN 03:21 0:00 /usr/bin/php /home/artporta/public_html/categories.php
artporta 10390 0.0 0.1 36044 14832 ? SN 03:22 0:00 /usr/bin/php /home/artporta/public_html/categories.php
artporta 10470 0.0 0.1 36044 14828 ? SN 03:22 0:00 /usr/bin/php /home/artporta/public_html/categories.php
artporta 11337 0.0 0.1 36044 14832 ? SN 03:22 0:00 /usr/bin/php /home/artporta/public_html/categories.php
artporta 11843 0.0 0.1 36044 14828 ? SN 03:23 0:00 /usr/bin/php /home/artporta/public_html/categories.php
artporta 11872 0.0 0.1 36044 14832 ? SN 03:23 0:00 /usr/bin/php /home/artporta/public_html/categories.php
artporta 11939 0.0 0.1 36044 14816 ? SN 03:23 0:00 /usr/bin/php /home/artporta/public_html/categories.php
artporta 12628 0.0 0.1 36044 14828 ? SN 03:24 0:00 /usr/bin/php /home/artporta/public_html/categories.php
artporta 12644 0.0 0.1 36044 14832 ? SN 03:24 0:00 /usr/bin/php /home/artporta/public_html/categories.php
artporta 12655 0.0 0.1 36044 14828 ? SN 03:24 0:00 /usr/bin/php /home/artporta/public_html/categories.php
artporta 12742 0.0 0.1 36044 14816 ? SN 03:24 0:00 /usr/bin/php /home/artporta/public_html/categories.php
artporta 13265 0.0 0.1 36044 14868 ? SN 03:25 0:00 /usr/bin/php /home/artporta/public_html/index.php
artporta 13416 0.0 0.1 36044 14884 ? SN 03:25 0:00 /usr/bin/php /home/artporta/public_html/index.php
Running Queries:
Current Site Requests:
141.170.229.44 artportal.in.ua /
141.170.229.44 artportal.in.ua /
141.170.229.44 artportal.in.ua /cat2.htm?page=17
141.170.229.44 artportal.in.ua /cat2.htm?page=17
141.170.229.44 artportal.in.ua /cat2.htm?page=18
141.170.229.44 artportal.in.ua /cat2.htm?page=19
141.170.229.44 artportal.in.ua /cat2.htm?page=19
141.170.229.44 artportal.in.ua /cat2.htm?page=19
141.170.229.44 artportal.in.ua /cat2.htm?page=19
141.170.229.44 artportal.in.ua /cat2.htm?page=19
141.170.229.44 artportal.in.ua /cat2.htm?page=19
141.170.229.44 artportal.in.ua /cat2.htm?page=19
141.170.229.44 artportal.in.ua /cat2.htm?page=20
141.170.229.44 artportal.in.ua /cat2.htm?page=20
157.55.17.199 artportal.in.ua /profile519.htm
[Sat Dec 31 03:40:18 CST 2011] Server Load Before Suspension: 71.58, 69.76, 46.55
[Sat Dec 31 03:40:18 CST 2011] Suspending /home/artporta/public_html!
Waiting 60 Seconds for Server Load.
[Sat Dec 31 03:41:19 CST 2011] Server Load After Suspension: 62.29, 67.75, 47.34
Waiting 60 Seconds for Server Load.
[Sat Dec 31 03:42:19 CST 2011] Server Load After Suspension: 46.27, 62.22, 46.72
3
Mods & Plugins (Releases & Support) / Re: [Mod] Photo Of The Day
« on: September 29, 2009, 07:48:15 PM »Code: [Select]DB Error: Bad SQL Query: SELECT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords, i.image_date, i.image_active, i.image_media_file, i.image_thumb_file, i.image_download_url, i.image_allow_comments, i.image_comments, i.image_downloads, i.image_votes, i.image_rating, i.image_hits, c.cat_name, u.user_name FROM 4images_images i, 4images_categories c LEFT JOIN 4images_users u ON (u.user_id = i.user_id) WHERE i.image_active = 1 AND i.cat_id NOT IN (0) AND c.cat_id = i.cat_id ORDER BY i.image_comments DESC LIMIT 1How can I fix that? Please help me!
Unknown column 'i.user_id' in 'on clause'
Regards,
Code: [Select]
$sql = "SELECT DISTINCT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords, i.image_date, i.image_active, i.image_media_file, i.image_thumb_file, i.image_download_url, i.image_allow_comments, i.image_comments, i.image_downloads, i.image_votes, i.image_rating, i.image_hits, c.cat_name".get_user_table_field(", u.", "user_name")."
FROM (".IMAGES_TABLE." i, ".CATEGORIES_TABLE." c)
LEFT JOIN ".USERS_TABLE." u ON (".get_user_table_field("u.", "user_id")." = i.user_id)
WHERE i.image_active = 1 AND i.cat_id NOT IN ($cat_id_sql) AND c.cat_id = i.cat_idHow to show TOP 3 images by 'rating'?
4
Mods & Plugins (Releases & Support) / Re: [MOD] Post It! (updated 08.01.2006)
« on: September 16, 2009, 02:34:00 PM »
Ho-ho!
Thank you very much!
Thank you very much!
5
Mods & Plugins (Releases & Support) / Re: [MOD] Post It! (updated 08.01.2006)
« on: September 15, 2009, 06:49:47 PM »
I test on other computer in other network sigment in Ukraine and have error. Please help!
it is my address in popup window
with parametr
without parametr
it is my address in popup window
with parametr
Code: [Select]
http://artportal.in.ua/postit.php?url=http://artportal.in.ua/img859.htm?l=russian&name=%D0%9C%D0%B0%D0%BA%D0%BE%D0%B2%D1%8B%D0%B9%20%D0%BA%D0%BE%D0%B2%D0%B5%D1%80&cat_id=2&media_url=45991.jpg&thumb=45991.jpg&height=533&width=800&size=473.2%C2%A0KBwithout parametr
Code: [Select]
http://artportal.in.ua/postit.php?url=http://artportal.in.ua/img859.htm&name=%D0%9C%D0%B0%D0%BA%D0%BE%D0%B2%D1%8B%D0%B9%20%D0%BA%D0%BE%D0%B2%D0%B5%D1%80&cat_id=2&media_url=45991.jpg&thumb=45991.jpg&height=533&width=800&size=473.2%C2%A0KB
6
Mods & Plugins (Releases & Support) / Re: [MOD] Post It! (updated 08.01.2006)
« on: September 15, 2009, 12:05:53 PM »
hm..
When a link like "http://artportal.in.ua/img859.htm" - there are no errors, but when a link like "http://artportal.in.ua/img859.htm?l=russian" - an error in all browsers.
When a link like "http://artportal.in.ua/img859.htm" - there are no errors, but when a link like "http://artportal.in.ua/img859.htm?l=russian" - an error in all browsers.
7
Mods & Plugins (Releases & Support) / Re: [MOD] Post It! (updated 08.01.2006)
« on: September 14, 2009, 07:03:17 PM »8
Mods & Plugins (Releases & Support) / Re: [MOD] Post It! (updated 08.01.2006)
« on: September 12, 2009, 12:00:30 AM »Code: [Select]
Service Temporarily Unavailable
The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later.everything works without ?l=russian parameter
9
Mods & Plugins (Releases & Support) / Re: [MOD] Post It! (updated 08.01.2006)
« on: September 10, 2009, 04:03:30 PM »
Hi All!
I use multilanguage support in my site and my url look like thise
With parametr ?|=language I received error.
I use multilanguage support in my site and my url look like thise
Code: [Select]
http://youpages.com/img849.htm?l=russianWith parametr ?|=language I received error.
10
Mods & Plugins (Requests & Discussions) / futured works
« on: September 02, 2009, 06:18:46 PM »
Hi guys!
How to create a module that shows on front page of 3-4 selected works separate block. Works selected by the administrator, through billing or which have a maximum of votes?
How to create a module that shows on front page of 3-4 selected works separate block. Works selected by the administrator, through billing or which have a maximum of votes?
11
Mods & Plugins (Releases & Support) / Re: [Mod] Mail Owner of image when Comment is Posted
« on: August 23, 2009, 12:11:12 AM »
Hi All.
I don't receive any comment_mail.
But when I sent email from ACP
What's wrong?
I don't receive any comment_mail.
Code: [Select]
#
193.43.222.3 - - [22/Aug/2009:14:26:14 -0700] "POST /ajaxcomments.php?l=ukrainian&js&commentbg=1&l=ukrainian HTTP/1.1" 200 1409 "http://xxx.com/img653.htm?l=ukrainian" "Mozilla/5.0 (Windows; U; Windows NT 5.1; uk; rv:1.9.1.2) Gecko/20090729 Firefox/3.5.2 WebMoney Advisor"
#
193.43.222.3 - - [22/Aug/2009:14:26:35 -0700] "GET /admin/email.php?action=emailusers&l=ukrainian HTTP/1.1" 200 5281 "http://xxx.com/admin/index.php?action=nav&l=ukrainian" "Mozilla/5.0 (Windows; U; Windows NT 5.1; uk; rv:1.9.1.2) Gecko/20090729 Firefox/3.5.2 WebMoney Advisor"
193.43.222.3 - - [22/Aug/2009:14:26:35 -0700] "GET /admin/email.php?action=emailusers&l=ukrainian HTTP/1.1" 200 5281 "http://xxx.com/admin/index.php?action=nav&l=ukrainian" "Mozilla/5.0 (Windows; U; Windows NT 5.1; uk; rv:1.9.1.2) Gecko/20090729 Firefox/3.5.2 WebMoney Advisor"
#
193.43.222.3 - - [22/Aug/2009:14:26:40 -0700] "GET /admin/settings.php?action=modifysettings&l=ukrainian HTTP/1.1" 200 5538 "http://xxx.com/admin/index.php?action=nav&l=ukrainian" "Mozilla/5.0 (Windows; U; Windows NT 5.1; uk; rv:1.9.1.2) Gecko/20090729 Firefox/3.5.2 WebMoney Advisor"
#
193.43.222.3 - - [22/Aug/2009:14:26:40 -0700] "GET /admin/settings.php?action=modifysettings&l=ukrainian HTTP/1.1" 200 5538 "http://xxx.com/admin/index.php?action=nav&l=ukrainian" "Mozilla/5.0 (Windows; U; Windows NT 5.1; uk; rv:1.9.1.2) Gecko/20090729 Firefox/3.5.2 WebMoney Advisor"
#
193.43.222.3 - - [22/Aug/2009:14:26:46 -0700] "GET /admin/email.php?action=emailusers&l=ukrainian HTTP/1.1" 200 5281 "http://xxx.com/admin/index.php?action=nav&l=ukrainian" "Mozilla/5.0 (Windows; U; Windows NT 5.1; uk; rv:1.9.1.2) Gecko/20090729 Firefox/3.5.2 WebMoney Advisor"
#
193.43.222.3 - - [22/Aug/2009:14:26:47 -0700] "GET /admin/email.php?action=emailusers&l=ukrainian HTTP/1.1" 200 5281 "http://xxx.com/admin/index.php?action=nav&l=ukrainian" "Mozilla/5.0 (Windows; U; Windows NT 5.1; uk; rv:1.9.1.2) Gecko/20090729 Firefox/3.5.2 WebMoney Advisor" But when I sent email from ACP
Code: [Select]
#
193.43.222.3 - - [22/Aug/2009:14:38:58 -0700] "POST /admin/email.php?l=ukrainian HTTP/1.1" 200 1446 "http://xxx.com/admin/email.php?action=emailusers&l=ukrainian" "Mozilla/5.0 (Windows; U; Windows NT 5.1; uk; rv:1.9.1.2) Gecko/20090729 Firefox/3.5.2 WebMoney Advisor"
#
What's wrong?
12
Mods & Plugins (Releases & Support) / Re: [MOD] 4images searchform with keywords - like google suggest by using ajax
« on: July 15, 2009, 12:19:50 AM »
how to correct for cyrillic letters?
I try add
I try add
Code: [Select]
$letters = preg_replace("/[^а-яa-z0-9 ]/si","",$letters); but still don't work
13
Mods & Plugins (Releases & Support) / Re: [MOD] Favorites Counter // How many user added this picture to their lightbox
« on: July 10, 2009, 01:54:05 PM »
Hi! Great mod, but i don't see file to download. How to create user rank = count_favorites / all_images_by_user *100% ?
14
Mods & Plugins (Releases & Support) / Re: [MOD] Multi-Language support for any text (updated 05-11-2005)
« on: July 08, 2009, 05:19:59 PM »
can anyone help me create fields like
--------------------------------
Image name in english |====|
Image name in russian |====|
$
--------------------------------
Image name in english |====|
Image name in russian |====|
$
15
Mods & Plugins (Releases & Support) / Re: [Mod] Avatar v2.01
« on: July 05, 2009, 06:03:51 PM »
Hi All!
How to display user_avatar_current in last_comments_bit.html on front page?
How to display user_avatar_current in last_comments_bit.html on front page?
Pages: [1] 2