75Designs Posted March 10, 2007 Posted March 10, 2007 I tried installing the all customers contrib. and I recieve the following error: 1120 - Cross dependency found in OUTER JOIN; examine your ON conditions SELECT c.customers_id , c.customers_default_address_id, c.customers_email_address, c.customers_fax, c.customers_telephone, a.entry_company, a.address_book_id, a.customers_id, a.entry_firstname, a.entry_lastname, a.entry_street_address, a.entry_suburb, a.entry_city, a.entry_state, a.entry_postcode, a.entry_country_id, a.entry_zone_id, z.zone_code, co.countries_name FROM customers c LEFT JOIN zones z ON a.entry_zone_id = z.zone_id JOIN countries co ON a.entry_country_id = co.countries_id LEFT JOIN address_book a ON c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id ORDER BY a.entry_lastname unnsure what to do from here, any help would be greatly appreciated.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.