problem with gift certificate

[Dashizna]

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

[Dashizna]

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

[Ajeh]

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?

[Dashizna]

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

[Ajeh]

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 ...

[Dashizna]

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

[Ajeh]

I would think so ...

How many customers and how many orders do you have?

[nagelkruid]

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

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

[gilby]

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