Page 1 of 3 123 LastLast
Results 1 to 10 of 24
  1. #1
    Join Date
    Jun 2006
    Posts
    2
    Plugin Contributions
    0

    Default index.php and server overload?

    I've been having issues for the last two days with my hosting company/server and website (www.heavenlypromises.com/shop is where my zencart is located).

    For some reason, the index.php file has been causing an overload on the server, and they have had to suspend my site three times to keep the server running.

    Has anyone had any issues with this kind of thing, or know why it's happening / how to keep it from happening? Currently the host has disabled my index.php file, but that really isn't a help, since without the index.php file I have no shopping cart/site! They can't seem to find any reasons why this would happen, so I'm sitting here with a site down, and no real solution.

    Any help would be appreciated!

    Char

  2. #2
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: index.php and server overload?

    They would blame index.php because everything runs through that file.

    I'd start by using FTP to download a complete copy of all the files on your site.
    Then use WinMerge to compare them with your working files already on your PC. Make sure there's no corruption in any of the files and that nothing has been hacked in them.
    Then do a comparison against a freshly-downloaded-and-unzipped copy of the same version of Zen Cart ... just to be sure it wasn't caused by an edit you did in your own working files. Naturally your customizations will be different, but need to be looked at carefully.

    You could also ask your host if (during the time of the overload) there were any extremely-slow-running MySQL queries or excessive numbers of unclosed MySQL connections from your account?
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  3. #3
    Join Date
    May 2006
    Location
    Pleven, Bulgaria
    Posts
    4
    Plugin Contributions
    0

    Default Re: index.php and server overload?

    I have the same problem, from the hosting company told me that there are excessive numbers of unclosed MySQL connections from my account. How can be resolved this?

    Thanks in advance!

  4. #4
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: index.php and server overload?

    If you are using v1.3.x, you should not have a problem with unclosed connections.
    If you have v1.2.4 or earlier, you may have "some" troubles.

    in your configure.php files, you need to have:
    PHP Code:
    define('USE_PCONNECT''false'); // use persistent connections? 
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  5. #5
    Join Date
    May 2006
    Location
    Pleven, Bulgaria
    Posts
    4
    Plugin Contributions
    0

    Default Re: index.php and server overload?

    Yes I am using Zen Cart 1.3.0.1 and persistent connections are off.

  6. #6
    Join Date
    Mar 2004
    Posts
    16,042
    Plugin Contributions
    5

    Default Re: index.php and server overload?

    what else are you running on your account....

    zen cart closes all of its sql connections.
    well zc 1.2.7 and above )

  7. #7
    Join Date
    May 2006
    Location
    Pleven, Bulgaria
    Posts
    4
    Plugin Contributions
    0

    Default Re: index.php and server overload?

    Nothing only Zen Cart 1.3.0.1. *URL removed*
    Last edited by DrByte; 7 Jun 2006 at 09:38 PM.

  8. #8
    Join Date
    Jun 2006
    Posts
    2
    Plugin Contributions
    0

    Default Re: index.php and server overload?

    I'm currently using v1.2.4. It sounds like that version might be the problem? If I upgrade to the current version, is this likely to eliminate the overload problem?

    Thanks much!

  9. #9
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: index.php and server overload?

    It's possible, but there are so many other possibilities that it can't be guaranteed.

    things like:
    - what else is on your site besides Zen Cart? (forum, blog, gallery, other things)
    - what mods have you installed to Zen Cart?
    - are there any rogue files on your server that you haven't discovered yet which might be causing this bad behaviour?
    - then there's server-side issues over which you have no control, etc
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  10. #10
    Join Date
    Mar 2005
    Location
    Tempe, AZ
    Posts
    324
    Plugin Contributions
    0

    Default Re: index.php and server overload?

    I am using zencart 1.3.8a and i just got a report from my server company saying that Zencart overloaded the server and suspended my account

    Below is the information they sent me:

    [---START REPORT---]
    ----- --------------- ----------- ------------------ --------- ------ ------- ------------------
    | Id | User | Host | db | Command | Time | State | Info |
    ----- --------------- ----------- ------------------ --------- ------ ------- ------------------
    | 694 | xxxxxxxxxxxxx | localhost | xxxxxxxxxxxxx | Sleep | 18 | | |
    | 695 | xxxxxxxxxxxxx | localhost | xxxxxxxxxxxxx | Sleep | 14 | | |
    | 696 | xxxxxxxxxxxxx | localhost | xxxxxxxxxxxxx | Sleep | 12 | | |
    | 728 | xxxxxxxxxxxxx | localhost | xxxxxxxxxxxxx | Sleep | 9 | | |
    | 741 | xxxxxxxxxxxxx | localhost | xxxxxxxxxxxxx | Sleep | 2 | | |
    | 742 | xxxxxxxxxxxxx | localhost | xxxxxxxxxxxxx | Sleep | 4 | | |
    | 745 | xxxxxxxxxxxxx | localhost | xxxxxxxxxxxxx | Sleep | 2 | | |
    | 749 | xxxxxxxxxxxxx | localhost | xxxxxxxxxxxxx | Sleep | 2 | | |
    | 750 | xxxxxxxxxxxxx | localhost | xxxxxxxxxxxxx | Sleep | 16 | | |
    | 753 | xxxxxxxxxxxxx | localhost | xxxxxxxxxxxxx | Sleep | 16 | | |
    | 758 | xxxxxxxxxxxxx | localhost | xxxxxxxxxxxxx | Sleep | 14 | | |
    | 761 | xxxxxxxxxxxxx | localhost | xxxxxxxxxxxxx | Sleep | 11 | | |
    | 768 | xxxxxxxxxxxxx | localhost | xxxxxxxxxxxxx | Sleep | 7 | | |
    | 778 | xxxxxxxxxxxxx | localhost |xxxxxxxxxxxxx | Sleep | 2 | | |
    | 782 | xxxxxxxxxxxxx | localhost | xxxxxxxxxxxxx | Sleep | 3 | | |
    | 786 | root | localhost | | Query | 0 | | show processlist |


    19:13:51 up 46 days, 2:39, 2 users, load average: 36.94, 24.82, 17.11, t = 2s

    21338 R www.lextechs.com 61.43% 1.40s GET /tnaimpactps3-p-17505.html HTTP/1.1
    21124 R www.lextechs.com 50.91% 1.65s GET /ext25singlebaysatausb-p-47705.html HTTP/1.1
    20205 R www.lextechs.com 33.19% 4.70s GET /sbxfigo-p-62235.html HTTP/1.0
    20155 R www.lextechs.com 29.96% 4.74s GET /35alumsatatousb20encl-p-47492.html HTTP/1.1
    17279 R www.lextechs.com 27.03% 7.99s GET /audiovoxaudiovoxdatacableforgzoneboulderc711-p-33201.html HTTP/1.0
    20206 R www.lextechs.com 20.22% 13.65s GET /max4hdd35satarack-p-46552.html HTTP/1.1
    17128 R www.lextechs.com 18.12% 17.38s GET /trayless35satainternal-p-47301.html HTTP/1.1
    21139 R www.lextechs.com 17.10% 27.13s GET /ext25singlebaysatausb-p-48046.html HTTP/1.1
    17282 R www.lextechs.com 16.69% 30.14s GET /truthb2030pstudiomonitor-p-24815.html HTTP/1.1
    17278 R www.lextechs.com 16.27% 46.83s GET /pdpnerflicensedarmorcasefornintendodslite-p-29356.html HTTP/1.0
    17124 R www.lextechs.com 14.85% 21.48s GET /satahddmobilerack-p-48178.html HTTP/1.1
    21138 R www.lextechs.com 14.71% 20.05s GET /audiovoxaudiovoxdatacableforgzoneboulderc711-p-33201.html HTTP/1.0
    17264 R www.lextechs.com 13.19% 46.39s GET /wirelesskeyboard6000usb-p-44370.html HTTP/1.1
    17129 R www.lextechs.com 13.00% 24.08s GET /pdpnerflicensedarmorcasefornintendodslite-p-29356.html HTTP/1.0
    18168 R www.lextechs.com 12.96% 49.92s GET /audiovoxaudiovoxdatacableforgzoneboulderc711-p-33201.html HTTP/1.0
    20230 R www.lextechs.com 12.65% 43.39s GET /24ghzmultimediakeyboard-p-46066.html HTTP/1.1
    20153 R www.lextechs.com 12.49% 57.17s GET /tripplitewirelessmultimediaflexiblekeyboard-p-43262.html HTTP/1.1
    20216 R www.lextechs.com 12.36% 49.27s GET /batteryvideolightvl10liii-p-10143.html HTTP/1.1
    20203 R www.lextechs.com 12.01% 55.87s GET /wirelesskeyboardk340-p-53206.html HTTP/1.1
    21086 R www.lextechs.com 11.24% 40.58s GET /go24seriesfullsizekb-p-49737.html HTTP/1.1
    21135 R www.lextechs.com 11.04% 36.95s GET /wirelesskeyboardk350-p-53205.html HTTP/1.1
    19826 R www.lextechs.com 10.67% 70.85s GET /audiovoxaudiovoxdatacableforgzoneboulderc711-p-33201.html HTTP/1.0
    17122 R www.lextechs.com 10.62% 69.29s GET /pro2000cordlesskeyboardwb-p-46601.html HTTP/1.1
    20217 R www.lextechs.com 9.50% 60.42s GET /24ghzwirelesskeyboard-p-49355.html HTTP/1.1

    [---END REPORT---]

    These are the question they asked me can anyone answer them

    "Hello,

    We can get this fixed, all of the log information is in the abuse notice. What's happening is that your mySQL queries are not being closed by ZenCart, they're sitting waiting for something to happen. There are a few things that could cause this.

    1) Using mysql_pconnect instead of mysql_connect. Is ZenCart set up to use persistent connections?
    2) Refreshing pages constantly. Are you, or possibly any of your customers, refreshing pages?
    3) Connection flood. Have you experienced any increase in traffic lately?
    4) mySQL code injection attempts. Are you running the latest version of ZenCart?"
    Lextechs.com Powered By ZenCart

 

 
Page 1 of 3 123 LastLast

Similar Threads

  1. Server Overload PHP
    By suekay in forum General Questions
    Replies: 6
    Last Post: 19 Nov 2011, 08:46 PM
  2. Server CPU overload
    By houman in forum General Questions
    Replies: 5
    Last Post: 20 Sep 2008, 06:46 AM
  3. Index.PHP on server Changed by mistake.
    By popss in forum General Questions
    Replies: 1
    Last Post: 6 Jun 2008, 10:06 PM
  4. Change the index.php?main_page=index and where it links to
    By tqualizer_man in forum Templates, Stylesheets, Page Layout
    Replies: 1
    Last Post: 25 Nov 2006, 01:41 PM
  5. Blank index.php and /admin/index.php page after install
    By gsummerlin in forum Installing on a Linux/Unix Server
    Replies: 4
    Last Post: 14 Jul 2006, 10:04 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR