problem with gift certificate

1317 Query execution was interrupted
in:
[SELECT DISTINCT c.customers_email_address as customers_email_address, c.customers_lastname as customers_lastname, c.customers_firstname as customers_firstname FROM zen_customers c LEFT JOIN zen_orders o ON c.customers_id=o.customers_id WHERE o.date_purchased IS NULL ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

That is what i get when i click on mail gift certificate

Still have this same issue can can't seem to figure out why.

If you go to phpMyAdmin and run this SQL query on your database:

SELECT DISTINCT c.customers_email_address as customers_email_address, c.customers_lastname as customers_lastname, c.customers_firstname as customers_firstname FROM zen_customers c LEFT JOIN zen_orders o ON c.customers_id=o.customers_id WHERE o.date_purchased IS NULL

how many records come up?

when i put that in it just takes forever and then goes to this screen back to the begining..

Sounds like you have a large number of customers and/or orders where your php is timing out based on the size of the SELECT statement ...

NOTE: this could be your server as I have 68,000 customers with 52,000 orders that takes 0.002 seconds ... the first time took 0.416 seconds ...

So then this is an issue with my hosting company? not Zen?

I would think so ...

How many customers and how many orders do you have?

Ajeh:

I would think so ...

How many customers and how many orders do you have?
Hello,

I know this threat is a bit old, but at the moment i have the exact same error message in zen and the same behaviour in php admin when i run the query from there.

I have approx 12.000 customers and a little less orders in my shop.

Do you please have a suggestion to make this query less intense on the MySQl?

nagelkruid:

Hello,

I know this threat is a bit old, but at the moment i have the exact same error message in zen and the same behaviour in php admin when i run the query from there.

I have approx 12.000 customers and a little less orders in my shop.

Do you please have a suggestion to make this query less intense on the MySQl?

ps. on a similar server with same database it does run:
Toon Records 0 - 29 (1.794 totaal, Query duurde 2.7893 sec)
SQL-query:SELECT DISTINCT c.customers_email_address AS customers_email_address, c.customers_lastname AS customers_lastname, c.customers_firstname AS customers_firstname
FROM engendcustomers c
LEFT JOIN engendorders o ON c.customers_id = o.customers_id
WHERE o.date_purchased IS NULL
LIMIT 0 , 30
it says the query took 2.7893 sec but i have waited at least 2 minutes to view the output :cool:

are there perhaps indexes or views that i can use to speed this up?

nagelkruid:

Hello,

I know this threat is a bit old, but at the moment i have the exact same error message in zen and the same behaviour in php admin when i run the query from there.

I have approx 12.000 customers and a little less orders in my shop.

Do you please have a suggestion to make this query less intense on the MySQl?

I assume you are NOT using zen139 ?

Consult this thread for a possible solution

http://www.zen-cart.com/forum/showthread.php?t=101799

I'm seeing this error on a 1.3.9h store with about 8200 customers and 6800 orders. Would this be a hosting issue?

Danielle:

I'm seeing this error on a 1.3.9h store with about 8200 customers and 6800 orders. Would this be a hosting issue?

139h has the updated index.
So... my guess is that its hosting issue
btw which host?

On the Mail a Gift Certificate, there is a dropdown for groups of Customers as well as each individual Customer email address ...

The problem is, with 8200 customers, you are trying to draw a dropdown of 8200 lines ... these 8200 lines must first draw and be downloaded to your computer through the browser ...

This can stall on a lot of servers/browsers ...

You may need to comment out the dropdown so as not to try to draw that monsterous dropdown ...

The select is not always the problem but rendering the dropdown can be ...