Jump to content

website taken off web by hosting provider due to scripting errors


slic535

Recommended Posts

I have been kicked off my hosting provider and they pulled out the script for seo urls. they said I was using to many resources and needed to fix it. I need some help on this one. I updated to 5.2.4 and then a day or two later this happened. here are some of the errors the site is giving me. from the error log I get these errors---

 

File: [hookloader.class.php] Line: [418] "SELECT * FROM `store1CubeCart_code_snippet` ;" - Table 'slic535_ccrt1.store1CubeCart_code_snippet' doesn't exist

 

File: [catalogue.class.php] Line: [781] "SELECT MAX(stock_level) AS `stock_level` FROM `store1CubeCart_option_matrix` ;" - Table 'slic535_ccrt1.store1CubeCart_option_matrix' doesn't exist

 

File: [catalogue.class.php] Line: [282] "SELECT MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `store1CubeCart_option_matrix` LIMIT 1;" - Table 'slic535_ccrt1.store1CubeCart_option_matrix' doesn't exist

 

File: [catalogue.class.php] Line: [478] "SELECT * FROM `store1CubeCart_option_matrix` ;" - Table 'slic535_ccrt1.store1CubeCart_option_matrix' doesn't exist

 

in the seo urls under search engine settings they have replaced my script with this

 

#BEGIN HG BLOCK
# The following configuration has been set by your hosting provider,
# and has been put in place for the benefit of the server.
#
# Any modification or removal by non-authorized individuals may
# result in corrective action.
#
# If you have any questions you may contact your provider for information.
order deny,allow
allow from 74.202.255.240/29 # Administrative
allow from 216.110.94.224/27 # Administrative
allow from 173.11.193.20/29 # Administrative
allow from 50.97.105.36 # Administrative
allow from 216.110.94.176/28 # Administrative
allow from 67.223.214.75 # Authenticated with FTP.
allow from 175.107.133.185 # GTMetrix
allow from 217.27.250.160 # GTMetrix
allow from 74.86.15.72 # GTMetrix
allow from 204.187.12.90 # GTMetrix
allow from 204.187.14.75 # GTMetrix
allow from 204.187.14.73 # GTMetrix
allow from 180.149.241.242 # GTMetrix
allow from 204.187.14.74 # GTMetrix
allow from 199.187.122.67 # ManageWP.com
allow from 199.187.122.66 # ManageWP.com
allow from 78.46.70.238 # ManageWP.com
allow from 50.87.144.190 # gator3157.hostgator.com
deny from all
#END HG BLOCK
## File Security
<FilesMatch ".(htaccess)$">
 Order Allow,Deny
 Deny from all
</FilesMatch>

#### Apache directory listing rules ####
DirectoryIndex index.php index.htm index.html
IndexIgnore *

#### Rewrite rules for SEO functionality ####

<IfModule mod_rewrite.c>
  RewriteEngine On
  RewriteBase /
  ######## START v4 SEO URL BACKWARD COMPATIBILITY ########
  RewriteCond %{QUERY_STRING} (.*)$
  RewriteCond %{REQUEST_FILENAME} !-f
  RewriteRule cat_([0-9]+)(.[a-z]{3,4})?(.*)$ index.php?_a=category&cat_id=$1&%1 [NC]

  RewriteCond %{QUERY_STRING} (.*)$
  RewriteCond %{REQUEST_FILENAME} !-f
  RewriteRule prod_([0-9]+)(.[a-z]{3,4})?$  index.php?_a=product&product_id=$1&%1 [NC]

  RewriteCond %{QUERY_STRING} (.*)$
  RewriteCond %{REQUEST_FILENAME} !-f
  RewriteRule info_([0-9]+)(.[a-z]{3,4})?$  index.php?_a=document&doc_id=$1&%1 [NC]

  RewriteCond %{QUERY_STRING} (.*)$
  RewriteCond %{REQUEST_FILENAME} !-f
  RewriteRule tell_([0-9]+)(.[a-z]{3,4})?$  index.php?_a=product&product_id=$1&%1 [NC]

  RewriteCond %{QUERY_STRING} (.*)$
  RewriteCond %{REQUEST_FILENAME} !-f
  RewriteRule _saleItems(.[a-z]+)?(?.*)?$  index.php?_a=saleitems&%1 [NC,L]
  ######## END v4 SEO URL BACKWARD COMPATIBILITY ########

  RewriteCond %{REQUEST_FILENAME} !-f
  RewriteCond %{REQUEST_FILENAME} !-d
  RewriteCond %{REQUEST_URI} !=/favicon.ico
  RewriteRule ^(.*).html?$ index.php?seo_path=$1 [L,QSA]
</IfModule>

<IfModule mod_suphp.c>
 suPHP_ConfigPath /home/slic535
 <Files php.ini>
   order allow,deny
   deny from all
 </Files>
</IfModule>

 

 

Link to comment
Share on other sites

here is what I got as an email to this problem

 

 

PLEASE NOTE:
We have attempted to provide restricted access to your website so that you may make
the necessary adjustments at your convenience.  We have checked recent account
activity and whitelisted IPs that have logged in to cPanel and/or FTP.  If you have
any trouble accessing the website, please reply to this ticket with your current IP
address (shown in RED at http://hostgator.com/ip.shtml ) and we will add it to the
access whitelist as well. Please note that while you can see your site the rest of
the world can not as restrictions are in place and you will need to update us to
review the site and remove the restrictions
*******************************************************************************************************************************************************
Hello,

I apologize, but I was forced to suspend the script /home/slic535/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 was 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. 

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.

Accounting Information for this hour:
slic535 68 0.10% 54.71re 0.97% 0.63cp 0.33% 0avio 50941k

Running Processes:
=============== Pass 1 ===============
slic535    599  0.4  0.1 314668 34812 ?        SN   21:07   0:00 /usr/bin/php
/home3/slic535/public_html/index.php
slic535   2342  0.4  0.1 313272 33572 ?        SN   21:07   0:00 /usr/bin/php
/home3/slic535/public_html/index.php
slic535   2384  0.4  0.1 314136 34392 ?        SN   21:07   0:00 /usr/bin/php
/home3/slic535/public_html/index.php
slic535   7237  0.7  0.1 314668 34760 ?        SN   21:07   0:00 /usr/bin/php
/home3/slic535/public_html/index.php
slic535   7284  0.3  0.0 311012 31088 ?        SN   21:04   0:00 /usr/bin/php
/home3/slic535/public_html/index.php
slic535   8500  0.2  0.0 299092 18424 ?        SN   21:07   0:00 /usr/bin/php
/home3/slic535/public_html/index.php
slic535  16014  0.8  0.1 314400 34568 ?        SN   21:08   0:00 /usr/bin/php
/home3/slic535/public_html/index.php
slic535  19352  0.3  0.1 314388 34548 ?        SN   21:05   0:00 /usr/bin/php
/home3/slic535/public_html/index.php
slic535  21215  0.8  0.0 300900 20696 ?        RN   21:08   0:00 /usr/bin/php
/home3/slic535/public_html/index.php
slic535  21760  0.4  0.0 299092 18424 ?        SN   21:08   0:00 /usr/bin/php
/home3/slic535/public_html/index.php
slic535  22704  0.8  0.1 317928 38068 ?        SN   21:03   0:03 /usr/bin/php
/home3/slic535/public_html/index.php
slic535  26409  0.5  0.1 313060 33192 ?        SN   21:03   0:01 /usr/bin/php
/home3/slic535/public_html/index.php
slic535  28656  0.4  0.0 311524 31608 ?        SN   21:03   0:01 /usr/bin/php
/home3/slic535/public_html/index.php
slic535  29428  0.4  0.0 310976 31116 ?        SN   21:06   0:00 /usr/bin/php
/home3/slic535/public_html/index.php
slic535  29462  3.3  0.0 303960 24084 ?        SN   21:09   0:00 /usr/bin/php
/home3/slic535/public_html/index.php
slic535  29856  0.1  0.0 299092 18432 ?        SN   21:06   0:00 /usr/bin/php
/home3/slic535/public_html/index.php
slic535  30723  0.4  0.1 314132 34384 ?        SN   21:06   0:00 /usr/bin/php
/home3/slic535/public_html/index.php
=============== Pass 2 ===============
slic535    599  0.4  0.1 313004 33216 ?        SN   21:07   0:00 /usr/bin/php
/home3/slic535/public_html/index.php
slic535   2342  0.4  0.1 313272 33572 ?        SN   21:07   0:00 /usr/bin/php
/home3/slic535/public_html/index.php
slic535   2384  0.4  0.1 314136 34392 ?        SN   21:07   0:00 /usr/bin/php
/home3/slic535/public_html/index.php
slic535   7237  0.7  0.1 314668 34760 ?        SN   21:07   0:00 /usr/bin/php
/home3/slic535/public_html/index.php
slic535   7284  0.3  0.0 311012 31088 ?        SN   21:04   0:00 /usr/bin/php
/home3/slic535/public_html/index.php
slic535   8500  0.2  0.0 299092 18424 ?        SN   21:07   0:00 /usr/bin/php
/home3/slic535/public_html/index.php
slic535  16014  0.8  0.1 314400 34568 ?        SN   21:08   0:00 /usr/bin/php
/home3/slic535/public_html/index.php
slic535  19352  0.3  0.1 314388 34548 ?        SN   21:05   0:00 /usr/bin/php
/home3/slic535/public_html/index.php
slic535  21215  0.8  0.0 303960 24000 ?        SN   21:08   0:00 /usr/bin/php
/home3/slic535/public_html/index.php
slic535  21760  0.4  0.0 299092 18424 ?        SN   21:08   0:00 /usr/bin/php
/home3/slic535/public_html/index.php
slic535  22704  0.8  0.1 317928 38068 ?        SN   21:03   0:03 /usr/bin/php
/home3/slic535/public_html/index.php
slic535  26409  0.5  0.1 313060 33192 ?        SN   21:03   0:01 /usr/bin/php
/home3/slic535/public_html/index.php
slic535  28656  0.4  0.0 311524 31608 ?        SN   21:03   0:01 /usr/bin/php
/home3/slic535/public_html/index.php
slic535  29428  0.4  0.0 311232 31564 ?        SN   21:06   0:00 /usr/bin/php
/home3/slic535/public_html/index.php
slic535  29462  3.8  0.0 310364 30124 ?        SN   21:09   0:00 /usr/bin/php
/home3/slic535/public_html/index.php
slic535  29856  0.1  0.0 299092 18432 ?        SN   21:06   0:00 /usr/bin/php
/home3/slic535/public_html/index.php
slic535  30633  9.0  0.0 298232 17848 ?        SN   21:09   0:00 /usr/bin/php
/home3/slic535/public_html/index.php
slic535  30723  0.4  0.1 314132 34384 ?        SN   21:06   0:00 /usr/bin/php
/home3/slic535/public_html/index.php
=============== Pass 3 ===============
slic535    599  0.4  0.1 313004 33216 ?        SN   21:07   0:00 /usr/bin/php
/home3/slic535/public_html/index.php
slic535   2342  0.4  0.1 313272 33572 ?        SN   21:07   0:00 /usr/bin/php
/home3/slic535/public_html/index.php
slic535   2384  0.4  0.1 314136 34392 ?        SN   21:07   0:00 /usr/bin/php
/home3/slic535/public_html/index.php
slic535   7237  0.7  0.1 314668 34760 ?        SN   21:07   0:00 /usr/bin/php
/home3/slic535/public_html/index.php
slic535   7284  0.3  0.0 311012 31088 ?        SN   21:04   0:00 /usr/bin/php
/home3/slic535/public_html/index.php
slic535   8500  0.2  0.0 299092 18424 ?        SN   21:07   0:00 /usr/bin/php
/home3/slic535/public_html/index.php
slic535  16014  0.8  0.1 314400 34568 ?        SN   21:08   0:00 /usr/bin/php
/home3/slic535/public_html/index.php
slic535  19352  0.3  0.1 314388 34548 ?        SN   21:05   0:00 /usr/bin/php
/home3/slic535/public_html/index.php
slic535  21215  0.8  0.0 303960 24000 ?        SN   21:08   0:00 /usr/bin/php
/home3/slic535/public_html/index.php
slic535  21760  0.4  0.0 299092 18424 ?        SN   21:08   0:00 /usr/bin/php
/home3/slic535/public_html/index.php
slic535  22704  0.8  0.1 318184 38068 ?        SN   21:03   0:03 /usr/bin/php
/home3/slic535/public_html/index.php
slic535  26409  0.5  0.1 313316 33192 ?        SN   21:03   0:01 /usr/bin/php
/home3/slic535/public_html/index.php
slic535  28656  0.4  0.0 311524 31608 ?        SN   21:03   0:01 /usr/bin/php
/home3/slic535/public_html/index.php
slic535  29428  0.4  0.0      0     0 ?        ZN   21:06   0:00

 <defunct>
slic535  29462  3.1  0.0 310364 30124 ?        SN   21:09   0:00 /usr/bin/php
/home3/slic535/public_html/index.php
slic535  29856  0.1  0.0 299092 18432 ?        SN   21:06   0:00 /usr/bin/php
/home3/slic535/public_html/index.php
slic535  30633  4.5  0.0 298232 17848 ?        SN   21:09   0:00 /usr/bin/php
/home3/slic535/public_html/index.php
slic535  30723  0.4  0.1 314132 34384 ?        SN   21:06   0:00 /usr/bin/php
/home3/slic535/public_html/index.php

Running Queries:
*************************** 1. row ***************************
   USER: slic535_ccr
     DB: slic535_ccrt1
  STATE: Opening tables
   TIME: 0
COMMAND: Query
   INFO: INSERT INTO `store1CubeCart_sessions`
(`admin_id`,`customer_id`,`ip_address`,`location`,`session_id`,`session_last`,`session_start`,`useragent`)
VALUES
('0','0','99.54.54.28','','b55d9a20b5ca8bb9f7db0133703685b6','1383793773','1383793773','Mozilla/5.0
(compatible; MSIE 10.0; Windows NT 6.1; WOW64; Trident/6.0)')
*************************** 2. row ***************************
   USER: slic535_ccr
     DB: slic535_ccrt1
  STATE: Opening tables
   TIME: 1
COMMAND: Query
   INFO: SHOW COLUMNS FROM store1CubeCart_option_matrix
*************************** 3. row ***************************
   USER: slic535_ccr
     DB: slic535_ccrt1
  STATE:
   TIME: 48
COMMAND: Sleep
   INFO: NULL
*************************** 4. row ***************************
   USER: slic535_ccr
     DB: slic535_ccrt1
  STATE: Opening tables
   TIME: 0
COMMAND: Query
   INFO: INSERT INTO `store1CubeCart_system_error_log` (`message`,`time`) VALUES
('File: [hookloader.class.php] Line: [418] "SELECT   * FROM
`store1CubeCart_code_snippet`    ;" - Table
'slic535_ccrt1.store1CubeCart_code_snippet' doesn't exist','1383793772')
*************************** 5. row ***************************
   USER: slic535_ccr
     DB: slic535_ccrt1
  STATE: Opening tables
   TIME: 0
COMMAND: Query
   INFO: SELECT `id` FROM `store1CubeCart_category_index` AS C INNER JOIN
`store1CubeCart_inventory` AS I ON I.`product_id` = C.`product_id` WHERE C.cat_id
= 12 AND I.status = 1
*************************** 6. row ***************************
   USER: slic535_ccr
     DB: slic535_ccrt1
  STATE: Opening tables
   TIME: 0
COMMAND: Query
   INFO: SELECT   `path` FROM `store1CubeCart_seo_urls` WHERE
store1CubeCart_seo_urls.type = 'cat' AND store1CubeCart_seo_urls.item_id = '73'
*************************** 7. row ***************************
   USER: slic535_ccr
     DB: slic535_ccrt1
  STATE: Opening tables
   TIME: 0
COMMAND: Query
   INFO: SELECT   `path` FROM `store1CubeCart_seo_urls` WHERE
store1CubeCart_seo_urls.type = 'cat' AND store1CubeCart_seo_urls.item_id = '34'
*************************** 8. row ***************************
   USER: slic535_ccr
     DB: slic535_ccrt1
  STATE: Opening tables
   TIME: 0
COMMAND: Query
   INFO: SELECT   `path` FROM `store1CubeCart_seo_urls` WHERE
store1CubeCart_seo_urls.type = 'cat' AND store1CubeCart_seo_urls.item_id = '45'
*************************** 9. row ***************************
   USER: slic535_ccr
     DB: slic535_ccrt1
  STATE: checking permissions
   TIME: 1
COMMAND: Query
   INFO: SHOW COLUMNS FROM store1CubeCart_access_log
*************************** 10. row ***************************
   USER: slic535_ccr
     DB: slic535_ccrt1
  STATE: Opening tables
   TIME: 0
COMMAND: Query
   INFO: SELECT   `path` FROM `store1CubeCart_seo_urls` WHERE
store1CubeCart_seo_urls.type = 'cat' AND store1CubeCart_seo_urls.item_id = '92'
*************************** 11. row ***************************
   USER: slic535_ccr
     DB: slic535_ccrt1
  STATE: Opening tables
   TIME: 0
COMMAND: Query
   INFO: SELECT   `path` FROM `store1CubeCart_seo_urls` WHERE
store1CubeCart_seo_urls.type = 'cat' AND store1CubeCart_seo_urls.item_id = '72'
*************************** 12. row ***************************
   USER: slic535_ccr
     DB: slic535_ccrt1
  STATE: Opening tables
   TIME: 0
COMMAND: Query
   INFO: SELECT   * FROM `store1CubeCart_filemanager` WHERE
store1CubeCart_filemanager.file_id = '1751'
*************************** 13. row ***************************
   USER: slic535_ccr
     DB: slic535_ccrt1
  STATE: Opening tables
   TIME: 0
COMMAND: Query
   INFO: INSERT INTO `store1CubeCart_system_error_log` (`message`,`time`) VALUES
('File: [catalogue.class.php] Line: [781] "SELECT   MAX(stock_level) AS
`stock_level` FROM `store1CubeCart_option_matrix`    ;" - Table
'slic535_ccrt1.store1CubeCart_option_matrix' doesn't exist','1383793773')
*************************** 14. row ***************************
   USER: slic535_ccr
     DB: slic535_ccrt1
  STATE: Opening tables
   TIME: 0
COMMAND: Query
   INFO: SELECT   * FROM `store1CubeCart_filemanager` WHERE
store1CubeCart_filemanager.file_id = '815'
*************************** 15. row ***************************
   USER: slic535_ccr
     DB: slic535_ccrt1
  STATE: Opening tables
   TIME: 0
COMMAND: Query
   INFO: SELECT `id` FROM `store1CubeCart_category_index` AS C INNER JOIN
`store1CubeCart_inventory` AS I ON I.`product_id` = C.`product_id` WHERE C.cat_id
= 3 AND I.status = 1
*************************** 1. row ***************************
   USER: slic535_ccr
     DB: slic535_ccrt1
  STATE: Opening tables
   TIME: 0
COMMAND: Query
   INFO: INSERT INTO `store1CubeCart_sessions`
(`admin_id`,`customer_id`,`ip_address`,`location`,`session_id`,`session_last`,`session_start`,`useragent`)
VALUES
('0','0','99.54.54.28','','b55d9a20b5ca8bb9f7db0133703685b6','1383793773','1383793773','Mozilla/5.0
(compatible; MSIE 10.0; Windows NT 6.1; WOW64; Trident/6.0)')
*************************** 2. row ***************************
   USER: slic535_ccr
     DB: slic535_ccrt1
  STATE: Opening tables
   TIME: 0
COMMAND: Query
   INFO: SHOW COLUMNS FROM store1CubeCart_manufacturers
*************************** 3. row ***************************
   USER: slic535_ccr
     DB: slic535_ccrt1
  STATE:
   TIME: 48
COMMAND: Sleep
   INFO: NULL
*************************** 4. row ***************************
   USER: slic535_ccr
     DB: slic535_ccrt1
  STATE: Opening tables
   TIME: 0
COMMAND: Query
   INFO: INSERT INTO `store1CubeCart_system_error_log` (`message`,`time`) VALUES
('File: [hookloader.class.php] Line: [418] "SELECT   * FROM
`store1CubeCart_code_snippet`    ;" - Table
'slic535_ccrt1.store1CubeCart_code_snippet' doesn't exist','1383793772')
*************************** 5. row ***************************
   USER: slic535_ccr
     DB: slic535_ccrt1
  STATE: Opening tables
   TIME: 0
COMMAND: Query
   INFO: SELECT `id` FROM `store1CubeCart_category_index` AS C INNER JOIN
`store1CubeCart_inventory` AS I ON I.`product_id` = C.`product_id` WHERE C.cat_id
= 12 AND I.status = 1
*************************** 6. row ***************************
   USER: slic535_ccr
     DB: slic535_ccrt1
  STATE: Opening tables
   TIME: 0
COMMAND: Query
   INFO: SELECT   `path` FROM `store1CubeCart_seo_urls` WHERE
store1CubeCart_seo_urls.type = 'cat' AND store1CubeCart_seo_urls.item_id = '73'
*************************** 7. row ***************************
   USER: slic535_ccr
     DB: slic535_ccrt1
  STATE: Opening tables
   TIME: 0
COMMAND: Query
   INFO: SELECT   `path` FROM `store1CubeCart_seo_urls` WHERE
store1CubeCart_seo_urls.type = 'cat' AND store1CubeCart_seo_urls.item_id = '34'
*************************** 8. row ***************************
   USER: slic535_ccr
     DB: slic535_ccrt1
  STATE: Opening tables
   TIME: 0
COMMAND: Query
   INFO: SELECT   `path` FROM `store1CubeCart_seo_urls` WHERE
store1CubeCart_seo_urls.type = 'cat' AND store1CubeCart_seo_urls.item_id = '45'
*************************** 9. row ***************************
   USER: slic535_ccr
     DB: slic535_ccrt1
  STATE: checking permissions
   TIME: 1
COMMAND: Query
   INFO: SHOW COLUMNS FROM store1CubeCart_access_log
*************************** 10. row ***************************
   USER: slic535_ccr
     DB: slic535_ccrt1
  STATE: Opening tables
   TIME: 0
COMMAND: Query
   INFO: SELECT   `path` FROM `store1CubeCart_seo_urls` WHERE
store1CubeCart_seo_urls.type = 'cat' AND store1CubeCart_seo_urls.item_id = '92'
*************************** 11. row ***************************
   USER: slic535_ccr
     DB: slic535_ccrt1
  STATE: Opening tables
   TIME: 0
COMMAND: Query
   INFO: SELECT   `path` FROM `store1CubeCart_seo_urls` WHERE
store1CubeCart_seo_urls.type = 'cat' AND store1CubeCart_seo_urls.item_id = '72'
*************************** 12. row ***************************
   USER: slic535_ccr
     DB: slic535_ccrt1
  STATE: Opening tables
   TIME: 0
COMMAND: Query
   INFO: SELECT   * FROM `store1CubeCart_filemanager` WHERE
store1CubeCart_filemanager.file_id = '1751'
*************************** 13. row ***************************
   USER: slic535_ccr
     DB: slic535_ccrt1
  STATE: Opening tables
   TIME: 0
COMMAND: Query
   INFO: INSERT INTO `store1CubeCart_system_error_log` (`message`,`time`) VALUES
('File: [catalogue.class.php] Line: [781] "SELECT   MAX(stock_level) AS
`stock_level` FROM `store1CubeCart_option_matrix`    ;" - Table
'slic535_ccrt1.store1CubeCart_option_matrix' doesn't exist','1383793773')
*************************** 14. row ***************************
   USER: slic535_ccr
     DB: slic535_ccrt1
  STATE: Opening tables
   TIME: 0
COMMAND: Query
   INFO: SELECT   * FROM `store1CubeCart_filemanager` WHERE
store1CubeCart_filemanager.file_id = '815'
*************************** 15. row ***************************
   USER: slic535_ccr
     DB: slic535_ccrt1
  STATE: Opening tables
   TIME: 0
COMMAND: Query
   INFO: SELECT COUNT(cat_id) AS Count FROM `store1CubeCart_category` WHERE
store1CubeCart_category.cat_parent_id = '3' AND store1CubeCart_category.status =
'1'

Open connections:

Recent Site Requests:
142.54.172.181        directknifesales.com        /
178.154.210.251        directknifesales.com        /kissing-crane-stag-lockback-folding-knife-19kc5078.html
178.154.243.84        directknifesales.com        /images/cache/gut-hook-knife-rite-edge-210413.45.jpg
198.204.231.86        directknifesales.com        /
199.30.20.65        directknifesales.com        /index.php?act=viewProd&productId=1313
199.30.20.65        directknifesales.com        /index.php?act=viewProd&productId=1313
208.83.156.117        directknifesales.com        /field-machete-926809.html
64.237.226.218        directknifesales.com        /automatic-knives.html?page=all
64.237.226.218        directknifesales.com        /automatic-knives.html?page=all
64.237.226.218        directknifesales.com        /automatic-knives.html?page=all
64.237.226.218        directknifesales.com        /automatic-knives.html?page=all
65.55.24.216        directknifesales.com        /index.php?act=viewProd&productId=121
66.249.74.99        directknifesales.com        /~slic535/images/cache/sentry-knuckle-knife-UC0784.45.jpg
66.249.74.99        directknifesales.com        /~slic535/images/cache/sentry-knuckle-knife-UC0784.45.jpg
67.223.214.75        directknifesales.com        /admin.php?_g=maintenance
67.223.214.75        directknifesales.com        /index.php
67.223.214.75        directknifesales.com        /js/plugins.php
67.223.214.75        directknifesales.com        /js/styles/styles.php
70.209.67.52        directknifesales.com        /
95.211.238.107        directknifesales.com        /gfactor-all-black-da-auto-knife-sp05440pk.html
95.211.238.107        directknifesales.com        /gfactor-black-da-serrated-autoknife-sp054pk3.html
95.211.238.107        directknifesales.com        /gfactor-rosewood-da-serrated-tanto-autoknife-sp054pk6.html
95.211.238.107        directknifesales.com        /pakka-wood-dual-action-auto-knife-sp504b12.html




Sincerely,

Kelly Y.

Linux Systems Administrator

Systems Monitoring

HostGator.com LLC

http://support.hostgator.com
Link to comment
Share on other sites

These statements about missing tables is evidence that, while you have upgraded the codebase from what it was to CC524, you did not allow CubeCart to run the /setup/index.php script.

 

The setup script is necessary to update any changes to the database. In your case, new tables were added between a version you had installed previously and the latest version you have installed now.

 

If possible, restore the setup folder and have your browser go to your_site/setup/index.php. Choose upgrade - do not choose to start with a fresh database.

Link to comment
Share on other sites

Using phpMyAdmin, please check for the presence of the table: store1CubeCart_code_snippet and store1CubeCart_option_matrix.

 

Also check in the table store1CubeCart_history, and make sure there is an entry for 5.2.4.

 

I have no advice on what any of the report's data means, nor why HostGator seems to think you are using a lot of resources.

 

"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."

 

PHP exists to make a web page for every request.

Link to comment
Share on other sites

Hi

You have at least two separate issues here :

1) As bsmither pointed out, the upgrade process had not completed (either because of error or because you didnt run it correctly) and that was causing the errors due to the database being out of sync for your version. If you ran the upgrade, this should now be fixed.

2) The bigger issue is that Hostgator have restricted access to your site due to what they deem to be excessive usage. The standard CubeCart script doesnt cause this but unfortunately they have not been helpful at all to you in identifying the cause and they have no regard for the fact that this is your business but then they dont know about CubeCart and frankly dont care !

Firstly, check that in Store Settings | Advanced tab that you have caching enabled as this will certainly help.

After this it is going to be difficult, if not impossible, to diagnose the problem further because they havent provided enough information and also because they have restricted access to everyone outside a selected few IP addresses, there is no way to see what is going on. Unless they can show that one or more IP addresses were making a large number of connections to your site (which the detail they have provided doesnt show and which they should be able to stop themselves at the server level anyway) then personally I would take my business elsewhere !

Thanks

Ian

Link to comment
Share on other sites

Did they immediately disable your account or give you any time to get it fixed? I can't see how the issue you have causes excessive resource usage. Maybe if you can get the database upgraded to the latest version as others have suggested the problem can go away and if they still complain we can look to see what is causing the issue. 

Link to comment
Share on other sites

  • 1 year later...

I am having this issue with Hostgator as well.  Here is the email they sent me:

 

This message is to advise you of a temporary block placed on your database. The database associated with the script in "/home4/flgames/public_html/battlemart.com/store/index.php" was found to be consuming an inordinate amount of processor time, to the point of degrading overall system performance. While we do limit each account to no more than 25% of a system's CPU in our terms of service, we do not actively disable accounts until they greatly exceed that number, which is what happened in this case.

Resolving this situation may be as simple as adding additional indexes to your database, optimizing the queries used, or something equally easy. If not, it may simply be a matter of moving this database to dedicated services, as it may have outgrown a shared environment.

If you believe you have a solution to this overuse, we are happy to discuss the situation with you and possibly reinstate the database on the server. Otherwise, we will be happy to assist you with the upgrade process if a dedicated server is the most appropriate solution. Thank you, and we look forward to hearing from you shortly.

~
Excessive MySQL activity is caused by (a) a long-running process that locks a table, causing other queries to back up, (B) a query that is not optimized ][example: select all from ... and involving a large or complex query], © huge table copies/maintenance during peak hours.

NOTE:, the following are just possible fixes or suggestions, and are not endorsed or supported by HostGator. They are included in the hope that they may apply to your situation, and/or help you reduce the amount of resources your SQL queries consume. As always, it's best to backup any data before making any changes or adjustments.

First and foremost, you may need to optimize your tables. The frequency depends on the size and usage of the database, but most databases would benefit from doing something like this on a yearly basis: a) Enter your phpMyAdmin/MySQL control panel. Click on the database (not the table, the database name), and on the right hand column your tables should be listed. Scroll down till you see the .Check all. link. Click on that link, make sure all database tables are checked and then from the drop-down next to it, and carefully select .Optimize table..

Additionally, adding indexes to your table(s) may improve performance. If you're not sure what you're doing, it's best not to modify any table; caution is recommended. There are various articles (http://www.developer.com/print.php/3667831). It may be best to Google for something like [Your Software Name] MySQL indexes for suggestions.

If you reply back to this with your IP address (http://www.hostgator.com/ip) 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.

Below were the active processes, MySQL queries, and incoming site requests at the time of suspension:
Running Processes:
flgames 3242 0.1 0.0 394564 19468 ? SN 19:37 0:00 /opt/php52/bin/php-cgi /home4/flgames/public_html/battlemart.com/store/index.php
flgames 6954 0.2 0.0 394564 19468 ? SN 19:37 0:00 /opt/php52/bin/php-cgi /home4/flgames/public_html/battlemart.com/store/index.php
flgames 10400 0.3 0.0 394564 19464 ? SN 19:38 0:00 /opt/php52/bin/php-cgi /home4/flgames/public_html/battlemart.com/store/index.php
flgames 10435 0.4 0.0 394564 19464 ? SN 19:38 0:00 /opt/php52/bin/php-cgi /home4/flgames/public_html/battlemart.com/store/index.php
flgames 12882 0.9 0.0 296896 18576 ? SN 19:38 0:00 /opt/php52/bin/php-cgi /home4/flgames/public_html/battlemart.com/store/index.php
flgames 12964 0.9 0.0 297152 18560 ? SN 19:38 0:00 /opt/php52/bin/php-cgi /home4/flgames/public_html/battlemart.com/store/index.php
flgames 32262 0.1 0.0 394564 19484 ? SN 19:36 0:00 /opt/php52/bin/php-cgi /home4/flgames/public_html/battlemart.com/store/index.php

Running Queries:
*************************** 1. row ***************************
USER: flgames_battle
DB: flgames_battle
STATE: Waiting for table level lock
TIME: 12
COMMAND: Query
INFO: SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I LEFT JOIN CubeCart_category AS C ON I.cat_id = C.cat_id WHERE C.hide != 1 AND I.cat_id > 0 ORDER BY RAND(2077) LIMIT 1
*************************** 2. row ***************************
USER: flgames_battle
DB: flgames_battle
STATE: Waiting for table level lock
TIME: 12
COMMAND: Query
INFO: SELECT I.name, I.image, I.productId FROM CubeCart_inventory AS I LEFT JOIN CubeCart_category AS C ON I.cat_id = C.cat_id WHERE C.hide != 1 AND I.cat_id > 0 ORDER BY RAND(778) LIMIT 1
*************************** 3. row ***************************
USER: flgames_battle
DB: flgames_battle
STATE: Waiting for table level lock
TIME: 23
COMMAND: Query
INFO: UPDATE CubeCart_inventory SET `popularity` = popularity+1 WHERE productId = '3300'
*************************** 4. row ***************************
USER: flgames_battle
DB: flgames_battle
STATE: Waiting for table level lock
TIME: 23
COMMAND: Query
INFO: UPDATE CubeCart_inventory SET `popularity` = popularity+1 WHERE productId = '2775'
*************************** 5. row ***************************
USER: flgames_battle
DB: flgames_battle
STATE: Waiting for table level lock
TIME: 23
COMMAND: Query
INFO: UPDATE CubeCart_inventory SET `popularity` = popularity+1 WHERE productId = '3300'
*************************** 6. row ***************************
USER: flgames_battle
DB: flgames_battle
STATE: Copying to tmp table
TIME: 23
COMMAND: Query
INFO: SELECT DISTINCT O.productId, I.name, I.image FROM CubeCart_order_inv AS O LEFT JOIN CubeCart_inventory AS I ON I.productId = O.productId WHERE O.cart_order_id IN (SELECT DISTINCT cart_order_id FROM CubeCart_order_inv WHERE productId = 3300) AND O.productId <> 3300 LIMIT 3
*************************** 7. row ***************************
USER: flgames_battle
DB: flgames_battle
STATE: Copying to tmp table
TIME: 23
COMMAND: Query
INFO: SELECT DISTINCT O.productId, I.name, I.image FROM CubeCart_order_inv AS O LEFT JOIN CubeCart_inventory AS I ON I.productId = O.productId WHERE O.cart_order_id IN (SELECT DISTINCT cart_order_id FROM CubeCart_order_inv WHERE productId = 67) AND O.productId <> 67 LIMIT 3

Open connections

Current Site Requests:
108.45.34.90 battlem.stonesterrain.com /AUCTIONS/Vampire_001Aa.jpg
108.45.34.90 battlem.stonesterrain.com /AUCTIONS/Vampire_001Aa.jpg
108.45.34.90 battlem.stonesterrain.com /Auctions/Force_of_Nature
108.45.34.90 battlem.stonesterrain.com /Auctions/Force_of_Nature
108.45.34.90 battlem.stonesterrain.com /Auctions/Mind_your_Manors
108.45.34.90 battlem.stonesterrain.com /Auctions/Mind_your_Manors
108.45.34.90 battlem.stonesterrain.com /Auctions/Vampire_020A.jpg
108.45.34.90 battlem.stonesterrain.com /Auctions/Vampire_020A.jpg
108.45.34.90 battlem.stonesterrain.com /Auctions/Vampire_021A.jpg
108.45.34.90 battlem.stonesterrain.com /Auctions/Vampire_021A.jpg
108.45.34.90 battlem.stonesterrain.com /Auctions/Vampire_035A.jpg
108.45.34.90 battlem.stonesterrain.com /Auctions/Vampire_035A.jpg
108.45.34.90 battlem.stonesterrain.com /Auctions/Wyrmgear
108.45.34.90 battlem.stonesterrain.com /Auctions/Wyrmgear
108.45.34.90 battlem.stonesterrain.com /images/Kickstarter_Cthulhu.jpg
108.45.34.90 battlem.stonesterrain.com /images/Kickstarter_Cthulhu.jpg
108.45.34.90 battlem.stonesterrain.com /images/Kickstarter_Nethyrmaul001.jpg
108.45.34.90 battlem.stonesterrain.com /images/Kickstarter_Nethyrmaul001.jpg
108.45.34.90 battlem.stonesterrain.com /images/Kickstarter_Nethyrmaul002.jpg
108.45.34.90 battlem.stonesterrain.com /images/Kickstarter_Nethyrmaul002.jpg
109.120.157.179 battlem.stonesterrain.com /store/index.php?_a=viewProd&productId=3990
109.120.157.179 battlem.stonesterrain.com /store/index.php?_a=viewProd&productId=3990
180.76.5.75 battlem.stonesterrain.com /store/index.php?_a=viewCat&catId=42
180.76.5.75 battlem.stonesterrain.com /store/index.php?_a=viewCat&catId=42
180.76.6.17 battlem.stonesterrain.com /store/index.php?_a=viewProd&productId=2775
180.76.6.17 battlem.stonesterrain.com /store/index.php?_a=viewProd&productId=2775
46.161.41.199 battlem.stonesterrain.com /store/index.php?_a=viewProd&productId=2702
46.161.41.199 battlem.stonesterrain.com /store/index.php?_a=viewProd&productId=2702
66.249.73.193 battlem.stonesterrain.com /store/index.php/index.php?_a=viewProd&productId=3580
66.249.73.193 battlem.stonesterrain.com /store/index.php/index.php?_a=viewProd&productId=3580
68.180.228.176 battlem.stonesterrain.com /store/index.php?_a=viewProd&productId=67
68.180.228.176 battlem.stonesterrain.com /store/index.php?_a=viewProd&productId=67
68.180.228.176 battlem.stonesterrain.com /store/index.php?_a=viewProd&productId=67
68.180.228.176 battlem.stonesterrain.com /store/index.php?_a=viewProd&productId=67
68.180.228.35 battlem.stonesterrain.com /store/index.php?_a=viewProd&productId=3300
68.180.228.35 battlem.stonesterrain.com /store/index.php?_a=viewProd&productId=3300
68.180.228.35 battlem.stonesterrain.com /store/index.php?_a=viewProd&productId=3300
68.180.228.35 battlem.stonesterrain.com /store/index.php?_a=viewProd&productId=3300
68.180.228.35 battlem.stonesterrain.com /store/index.php?_a=viewProd&productId=3300
68.180.228.35 battlem.stonesterrain.com /store/index.php?_a=viewProd&productId=3300

 

 

I am running CC 4.0.2, PHP 5.2.17, MySQL 5.5.40-36.1

 

Do you think a CC upgrade would help?

Link to comment
Share on other sites

Short answer: yes.

 

Long answer: CC3/early-4 has a much less feature set than later versions, so the database impact should be a bit less. On the other hand, discoveries were made that were implemented in later versions of CC4 and in CC5 that solved problems with 'scaling'.

 

One in particular is the use of RAND() on a table with more than a couple hundred records.

 

But some of these queries make no sense to be causing a problem. For example, "UPDATE CubeCart_inventory SET `popularity` = popularity+1 WHERE productId = '2775'". That should be executed rather quickly.

 

You will probably be getting a more knowledgeable response about queries and their impact on database performance shortly.

Link to comment
Share on other sites

I am having this issue with Hostgator as well.

A short answer would be find a new hosting company - any company that treats people like this doesnt deserve your money. They of course have to protect their servers but there are better ways from a customer service point of view but then like most big companies, they probably dont really care as expect churn rate in excess of 60% per year

STATE: Waiting for table level lock

Whenever you see this it means the MySQL database server is stressed - can be caused by poor queries and indexing on the tables, not enough memory for the MySQL server or an overloaded server - in this situation it could be any or all of the above

I am running CC 4.0.2, PHP 5.2.17, MySQL 5.5.40-36.1

You are running on reasonably up to date version of MySQL, BUT a very old, insecure and unsupported (for at least three years) version of PHP but the main issues is a massively old version of CubeCart. You should upgrade to V6 but if you need to stay with V4 then upgrade to the the latest available version of V4 - there were lots and lots of indexes that are missing in older versions of V4

Do you think a CC upgrade would help?

As above yes. There are a lot of security issues in this old version that need 100% updating

Ian

Link to comment
Share on other sites

Thanks for the replies.  I really feel like this is out of my league, so now we're looking to hire someone to manage this for us.  I'm even hesitant to upgrade at this point since we have had issues from that in the past as well, and with this being such an old version of CC, I wouldn't even know where to start.

 

I agree that we need to change hosting companies, but we just switched to HG after being with another company for over 10 years because they were highly recommended and had excellent reviews. I'm afraid if we switch again we will just encounter more of the same thing.

 

Thanks again for the help! :-)

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...