Site maintenance: Sun 15 Nov, from 12:00 UTC, about 4–6 hours. Details

This cutover relies on some testing that is still incomplete so may be cancelled at short notice

Forums / All Other Contributions/Addons / Email Export Error

Email Export Error

Locked

Started by ljdream00 on 17 Jan 2008, 7:31 PM · Views: 1,334

Results 1 to 1 of 1
This thread is locked. New replies are disabled.
17 Jan 2008, 7:31 PM
#1
ljdream00 avatar

ljdream00

Zen Follower

Join Date:
Jun 2007
Location:
Michigan
Posts:
168
Plugin Contributions:
0

Email Export Error

:blink:Please review this message below. How do I resolve this error.
It appears when I go to Admin->Email Export

Please choose the desired recipient list:

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 'from address_book o, customers c where c.customers_id = o.customers_id GROUP B' at line 2
in:
[select c.customers_telephone, c.customers_email_address, c.customers_lastname, c.customers_firstname, o.entry_street_address as customers_street_address, o.entry_suburb as customers_suburb,o.entry_city as customers_city, o.entry_state as customers_state from address_book o, o.entry_postcode as customers_postcode from address_book o, customers c where c.customers_id = o.customers_id GROUP BY c.customers_email_address order by c.customers_lastname, c.customers_firstname ASC ]
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.

Zencart Websites I've Designed:
deejaycentipede(DOT)com
djellery216(DOT)com