Email Address Exporter (slight problem)

[nrg77]

What DB_PREFIX are you using in your configure.php file?

None, I am not using prefixes.

[DrByte]

Okay.

What happens if you run the query directly using the SQL tab in phpMyAdmin?

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

[nrg77]

Okay.


What happens if you run the query directly using the SQL tab in phpMyAdmin?

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

Same thing as if I had ran ZC Send Mail, Email Exporter...etc, hangs...

I just did another test. I emptied out orders table and it works again...So now I am suspecting maybe instead of the problem being in the customers table, it might be orders table....At this point, I am just drawing to any conclusion I find....

[DrByte]

What's special about this database?
What's its history? Exports/Imports/Backup+Restores? Customer and/or order imports?
Which versions of Zen Cart has it lived through? Did it start fresh in a clean Zen Cart install, or did data come from somewhere else at some point?

Try doing a "repair" on both the Customers and Orders tables (click on the table in the left column of phpMyAdmin, then click the Operations tab on top right, then click Repair Table down in the list of choices. Repeat for both tables). Then run the query again via the SQL tab.

[nrg77]

The database was generated from a fresh 1.3.7 ZC and the cart was updated to 1.3.7.1, thats it.

I repaired both tables and ran the query again and same thing, hanging..