[Deprecated] DMZ 1.5.3 (DataMapper OverZealous Edition)

Code:

DROP TABLE bugs_categories CASCADE;

DROP TABLE bugs_users CASCADE;

DROP TABLE dependencies_dependents CASCADE;

DROP TABLE bugs CASCADE;

DROP TABLE categories CASCADE;

DROP TABLE comments CASCADE;

DROP TABLE groups CASCADE;

DROP TABLE statuses CASCADE;

DROP TABLE users CASCADE;

Code:

class Referenceitem extends DataMapper {



    var $has_many = array(

        'file',

        'child' => array(

            'class' => 'referenceitem',

            'other_field' => 'parent'

        )

    );

    var $has_one = array(

        'parent' => array(

            'class' => 'referenceitem',

            'other_field' => 'child'

        )        

    );



    function  __construct($id = null)

    {

        parent::__construct($id);

    }

}

Code:

$obj = new Company();

            $obj->include_related('presponsavel/cpf', 'stNumero');

            $obj->include_related('presponsavel/rg', 'stNumero');

            $obj->include_related('presponsavel/oab', 'stNumero');

            $obj->include_related('presponsavel/enderecoprincipal', array('nmCep','stLogradouro','nmNumero ','stComplemento','stBairro','stCidade', 'stEstado','isAtivo','created','updated'));  //THOSE ARE ALL THE FIELDS FROM THE TABLE

            $obj->where('id',$this->uri->segment(3));

            $obj->get();

Code:

A Database Error Occurred



Error Number: 1064



You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`) LEFT OUTER JOIN `pfisicas` as presponsavel_pfisicas ON `presponsavel_pfisicas' at line 1



SELECT `companies`.*, `presponsavel_cpf_documentos`.`stNumero` AS presponsavel_cpf_stNumero, `presponsavel_rg_documentos`.`stNumero` AS presponsavel_rg_stNumero, `presponsavel_oab_documentos`.`stNumero` AS presponsavel_oab_stNumero, `presponsavel_enderecoprincipal_enderecos`.` AS presponsavel_enderecoprincipal_ FROM (`companies`) LEFT OUTER JOIN `pfisicas` as presponsavel_pfisicas ON `presponsavel_pfisicas`.`id` = `companies`.`presponsavel_id` LEFT OUTER JOIN `documentos` as presponsavel_cpf_documentos ON `presponsavel_cpf_documentos`.`id` = `presponsavel_pfisicas`.`cpf_id` LEFT OUTER JOIN `documentos` as presponsavel_rg_documentos ON `presponsavel_rg_documentos`.`id` = `presponsavel_pfisicas`.`rg_id` LEFT OUTER JOIN `documentos` as presponsavel_oab_documentos ON `presponsavel_oab_documentos`.`id` = `presponsavel_pfisicas`.`oab_id` LEFT OUTER JOIN `enderecos` as presponsavel_enderecoprincipal_enderecos ON `presponsavel_enderecoprincipal_enderecos`.`id` = `presponsavel_pfisicas`.`enderecoprincipal_id` WHERE `companies`.`id` = '18'

Code:

$render_form = array (

        'name' => array(

            'size' =>80

        ),

        'title',

        'message' => array(

            'type' => 'textarea',

            'rows'  => 6,

            'cols' => 80

        ),

        array (

            'row_options' => array (

                'label'=> 'Which colors do you like'

            ),

            'coloroptions' => array (

                'type' => 'checkbox',

                'name' => 'coloroptions[]',

                'list' => array (

                    'green' => 'Green',

                    'red' => 'Red',

                    'yellow' => 'Yellow',

                    'blue' => 'Blue'

                )

            )   

        )

    )

);