The problem with that is that the customizations are extremely extensive - there are at least 7 different add-ons, plus about 20 hours of entering in different tax zones, setting up configs, as well as heavily modified CSS and templating that goes into the code itself. I've paid a web designer a great deal of money to do it.6. If the error/timeout doesn't occur, then begin re-applying your customizations to this fresh site.
Starting again from scratch isn't really an option.
It's obviously a database issue, so figuring out what data in the database is causing the issue would be a lot better than being forced to apply all those modifications to new code, which would cost me hundred of dollars in labour. I can do database stuff myself.
Thread: Timeout when selecting Catagory
Results 1 to 10 of 11
Hybrid View
-
8 Aug 2006, 01:56 PM #1
New Zenner
- Join Date
- Apr 2006
- Posts
- 10
- Plugin Contributions
- 0
Re: Timeout when selecting Catagory
-
8 Aug 2006, 08:43 PM #2
Sensei
- Join Date
- Jan 2004
- Posts
- 66,446
- Plugin Contributions
- 81
Re: Timeout when selecting Catagory
Moving this post out of the Bug Reports section into General Questions.
-
8 Aug 2006, 08:58 PM #3
Sensei
- Join Date
- Jan 2004
- Posts
- 66,446
- Plugin Contributions
- 81
Re: Timeout when selecting Catagory
If you were to use steps 1-5, and in #4 import your current database, you could at least determine whether the problem has anything to do with code or whether maybe it's related to database-corruption.
You may have already tried running Repair Table and/or Optimize Table procedures on your current database ... but if not, give it a try after taking a backup..
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 Aug 2006, 03:52 PM #4
New Zenner
- Join Date
- Apr 2006
- Posts
- 10
- Plugin Contributions
- 0
Re: Timeout when selecting Catagory
I did 1-5 and the problem does indeed go away. However, the modifications to the site are extensive and would take many man hours to replicate - also, if this problem occured when I had a few thousand products, I don't think I'd be so keen to just start from scratch and enter them all in again, so I was hoping for some way to maybe check the database for what's supposed to be there.
-
11 Aug 2006, 10:56 AM #5
Sensei
- Join Date
- Jan 2004
- Posts
- 66,446
- Plugin Contributions
- 81
Re: Timeout when selecting Catagory
You said the problem went away.
If you imported your own database so that all your products are present, and the problem still doesn't appear ... then either:
- your main database itself has need for some repair or optimization at the database-engine-level
or
- your customization code has busted something somewhere.
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.
-
11 Aug 2006, 03:27 PM #6
New Zenner
- Join Date
- Apr 2006
- Posts
- 10
- Plugin Contributions
- 0
Re: Timeout when selecting Catagory
No, the problem went away when I reinstalled a fresh copy on another server and manually entered in a couple of products.
If I apply my existing database to the fresh copy, it stops working.
I ran myisamchk on the table and it had no effect. Dumping, dropping, recreating and reimporting the data has no effect either.
Similar Threads
-
v151 Shared SSL- Login Timeout problems when customer goes to checkout or when admin logs
By oldwolfe in forum General QuestionsReplies: 8Last Post: 11 Oct 2012, 12:21 AM -
Selecting a header when when main_page=product_info
By borillion_star in forum Templates, Stylesheets, Page LayoutReplies: 9Last Post: 8 Mar 2010, 01:26 AM -
Error when selecting atribute
By malhyp in forum Setting Up Categories, Products, AttributesReplies: 3Last Post: 16 Feb 2009, 01:03 AM -
Error when selecting customer
By isaacr25 in forum Basic ConfigurationReplies: 1Last Post: 8 Jan 2008, 04:22 PM
