Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

All Customers contrib help


75Designs

Recommended Posts

Posted

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.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...