Hi everybody!
im have problem:
$crud = new grocery_CRUD();
$crud
->where('survey_oy.region_id', $p1)
->set_table('survey_oy')
->set_subject('subject')
//this work correct
->set_relation('region_id', 'survey_region', 'region_name')
//but if this uncomment i have error. because ?('survey_oy' == 'survey_oy')
//->set_relation('oy_parent_id', 'survey_oy', 'name_oy')
;
;
$crud->render();
ERROR
Unknown column 'survey_oy.name_oy' in 'field list' SELECT dml_survey_oy.*, j0f442f96.region_name AS s0f442f96, ja45a2255.name_oy AS sa45a2255, `survey_oy`.name_oy AS 'survey_oy.name_oy' FROM `dml_survey_oy` LEFT JOIN `dml_survey_region` as `j0f442f96` ON `j0f442f96`.`id` = `dml_survey_oy`.`region_id` LEFT JOIN `dml_survey_oy` as `ja45a2255` ON `ja45a2255`.`id` = `dml_survey_oy`.`oy_parent_id` WHERE `dml_survey_oy`.`region_id` = '1' LIMIT 30
column exist
CREATE TABLE IF NOT EXISTS `dml_survey_oy` ( `id` int(9) unsigned NOT NULL AUTO_INCREMENT, `region_id` int(10) DEFAULT NULL, `type_oy` int(10) DEFAULT NULL, `oy_active` tinyint(1) NOT NULL DEFAULT '1', `name_oy` varchar(500) DEFAULT NULL, `oy_parent_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=197 ;
my issue here but im not understund how fix it
//Grocery_crud_model.php
if ($this->field_exists($related_field_title))
$select .= ", `{$this->table_name}`.$related_field_title AS '{$this->table_name}.$related_field_title'";
help!
