DataMapper ORM v1.8.2

[eluser]mkultra[/eluser]
Hello!

New on the forums here. I seriously need some help. Let me briefly describe what I'd like to do, and what I've tried in order to accomplish it:

I need Datamapper ORM to work for me; it does, but many-to-many relationships do not. So, I've tried everything. I've re-read the docs many many times over, double checked config's, double checked spelling of classes, models, columns, tables etc. to no avail.

I have tried many previous versions of DM, I've used the latest from GitHub (ty, btw), I've even gone back to try DMZ. Not only that, I've try these various versions on a blank CI install, CI 2.1.3 (which is the core we develop on), CI 2.1, CI 2.0.3. I've used it with HMVC, and non-HMVC.

No matter what I try, or what server I use it on, many-to-many does not work. I'm out of options and I'm desperately reaching out to you, whoever will help me.

I've developed a simple test case for all of these different cases using two simple models:

Cars and Wheels.

Code:

class Car extends DataMapper {

var $has_one = array();
var $has_many = array('wheel');
var $validation = array();

}

Code:

class Wheel extends DataMapper {

var $has_one = array();
var $has_many = array('car');
var $validation = array();

}

Pretend the appropriate constructor is in there...

The tables are just as simple:

Code:

CREATE TABLE `cars` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `name` text collate latin1_general_ci,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

Code:

CREATE TABLE `wheels` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `name` text collate latin1_general_ci,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

Code:

CREATE TABLE `cars_wheels` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `car_id` int(11) unsigned default NULL,
  `wheel_id` int(11) unsigned default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

One of the strangest things that occurs to me that I know for sure something is wrong is that I can destroy "cars_wheels" table, and DM doesn't complain.

When I run my test function...

Code:

public function test()
{
  $wheel = new Wheel();
  $wheel->name = 'Goodyear';
  $wheel->save();
  
  $car = new Car();
  $car->name = 'Car';
  $car->wheel= $wheel;
  $car->save();
}

...it saves both entries, and no relationship. Please... please guide me to the light that I know is so close at hand