Query Builder Hanging

[thomasharding]

Hey Guys,

Odd problem I'm having here.

No doubt about it I'll find the solution instantly after posting a new thread. Worth a try anyway.

Ok, I've upgraded a 1.3.7 to a 1.3.8. This site has about 18,000 customers with about 13,000 orders. It's pushing ZC to the absolute limit!

Everything is going swimmingly. No issues with the upgrade except for one thing - the Query Builder stuff (when you want to email customers).

Firstly, when I clicked on 'email customer' from customers.php, I got an error about TABLE_CUSTOMERS not being found. Rather odd, so I removed the constant to 'customers' for the time being to remedy it temporarily.

Now though, the page is hanging. I've worked out it's on line 312 of admin/mail.php which is:

$customers = get_audiences_list('email'); 

I quote that out and the page loads without any text.

After going into the query builder table (and removing various tags from the query_name field), I've found out that removing 'email,newsletters' from 'administrator' and 'customers who have never completed a purchase' gives me the following error:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE customers_email_format != 'NONE' order by customers_lastname, customers_fi' at line 1
in:
[select customers_email_address, customers_firstname, customers_lastname from customers WHERE customers_email_format != 'NONE' order by customers_lastname, customers_firstname, customers_email_address]
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.

Not sure if that's related to this, but it seems to be.

I have the following modules installed:

Amazon Populator
Google XML Sitemap
YSM Analytics Module
Cross Seller
Add Customer
Advanced Stats
Quantity Time Report
Search Log
Monthly Sales
Sales Report
Export Email Addresses
Orders Export

YSM Addon
Product Listing
Numinix Lightbox
Search Helper

Protx Form


NO IDEA whats happening here, but I have a feeling it's something to do with the upgrade.

Please help!!!!!

Thanks
Tom

[DrByte]

http://www.zen-cart.com/forum/showpo...08&postcount=2

[thomasharding]

Thanks for the help Bytey.

That query worked fine, in the sense that it stopped the script from hanging, but now I'm just getting a blank page showing up.

I have a feeling i've quoted something out along the way and forgotten to unquote it.

However, the page loads with the header intact, but the navigation stops after 'Tools'.

Thanks

[DrByte]

"Bytey"? That's a new one.

FAQ on dealing with blank pages: https://www.zen-cart.com/tutorials/index.php?article=82 ... try the debug logging utility mentioned there.

[thomasharding]

"Bytey"? That's a new one.

FAQ on dealing with blank pages: https://www.zen-cart.com/tutorials/index.php?article=82 ... try the debug logging utility mentioned there.

Hah, I'm surprised no-ones called you that already!

Right, it appears to be a memory allocation error:

[06-Oct-2009 08:35:12] PHP Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 35 bytes) in /site/path/includes/classes/db/mysql/query_factory.php on line 411

Sorry to keep pestering you about this.

[thomasharding]

Never mind, I found a thread

[thomasharding]

Just an interesting note actually, I didn't get this memory error on the clients 1.3.7 website, it's only happening after I upgraded it.

I assume the errors being throw because of the the amount of customers on the site?