|
Daily Database Errors |
Post Reply 
|
| Author | |
Espressotec 
Groupie 
Joined: 10-August-2007 Location: Canada Status: Offline Points: 0 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: Daily Database ErrorsPosted: 14-May-2008 at 1:29pm |
|
Hello everybody, daily around 3pm PST we can't login into Product Cart. It throws a database error script.
On top of that, the site goes extremely slow and no orders can be placed.
We've tried contacting our webdesiger and our server and we have no idea what's causing this. Yesterday product cart went down at 3pm, and some time during the night it went back up!
It happens almost everyday for 2 weeks now at a general time of 3pm PST.
Any suggestions?
|
|
 |
|
|
Greg Dinger
Certified ProductCart Developers 
Joined: 23-September-2006 Location: United States Status: Offline Points: 238 |
Post Options
Thanks(0)
Quote Reply
Posted: 14-May-2008 at 1:38pm |
|
I'd be talking to tech support or the server administrator where you host the site. There may be a scheduled process popping up at that time or something of that nature.
|
|
|
|
|
katharina
Senior Member 
Joined: 25-October-2005 Location: United States Status: Offline Points: 0 |
Post Options
Thanks(0)
Quote Reply
Posted: 14-May-2008 at 1:47pm |
|
I would guess the same. We had a similar problem on our provider's server. We talked to them and they moved us to a different server with a limited number of users (semi dedicated) without any up cost. Apparently pc (in our case SQL) needs a certain amount of system resources to run smoothly. Plus we have lots of products. I think they only had to move the database to another server. Talk to your host and see what may be the issue.
Katharina |
|
|
|
|
Espressotec
Groupie
Joined: 10-August-2007 Location: Canada Status: Offline Points: 0 |
Post Options
Thanks(0)
Quote Reply
Posted: 14-May-2008 at 2:22pm |
|
Thanks for the amazingly quick replies
After talking to our server, he says that there is Prodcut Cart is running it to 100%, him and our web designer beleive that there is a script error that is causing such a strain on the server causing the database error.
Right now the site went down again. BTW we only have under 1000 products Edited by Espressotec - 14-May-2008 at 2:22pm |
|
|
|
|
Hamish
Admin Group 
Joined: 12-October-2006 Location: United Kingdom Status: Offline Points: 56 |
Post Options
Thanks(0)
Quote Reply
Posted: 14-May-2008 at 2:35pm |
|
Hi,
If there was a problem with Product Cart it would most likely be impacting more than just your site. Also, as this is happening at a particular time that also pretty much rules out product cart as, AFAIK, it does nothing at any particular scheduled time - it just reacts to requests for web pages. If the hosting company cannot be specific about the issue I would go with the request to move your DB to another server - if the problem still persists then further diagnostics will be needed - but probably this will need to be done by the hosting company, depending on the level of access to the server they permit. |
|
|
|
|
Espressotec
Groupie
Joined: 10-August-2007 Location: Canada Status: Offline Points: 0 |
Post Options
Thanks(0)
Quote Reply
Posted: 14-May-2008 at 3:04pm |
|
Thanks for all the replies, we upgraded out server to a higher capacity and our site is back and fully functional.
|
|
|
|
|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
Topic Options