Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Thanks, @bsmither All of my indexes say "OK" so I have no idea what the problem is with this one site. I have a few other CC shops on the same server with no issues but of course they don't have monster databases. Hmmmm
  2. Does anyone happen to know if there is a guide to indexing the tables?
  3. My store is a download store so the orders and download records are in the millions. I switched from an older dedicated server to a new VPS about a year ago, hoping for some improvement but no luck. The other thing I'd like to try to do is find a way to identify and delete possible orphaned download and order records. Maybe the database is getting stuck looking for something that might not be there? I just don't know. My downloads table has 1,299,799 records and order inventory is at 1,300,401. I don't know if that discrepancy is significant or not but they should match considering everything I sell is a download, right?
  4. Is there a way to see when the last time a customer logged in was? My database is 10+ years old and I've managed to delete customer accounts who had 0 orders and were older than 1 year but I'm still left with nearly 80K customer accounts. I think it would be great if I could reduce my database further by deleting customer accounts who have not logged in in the past 5 years or so. My database lags so badly that I can't view statistics or do any type of exports and I'd really like to start exploring ways to pare it down.
  5. I already have a mailchimp popup on my shop's index page. Could this popup show up in the catalog pages and not the homepage?
  6. No worries, Al, I have it back up for now. Hosting company is clueless.
  7. Quick update. I have nothing nice to say about my hosting company's tech support. Instead of clearing my cache files, he deleted the cache directories. I have gone through each folder of my store and compared to a clean copy of cubecart and replaced the deleted cache folder. Back up and running for now and am confident Al can figure out what happened with the initial connection error. Goodness.
  8. My site was recently upgraded. Everything was working as planned until I sent out some marketing and the site went down under heavy traffic. Fatal error: User xxx already has more than 'max_user_connections' active connections in /xxx/xxx/public_html/shop/classes/db/mysqli.class.php on line 38 I contacted my hosting company to see if there's a setting or something to increase connections. I have a dedicated server so I thought "no problem", right? Wrong. I don't know what this guy did but all of a sudden it's a coding issue that they can't fix and these are my new errors. Admin: Fatal error: Class 'Cache' not found in /xxx/xxx/public_html/shop/controllers/controller.admin.pre_session.inc.php on line 17 Shop index: Fatal error: Call to a member function display() on null in /xxx/xxx/public_html/shop/index.php on line 22 I have a tech support plan but it's the weekend and I am desperate to get my site back up! Any ideas? Thanks in advance.
  • Create New...