Jump to content

M. Smith

Member
  • Posts

    57
  • Joined

  • Last visited

Profile Information

  • Gender
    Female

M. Smith's Achievements

Newbie

Newbie (1/14)

2

Reputation

  1. Okay, that's what I thought. Thanks for the quick reply!
  2. I am trying to assign per category shipping to one specific category and then something else (all-in-one-shipping) to everything else. Is there a way to do this?
  3. 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! :-)
  4. Thanks, Ian, but this post was about hiring someone to fix the issue for us. I didn't see the replies to my other post, so thanks for the heads up. :-D
  5. HostGator took our site down due to processor overuse, and we need help fixing it. We are running an older version of CC (4.0.2) and also will eventually need to upgrade, but for now, just need it fixed so we can get our site back online. Please send an estimate of how much you think it will cost to fix. Here is the message they sent AFTER taking our site down: 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.
  6. 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?
  7. Okay, thanks so much anyway for your efforts!
  8. Yes, I'm sorry! I'm still using CC4 on this site. I forgot that my tagline was referring to another site that I have. I restored the global.inc.php file, and now I'm back to this: Warning: Invalid argument supplied for foreach() in /homepages/38/d121554869/htdocs/battlemart/store/includes/functions.inc.php on line 1019 MySQL Error Occured Error Message: 1054: Unknown column 'sessId' in 'field list' SQL: SELECT sessId FROM CubeCart_sessions WHERE sessId=''
  9. Oops! That's not right. Disregard my last comment. Here's what I had before I added 'cube_' in the global.inc.php file: Warning: Invalid argument supplied for foreach() in /homepages/38/d121554869/htdocs/battlemart/store/includes/functions.inc.php on line 1019 MySQL Error Occured Error Message: 1054: Unknown column 'sessId' in 'field list' SQL: SELECT sessId FROM CubeCart_sessions WHERE sessId='' Now I have (after adding the prefix): MySQL Error Occured Error Message: 1146: Table 'db468447140.cube_CubeCart_config' doesn't exist SQL: SELECT array FROM cube_CubeCart_config WHERE name = 'config'
  10. Cool, got rid of that error! Still getting the MySQL can't open sessions error, though (sigh). My brain hurts.
  11. I think I'm having the same issue. Where do you add the 'cube_' in the global.inc.php file?
  12. Yes, $glob['encoder'] is equal to 'ioncube' but my php.ini file has this line: zend_extension = /homepages/38/d121554869/htdocs/battlemart/store/ioncube/ioncube_loader_lin_5.2.so Should I change that to 'loader_lin_4.2.so'? There is a 'ioncube_loader_lin_4.2.so' file in my ioncube directory.
  13. I also tried a fresh install on a test site and got the same blank screen after installation.
  14. 1and1 is telling me that the CC script is not compatible with php 5.4. They have no error logs, but I'm now getting this: MySQL Error Occured Error Message: 1016: Can't open file: 'CubeCart_sessions.MYI'. (errno: 130) SQL: SELECT sessId FROM CubeCart_sessions WHERE sessId=''
  15. My server (1and1.com) just upgraded from MYSQL 4 to 5 (mandatory), and now my shop is not working. I have an older and newer version of CC and both are giving me a blank screen. Any thoughts? Melinda :-D
×
×
  • Create New...