ZC Main & Admin HANGING and RUNNING SLOWLY -Getting Error Message

[Donn]

Hi Zen Cart Ppl.... It's been a while...

My cart has been working 100% until fairly recently.

Now, it seems to run REALLY slowly when browsing and using the various pages on the cart as a user, logged in or not logged in.

Sometimes, the cart, and even the admin page, can't be loaded.

Now, when trying to login to admin, I get this message nearly ALWAYS:

select * from MDproject_version WHERE project_version_key = 'Zen-Cart Database' ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

and have to retry at least twice in order to get the login page to even load. If even....at all.....(lately not at ALL...and it's been progressively getting WORSE!)

And, as I stated, ALL pages on the cart seem to load SLOWLY, while other items on my server are still accessible without any delay. So it isn't that my server's just slow....and it isn't any ONE page or pages on the cart.

It's all of them, or none that end up not being able to load, or load slowly. And it happens using different browsers, on different machines.

But it's *JUST* the cart that's affected.



The cart itself, when browsing as a logged in ( or not logged in ) user, seems to just hang lately. After ten minutes, it sometimes works again.

It seems that trying to even LOAD the admin.php, and getting that error message, will hang ALL workings of the cart - PERIOD - for at least a few minutes. Then it seems to reset, and the cart is again accessible, though still running slowly.

But---the admin is usually STILL not accessible.

GoDaddy is my hosting service, and I run ZenCart version 1.3.7 .

I hadn't dumped the admin log file for a while....was getting warnings from the ZC software to do so, but waited a while...

Finally backed up my database and reset the admin log....

Could it be that waiting too long to reset somehow messed up my database??? Or SOMEthing?!?!

[charmedbytina2]

Do a forum search of goDaddy.

Take it from a FORMER goDaddy customer.

You'll need a new host. Don't fall for the upgrade to a vitrual dedicated server sales pitch.

Tina

[DrByte]

You might just need to do a Repair on all your database tables.
Or maybe the server is overloaded.

[Donn]

You might just need to do a Repair on all your database tables.
Or maybe the server is overloaded.

Hi again, Dr. Byte...

Well, as far as server overload, that seems unlikely, as EVERYthing on the server loads super fast, with the exception of the running cart.

As far as SQL 'repair', I am clueless. How does one go about proceeding with a repair?

Thanks...

Do a forum search of goDaddy.

Take it from a FORMER goDaddy customer.

You'll need a new host. Don't fall for the upgrade to a vitrual dedicated server sales pitch.

Tina

Hi, Tina....

If at all possible, I'd rather avoid that....I'll look into the GoDaddy posts as you suggested, though...

Are there ANY ZC users remaining on GoDaddy using 1.3.7 ??

[DrByte]

As far as SQL 'repair', I am clueless. How does one go about proceeding with a repair?

One at a time.

Open your phpMyAdmin console, and select your store database.
Then one-by-one with each table, click on Operations, and choose the Repair Table option.

[Donn]

One at a time.

Open your phpMyAdmin console, and select your store database.
Then one-by-one with each table, click on Operations, and choose the Repair Table option.

I tried, but it seems that the only option avail when I click OPERATIONS is:

'create new table on database DATABASENAME'


under that, it says:

'Error
The additional features for working with linked tables have been deactivated. To find out why click here.'

Clicking HERE, this is what I get:

'PMA Database ... not OK[ Documentation ]
General relation features Disabled'


Clicking on Documentation, I get:

'$cfg['Servers'][$i]['pmadb'] string
The name of the database containing the linked-tables infrastructure.

See the Linked-tables infrastructure section in this document to see the benefits of this infrastructure, and for a quick way of creating this database and the needed tables.

If you are the only user of this phpMyAdmin installation, you can use your current database to store those special tables; in this case, just put your current database name in $cfg['Servers'][$i]['pmadb']. For a multi-user installation, set this parameter to the name of your central database containing the linked-tables infrastructure.'


Do I need to do all of this in order to have MYSQL present me with the option to repair the database? I don't want to do this if it isn't necessary. But if it is, I will set up the additional table...

Thanks,
Donn

[DrByte]

No, that's not necessary in order to repair tables.


You could just click on the SQL tab and type in the following:

repair table ZZZZZZZZZZZ;

... where ZZZZZZZZZZ is the name of a table.
Then do the same for all 93 tables ...

[Donn]

No, that's not necessary in order to repair tables.


You could just click on the SQL tab and type in the following:

repair table ZZZZZZZZZZZ;

... where ZZZZZZZZZZ is the name of a table.
Then do the same for all 93 tables ...

OK....I executed the repair command on all 93 tables using the method described above.

All operations were completed successfully.

There doesn't seem to be any improvement at ALL.

What remains as a possible reason for this issue???

(for those stating that this is an issue with GoDaddy...could you please explain how/why this is the case? Thanks!)

[Donn]

To make this clearer:

My cart seems to run OK on the customer side UNTIL I simultaneously try to login to, or access, any admin pages.

At that point, the cart freezes up. I never get an error message on that user/cart side...just a frozen cart....

The message error messge about losing connection with the database
only appears when I try to logon to admin, or try to access any of the admin pages, and the page does not load.

So, chiefly, this is a problem with my admin....which seems to affect the cart's overall performance.....

*SOMETIMES* the admin page I'm trying to load actually does come up - this is an intermittent problem - But then, clicking on any option on an admin page yields the same error message about 9 out of ten times. Sometimes the cart then hangs and will only work again if I leave it alone for about ten minutes.

On the user side, the cart seems to work fine...again, until I try to use any Admin functions.

[DrByte]

Very odd.

*When* did this start happening?
And how does that "when" relate to anything else done to your site? to your site's files? to any addons? to your hosting account? to any emails from your hosting company?

If you install another clean uncustomized store into another folder and separate database (use demo data for simplicity), do the problems follow? ie: storefront works fine but the admin locks up?
And then test the admin of your live site ... get it to lock up or slow down or whatever, and then immediately (another browser tab?) check to see if your other demo store is at all impacted by the problem triggered on your live site.

I suspect you'll not be able to make the demo store have the same problem ... in which case, the fingers are pointed to either your customizations/addons or something damaged in your database.
You can sort out addon problems with the time-consuming process of comparing your site's files against a good backup from when it was working fine.
If you have database damage, I recommend hiring someone who specializes in that area to sort out what you've damaged.