DataMapper ORM v1.8.2

[eluser]Stolz[/eluser]
[quote author="WanWizard" date="1358519144"]@Stolz,

What does the Orderitem model look like?

The count query generated is created on on instance of this model, and therefore uses that models relation definitions. So my assumption at the moment is that there is something wrong with the relationship definition from orderitem to order, causing the incorrect SQL.[/quote]

@WanWizard, thaks again for the support. Here are both models:

Code:

/*SQL:
CREATE TABLE IF NOT EXISTS orders (
id mediumint(4) unsigned NOT NULL auto_increment PRIMARY KEY,
user_id mediumint(1) unsigned, FOREIGN KEY (user_id) REFERENCES users(id) ON UPDATE CASCADE ON DELETE RESTRICT,
orderstatus_id tinyint(1) unsigned, FOREIGN KEY (orderstatus_id) REFERENCES orderstatuses(id) ON UPDATE CASCADE ON DELETE RESTRICT,
place_id tinyint(1) unsigned, FOREIGN KEY (place_id) REFERENCES places(id) ON UPDATE CASCADE ON DELETE SET NULL,
paymenttype_id tinyint(1) unsigned, FOREIGN KEY (paymenttype_id) REFERENCES paymenttypes(id) ON UPDATE CASCADE ON DELETE SET NULL,
total float NOT NULL DEFAULT 0
) ENGINE = InnoDB;
*/
class Order extends DataMapper {

public $has_one = array('user', 'orderstatus', 'place',  'paymenttype');
public $has_many = array('orderitem');

public $validation = = array(
  'total' => array(
   'label' => 'Total',
   'rules' => array('trim', 'numeric', 'greater_than_equal_to' => 0)
  ),

  //Relationships validation

  'paymenttype' => array(
   'label' => 'Payment',
  ),

  'orderstatus' => array(
   'label' => 'Status',
   'rules' => array('required')
  ),

  'place' => array(
   'label' => 'Place',
   'rules' => array('required')
  ),

  'user' => array(
   'label' => 'User',
   'rules' => array('required')
  ),

  'orderitem' => array(
   'label' => 'Items',
   'rules' => array('required')
  ),
);

...

Code:

/*SQL:
CREATE TABLE IF NOT EXISTS orderitems (
id int(1) unsigned NOT NULL auto_increment PRIMARY KEY,
order_id mediumint(1) unsigned, FOREIGN KEY (order_id) REFERENCES orders(id) ON UPDATE CASCADE ON DELETE CASCADE,
orderitemstatus_id tinyint(1) unsigned, FOREIGN KEY (orderitemstatus_id) REFERENCES orderitemstatuses(id) ON UPDATE CASCADE ON DELETE RESTRICT,
name varchar(128) NOT NULL,
price float NOT NULL,
) ENGINE = InnoDB;
*/

class Orderitem extends DataMapper {

public $has_one = array('order', 'orderitemstatus');
public $has_many = array('orderitemextra');

public $validation = array(
  'name' => array(
   'label' => 'Name',
   'rules' => array('trim', 'required', 'max_length' => 128)
  ),

  'price' => array(
   'label' => 'Price',
   'rules' => array('trim', 'required', 'numeric', 'greater_than_equal_to' => 0)
  ),

  //Relationships validation

  'order' => array(
   'label' => 'Order',
   'rules' => array('required')
  ),

  'orderitemstatus' => array(
   'label' => 'Status',
   'rules' => array('required')
  ),
);
...