[jcasanova]

Hi... I'm facing a problem here don't know why...

when I set the relation $crud->set_relation('id_tipo','tipos_parametros','descripcion');
I get a DB error.



ERROR: syntax error at or near "'parametros.descripcion'" LINE 1: ...scripcion as sb55f4aee, parametros.descripcion as 'parametro... ^

SELECT parametros.*, jb55f4aee.descripcion as sb55f4aee[b], parametros.descripcion as 'parametros.descripcion'[/b] FROM "parametros" LEFT JOIN "tipos_parametros" as jb55f4aee ON "jb55f4aee"."id_tipo" = "parametros"."id_tipo" LIMIT 10


the string in bold, it should be there If I remove the query is correct.

web-johnny can you help me here?

[jcasanova]

So wierd... I made another new name same columns and worked... I think the problem was some name repited in name table or field tables...

[HumbleMonk]

Weird.. I just had this same problem.

Tried to set a a relation and got a DB error. Dropped the table and recreated exactly the same and then it worked...

[jcasanova]

shit the same problem again with relation =/ but re-create the table doesn't work this time...

Any ideas???

[jcasanova]

worked again, due to add unique index. , problem kkeeps.. it worked to show the add form... but not working in list.
gives the same sql error...

[web-johnny]

Can you please copy the structure of the two tables? I am sorry but I cannot reproduce the error. If you just post the structure of the basic table and the structure of the relation table to check it out it would be great.

[jcasanova]

CREATE TABLE detalle_zonas

(

  id_detzona integer NOT NULL DEFAULT nextval('sec_id_detzona'::regclass),

  nombre character varying,

  descripcion character varying,

  usuario character varying,

  fecha_creacion timestamp without time zone DEFAULT now(),

  fecha_mod timestamp without time zone,

  codigo_comuna integer

)





CREATE UNIQUE INDEX pkdetalle_zona

  ON detalle_zonas

  USING btree

  (id_detzona );





CREATE TABLE geo_comunas

(

  codigo_region integer,

  codigo_provincia integer,

  nombre character varying,

  codigo_comuna integer

)





CREATE UNIQUE INDEX pk_asdasd

  ON geo_comunas

  USING btree

  (codigo_comuna );







$crud->set_table('detalle_zonas2');

$crud->columns('nombre','descripcion','usuario','fecha_creacion','codigo_comuna');

$crud->display_as('codigo_comuna','Comuna');

$crud->set_relation('codigo_comuna','geo_comunas','nombre');

please help =)

[web-johnny]

The problem is that the grocery CRUD supports only mysql databases and mysqli only sorry but I cannot help you with your situation you have to change the model to make it work correctly.Perhaps someone else can help you but not me. Sorry again.

[jcasanova]

deleted

[jcasanova]

deleted

[jcasanova]

@web-johnny, I fixed the problem, it was a problem with the char ' in the get_list function in the model, because pg uses " instead of ' so the problem is fixed.

if($this->field_exists($related_field_title)){ 

     $select .= ", {$this->table_name}.$related_field_title as '{$this->table_name}.$related_field_title' ";

}



changed to:





if($this->field_exists($related_field_title)){ 

     $select .= ", {$this->table_name}.$related_field_title as \"{$this->table_name}.$related_field_title\"";

}

Thanks for your consern =)

I'm fixing this issues for a postgres version maybe you should add in the future.

Great Work!!

[web-johnny]

Sorry jcasanova for the delayed answer. I am glad that you find the solution