Jump to content

comprausa

Members
 View Profile  See their activity

  • Posts

    69

  • Joined

  • Last visited

comprausa's Achievements

Newbie

Newbie (1/14)

3

Reputation

  1. comprausa
    Were you able to Solve this? If yes please share. Thanks.
  2. comprausa
    Had the same problem Adding the 'defalut' column to table ps_wishlist solved it. Thanks!
  3. comprausa
    Hello tuk66, Why would ipage numbers differ from mine by 3 times as much? If I increase the limit further I am ignoring the fact that we have had a lot more traffic and orders (queries) in the past with no ocurrence of this issue. Shouldn't I be looking for true the cause of the error? Thanks again.
  4. comprausa
    Hello tuk66, I have monitored manually every hour in the past week, I decided to monitor every 30min this time. I don't know how to monitor it by cron, but I did it manually by looking at the SQL process list ID every hour. You can see that at not interval we go over the 150,000/hr query limit. But since we upgraded from 75,000 to 150,000 queries per hour the errors have been reduced from 8 a day to 1 a day (aprox). Either I am monitoring the wrong value, or Ipage is not telling the whole truth. August 24th Monitoring Time / SQL Process ID / Queries per 1/2 hr 8:00 12280765 8:30 12303988 23223 9:00 12329732 25744 9:30 12358272 28540 10:00 12387234 28962 10:30 12431770 44536 11:00 12448450 16680 11:30 12477524 29074 12:00 12510061 32537 12:17 ERROR 12:30 12524655 14594 13:00 12533879 9224 13:30 12556772 22893 14:00 12577498 20726 14:30 12599768 22270 15:00 12622735 22967 15:30 12673403 50668
  5. comprausa
    Hello tuk66, thank you very much for the reply. Yesterday I requested ipage to increase from 75,000 to 150,000 queries/hr. Today we thought the problem had been fixed but the error appeared again 25 hrs after the increase to 150,000. In he past 7 days the error occured 5-6 daily. It seems like an improvement. We have been with ipage for 3+ years and have handled greater traffic & orders without problems. Currently we are processing only about 25 orders/day. We've been monitoring queries on phpMyAdmin>Show processes....If process ID = 1 query, then: @8:00am ID counter = 9545693 @12:30pm ID counter = 9723637 (when the error appeared) Total Queries in 4.5 hours 177,944, this is far below the 150,000/hr queries allowed. I keep thinking the issue may be related to something else, or Ipage is not telling us the truth about the limits in queries. Ipage says there is no way to see this query limit or monitor queries/hr from the Control Panel, only from their back end. What do you think?
  6. comprausa
    Hello, Please help, we've been getting this error for the past week. "PrestaShop Fatal error: no utf-8 support. Please check your server configuration." It occurs around 7 times a day. Resetting the database user fixes it for a while. Our hosting response (ipage): You are experiencing this issue because your database user 'xyzuser' has exceeded the query limit set in our server which is 75000/hour. We told Ipage that we've been operating flawlessly for 3 years. In past months traffic and orders have decreased. Therefore any increase in queries seems illogical. In addition we monitored the SQL process list ID and hourly intervals resulted in less than 45000/hr queries. Error seems to be triggered while we are filling an order in the front office. Some orders are generated without any problem and others seem to trigger the error. The first time the error occurred the cgi_error_log recorded the following error: 20150811T083347: xyzwebsite.com/shop/order.php PHP Warning: Invalid argument supplied for foreach() in xyzlocalserver/shop/classes/Cart.php on line 375 PHP Warning: Invalid argument supplied for foreach() in xyzlocalserver/shop/classes/Cart.php on line 375 PHP Warning: Invalid argument supplied for foreach() in xyzlocalserver/shop/classes/Cart.php on line 375 PHP Warning: Invalid argument supplied for foreach() in xyzlocalserver/sh (error abruptly ends here) We can't tell if this error trigger the database error or the other way around SQL runtime information shows the database restarted the night before the whole problem began. "This MySQL server has been running for 8 days, 18 hours, 27 minutes and 29 seconds. It started up on Aug 10, 2015 at 10:55 PM. Ipage offered to increase query limit to 150000/hr, but all evidence shows we are not exceeding the 75000 limit. Even with the evidence it looks like that is our last resource. Do you have any insight? Prestashop version: 1.4.6.2 MySQL - 5.5.44-0ubuntu0.12.04.1-log phpMyAdmin - 2.8.0.1
  7. comprausa
    Regardless of our multiple request to our hosting (ipage) to check server spam blocks or filtering, it took them more than 20 days and contact with more than a docen technical specialists to determine that the problem was caused by the server blocking these emails. Same thing happened last year around the same time. This email filtering is absurd and arbitrary, specially since we do not send spam, newsletters, or any advertising to any customer or mailling list.
  8. comprausa
    Hello El Patron, "New order notifications" depend on mail alerts module, but I think "messages to customer from an order", and "order status change notifications" do not, and those are not going out either. Low inventory threshold alerts stopped working several monts back, but we didn't make fixing it a priority. Even during that time while that alert was not working, "Messages to customer from order," "Order status change messages," and "New order notifications" were working fine until a few days ago. We have not installed, modified, any modules or scripts in the past year. I followed your instructions anyways: Mail alerts was installed already, Uninstalled it, Installed it, then moved all module position to top of hooks' execution. Tested mail alerts and order messages, result unsuccessful. Any other ideas?
  9. comprausa
    Version: 1.4.6.2 Email mode: PHPmail Problem: Prestashop stopped sending the following emails from BO: - Messages to customer from Orders. - Change of status notification - New order confirmation email (we do not receive and neither does the customer) The first occurrence of this problem was Monday Oct 6th. Reported it to hosting (Ipage) the next day the problem fixed itself according to Ipage, and they did not know what the cause was. Then on Monday Oct. 20th the problem happened again and still today Friday Oct 24th we have no solution. Checks Performed: 1. Ipage says we are not being spam blocked 2. Ipage placed a PHPmail test script in a folder in our account and the test was successful. 3. We tested "Prestashop Test email tool" and PHPmail test is successful. Tabs > Preferences > E-mail... "Test your email configuration" So we are having problems only with those emails related to orders. 4. We have 2 other Prestashop installations on our Ipage account, and these have no problems sending emails. I also compared the following scripts, and they are identical in the 3 prestashop installations: - tools/swift/Swift.php - tools/swift/Swift/Message.php - tools/swift/Swift/Plugin/MailSend.php None have been modified since 2012, and have worked well for almost 3 years. 5. If we switch email mode to SMTP and try to email a customer from an order, we get this error message: “An error occurred while sending e-mail to the customer.” Again, in the other prestashop installations this test is also successful. Thanks comprausa
  10. comprausa
    Can I use this override on version 1.4.6.2? Thx.
  11. comprausa
    It turned out to be the email Smap Blocker on the hosting provider. Our hosting administrator submitted our emial address to their spam blocker and everything is now back to normal.
  12. comprausa
    Could it be something in a Script that manages only customer's emails? Which script should I look for? Please!
  13. comprausa
    More tests: - I also set up email with SMTP and still Unsuccessful. - then Switched back to PHP mail and still Unsuccessful Keep in mind both SMTP and PHP work on anothe prestashop shop that is set up in the same hosting account. Please help!
  14. comprausa
    I'm not sure about the password reminder, I've never received a password reminder, but I did another test with these emails: "Alert Product Availability" > Unsuccesful "Sent to friend" > Unsuccesful "Module Emailmaster" Succesful Any ideas?
  15. comprausa
    Hi, my shop stopped sending these messages to customers about a week ago: - Order Confirmation Mail to Customer - Order Messages to Customer sent from Order in BO. - Status Change Notification to Customer Any ideas on what these 3 have in common, or where to look for problems. We have not made changes to the site. Everything had been working fine for the past 2 years. Tested alrady: - When New order is placed we receive confirmation of the order in the shop email account. (but customer does not) - PHP mail function. Preferences/Email. Tested 3 different addresses successfully - Tested another Prestashop site in the same hosting account and All works fine. Using PS 1.4.6.2 Thanks!
×
×
  • Create New...