Jump to content

M. Smith

Member
 View Profile  See their activity

  • Posts

    57

  • Joined

  • Last visited

 Content Type 

Posts posted by M. Smith

    website taken off web by hosting provider due to scripting errors

    in Technical Help

    Posted

    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! :-)

    Need developer to fix our site

    in Technical Help

    Posted

    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.

     

     

    website taken off web by hosting provider due to scripting errors

    in Technical Help

    Posted

    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?

    MySQL Error Occurred

    in Technical Help

    Posted

    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=''

    MySQL Error Occurred

    in Technical Help

    Posted

    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'

    MYSQL 5.1 upgrade - site not working

    in Technical Help

    Posted

    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.

    MYSQL 5.1 upgrade - site not working

    in Technical Help

    Posted

    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=''

     

     

    How to assign percent sale per category

    in Technical Help

    Posted

    Thanks.  Tried to go to their site, but got a bunch of error messages. Not sure what that's about.  My husband really wants to have this function and is trying to get me to switch shopping carts because of it.  I really REALLY don't want to do that since I have spent several years learning CC and still prefer it to other carts that I've tried. Do you know if there are any plans to add the function in the future?

    Resolved - Modifying "Latest Products" div

    in Customising Look & Feel

    Posted

    I would like to make a dark gray box around the Latest Products section of my home page like the one at the top of the page: http://frontline-games.com/shop/

    I tried changing its div container it on the content.homepage.php page to <div id="annoucement"> to match the one I modified for the top of the page, but it only surrounds the header. I'm familiar with html/css, but not PHP. Here's what I have for the content.homepage.php:

    {if isset($DOCUMENT)}

    <div id="announcement">

    {$document.content}

    </div>

    {/if}

    {if isset($LATEST_PRODUCTS)}

    <div id="announcement">

    <h2>{$LANG.catalogue.latest_products}</h2>

    {foreach from=$LATEST_PRODUCTS item=product}

    <div class="latest_product">

    <form action="{$VAL_SELF}" method="post" class="addForm">

    <p class="image">

    <a href="{$product.url}" title="{$product.name}">

    <img src="{$product.image}" alt="{$product.name}" />

    </a>

    </p>

    <p class="title"><a href="{$product.url}" title="{$product.name}">{$product.name|truncate:38:"&hellip;"}</a></p>

    {if $product.ctrl_sale}

    <p class="price"><span class="price_previous">{$product.price}</span> <span class="price_sale">{$product.sale_price}</span></p>

    {else}

    <p class="price">{$product.price}</p>

    {/if}

    <p class="actions">

    <a href="{$product.url}" title="{$product.name}" class="button_black">{$LANG.common.info}</a>

    <input type="hidden" name="add" value="{$product.product_id}" />

    {if $product.ctrl_stock && !$CATALOGUE_MODE}

    <input type="submit" value="{$LANG.catalogue.add_to_basket}" class="button_white" />

    {elseif !$CATALOGUE_MODE}

    <input type="submit" value="{$LANG.catalogue.out_of_stock_short}" class="button_white disabled" disabled="disabled" />

    {/if}

    </p>

    </form>

    </div>

    {/foreach}

    </div>

    {/if}

×
×
  • Create New...