BusyBee:
Hi,
I received a Notification of instant payment from a New Order. When I logged into my Admin the Customer was listed as a New Customer however the order did not show up. I set up a TEST purchase for a Friend to buy so I could try to figure out what was going on. Same thing notification of payment received but no Order. She said that when making payment she had to click on "if not redirected in 10 seconds click here" is that what makes the order complete? Would having 2 Zen Carts with separate PayPal accts create a problem? Can someone explain why and how to resolve the problem?
Thank You!
i was having a similar problem to your self (see here )
i contacted my webhosts and below was there answer, i don't know if yours is the same problem as i am having ,but i am new to all this zencart and thought it may help you.
Hello,
Thank you for contacting our Support Help Desk.
As you probably know your account is hosted on a shared hosting server which means that all resourced of the server are shared between the customers located on the server. In order to prevent one`s website affecting other customers by using a large amount of the resources a certain limitations are applied such as max query time and max query size.
The error message provided above means that your application is trying to execute too big or too long mysql query which can not be completed on the server and require more resources.
Unfortunately, the limitations explained above can not be modified per user bases due to the fact that they are globally applied. If you really need to use this function you may consider to optimize/reduce the size of your mysql database.
On the other hand, you may consider a VPS upgrade for your hosting where your account will be the only one located on the server and your application will be able to take advantage of all the resources of the server. You may revise our vps offers at:
http://siteground.com/vps.htm
Be advised that as an existing customer the setup fee will be waived for you and your account will be transfered to your new server free of charge.
Please, do not hesitate to contact us if you have any further questions or comments.
Kind Regards,
George Y.