Post by MZBS » Tue Jun 05, 2012 9:36 pm

Hello,

First the info about my web:
- Shoppica
- Opencart 1.5.2.1
- Option Boost
- Advanced Product Profile Report
- SEO Pro Pack

- Visits: 1500-1800 per day.
- Page views: 11.022
- FatCow server

My server tell me that my database is executing an average of "103989" queries per hour.

Is that normal in Opencart or there is something wrong? Can anybody help me to know how can I improve this?

In the error log I see things like this some days:
2012-06-04 17:12:22 - PHP Notice: fputs() [<a href='function.fputs'>function.fputs</a>]: send of 22 bytes failed with errno=32 Broken pipe in /hermes/waloraweb033/b414/moo.herziostorecom/volvooceanrace/system/library/mail.php on line 187
2012-06-04 17:12:22 - PHP Notice: Error: EHLO not accepted from server! in /system/library/mail.php on line 200
2012-06-04 17:20:52 - PHP Notice: Error: RCPT TO not accepted from server! in /system/library/mail.php on line 308
2012-06-04 18:17:08 - PHP Notice: Error: DATA not accepted from server! in /system/library/mail.php on line 380
2012-06-05 6:01:30 - PHP Notice: Error: User 'dzafra' has exceeded the 'max_questions' resource (current value: 75000)<br />Error No: 1226<br />SELECT * FROM url_alias WHERE `query` = 'category_id=83' in /system/database/mysql.php on line 49
But I am not sure how can I correct this.

Thank you so much.

New member

Posts

Joined
Tue Jan 17, 2012 1:36 am

Post by Tcalp » Tue Jun 05, 2012 9:39 pm

I have a module which helps to reduce queries/increase speed, mind you Shoppica will add quite a bit to queries also.
http://www.opencart.com/index.php?route ... on_id=6204

There is also a great page caching module from JAY6390 which helps as well.
http://www.opencart.com/index.php?route ... on_id=3477

Increase Page Speed (#1 rated commercial extension on OpenCart Marketplace)
15in1 Essential Extensions Value Pack Premium Customer Testimonials Reward Points Extended Admin Security Lockdown Suite

Image
irc.freenode.net #opencart


User avatar
Active Member

Posts

Joined
Wed Jul 06, 2011 1:49 pm

Post by MZBS » Tue Jun 05, 2012 9:54 pm

To solve this problem with my server which of those two plugins I need? Are for the same? Are compatible with all plugins?

So that amount of queries is normal with that number of visits? Can I be assured that is no any serious error in my store?

Thank you for your fast answer.

New member

Posts

Joined
Tue Jan 17, 2012 1:36 am

Post by Avvici » Tue Jun 05, 2012 10:44 pm

I'd recommend both. You get lot's of traffic , or, more than the norm. Delete your error log from the admin and pay attention to it the next couple day's. Those errors could have been from the past. If you cannot afford both then I would start off with the http://www.opencart.com/index.php?route ... on_id=3477

User avatar
Expert Member

Posts

Joined
Tue Apr 05, 2011 12:09 pm
Location - Asheville, NC

Post by sprabhat2005 » Thu Jun 14, 2012 5:51 pm

Hi All
Can you help me... my all work has stopped. Email notifications is not working at all.
Neither CONTACT US form, nor i am receiving any emails from customer/orders. News letters are also not sending.

Notice: Error: RCPT TO not accepted from server! in C:\inetpub\vhosts\seeandwear.com\httpdocs\system\library\mail.php on line 316

When i try to send newsletter.
Previously everything was working fine.

Pls help me.

Regards
sainiprabhat@yahoo.co.in
1.5.1.3

Newbie

Posts

Joined
Mon Apr 09, 2012 5:10 am
Who is online

Users browsing this forum: No registered users and 14 guests