FuelPHP Forums

There's 2 issues here at least: 1. You're using find_one_by() which the Orm doesn't support, it's either find_by_ (= one) or find_all_by_, and for PKs you can just use find($id) 2. You're using a has_one relation for something that's a belongs_to, when the foreign key is in the table that table belongs to the other one. This is the case for all your has-one relations btw, which don't fail miserably because you've set the keys to be used manually - though that only makes the fails less understandable as it can't work.

I switched to the 1.1/develop branch and get a different issue. On the initial save I get the following error "OutOfBoundsException [ Error ]: Unknown property or relation: supplier_factory"

That happens when you try to use a non-existant key or when the relations are being set using a non-existant key. Based on the models you're posting you're probably attempting to fetch that key from the wrong model.

Just to be clear - newbie question - is the code generated by scaffolding not to be used as a guide? Why the differences? Thanks, Ben.

Thanks; to scaffold with ORM, I've used the following commands to create a basic scaffold: oil g scaffold freak title:string summary:varchar[250] body:text --orm and ran the migration. Tried the basic listing http://$sitename/freaks and got this error:
"Fuel\Core\FuelException [ Error ]: Listing columns failed, you have to set the model properties with a static $_properties setting in the model. Original exception: Database method Fuel\Core\Database_PDO_Connection::list_columns is not supported by Fuel\Core\Database_PDO_Connection" So I specified all the field names in the Freak model: protected static $_properties = array('id', 'title', 'summary', 'body', 'created_at', 'updated_at'); And now get the following error:
Fuel\Core\Database_Exception [ Error ]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.' in 'where clause' with query: "SELECT `t0`.`id` AS `t0_c0`, `t0`.`title` AS `t0_c1`, `t0`.`summary` AS `t0_c2`, `t0`.`body` AS `t0_c3`, `t0`.`created_at` AS `t0_c4`, `t0`.`updated_at` AS `t0_c5` FROM `freaks` AS `t0` WHERE `t0`.`id` = '0' OR ((`t0`.`` IS null)) LIMIT 1" "OR ((`t0`.`` IS null)) " seems to be the problem. This is with no code hacking, straight out of the box.

...which didn't work. Gets me straight back to the error: ... Unknown column 't0.' in 'where clause' ...

Update; I've zeroed and reinstalled the default fuel application from scratch, copied and pasted the oil+orm scaffolding code from the docs page: oil g scaffold post title:varchar[50] body:text user_id:int --orm ...and still get the same ... Unknown column 't0.' in 'where clause' ... error: when I try to view http://.../posts Fuel\Core\Database_Exception [ Error ]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.' in 'where clause' with query: "SELECT `t0`.`title` AS `t0_c0`, `t0`.`body` AS `t0_c1`, `t0`.`user_id` AS `t0_c2` FROM `posts` AS `t0` WHERE `t0`.`id` = '0' OR ((`t0`.`` IS null)) LIMIT 1" COREPATH/classes/database/mysql/connection.php @ line 210 The backtrace is as follows: COREPATH/classes/database/query.php @ line 240
PKGPATH/orm/classes/query.php @ line 901
PKGPATH/orm/classes/query.php @ line 959
PKGPATH/orm/classes/model.php @ line 424
PKGPATH/orm/classes/model.php @ line 545
APPPATH/classes/controller/frocks.php @ line 8
APPPATH/classes/controller/frocks.php @ line 8
COREPATH/classes/request.php @ line 443
DOCROOT/index.php @ line 38 the "Post" model specifies:
protected static $_properties = array('title', 'body', 'user_id'); I've also tried:
protected static $_properties = array('id', 'title', 'body', 'user_id');
and
protected static $_properties = array('id', 'title', 'body', 'user_id', 'updated_at', 'created_at'); with effectively identical results. My config/DEVELOPMENT/db.php is as follows:
'connection' => array(
'dsn' => 'mysql:host=localhost;dbname='mypersonal_fuel_dbname',
'username' => 'mypersonal_fuel_dbuser',
'password' => 'mypersonal_fuel_password', I've also tried specifying 'mysql' (and database name) instead of 'pdo' in the main config/db.php file. The results are indistinguishable. My stack is snowleopard+MAMP, php version 5.3, with plenty of other non-fuel php sites virtually hosted. Help greatly appreciated. -Ben.

I shall repost. Thanks for the help so far. Redirecting to: http://fuelphp.com/forums/topics/view/6082