Thursday, July 12, 2012

Error: Select query cannot join with another table

I was joining two tables in Zend framework. I come across following error:
Error:  Select query cannot join with another table

The code that I was using is as below:
$calc = $this->select()
  ->from(array('c'=>'sed_cal'),array('c.id','c.name'))
  ->join(array('ctr'=>'sed_calc_to_road'),'c.id = ctr.calc_id')
  ->where('ctr.road_id',$id)
  ->order(array('c.id ASC'));

After searching the web, I found that I need to use the setIntegrityCheck function with false value. Hence, the code goes as this:
$calc = $this->select()
  ->setIntegrityCheck(false)
  ->from(array('c'=>'sed_cal'),array('c.id','c.name'))
  ->join(array('ctr'=>'sed_calc_to_road'),'c.id = ctr.calc_id')
  ->where('ctr.road_id',$id)
  ->order(array('c.id ASC'));

See the book OpenCart 1.4 Template Design Cookbook.
See the book Joomla Mobile Development Beginners Guide




List of my works:

Opencart Extensions:

  1. Product Based Quantity Wise Shipping: Find it here.
  2. OpenSSLCOMMERZ: integrate SSLCOMMERZ with opencart: Find it here.
  3. Fine Search v.1.0 - Improves Opencart search feature to find relevant: Find it here.
  4. Opensweetcaptcha - An easy way to generate attractive captcha for your system!: Find it here.
  5. Custom Field Product - add unlimited custom fields to the product form: Find it here.
  6. Formcaptcha - add captcha on the register page: Find it here.

My Books:

  1. OpenCart 1.4 Template Design Cookbook.
  2. Joomla Mobile Development Beginners Guide

No comments: