slic535 Posted November 7, 2013 Share Posted November 7, 2013 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> Quote Link to comment Share on other sites More sharing options...
slic535 Posted November 7, 2013 Author Share Posted November 7, 2013 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 LLChttp://support.hostgator.com Quote Link to comment Share on other sites More sharing options...
bsmither Posted November 7, 2013 Share Posted November 7, 2013 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. Quote Link to comment Share on other sites More sharing options...
slic535 Posted November 7, 2013 Author Share Posted November 7, 2013 I have the setup folder that came with the 5.2.4. I went to setup/index.php. now what do I push? the continue button on the bottom or the update button on top? Quote Link to comment Share on other sites More sharing options...
bsmither Posted November 7, 2013 Share Posted November 7, 2013 The Continue button. (The Update button on top is to make CubeCart Setup use a new choice in language.) Quote Link to comment Share on other sites More sharing options...
slic535 Posted November 7, 2013 Author Share Posted November 7, 2013 ok it says complete. so does this fix the problem? also I was going to use a ticket on this and went to the page to input my info. will the ticket be used if I don't submit it? Quote Link to comment Share on other sites More sharing options...
bsmither Posted November 7, 2013 Share Posted November 7, 2013 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. Quote Link to comment Share on other sites More sharing options...
slic535 Posted November 7, 2013 Author Share Posted November 7, 2013 its all there but when I try and look inside the history folder I just get a blank white page. am I pushing the wrong thing? Quote Link to comment Share on other sites More sharing options...
bsmither Posted November 7, 2013 Share Posted November 7, 2013 The "history" is not a folder. It is a table, just like the code_snippet and options_matrix tables. Have phpMyAdmin "browse" the store1CubeCart_history table. Quote Link to comment Share on other sites More sharing options...
havenswift-hosting Posted November 7, 2013 Share Posted November 7, 2013 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 Quote Link to comment Share on other sites More sharing options...
Al Brookbanks Posted November 7, 2013 Share Posted November 7, 2013 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. Quote Link to comment Share on other sites More sharing options...
slic535 Posted November 9, 2013 Author Share Posted November 9, 2013 they immediately disabled my account without letting me fix it first. I did upgrade and the problem was fixed and I had no errors until later today. Quote Link to comment Share on other sites More sharing options...
Dirty Butter Posted November 9, 2013 Share Posted November 9, 2013 I use Hostgator and am not having any such issues. Have you upgraded your Support Ticket with Hostgator to inform them that you found what you think is the error and corrected it and to please enable the site again? Quote Link to comment Share on other sites More sharing options...
Al Brookbanks Posted November 11, 2013 Share Posted November 11, 2013 Seems pretty bad to instantly disable it unless the issue was so bad it was taking down other sites. That's understandable. Is everything ok now? Quote Link to comment Share on other sites More sharing options...
M. Smith Posted March 24, 2015 Share Posted March 24, 2015 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, ( 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? Quote Link to comment Share on other sites More sharing options...
bsmither Posted March 24, 2015 Share Posted March 24, 2015 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. Quote Link to comment Share on other sites More sharing options...
havenswift-hosting Posted March 24, 2015 Share Posted March 24, 2015 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 lockWhenever 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.1You 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 Quote Link to comment Share on other sites More sharing options...
M. Smith Posted March 27, 2015 Share Posted March 27, 2015 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! :-) Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.